P_FINS_GL_OPENITEMS

GL Open Items select to clearing | view: PFINSGLOPENITEMS | Extraction: Not supported | Component: Posting/Clearing
Tables used: ACDOCA, BKPF, SKB1, T001, FINSC_LEDGER, FAGL_TLDGRP_MAP
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
AccountingDocumentItem Reference Document Line Item
Column Name Description
AmountInTransCrcy Amount in Transaction Currency
AmountInTransCrcyWithNoSign null
AmountInCoCodeCrcy Amount in Company Code Currency
AmountInCoCodeCrcyWithNoSign null
AmountInFunctCrcyWithNoSign null
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
Column Name Description
Column Name Description
DocumentDate Document Date in Document
PostingDate Posting Date in the Document
ValueDate Value date
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
FinancialAccountType Account type Show values
AccountingDocumentCategory Document Status Show values
Column Name Description Domain name
tmpid Temporary Accounting Document ID FDC_ACCDOC_TMP_DOC_ID
AssignmentReference Assignment number ZUONR
DocumentItemText Item Text TEXT50
FollowOnDocumentType Follow-On Document Type REBZT
InvoiceItemReference Line Item in the Relevant Invoice BUZEI
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
InvoiceReferenceFiscalYear Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
FiscalPeriod Fiscal period MONAT
CompanyCodeName Name of Company Code or Company TEXT25
IsOpenItemManaged null
ClearingIsLedgerGroupSpecific null
Reference1IDByBusinessPartner Business Partner Reference Key CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key CHAR12
Reference3IDByBusinessPartner Reference key for line item CHAR20
DocumentReference Reference Document Number XBLNR1
AccountingDocumentHeaderText Document Header Text TEXT25
GLAccountAuthorizationGroup Authorization Group BRGRU
Cheque Check number CHCKN
PaymentReference Document Number of the Payment Document BELNR
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • P_FINS_GL_OPENITEMS.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_FINS_GL_OPENITEMS.MANDT == T003.MANDT
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_FINS_GL_OPENITEMS.MANDT == TCURC.MANDT
  • P_FINS_GL_OPENITEMS.BALANCETRANSCRCY == TCURC.WAERS
Business Area
  • Client
  • Business Area
  • P_FINS_GL_OPENITEMS.MANDT == TGSB.MANDT
  • P_FINS_GL_OPENITEMS.BUSINESSAREA == TGSB.GSBER
Company Code
  • Company Code
  • Client
  • P_FINS_GL_OPENITEMS.COMPANYCODE == T001.BUKRS
  • P_FINS_GL_OPENITEMS.MANDT == T001.MANDT
Equity group
  • Joint venture
  • ?
  • Client
  • Equity group
  • P_FINS_GL_OPENITEMS.JOINTVENTURE == T8JF.VNAME
  • P_FINS_GL_OPENITEMS.[column in domain "BUKRS"] == T8JF.BUKRS
  • P_FINS_GL_OPENITEMS.MANDT == T8JF.MANDT
  • P_FINS_GL_OPENITEMS.EQUITYGROUP == T8JF.EGRUP
Transaction type
  • Client
  • Transaction type
  • P_FINS_GL_OPENITEMS.MANDT == T856.MANDT
  • P_FINS_GL_OPENITEMS.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Functional Area
  • Client
  • P_FINS_GL_OPENITEMS.FUNCTIONALAREA == TFKB.FKBER
  • P_FINS_GL_OPENITEMS.MANDT == TFKB.MANDT
Functional Currency
  • Functional Currency
  • Client
  • P_FINS_GL_OPENITEMS.FUNCTIONALCURRENCY == TCURC.WAERS
  • P_FINS_GL_OPENITEMS.MANDT == TCURC.MANDT
Account Number
  • Account Number
  • Company Code
  • Client
  • P_FINS_GL_OPENITEMS.GENERALLEDGERACCOUNT == SKB1.SAKNR
  • P_FINS_GL_OPENITEMS.COMPANYCODE == SKB1.BUKRS
  • P_FINS_GL_OPENITEMS.MANDT == SKB1.MANDT
