P_ARJrnlEntrItmOpenRec2_WSJ
P_ARJrnlEntrItmOpenRec2_WSJ is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (P_ARJrnlEntrItmOpenRec1, P_ARJrnlEntrItmOpenRec1, P_ReceivablesItem) and exposes 143 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem, FiscalYear.
Data Sources (3)
| Source | Alias | Join Type |
|---|---|---|
| P_ARJrnlEntrItmOpenRec1 | P_ARJrnlEntrItmOpenRec1 | from |
| P_ARJrnlEntrItmOpenRec1 | P_ARJrnlEntrItmOpenRec1 | union_all |
| P_ReceivablesItem | ReferencedInvoices | inner |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_KeyDate | sydate |
Annotations (4)
| Name | Value | Level | Field |
|---|---|---|---|
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view |
Fields (143)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | OpenReceivables | CompanyCode | Receiver Company Code |
| KEY | FiscalYear | OpenReceivables | FiscalYear | G/L Fiscal Year |
| KEY | AccountingDocument | OpenReceivables | AccountingDocument | Journal Entry |
| KEY | LedgerGLLineItem | OpenReceivables | LedgerGLLineItem | Journal Entry Item |
| AccountingDocumentCategory | OpenReceivables | AccountingDocumentCategory | Journal Entry Category | |
| AccountingDocumentType | OpenReceivables | AccountingDocumentType | Journal Entry Type | |
| AccountingDocumentItem | OpenReceivables | AccountingDocumentItem | Posting View Item | |
| InvoiceReference | OpenReceivables | InvoiceReference | Invoice Reference | |
| InvoiceItemReference | OpenReceivables | InvoiceItemReference | Item | |
| InvoiceReferenceFiscalYear | OpenReceivables | InvoiceReferenceFiscalYear | Invoice Reference Fiscal Year | |
| ClearingDate | OpenReceivables | ClearingDate | Clearing Date | |
| PostingDate | OpenReceivables | PostingDate | Posting Date for GR | |
| DocumentDate | OpenReceivables | DocumentDate | Journal Entry Date | |
| FinancialAccountType | OpenReceivables | FinancialAccountType | Fin. Account Type | |
| Customer | OpenReceivables | Customer | Sold-to Party | |
| FollowOnDocumentType | OpenReceivables | FollowOnDocumentType | Follow-On Document Type | |
| SpecialGLCode | OpenReceivables | SpecialGLCode | Special G/L Ind | |
| SpecialGLTransactionType | OpenReceivables | SpecialGLTransactionType | Transact.Type | |
| GLAccount | OpenReceivables | GLAccount | General Ledger | |
| ProfitCenter | OpenReceivables | ProfitCenter | Profit Center | |
| BusinessArea | OpenReceivables | BusinessArea | Business Area | |
| Segment | OpenReceivables | Segment | Segment number | |
| BillingDocument | OpenReceivables | BillingDocument | SD Document | |
| AssignmentReference | OpenReceivables | AssignmentReference | Assignment Reference | |
| CompanyCodeCurrency | OpenReceivables | CompanyCodeCurrency | Local Currency | |
| AmountInCompanyCodeCurrency | OpenReceivables | AmountInCompanyCodeCurrency | Local Crcy Amt | |
| TransactionCurrency | OpenReceivables | TransactionCurrency | Transaction Currency | |
| AmountInTransactionCurrency | OpenReceivables | AmountInTransactionCurrency | Pt Crcy Amt | |
| Reference1IDByBusinessPartner | OpenReceivables | Reference1IDByBusinessPartner | Reference Key 1 | |
| Reference2IDByBusinessPartner | OpenReceivables | Reference2IDByBusinessPartner | Reference Key 2 | |
| Reference3IDByBusinessPartner | OpenReceivables | Reference3IDByBusinessPartner | Reference Key 3 | |
| PaymentMethod | OpenReceivables | PaymentMethod | Pymt Meth. | |
| ChartOfAccounts | OpenReceivables | ChartOfAccounts | Node Class | |
| ControllingArea | OpenReceivables | ControllingArea | Controlling Area | |
| RefInvcDocumentDate | P_ReceivablesItem | DocumentDate | Journal Entry Date | |
| RefInvcFinancialAccountType | P_ReceivablesItem | FinancialAccountType | Fin. Account Type | |
| RefInvcDebitCreditCode | P_ReceivablesItem | DebitCreditCode | Single-Character Flag | |
| RefInvcNetPaymentDays | P_ReceivablesItem | NetPaymentDays | Net Pmt Terms Period | |
| RefInvcInvoiceReference | P_ReceivablesItem | InvoiceReference | Invoice Reference | |
| RefInvcNetDueDate | P_ReceivablesItem | NetDueDate | Net Due Date | |
| NetDueDate | P_ReceivablesItem | NetDueDate | Net Due Date | |
| _Customer | OpenReceivables | _Customer | ||
| _CompanyCode | OpenReceivables | _CompanyCode | ||
| _JournalEntry | OpenReceivables | _JournalEntry | ||
| _SpecialGLCode | OpenReceivables | _SpecialGLCode | ||
| _FinancialAccountType | OpenReceivables | _FinancialAccountType | ||
| _ChartOfAccounts | OpenReceivables | _ChartOfAccounts | ||
| _GLAccountInChartOfAccounts | OpenReceivables | _GLAccountInChartOfAccounts | ||
| _ProfitCenter | OpenReceivables | _ProfitCenter | ||
| CustomerCountry | OpenReceivables | CustomerCountry | ||
| CustomerRegion | OpenReceivables | CustomerRegion | ||
| ReconciliationAccount | OpenReceivables | ReconciliationAccount | Recon. account | |
| CustomerAccountGroup | OpenReceivables | CustomerAccountGroup | Account group | |
| AccountingClerk | OpenReceivables | AccountingClerk | Clerk Abbrev. | |
| Country | OpenReceivables | Country | Venue: Ctry/Reg | |
| CustomerBasicAuthorizationGrp | OpenReceivables | CustomerBasicAuthorizationGrp | ||
| CustomerFinsAuthorizationGrp | OpenReceivables | CustomerFinsAuthorizationGrp | AuthorizGroup | |
| CustomerClassification | OpenReceivables | CustomerClassification | Customer Class. | |
| CustomerAccountNote | OpenReceivables | CustomerAccountNote | Account Memo | |
| CustomerCorporateGroup | OpenReceivables | CustomerCorporateGroup | Group | |
| _FiscalYear | OpenReceivables | _FiscalYear | ||
| _AccountingClerk | OpenReceivables | _AccountingClerk | ||
| _ReconciliationAccount | OpenReceivables | _ReconciliationAccount | ||
| _CustomerAccountGroup | OpenReceivables | _CustomerAccountGroup | ||
| _PaymentMethod | OpenReceivables | _PaymentMethod | ||
| _CustomerCountry | OpenReceivables | _CustomerCountry | ||
| _CustomerRegion | OpenReceivables | _CustomerRegion | ||
| _CustomerCompany | OpenReceivables | _CustomerCompany | ||
| _CurrentProfitCenter | OpenReceivables | _CurrentProfitCenter | ||
| _Country | OpenReceivables | _Country | ||
| _ControllingArea | OpenReceivables | _ControllingArea | ||
| CompanyCodeasCompanyCode | ||||
| KEY | FiscalYear | OpenReceivables | FiscalYear | G/L Fiscal Year |
| KEY | AccountingDocument | OpenReceivables | AccountingDocument | Journal Entry |
| KEY | LedgerGLLineItem | OpenReceivables | LedgerGLLineItem | Journal Entry Item |
| AccountingDocumentCategory | OpenReceivables | AccountingDocumentCategory | Journal Entry Category | |
| AccountingDocumentType | OpenReceivables | AccountingDocumentType | Journal Entry Type | |
| AccountingDocumentItem | OpenReceivables | AccountingDocumentItem | Posting View Item | |
| InvoiceReference | OpenReceivables | InvoiceReference | Invoice Reference | |
| InvoiceItemReference | OpenReceivables | InvoiceItemReference | Item | |
| InvoiceReferenceFiscalYear | OpenReceivables | InvoiceReferenceFiscalYear | Invoice Reference Fiscal Year | |
| ClearingDate | OpenReceivables | ClearingDate | Clearing Date | |
| PostingDate | OpenReceivables | PostingDate | Posting Date for GR | |
| DocumentDate | OpenReceivables | DocumentDate | Journal Entry Date | |
| FinancialAccountType | OpenReceivables | FinancialAccountType | Fin. Account Type | |
| Customer | OpenReceivables | Customer | Sold-to Party | |
| FollowOnDocumentType | OpenReceivables | FollowOnDocumentType | Follow-On Document Type | |
| SpecialGLCode | OpenReceivables | SpecialGLCode | Special G/L Ind | |
| SpecialGLTransactionType | OpenReceivables | SpecialGLTransactionType | Transact.Type | |
| GLAccount | OpenReceivables | GLAccount | General Ledger | |
| ProfitCenter | OpenReceivables | ProfitCenter | Profit Center | |
| BusinessArea | OpenReceivables | BusinessArea | Business Area | |
| Segment | OpenReceivables | Segment | Segment number | |
| BillingDocument | OpenReceivables | BillingDocument | SD Document | |
| AssignmentReference | OpenReceivables | AssignmentReference | Assignment Reference | |
| CompanyCodeCurrency | OpenReceivables | CompanyCodeCurrency | Local Currency | |
| AmountInCompanyCodeCurrency | OpenReceivables | AmountInCompanyCodeCurrency | Local Crcy Amt | |
| TransactionCurrency | OpenReceivables | TransactionCurrency | Transaction Currency | |
| AmountInTransactionCurrency | OpenReceivables | AmountInTransactionCurrency | Pt Crcy Amt | |
| Reference1IDByBusinessPartner | OpenReceivables | Reference1IDByBusinessPartner | Reference Key 1 | |
| Reference2IDByBusinessPartner | OpenReceivables | Reference2IDByBusinessPartner | Reference Key 2 | |
| Reference3IDByBusinessPartner | OpenReceivables | Reference3IDByBusinessPartner | Reference Key 3 | |
| PaymentMethod | OpenReceivables | PaymentMethod | Pymt Meth. | |
| ChartOfAccounts | OpenReceivables | ChartOfAccounts | Node Class | |
| ControllingArea | OpenReceivables | ControllingArea | Controlling Area | |
| RefInvcDocumentDate | P_ReceivablesItem | DocumentDate | Journal Entry Date | |
| RefInvcFinancialAccountType | P_ReceivablesItem | FinancialAccountType | Fin. Account Type | |
| RefInvcDebitCreditCode | P_ReceivablesItem | DebitCreditCode | Single-Character Flag | |
| RefInvcNetPaymentDays | P_ReceivablesItem | NetPaymentDays | Net Pmt Terms Period | |
| RefInvcInvoiceReference | P_ReceivablesItem | InvoiceReference | Invoice Reference | |
| RefInvcNetDueDate | P_ReceivablesItem | NetDueDate | Net Due Date | |
| NetDueDate | OpenReceivables | NetDueDate | Net Due Date | |
| _Customer | OpenReceivables | _Customer | ||
| _CompanyCode | OpenReceivables | _CompanyCode | ||
| _JournalEntry | OpenReceivables | _JournalEntry | ||
| _SpecialGLCode | OpenReceivables | _SpecialGLCode | ||
| _FinancialAccountType | OpenReceivables | _FinancialAccountType | ||
| _ChartOfAccounts | OpenReceivables | _ChartOfAccounts | ||
| _GLAccountInChartOfAccounts | OpenReceivables | _GLAccountInChartOfAccounts | ||
| _ProfitCenter | OpenReceivables | _ProfitCenter | ||
| CustomerCountry | OpenReceivables | CustomerCountry | ||
| CustomerRegion | OpenReceivables | CustomerRegion | ||
| ReconciliationAccount | OpenReceivables | ReconciliationAccount | Recon. account | |
| CustomerAccountGroup | OpenReceivables | CustomerAccountGroup | Account group | |
| AccountingClerk | OpenReceivables | AccountingClerk | Clerk Abbrev. | |
| Country | OpenReceivables | Country | Venue: Ctry/Reg | |
| CustomerBasicAuthorizationGrp | OpenReceivables | CustomerBasicAuthorizationGrp | ||
| CustomerFinsAuthorizationGrp | OpenReceivables | CustomerFinsAuthorizationGrp | AuthorizGroup | |
| CustomerClassification | OpenReceivables | CustomerClassification | Customer Class. | |
| CustomerAccountNote | OpenReceivables | CustomerAccountNote | Account Memo | |
| CustomerCorporateGroup | OpenReceivables | CustomerCorporateGroup | Group | |
| _FiscalYear | OpenReceivables | _FiscalYear | ||
| _AccountingClerk | OpenReceivables | _AccountingClerk | ||
| _ReconciliationAccount | OpenReceivables | _ReconciliationAccount | ||
| _CustomerAccountGroup | OpenReceivables | _CustomerAccountGroup | ||
| _PaymentMethod | OpenReceivables | _PaymentMethod | ||
| _CustomerCountry | OpenReceivables | _CustomerCountry | ||
| _CustomerRegion | OpenReceivables | _CustomerRegion | ||
| _CustomerCompany | OpenReceivables | _CustomerCompany | ||
| _CurrentProfitCenter | OpenReceivables | _CurrentProfitCenter | ||
| _Country | OpenReceivables | _Country | ||
| _ControllingArea | OpenReceivables | _ControllingArea | ||
| _CustomerClassification | OpenReceivables | _CustomerClassification |
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 P_ARJrnlEntrItmOpenRec2_WSJ.
-- 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.
-- Parameters: P_KeyDate : sydate
CREATE VIEW P_ARJrnlEntrItmOpenRec2_WSJ AS
SELECT
OpenReceivables.CompanyCode AS CompanyCode,
OpenReceivables.FiscalYear AS FiscalYear,
OpenReceivables.AccountingDocument AS AccountingDocument,
OpenReceivables.LedgerGLLineItem AS LedgerGLLineItem,
OpenReceivables.AccountingDocumentCategory AS AccountingDocumentCategory,
OpenReceivables.AccountingDocumentType AS AccountingDocumentType,
OpenReceivables.AccountingDocumentItem AS AccountingDocumentItem,
OpenReceivables.InvoiceReference AS InvoiceReference,
OpenReceivables.InvoiceItemReference AS InvoiceItemReference,
OpenReceivables.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
OpenReceivables.ClearingDate AS ClearingDate,
OpenReceivables.PostingDate AS PostingDate,
OpenReceivables.DocumentDate AS DocumentDate,
OpenReceivables.FinancialAccountType AS FinancialAccountType,
OpenReceivables.Customer AS Customer,
OpenReceivables.FollowOnDocumentType AS FollowOnDocumentType,
OpenReceivables.SpecialGLCode AS SpecialGLCode,
OpenReceivables.SpecialGLTransactionType AS SpecialGLTransactionType,
OpenReceivables.GLAccount AS GLAccount,
OpenReceivables.ProfitCenter AS ProfitCenter,
OpenReceivables.BusinessArea AS BusinessArea,
OpenReceivables.Segment AS Segment,
OpenReceivables.BillingDocument AS BillingDocument,
OpenReceivables.AssignmentReference AS AssignmentReference,
OpenReceivables.CompanyCodeCurrency AS CompanyCodeCurrency,
OpenReceivables.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
OpenReceivables.TransactionCurrency AS TransactionCurrency,
OpenReceivables.AmountInTransactionCurrency AS AmountInTransactionCurrency,
OpenReceivables.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
OpenReceivables.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
OpenReceivables.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
OpenReceivables.PaymentMethod AS PaymentMethod,
OpenReceivables.ChartOfAccounts AS ChartOfAccounts,
OpenReceivables.ControllingArea AS ControllingArea,
ReferencedInvoices.DocumentDate AS RefInvcDocumentDate,
ReferencedInvoices.FinancialAccountType AS RefInvcFinancialAccountType,
ReferencedInvoices.DebitCreditCode AS RefInvcDebitCreditCode,
ReferencedInvoices.NetPaymentDays AS RefInvcNetPaymentDays,
ReferencedInvoices.InvoiceReference AS RefInvcInvoiceReference,
ReferencedInvoices.NetDueDate AS RefInvcNetDueDate,
ReferencedInvoices.NetDueDate AS NetDueDate,
OpenReceivables._Customer AS _Customer,
OpenReceivables._CompanyCode AS _CompanyCode,
OpenReceivables._JournalEntry AS _JournalEntry,
OpenReceivables._SpecialGLCode AS _SpecialGLCode,
OpenReceivables._FinancialAccountType AS _FinancialAccountType,
OpenReceivables._ChartOfAccounts AS _ChartOfAccounts,
OpenReceivables._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
OpenReceivables._ProfitCenter AS _ProfitCenter,
OpenReceivables.CustomerCountry AS CustomerCountry,
OpenReceivables.CustomerRegion AS CustomerRegion,
OpenReceivables.ReconciliationAccount AS ReconciliationAccount,
OpenReceivables.CustomerAccountGroup AS CustomerAccountGroup,
OpenReceivables.AccountingClerk AS AccountingClerk,
OpenReceivables.Country AS Country,
OpenReceivables.CustomerBasicAuthorizationGrp AS CustomerBasicAuthorizationGrp,
OpenReceivables.CustomerFinsAuthorizationGrp AS CustomerFinsAuthorizationGrp,
OpenReceivables.CustomerClassification AS CustomerClassification,
OpenReceivables.CustomerAccountNote AS CustomerAccountNote,
OpenReceivables.CustomerCorporateGroup AS CustomerCorporateGroup,
OpenReceivables._FiscalYear AS _FiscalYear,
OpenReceivables._AccountingClerk AS _AccountingClerk,
OpenReceivables._ReconciliationAccount AS _ReconciliationAccount,
OpenReceivables._CustomerAccountGroup AS _CustomerAccountGroup,
OpenReceivables._PaymentMethod AS _PaymentMethod,
OpenReceivables._CustomerCountry AS _CustomerCountry,
OpenReceivables._CustomerRegion AS _CustomerRegion,
OpenReceivables._CustomerCompany AS _CustomerCompany,
OpenReceivables._CurrentProfitCenter AS _CurrentProfitCenter,
OpenReceivables._Country AS _Country,
OpenReceivables._ControllingArea AS _ControllingArea,
OpenReceivables._CustomerClassification AS CompanyCodeasCompanyCode,
OpenReceivables._CustomerClassification AS _CustomerClassification
FROM P_ARJrnlEntrItmOpenRec1
INNER JOIN P_ReceivablesItem AS ReferencedInvoices ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_ARJrnlEntrItmOpenRec1
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA