0PPS_FPIA_IOA_LITEM_OC

IoA line item open/cleared docs | #TRAN | Extraction method: F1 | Delta: AIE | Component: Interest on Arrears for France
Tables used: BKPF, FPIA_INTEREST, T001, GLFUNCT, KNB4 ... +5 more
Column Name Description
CLIENT Client
BUKRS Company Code
KKBER Credit control area
GJAHR Fiscal Year
Column Name Description
💲 Currency key of the local currency (LCURR):
DMSOL Debit Amount in Local Currency
DMHAB Credit Amount in Local Currency
DMSHB Amount in Local Currency with +/- Signs
SKNTO Cash Discount Amount in Local Currency
DMBTR Amount in local currency
💲 Currency Key (WAERS):
WRBTR Amount in document currency
WSKTO Cash Discount Amount in Document Currency
WRSOL Debit Amount in Document Currency
WRSHB Foreign Currency Amount with Signs (+/-)
WRHAB Credit Amount in Document Currency
💲 Currency Key of Second Local Currency (HWAE2):
DMSO2 Debit Amount in Second Local Currency
DMSH2 Amount in Second Local Currency with +/- Sign
DMHA2 Credit Amount in Second Local Currency
DMBE2 Amount in Second Local Currency or Global Currency
💲 Currency Key of Third Local Currency (HWAE3):
DMSO3 Debit Amount in Third Local Currency
DMHA3 Credit Amount in Third Local Currency
DMSH3 Amount in Third Local Currency with +/- Sign
DMBE3 Amount in Third Local Currency or First Freely-Def. Currency
Column Name Description
Column Name Description
BLDAT Document Date in Document
BUDAT Posting Date in the Document
CPUDT Day On Which Accounting Document Was Entered
AUGDT Clearing Date
NETDT Net Due Date
SK1DT Due Date for Cash Discount 1
SK2DT Due Date for Cash Discount 2
ZFBDT Baseline Date for Due Date Calculation
BUDAT_MM Posting Date in the Document
REINDAT Invoice Receipt Date
AEDAT Last Changed On
Column Name Description
KOART Account type Show values
XNEGP Indicator: Negative Posting Show values
SHKZG Debit/Credit Indicator Show values
FPIA_DTYPE Document Type Show values
LINE_TYPE Line type of FI-documents Show values
Column Name Description Domain name
GSBER Business Area GSBER
FISCPER Fiscal year / period RSFISCPER
BELNR_FI Accounting Document Number BELNR
BUZEI_FI Number of Line Item Within Accounting Document BUZEI
UPOSZ Subitem Number SPOSN
LIFNR Account Number of Supplier LIFNR
UMSKZ Special G/L Indicator UMSKZ
BLART Document Type BLART
BSCHL Posting Key BSCHL
FISCVAR Fiscal year variant RSFISCVAR
ZBD1T Cash discount days 1 ZBDXT
ZBD2T Cash discount days 2 ZBDXT
ZBD3T Net Payment Terms Period ZBDXT
ZBD1P Cash discount percentage 1 PRZ23
ZBD2P Cash Discount Percentage 2 PRZ23
LAND1 Country/Region Key LAND1
ZLSCH Payment Method ZLSCH
ZTERM Terms of payment key ZTERM
ZLSPR Payment Block Key ZAHLS
RSTGR Reason Code for Payments RSTGR
KTOPL Chart of Accounts KTOPL
HKONT General Ledger Account SAKNR
SAKNR G/L Account Number SAKNR
FILKD Account Number of the Branch MAXKK
AUGBL Document Number of the Clearing Document BELNR
XBLNR Reference Document Number XBLNR
BELNR_MM Document Number of an Invoice Document BELNR
BUZEI_MM Document Item in Invoice Document NUMC6
REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
REBZZ Line Item in the Relevant Invoice BUZEI
VBELN Sales and Distribution Document Number VBELN
XREF1 Business Partner Reference Key CHAR12
XREF2 Business Partner Reference Key CHAR12
XREF3 Reference key for line item CHAR20
SGTXT Item Text TEXT50
UMSKS Special G/L Transaction Type UMSKS
ZUONR Assignment Number ZUONR
FIPOS Commitment Item FIPOS
MEASURE Funded Program FM_MEASURE
FISTL Funds Center FISTL
FIKRS Financial Management Area FIKRS
ANLN1 Main Asset Number ANLN1
ANLN2 Asset Subnumber ANLN2
AWTYP Reference procedure AWTYP
AWKEY Reference Key AWKEY
MONAT Fiscal period MONAT
PROJK Work Breakdown Structure Element (WBS Element) PS_POSNR
GEBER Fund BP_GEBER
FPIA_DOCN Document Number of an Invoice Document BELNR
FPIA_LITM Number of Line Item Within Accounting Document BUZEI
AETIM null CHAR04
BSTA1 Requirements status key CHAR1
BSTA2 Requirements status key CHAR1
BSTA3 Requirements status key CHAR1