P_APJrnlEntrItmOpenPay1

P_APJrnlEntrItmOpenPay1 | view: PAPJEITMOPNPAY1 | Extraction: Not supported | Component: Information System
Tables used: ACDOCABKPFBSEGT001TKA02PROJPRPST001T014FINSC_LEDGER_REP
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
ClearingDate Clearing Date
PostingDate Posting Date
DocumentDate Journal Entry Date
NetDueDate Net Due Date
RefInvcDocumentDate Journal Entry Date
RefInvcNetDueDate Due Date for Net Payment
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
FinancialAccountType Account Type Show values
RefInvcFinancialAccountType Account Type Show values
RefInvcDebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
InvoiceReference Invoice Reference BELNR
InvoiceItemReference Invoice Item Reference BUZEI
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
FollowOnDocumentType Follow-On Document Type REBZT
AssignmentReference Assignment Reference ZUONR
RefInvcNetPaymentDays Net Payment Terms Period ZBDXT
RefInvcInvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_APJRNLENTRITMOPENPAY1.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_APJRNLENTRITMOPENPAY1.MANDT == T003.MANDT
Business Area
  • Business Area
  • Client
  • P_APJRNLENTRITMOPENPAY1.BUSINESSAREA == TGSB.GSBER
  • P_APJRNLENTRITMOPENPAY1.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • P_APJRNLENTRITMOPENPAY1.COMPANYCODE == T001.BUKRS
  • P_APJRNLENTRITMOPENPAY1.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_APJRNLENTRITMOPENPAY1.COMPANYCODECURRENCY == TCURC.WAERS
  • P_APJRNLENTRITMOPENPAY1.MANDT == TCURC.MANDT
Cost Center
  • Cost Center
  • ?
  • ?
  • Client
  • P_APJRNLENTRITMOPENPAY1.COSTCENTER == CSKS.KOSTL
  • P_APJRNLENTRITMOPENPAY1.[column in domain "DATBI"] == CSKS.DATBI
  • P_APJRNLENTRITMOPENPAY1.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_APJRNLENTRITMOPENPAY1.MANDT == CSKS.MANDT
Functional Area
  • Client
  • Functional Area
  • P_APJRNLENTRITMOPENPAY1.MANDT == TFKB.MANDT
  • P_APJRNLENTRITMOPENPAY1.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_APJRNLENTRITMOPENPAY1.COMPANYCODE == SKB1.BUKRS
  • P_APJRNLENTRITMOPENPAY1.GLACCOUNT == SKB1.SAKNR
  • P_APJRNLENTRITMOPENPAY1.MANDT == SKB1.MANDT
Profit Center
  • Profit Center
  • ?
  • ?
  • Client
  • P_APJRNLENTRITMOPENPAY1.PROFITCENTER == CEPC.PRCTR
  • P_APJRNLENTRITMOPENPAY1.[column in domain "DATBI"] == CEPC.DATBI
  • P_APJRNLENTRITMOPENPAY1.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_APJRNLENTRITMOPENPAY1.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_APJRNLENTRITMOPENPAY1.SEGMENT == FAGL_SEGM.SEGMENT
  • P_APJRNLENTRITMOPENPAY1.MANDT == FAGL_SEGM.MANDT
Special G/L Indicator
  • Account Type
  • Account Type
  • Special G/L Indicator
  • Client
  • P_APJRNLENTRITMOPENPAY1.FINANCIALACCOUNTTYPE == T074U.KOART
  • P_APJRNLENTRITMOPENPAY1.REFINVCFINANCIALACCOUNTTYPE == T074U.KOART
  • P_APJRNLENTRITMOPENPAY1.SPECIALGLCODE == T074U.UMSKZ
  • P_APJRNLENTRITMOPENPAY1.MANDT == T074U.MANDT
Supplier
  • Supplier
  • Client
  • P_APJRNLENTRITMOPENPAY1.SUPPLIER == LFA1.LIFNR
  • P_APJRNLENTRITMOPENPAY1.MANDT == LFA1.MANDT