C_JP_MachineLearningOpenItem

DDL: C_JP_MACHINELEARNINGOPENITEM SQL: CJPMLOPNITM Type: view CONSUMPTION
67 Fields 2 Data Sources 5 Associations

Machine Learning Open Receivable Items

C_JP_MachineLearningOpenItem is a Consumption CDS View that provides data about "Machine Learning Open Receivable Items" in SAP S/4HANA. It reads from 2 data sources (I_JournalEntry, I_OperationalAcctgDocItem) and exposes 67 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. It has 5 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_JournalEntry _AccDocHdr from
I_OperationalAcctgDocItem _AccDocItm inner

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer _AccDocItm.Customer = _Customer.Customer
[0..1] I_Supplier _Supplier _AccDocItm.Supplier = _Supplier.Supplier
[0..1] I_CompanyCode _CompanyCode _AccDocHdr.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_CustomerCompany _CustCompany _AccDocItm.Customer = _CustCompany.Customer and _AccDocItm.CompanyCode = _CustCompany.CompanyCode
[1..1] I_JP_InvcSummaryMchnLrngItem _InvcSmmryItem _AccDocItm.AccountingDocument = _InvcSmmryItem.AccountingDocument and _AccDocItm.AccountingDocumentItem = _InvcSmmryItem.AccountingDocumentItem and _AccDocItm.CompanyCode = _InvcSmmryItem.CompanyCode and _AccDocItm.FiscalYear = _InvcSmmryItem.FiscalYear

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CJPMLOPNITM view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Machine Learning Open Receivable Items view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode Receiver Company Code
KEY FiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntry AccountingDocument Journal Entry
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
Country _CompanyCode Country Venue: Ctry/Reg
AccountingDocumentType I_JournalEntry AccountingDocumentType Journal Entry Type
PostingDate I_JournalEntry PostingDate Posting Date for GR
DocumentReferenceID I_JournalEntry DocumentReferenceID Reference
CompanyCodeCurrency I_JournalEntry CompanyCodeCurrency Local Currency
TransactionCurrency I_JournalEntry TransactionCurrency Transaction Currency
AccountingDocumentHeaderText I_JournalEntry AccountingDocumentHeaderText Doc.Header Text
AssignmentReference I_OperationalAcctgDocItem AssignmentReference Assignment Reference
PaymentReference I_OperationalAcctgDocItem PaymentReference Payment Reference
BillingDocument I_OperationalAcctgDocItem BillingDocument SD Document
ClearingDocFiscalYear I_OperationalAcctgDocItem ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
ClearingJournalEntryFiscalYear I_OperationalAcctgDocItem ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
ClearingAccountingDocument I_OperationalAcctgDocItem ClearingAccountingDocument Clearing Journal Entry
ClearingJournalEntry I_OperationalAcctgDocItem ClearingJournalEntry Clrng doc.
ClearingDate I_OperationalAcctgDocItem ClearingDate Clearing Date
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency Local Crcy Amt
AmountInTransactionCurrency I_OperationalAcctgDocItem AmountInTransactionCurrency Pt Crcy Amt
TaxAmountInCoCodeCrcy I_OperationalAcctgDocItem TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxAmount I_OperationalAcctgDocItem TaxAmount Tax Amt in Rptg Crcy
CashDiscountAmtInCoCodeCrcy I_OperationalAcctgDocItem CashDiscountAmtInCoCodeCrcy Discount Amt
CashDiscountAmount I_OperationalAcctgDocItem CashDiscountAmount CD Amount
DebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
DocumentItemText I_OperationalAcctgDocItem DocumentItemText Text
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
InvoiceReference I_OperationalAcctgDocItem InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference I_OperationalAcctgDocItem InvoiceItemReference Item
FollowOnDocumentType I_OperationalAcctgDocItem FollowOnDocumentType Follow-On Document Type
CustomerendasDebtor
CityNameendasCityName
CountryendasBusinessPartnerCountry
PartnerCompany I_OperationalAcctgDocItem PartnerCompany Trading Partner
NetDueDate I_OperationalAcctgDocItem NetDueDate Net Due Date
CashDiscount1Percent I_OperationalAcctgDocItem CashDiscount1Percent Disc. Percent 1
CashDiscount1DueDate I_OperationalAcctgDocItem CashDiscount1DueDate Cash Discount 1
CashDiscount2Percent I_OperationalAcctgDocItem CashDiscount2Percent Disc. Percent 2
CashDiscount2DueDate I_OperationalAcctgDocItem CashDiscount2DueDate Cash Discount 2
DueCalculationBaseDate I_OperationalAcctgDocItem DueCalculationBaseDate Due Calculation Base Date
PaymentMethod I_OperationalAcctgDocItem PaymentMethod Pymt Meth.
GLAccount I_OperationalAcctgDocItem GLAccount General Ledger
AlternativePayerAccount _Customer AlternativePayerAccount Alternat.payer
CoCodeAlternativePayerAccount _CustCompany AlternativePayerAccount Alternat.payer
InvcSmmryPayer _InvcSmmryItem InvcSmmryPayer
InvcSmmryPayerName _InvcSmmryItem InvcSmmryPayerName
InvcSmmryRecipient _InvcSmmryItem InvcSmmryRecipient
InvcSmmryRecipientName _InvcSmmryItem InvcSmmryRecipientName
AlternativePayerName1 _InvcSmmryItem AlternativePayerName1
AlternativePayerName2 _InvcSmmryItem AlternativePayerName2
AlternativePayerName3 _InvcSmmryItem AlternativePayerName3
AlternativePayerName4 _InvcSmmryItem AlternativePayerName4
AlternativeBankName1 _InvcSmmryItem AlternativeBankName1
AlternativeBankName2 _InvcSmmryItem AlternativeBankName2
AlternativeBankName3 _InvcSmmryItem AlternativeBankName3
AlternativeBankName4 _InvcSmmryItem AlternativeBankName4
AlternativeBankBranchName1 _InvcSmmryItem AlternativeBankBranchName1
AlternativeBankBranchName2 _InvcSmmryItem AlternativeBankBranchName2
AlternativeBankBranchName3 _InvcSmmryItem AlternativeBankBranchName3
AlternativeBankBranchName4 _InvcSmmryItem AlternativeBankBranchName4
InvcSmmryVirtualAcctNo _InvcSmmryItem InvcSmmryVirtualAcctNo
Bank _InvcSmmryItem Bank Bank Number
BankCountry _InvcSmmryItem BankCountry Bank Ctry/Rgn. Key
InvcSmmryMonthlyInvc _InvcSmmryItem InvcSmmryMonthlyInvc
InvcSmmryPayerInvc _InvcSmmryItem InvcSmmryPayerInvc

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_JP_MachineLearningOpenItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CJPMLOPNITM