Short Key for a House Bank
  • Short Key for a House Bank
  • ?
  • Client
  • P_FINS_GL_OPENITEMS.HOUSEBANK == T012.HBKID
  • P_FINS_GL_OPENITEMS.[column in domain "BUKRS"] == T012.BUKRS
  • P_FINS_GL_OPENITEMS.MANDT == T012.MANDT
ID for Account Details
  • Short Key for a House Bank
  • ?
  • Client
  • ID for Account Details
  • P_FINS_GL_OPENITEMS.HOUSEBANK == T012K.HBKID
  • P_FINS_GL_OPENITEMS.[column in domain "BUKRS"] == T012K.BUKRS
  • P_FINS_GL_OPENITEMS.MANDT == T012K.MANDT
  • P_FINS_GL_OPENITEMS.HOUSEBANNKACCOUNT == T012K.HKTID
Joint venture
  • Joint venture
  • ?
  • Client
  • P_FINS_GL_OPENITEMS.JOINTVENTURE == T8JV.VNAME
  • P_FINS_GL_OPENITEMS.[column in domain "BUKRS"] == T8JV.BUKRS
  • P_FINS_GL_OPENITEMS.MANDT == T8JV.MANDT
Ledger Group
  • Ledger Group
  • Client
Order Number
  • Client
  • Order Number
  • P_FINS_GL_OPENITEMS.MANDT == AUFK.MANDT
  • P_FINS_GL_OPENITEMS.ORDERS == AUFK.AUFNR
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_FINS_GL_OPENITEMS.PARTNERCOMPANY == T880.RCOMP
  • P_FINS_GL_OPENITEMS.MANDT == T880.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • P_FINS_GL_OPENITEMS.PARTNERPROFITCENTER == FAGL_SEGM.SEGMENT
  • P_FINS_GL_OPENITEMS.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • P_FINS_GL_OPENITEMS.MANDT == FAGL_SEGM.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • P_FINS_GL_OPENITEMS.PARTNERPROFITCENTER == FAGL_SEGM.SEGMENT
  • P_FINS_GL_OPENITEMS.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • P_FINS_GL_OPENITEMS.MANDT == FAGL_SEGM.MANDT
Plant
  • Client
  • Plant
  • P_FINS_GL_OPENITEMS.MANDT == T001W.MANDT
  • P_FINS_GL_OPENITEMS.PLANT == T001W.WERKS
Profit Center
  • ?
  • Client
  • ?
  • Profit Center
  • P_FINS_GL_OPENITEMS.[column in domain "DATBI"] == CEPC.DATBI
  • P_FINS_GL_OPENITEMS.MANDT == CEPC.MANDT
  • P_FINS_GL_OPENITEMS.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_FINS_GL_OPENITEMS.PROFITCENTER == CEPC.PRCTR
Recovery Indicator
  • ?
  • Client
  • Recovery Indicator
  • P_FINS_GL_OPENITEMS.[column in domain "BUKRS"] == T8JJ.BUKRS
  • P_FINS_GL_OPENITEMS.MANDT == T8JJ.MANDT
  • P_FINS_GL_OPENITEMS.RECOVERYINDICATOR == T8JJ.RECID
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_FINS_GL_OPENITEMS.MANDT == FAGL_SEGM.MANDT
  • P_FINS_GL_OPENITEMS.SEGMENT == FAGL_SEGM.SEGMENT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • P_FINS_GL_OPENITEMS.TAXCODE == T007A.MWSKZ
  • P_FINS_GL_OPENITEMS.[column in domain "KALSM_D"] == T007A.KALSM
  • P_FINS_GL_OPENITEMS.MANDT == T007A.MANDT
Currency Key
  • Currency Key
  • Client
  • P_FINS_GL_OPENITEMS.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_FINS_GL_OPENITEMS.MANDT == TCURC.MANDT