FIPLD_SDINV_H

SAFT: Invoices from SD/FI module (Header) | #transactional | Component: SAF-T Poland
Column Name Description
MANDT FK Client
BUKRS FK Company Code
INVOICE_NO Invoice number
INV_YEAR Fiscal Year
EXT_UUID UUID in character form
INVOICE_SOURCE SAFT: Source Module for Invoices
Column Name Description
💲 Currency Key (CURRENCY):
DOC_TOTAL_GROSS Target length CURR(23,2) Output 31 w/ Sign
DOC_TOTAL_NET Target length CURR(23,2) Output 31 w/ Sign
DOC_TOTAL_TAX 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
GROSS_AMOUNT_VA SAF-T PL: Sales Order Gross Amount
Column Name Description
Column Name Description
INV_DATE Billing Date
DELIVERYDATE Actual Goods Movement Date
Column Name Description
INV_TYPE SAFT : Target Invoice Type Show values
INV_CATEGORY SD document category Show values
ONETIME_IND Indicator: Is the account a one-time account? Show values
XREVERSAL Specifies Whether Document Is Reversal Doc. or Reversed Doc. Show values
RFBSK Status for Transfer to Accounting Show values
SPLIT_PAYM_IND SAF-T PL: Split Payment Indicator Show values
Column Name Description Domain name
INV_PERIOD Fiscal period MONAT
INV_DOCTYPE SD/FI document type
ERNAM Name of Person Responsible for Creating the Object USNAM
ADRNR Address ADRNR
STCEG VAT Registration Number STCEG
CANCEL_DOC SAFT: Reversed Document Number FIPL_INV_NUMBER
EXCHANGE_RATE Exchange Rate for Price Determination KURRF
VBELN Billing Document VBELN
VBELN_VA Sales Document VBELN
DP_PREV_INV SAF-T PL: Previous Invoices for Down Payment CHAR255
Master Data Relations Join Conditions
Company Code
  • FIPLD_SDINV_H.MANDT == T001.MANDT
  • FIPLD_SDINV_H.BUKRS == T001.BUKRS
Currency Key
  • FIPLD_SDINV_H.MANDT == TCURC.MANDT
  • FIPLD_SDINV_H.CURRENCY == TCURC.WAERS
Customer Number
  • FIPLD_SDINV_H.MANDT == KNA1.MANDT
  • FIPLD_SDINV_H.CUSTOMER == KNA1.KUNNR
Client FIPLD_SDINV_H.MANDT == T000.MANDT
Division
  • FIPLD_SDINV_H.MANDT == TSPA.MANDT
  • FIPLD_SDINV_H.SPART == TSPA.SPART
Account Number of Supplier
  • FIPLD_SDINV_H.MANDT == LFA1.MANDT
  • FIPLD_SDINV_H.VENDOR == LFA1.LIFNR
Sales office
  • Sales office
  • Client
  • FIPLD_SDINV_H.VKBUR == TVBUR.VKBUR
  • FIPLD_SDINV_H.MANDT == TVBUR.MANDT
Sales Organization
  • FIPLD_SDINV_H.MANDT == TVKO.MANDT
  • FIPLD_SDINV_H.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • FIPLD_SDINV_H.VTWEG == TVTW.VTWEG
  • FIPLD_SDINV_H.MANDT == TVTW.MANDT