FIEUD_FIDOC_I

SAFT: FI Transaction Document Item | #transactional | Component: SAF-T Reporting (Generic Part)
Column Name Description
MANDT FK Client
BUKRS FK Company Code
BELNR Document Number of an Accounting Document
GJAHR Fiscal Year
BUZEI Number of Line Item Within Accounting Document
BLDAT Document Date in Document
SYSUUID_C UUID in character form
Column Name Description
💲 Currency Key (LOCAL_CURRENCY):
AMOUNT Target length CURR(23,2) Output 31 w/ Sign
TAXPERCENT Condition Amount or Percentage
TAX_AMOUNT Tax Amount in Local Currency
DISCOUNT_AMT Target length CURR(23,2) Output 31 w/ Sign
WITH_AMOUNT SAFT PT : Withholding Tax Amount
TAX_BASE Tax Base Amount in Local Currency
IECAMOUNT Decimal Amount field with 7 decimal places
💲 Currency Key (WAERS):
CURRENCY_AMT Amount in document currency
CURRENCY_BASE Tax Base Amount in Document Currency
CURRENCY_TAX Tax Amount in Document Currency
💲 Currency Key (PAYCURR):
PAYMENTAMT Payment Amount
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Quantity
Column Name Description
BLDAT Document Date in Document
ORGDATE Document Date (Date Received/Sent)
TAXPOINTDATE Delivery Date
DISCOUNT_DATE SAFT : Discount Agreement Date
PAYMENTDATE Posting Date of Payment Document
AUGDT Clearing Date
Column Name Description
KOART Account type Show values
SKHZG Debit/Credit Indicator Show values
XNEGP Indicator: Negative Posting Show values
PAYMECH SAFT PT : Payment Mechanism Show values
OT_BP_IND Indicator: Is the account a one-time account? Show values
XAUTO Indicator: Line item automatically created Show values
Column Name Description Domain name
BUZID Identification of the Line Item CHAR1
HKONT General Ledger Account SAKNR
MWSKZ Tax on sales/purchases code MWSKZ
ANLN1 Main Asset Number ANLN1
SOURCE_DOCID SAFT : Source ID/Invoice number
DESCRIPTION Description
MATNR Material Number MATNR
PRODUCTID SAF-T: Product ID
MATERIAL_DESC SAFT : Product Description
SOURCE_MATNR SAFT : Material source
UNITPRICE Price unit PACK3
SYSTEMENTRYDATE SAFT: System Entry Date/Time
ORDERREF SAFT PT : Originating ON TEXT30
WERKS Plant WERKS
CRNOTE_REF SAFT : Reference Document
CRED_NOTE_REA SAFT : Reason
EXCHANGERATE Exchange Rate for Price Determination KURRF
SETLMNT_AGRMNT Own Explanation of Term of Payment TEXT50
WITH_TAXCODE Tax on sales/purchases code MWSKZ
WITH_TAXTYPE SAFT PT : Withholding Tax Type
WITH_TAXDESC SAFT PT : Withholding tax type description
DISCOUNT_AGRMNT SAFT PT : Discount Agreements
SOURCEBILLING SAFT PT : Source of Billing
EACCODE SAFT PT : CAE code of Company
PAYMENTTERM SAFT : Payment Terms
PRODUCTSERIALNUMBER Text (100 characters) TEXT100
ARCNO null
CUSTOMERID SAFT: Customer ID
SUPPLIERID SAFT: Supplier ID
BUSINESS_PARTNER Customer Number KUNNR
OT_COMPANY SAFT: Business Partner Name
OT_ADDRESSDET SAFT: Address Details
OT_STRAS SAFT:Street Name
OT_CITY SAFT: City TEXT50
OT_POSTALCODE SAFT PT: Postal Code TEXT20
OT_COUNTRY ISO Code of the Country/Region INTCA
OT_ACCOUNTID Reconciliation Account in General Ledger SAKNR
ISREVERSE null
AUGBL Document Number of the Clearing Document BELNR
REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
UMSKZ Special G/L Indicator UMSKZ
UMSKS Special G/L Transaction Type UMSKS
KUNNR Customer Number KUNNR
ZLSCH Payment Method ZLSCH
SGTXT Item Text TEXT50
EGBLD Country/Region of Destination for Delivery of Goods LAND1
BSCHL Posting Key BSCHL
Master Data Relations Join Conditions
Company Code
  • FIEUD_FIDOC_I.MANDT == T001.MANDT
  • FIEUD_FIDOC_I.BUKRS == T001.BUKRS
Client FIEUD_FIDOC_I.MANDT == T000.MANDT