Forum Discussion
Custom headers preparation for Excel file to load into SAP- Azure Synapse / ADF
Hi All,
I am working on one requirement and explaining below.
1. I get raw file from our third party system and we need to perform some ETL operations and need to prepare exact target file format which accepts by our custom SAP program.
Source file format:
| object no. | account No. Vendor | description | account No. Internal | account No. | Cost Centre | booking No. | description | value Date | value | value incl. tax | value without tax | tax | tax code | voucher desc. | invoice no. | invoice date | creditor no. | creditor name | contra account no. | contra account name | time of performance from | time of performance to |
Target Format ( I am looking like below 😞
| HD | Company | Doc Type | Posting Date | Doc Date | Currency | Ex Rate | Reference | HeaderText | Ldger | |||||
| HT | 0 | YY | 21.03.2022 | 21.03.2022 | XYZ | UPLOADFILE | MAR UPLOAD FILE | |||||||
| LD | \ | Posting Key | Account | Special G/L Indicator | Transaction Type | Amount (Doc curr) | Amount (Loc Curr) | Amount (Group Curr) | Contract | Contract type | Tax code | Payment terms | Baseline/Due Date | Pmt Method |
| LT | 1 | 40/50 | ABCD | 2200.00 | 2200.00 | 2200.00 |
Note: I will have many line items (LT ) in this diagram shown only one line but HT line always be one.
my questions:
How can we have 2 separate custom headers to populate data into target format ?
I am able to populate my line item data & line item header but for every file i need to provide custom header & its one line.
please suggest.
No RepliesBe the first to reply