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
- Have finance-related data stored in an Excel file on an FTP server.
- 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
- Note that a direct import from an FTP-hosted Excel file into a Custom Business Object is not available as standard functionality.
- Implement a custom solution to load the data:
- Expose an API for the Custom Business Object (for example, via a service interface).
- For design guidance and community best practices, refer to the resources listed below.
- https://community.sap.com/topics/cloud-applications-studio
See Also
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
SAP Knowledge Base Article - Public