FIPLD_SDINV_I

SAFT: Invoices from SD/FI module (Item) | #transactional | Component: SAF-T Poland
Column Name Description
MANDT FK Client
BUKRS FK Company Code
INVOICE_NO Invoice number
INV_YEAR Fiscal Year
POSNR Item number of the SD document
EXT_UUID UUID in character form
INVOICE_SOURCE SAFT: Source Module for Invoices
Column Name Description
💲 Currency Key (FIPLD_SDINV_H.CURRENCY):
UNITPRICE Target length CURR(23,2) Output 31 w/ Sign
GROSS_UNITPRICE Target length CURR(23,2) Output 31 w/ Sign
TAXBASE Net value of the billing item in document currency
TAXAMOUNT Tax amount in document currency
GROSS_AMT Target length CURR(23,2) Output 31 w/ Sign
DCUR_GROSS Gross value in document currency
DCUR_NET Net value in document currency
DCUR_TAX Tax value in document currency
DCUR_UNITPRICE Unit Price in document currency
DCUR_UPRICEGROSS Gross Unit Price in document currency
Column Name Description
📏 Base Unit of Measure (UNITOFMEASURE):
QUANTITY Quantity
Column Name Description
FBUDA Date on which services are rendered
ORG_INV_DATE Posting Date in the Document
Column Name Description
VGTYP Document Category of Preceding SD Document Show values
SHKZG Returns item Show values
Column Name Description Domain name
PRODUCTCODE SAF-T: Product Code
DESCRIPTION_LINE Description
VGBEL Document number of the reference document VBELN
VGPOS Item number of the reference item POSNR
EBELN Purchasing Document Number EBELN
EBELP Item Number of Purchasing Document EBELP
ORG_INV_REF Sales and Distribution Document Number VBELN
CORR_REASON Description TEXT40
KNUMV Number of the Document Condition KNUMV
TAXPERCENT SAF-T PL Tax Percentage (special cases) FIPL_TAX_PERCENTAGE
Master Data Relations Join Conditions
Order Reason (Reason for the Business Transaction)
  • FIPLD_SDINV_I.MANDT == TVAU.MANDT
  • FIPLD_SDINV_I.AUGRU_AUFT == TVAU.AUGRU
Company Code
  • FIPLD_SDINV_I.MANDT == T001.MANDT
  • FIPLD_SDINV_I.BUKRS == T001.BUKRS
Client FIPLD_SDINV_I.MANDT == T000.MANDT
Plant
  • FIPLD_SDINV_I.MANDT == T001W.MANDT
  • FIPLD_SDINV_I.PLANT == T001W.WERKS