Custom headers preparation for Excel file to load into SAP- Azure Synapse / ADF

Copper Contributor

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. Vendordescriptionaccount No. Internalaccount No. Cost Centrebooking No.descriptionvalue Datevalue value incl. taxvalue without tax    taxtax codevoucher desc. invoice no.invoice datecreditor no.creditor namecontra account no.contra account nametime of performance fromtime of performance to

 

Target Format ( I am looking like below :(

HDCompanyDoc TypePosting DateDoc DateCurrencyEx RateReferenceHeaderText Ldger    
HT0YY21.03.202221.03.2022XYZ UPLOADFILEMAR UPLOAD FILE      
LD\Posting KeyAccountSpecial G/L IndicatorTransaction TypeAmount (Doc curr)Amount (Loc Curr)Amount (Group Curr)ContractContract typeTax codePayment termsBaseline/Due DatePmt Method
LT140/50ABCD  2200.002200.002200.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.

 

 

0 Replies