SAP Knowledge Base Article - Public

3774505 - Direct import of FTP-hosted excel into Custom Business Object

Symptom

User asks if Finance-related data can be imported directly from an Excel file located on an FTP server into a BYD custom Business Object in SAP Business ByDesign.

Environment

  • SAP Business ByDesign Studio Lifecycle Management.

Reproducing the Issue

  1. Have finance-related data stored in an Excel file on an FTP server.
  2. Attempt to import the Excel file directly into a BYD custom Business Object in SAP Business ByDesign.

Cause

There is no standard SAP Business ByDesign functionality to import an FTP-hosted Excel file directly into a Custom Business Object.

Resolution

  1. Note that a direct import from an FTP-hosted Excel file into a Custom Business Object is not available as standard functionality.
  2. Implement a custom solution to load the data:
  3. Expose an API for the Custom Business Object (for example, via a service interface).
  4. For design guidance and community best practices, refer to the resources listed below.
  5. https://community.sap.com/topics/cloud-applications-studio

See Also

Refer to: 0002973358 - SAP Community: Preferred Support Channel for How-To Questions

Keywords

Business byDesign, FTP, Excel Import, Data Migration, PDI, Cloud Applications Studio, API, Service Interface, External file. , KBA , AP-RC-BDS-LM , ByDesign Studio Lifecycle Management , Problem

Product

SAP Business ByDesign all versions