C_JP_MachineLearningOpenItem

Machine Learning Open Receivable Items | view: CJPMLOPNITM | Extraction: Not supported | Component: Financials Japan
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
TaxAmountInCoCodeCrcy Signed Tax Amount in Company Code Currency
CashDiscountAmtInCoCodeCrcy Cash Discount Amount in Company Code Currency
💲 Currency Key (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
TaxAmount Tax Amount in Transaction Currency
CashDiscountAmount Cash Discount Amount
Column Name Description
Column Name Description
PostingDate Posting Date
ClearingDate Clearing Date
NetDueDate Due Date for Net Payment
CashDiscount1DueDate Due Date for Cash Discount 1
CashDiscount2DueDate Cash Discount 2 Due Date
DueCalculationBaseDate Due Calculation Base Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
DocumentReferenceID Document Reference ID XBLNR1
AccountingDocumentHeaderText Document Header Text TEXT25
AssignmentReference Assignment Reference ZUONR
PaymentReference Payment Reference CHAR30
BillingDocument Billing Document VBELN
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
ClearingAccountingDocument Clearing Journal Entry BELNR
DocumentItemText Item Text TEXT50
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
FollowOnDocumentType Follow-On Document Type REBZT
Debtor Customer Number KUNNR
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
CityName City TEXT35
BusinessPartnerCountry Country/Region Key LAND1
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
InvcSmmryPayer Invoice Summary Payer ISJPINVSUMPAYER
InvcSmmryPayerName Name of Customer TEXT80
InvcSmmryRecipient Customer Number KUNNR
InvcSmmryRecipientName Name of Customer TEXT80
AlternativePayerName1 Alternative Name for Payer
AlternativePayerName2 Alternative Name for Payer
AlternativePayerName3 Alternative Name for Payer
AlternativePayerName4 Alternative Name for Payer
AlternativeBankName1 Counter Party Bank Name CHAR15
AlternativeBankName2 Counter Party Bank Name CHAR15
AlternativeBankName3 Counter Party Bank Name CHAR15
AlternativeBankName4 Counter Party Bank Name CHAR15
AlternativeBankBranchName1 Counter Party Bank Branch Name CHAR15
AlternativeBankBranchName2 Counter Party Bank Branch Name CHAR15
AlternativeBankBranchName3 Counter Party Bank Branch Name CHAR15
AlternativeBankBranchName4 Counter Party Bank Branch Name CHAR15
InvcSmmryVirtualAcctNo Virtual Account Number ISJPVIRTACCTNR
InvcSmmryMonthlyInvc Invoice Summary Number ISJPINVSUMNR
InvcSmmryPayerInvc Invoice Summary Payer Invoice ISJPINVSUMNR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_JP_MACHINELEARNINGOPENITEM.MANDT == T003.MANDT
  • C_JP_MACHINELEARNINGOPENITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Account Number of an Alternative Payer
  • Client
  • Account Number of an Alternative Payer
  • C_JP_MACHINELEARNINGOPENITEM.MANDT == KNA1.MANDT
  • C_JP_MACHINELEARNINGOPENITEM.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
Bank Keys
  • Client
  • Country/Region Key of Bank
  • Bank Keys
  • C_JP_MACHINELEARNINGOPENITEM.MANDT == BNKA.MANDT
  • C_JP_MACHINELEARNINGOPENITEM.BANKCOUNTRY == BNKA.BANKS
  • C_JP_MACHINELEARNINGOPENITEM.BANK == BNKA.BANKL
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • C_JP_MACHINELEARNINGOPENITEM.MANDT == T005.MANDT
  • C_JP_MACHINELEARNINGOPENITEM.BANKCOUNTRY == T005.LAND1
Account number of an alternative payer
  • Client
  • Account number of an alternative payer
  • C_JP_MACHINELEARNINGOPENITEM.MANDT == KNA1.MANDT
  • C_JP_MACHINELEARNINGOPENITEM.COCODEALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
Company Code
  • Client
  • Company Code
  • C_JP_MACHINELEARNINGOPENITEM.MANDT == T001.MANDT
  • C_JP_MACHINELEARNINGOPENITEM.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • C_JP_MACHINELEARNINGOPENITEM.MANDT == T005.MANDT
  • C_JP_MACHINELEARNINGOPENITEM.COUNTRY == T005.LAND1
G/L Account
  • G/L Account
  • Client
  • Company Code
  • C_JP_MACHINELEARNINGOPENITEM.GLACCOUNT == SKB1.SAKNR
  • C_JP_MACHINELEARNINGOPENITEM.MANDT == SKB1.MANDT
  • C_JP_MACHINELEARNINGOPENITEM.COMPANYCODE == SKB1.BUKRS
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_JP_MACHINELEARNINGOPENITEM.MANDT == T880.MANDT
  • C_JP_MACHINELEARNINGOPENITEM.PARTNERCOMPANY == T880.RCOMP
Payment Method
  • Client
  • Payment Method
  • Country/Region Key
  • C_JP_MACHINELEARNINGOPENITEM.MANDT == T042Z.MANDT
  • C_JP_MACHINELEARNINGOPENITEM.PAYMENTMETHOD == T042Z.ZLSCH
  • C_JP_MACHINELEARNINGOPENITEM.COUNTRY == T042Z.LAND1
Currency Key
  • Client
  • Currency Key
  • C_JP_MACHINELEARNINGOPENITEM.MANDT == TCURC.MANDT
  • C_JP_MACHINELEARNINGOPENITEM.TRANSACTIONCURRENCY == TCURC.WAERS