P_OpenAccountsReceivables2_NSJ

Open Accounts Receivables for SMB Apps 2 No Self-Join | view: POPENACCTRBLS2N | Extraction: Not supported | Component: Information System
Tables used: BSEGT001TKA02T001T014
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
AccountingDocumentItem Posting View Item
FiscalYear Fiscal Year
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
DueCalculationBaseDate Due Calculation Base Date
RefInvcDocumentDate Journal Entry Date
RefInvcDueCalculationBaseDate Due Calculation Base Date
RefInvcNetDueDate Due Date for Net Payment
NetDueDate Due Date for Net Payment
Column Name Description
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
RefInvcFinancialAccountType Account Type Show values
RefInvcDebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
InvoiceItemReference Line Item BUZEI
InvoiceReferenceFiscalYear Fiscal Year GJAHR
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount2Days Cash Discount Days 2 ZBDXT
CashDiscount1Days Cash Discount Days 1 ZBDXT
FollowOnDocumentType Follow-On Document Type REBZT
SpecialGLTransactionType Special G/L Transaction Type UMSKS
RefInvcNetPaymentDays Net Payment Terms Period ZBDXT
RefInvcCashDiscount2Days Cash Discount Days 2 ZBDXT
RefInvcCashDiscount1Days Cash Discount Days 1 ZBDXT
RefInvcInvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
NumberOfOpenItems Number of Open Items FARP_NUMBER_OF_OPEN_ITEMS
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_OPENACCOUNTSRECEIVABLES2_NSJ.COMPANYCODE == T001.BUKRS
  • P_OPENACCOUNTSRECEIVABLES2_NSJ.MANDT == T001.MANDT
Credit Control Area
  • Credit Control Area
  • Client
  • P_OPENACCOUNTSRECEIVABLES2_NSJ.CREDITCONTROLAREA == T014.KKBER
  • P_OPENACCOUNTSRECEIVABLES2_NSJ.MANDT == T014.MANDT
Customer
  • Customer
  • Client
  • P_OPENACCOUNTSRECEIVABLES2_NSJ.CUSTOMER == KNA1.KUNNR
  • P_OPENACCOUNTSRECEIVABLES2_NSJ.MANDT == KNA1.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_OPENACCOUNTSRECEIVABLES2_NSJ.COMPANYCODE == SKB1.BUKRS
  • P_OPENACCOUNTSRECEIVABLES2_NSJ.GLACCOUNT == SKB1.SAKNR
  • P_OPENACCOUNTSRECEIVABLES2_NSJ.MANDT == SKB1.MANDT
Special G/L Indicator
  • ?
  • Special G/L Indicator
  • Client
  • P_OPENACCOUNTSRECEIVABLES2_NSJ.[column in domain "KOART"] == T074U.KOART
  • P_OPENACCOUNTSRECEIVABLES2_NSJ.SPECIALGLCODE == T074U.UMSKZ
  • P_OPENACCOUNTSRECEIVABLES2_NSJ.MANDT == T074U.MANDT