CREATE VIEW C_JP_MachineLearningOpenItem AS
SELECT
  _AccDocHdr.CompanyCode AS CompanyCode,
  _AccDocHdr.FiscalYear AS FiscalYear,
  _AccDocHdr.AccountingDocument AS AccountingDocument,
  _AccDocItm.AccountingDocumentItem AS AccountingDocumentItem,
  _CompanyCode.Country AS Country,
  _AccDocHdr.AccountingDocumentType AS AccountingDocumentType,
  _AccDocHdr.PostingDate AS PostingDate,
  _AccDocHdr.DocumentReferenceID AS DocumentReferenceID,
  _AccDocHdr.CompanyCodeCurrency AS CompanyCodeCurrency,
  _AccDocHdr.TransactionCurrency AS TransactionCurrency,
  _AccDocHdr.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  _AccDocItm.AssignmentReference AS AssignmentReference,
  _AccDocItm.PaymentReference AS PaymentReference,
  _AccDocItm.BillingDocument AS BillingDocument,
  _AccDocItm.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  _AccDocItm.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  _AccDocItm.ClearingAccountingDocument AS ClearingAccountingDocument,
  _AccDocItm.ClearingJournalEntry AS ClearingJournalEntry,
  _AccDocItm.ClearingDate AS ClearingDate,
  _AccDocItm.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _AccDocItm.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _AccDocItm.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  _AccDocItm.TaxAmount AS TaxAmount,
  _AccDocItm.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  _AccDocItm.CashDiscountAmount AS CashDiscountAmount,
  _AccDocItm.DebitCreditCode AS DebitCreditCode,
  _AccDocItm.DocumentItemText AS DocumentItemText,
  _AccDocItm.FinancialAccountType AS FinancialAccountType,
  _AccDocItm.InvoiceReference AS InvoiceReference,
  _AccDocItm.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  _AccDocItm.InvoiceItemReference AS InvoiceItemReference,
  _AccDocItm.FollowOnDocumentType AS FollowOnDocumentType,
  case when _AccDocItm.FinancialAccountType='K' then _AccDocItm.Supplier else _AccDocItm.Customer end as Debtor AS CustomerendasDebtor,
  case when _AccDocItm.FinancialAccountType='K' then _Supplier.CityName else _Customer.CityName end as CityName AS CityNameendasCityName,
  case when _AccDocItm.FinancialAccountType='K' then _Supplier.Country else _Customer.Country end as BusinessPartnerCountry AS CountryendasBusinessPartnerCountry,
  _AccDocItm.PartnerCompany AS PartnerCompany,
  _AccDocItm.NetDueDate AS NetDueDate,
  _AccDocItm.CashDiscount1Percent AS CashDiscount1Percent,
  _AccDocItm.CashDiscount1DueDate AS CashDiscount1DueDate,
  _AccDocItm.CashDiscount2Percent AS CashDiscount2Percent,
  _AccDocItm.CashDiscount2DueDate AS CashDiscount2DueDate,
  _AccDocItm.DueCalculationBaseDate AS DueCalculationBaseDate,
  _AccDocItm.PaymentMethod AS PaymentMethod,
  _AccDocItm.GLAccount AS GLAccount,
  _Customer.AlternativePayerAccount AS AlternativePayerAccount,
  _CustCompany.AlternativePayerAccount AS CoCodeAlternativePayerAccount,
  _InvcSmmryItem.InvcSmmryPayer AS InvcSmmryPayer,
  _InvcSmmryItem.InvcSmmryPayerName AS InvcSmmryPayerName,
  _InvcSmmryItem.InvcSmmryRecipient AS InvcSmmryRecipient,
  _InvcSmmryItem.InvcSmmryRecipientName AS InvcSmmryRecipientName,
  _InvcSmmryItem.AlternativePayerName1 AS AlternativePayerName1,
  _InvcSmmryItem.AlternativePayerName2 AS AlternativePayerName2,
  _InvcSmmryItem.AlternativePayerName3 AS AlternativePayerName3,
  _InvcSmmryItem.AlternativePayerName4 AS AlternativePayerName4,
  _InvcSmmryItem.AlternativeBankName1 AS AlternativeBankName1,
  _InvcSmmryItem.AlternativeBankName2 AS AlternativeBankName2,
  _InvcSmmryItem.AlternativeBankName3 AS AlternativeBankName3,
  _InvcSmmryItem.AlternativeBankName4 AS AlternativeBankName4,
  _InvcSmmryItem.AlternativeBankBranchName1 AS AlternativeBankBranchName1,
  _InvcSmmryItem.AlternativeBankBranchName2 AS AlternativeBankBranchName2,
  _InvcSmmryItem.AlternativeBankBranchName3 AS AlternativeBankBranchName3,
  _InvcSmmryItem.AlternativeBankBranchName4 AS AlternativeBankBranchName4,
  _InvcSmmryItem.InvcSmmryVirtualAcctNo AS InvcSmmryVirtualAcctNo,
  _InvcSmmryItem.Bank AS Bank,
  _InvcSmmryItem.BankCountry AS BankCountry,
  _InvcSmmryItem.InvcSmmryMonthlyInvc AS InvcSmmryMonthlyInvc,
  _InvcSmmryItem.InvcSmmryPayerInvc AS InvcSmmryPayerInvc
FROM I_JournalEntry AS _AccDocHdr
INNER JOIN I_OperationalAcctgDocItem AS _AccDocItm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON _AccDocItm.Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _AccDocItm.Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _AccDocHdr.CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustCompany ON _AccDocItm.Customer = _CustCompany.Customer AND _AccDocItm.CompanyCode = _CustCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JP_InvcSummaryMchnLrngItem AS _InvcSmmryItem ON _AccDocItm.AccountingDocument = _InvcSmmryItem.AccountingDocument AND _AccDocItm.AccountingDocumentItem = _InvcSmmryItem.AccountingDocumentItem AND _AccDocItm.CompanyCode = _InvcSmmryItem.CompanyCode AND _AccDocItm.FiscalYear = _InvcSmmryItem.FiscalYear  -- association [1..1]
;

Learn More