Available fields
If you like to use other field names than in the list below, the table ZODIN_ALIAS is available. Edit this table via transaction se16n. Leave the STRATEGY field empty for global entries, otherwise entries are only valid for the specified strategy. Example:
| Field | Description |
|---|---|
| COUNTER | Document counter, provide one unique numeric value > 0 per FI document (not per line item) |
| STRATEGY | If supplied, extensions (BAdIs) will be called and the field value of STRATEGY will be passed as filter, see BAdI Reference |
| BUKRS | Company Code, note that cross-company code postings are possible |
| BKTXT | Document Header Text |
| BLDAT | Document Date in Document; in Excel the cell must be formated as date |
| BUDAT | Posting Date in the Document; in Excel the cell must be formated as date |
| BLART | Document type |
| SGTXT | Item Text |
| LIFNR | Account Number of Vendor or Creditor |
| KUNNR | Customer Number |
| HKONT | General Ledger Account |
| WRBTR_S | Amount gross in document currency in debit. The difference between WRBTR_S and WRBTR_H must be 0 within one document. |
| WRBTR_H | Amount gross in document currency in credit. The difference between WRBTR_S and WRBTR_H must be 0 within one document. |
| WAERS | Currency Key |
| MWSKZ | Tax on Sales/Purchases Code |
| ZTERM | Terms of Payment Key |
| CUSTOM<1-10> | Custom fields, 10 fields of type string available |
| AUFNR | Order Number |
| ZLSPR | Payment Block Key |
| QSSKZ | Withholding Tax Code, available for vendor only |
| LZBKZ | State Central Bank Indicator |
| KURSF | Exchange rate; if neither of KURSF and KURSF_M is supplied, current exchange rate (tcurr) will apply |
| KURSF_M | Exchange rate, indirect quotation, i.e. units of foreign currency per unit of local currency (displayed in SAP with leading "/" or negative sign, leave out prefix and sign here); if neither of KURSF and KURSF_M is supplied, current exchange rate (tcurr) will apply |
| XREF1 | Business Partner Reference Key |
| XREF2 | Business Partner Reference Key |
| XREF3 | Reference key for line item |
| ZFBDT | Baseline Date for Due Date Calculation; in Excel the cell must be formated as date |
| BEWAR | Transaction type |
| KOSTL | Cost Center |
| PROJK | Work Breakdown Structure Element (WBS Element) |
| VBEL2 | Sales Document |
| POSN2 | Sales Document Item |
| PRZNR | Business Process |
| VBUND | Company ID of trading partner |
| EBELN | Purchasing Document Number |
| EBELP | Item Number of Purchasing Document |
| MENGE | Quantity |
| MEINS | Base Unit of Measure |
| XBLNR | Reference Document Number |
| ZUONR | Assignment number |
| MANSP | Dunning Block, available for customer only |
| LANDL | Supplying Country |
| UMSKZ | Special G/L Indicator |
| DOC_STATUS | Document Status. Leave out for normal documents. For parked documents use value "2" and also set BUS_ACT = "RFBV", see SAP Note 2092366 |
| GLVOR | Business Transaction. Leave out for normal documents. For parked documents use value "RFBV" and also set DOC_STATUS = "2", see SAP Note 2092366. For down payments (noted items) use value "RFST" |
| BVTYP | Partner bank type |
| REBZG | Document no. of the invoice to which the transaction belongs |
| REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) |
| REBZZ | Line Item in the Relevant Invoice |
| BSCHL | Posting Key; note he posting key does not have to be specified in most cases, but only if the default setting (by SAP standard) is to be overridden |
| KUNNR_GL | ID customer in G/L position (use field KUNNR if you want to post a customer position) |
| LIFNR_GL | ID vendor in G/L position (use field LIFNR if you want to post a vendor position) |
| ANLN1 | Main Asset Number |
| ANLN2 | Asset Subnumber |
| PRCTR | Profit Center |