P_ARJrnlEntrItmOpenRec2_CC

DDL: P_ARJRNLENTRITMOPENREC2_CC Type: view_entity COMPOSITE
140 Fields 2 Data Sources

P_ARJrnlEntrItmOpenRec2_CC is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_ARJrnlEntrItmOpenRec2_NSJ_CC, P_ARJrnlEntrItmOpenRec2_WSJ_CC) and exposes 140 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem, FiscalYear.

Data Sources (2)

SourceAliasJoin Type
P_ARJrnlEntrItmOpenRec2_NSJ_CC P_ARJrnlEntrItmOpenRec2_NSJ_CC from
P_ARJrnlEntrItmOpenRec2_WSJ_CC P_ARJrnlEntrItmOpenRec2_WSJ_CC union_all

Parameters (2)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_LeadingLedger fins_ledger

Annotations (4)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (140)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
AccountingDocumentItem AccountingDocumentItem Posting View Item
InvoiceReference InvoiceReference Invoice Reference
InvoiceItemReference InvoiceItemReference Item
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
ClearingDate ClearingDate Clearing Date
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
FinancialAccountType FinancialAccountType Fin. Account Type
Customer Customer Sold-to Party
FollowOnDocumentType FollowOnDocumentType Follow-On Document Type
SpecialGLCode SpecialGLCode Special G/L Ind
SpecialGLTransactionType SpecialGLTransactionType Transact.Type
GLAccount GLAccount General Ledger
RefInvcDocumentDate RefInvcDocumentDate Journal Entry Date
RefInvcFinancialAccountType RefInvcFinancialAccountType Fin. Account Type
RefInvcDebitCreditCode RefInvcDebitCreditCode Single-Character Flag
RefInvcNetPaymentDays RefInvcNetPaymentDays Net Pmt Terms Period
RefInvcInvoiceReference RefInvcInvoiceReference Invoice Reference
RefInvcNetDueDate RefInvcNetDueDate Net Due Date
ProfitCenter ProfitCenter Profit Center
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
Segment Segment Segment number
BillingDocument BillingDocument SD Document
AssignmentReference AssignmentReference Assignment Reference
Reference1IDByBusinessPartner Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner Reference2IDByBusinessPartner Reference Key 2
Reference3IDByBusinessPartner Reference3IDByBusinessPartner Reference Key 3
PaymentMethod PaymentMethod Pymt Meth.
ChartOfAccounts ChartOfAccounts Node Class
ControllingArea ControllingArea Controlling Area
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
NetDueDate NetDueDate Net Due Date
CustomerCountry CustomerCountry
CustomerRegion CustomerRegion
CustomerAccountGroup CustomerAccountGroup Account group
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
CustomerBasicAuthorizationGrp CustomerBasicAuthorizationGrp
CustomerClassification CustomerClassification Customer Class.
CustomerCorporateGroup CustomerCorporateGroup Group
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSElementInternalID WBSElementInternalID WBS Internal ID
ProjectExternalID ProjectExternalID Project def.
ProjectInternalID ProjectInternalID Project Def.
_Customer _Customer
_CompanyCode _CompanyCode
_JournalEntry _JournalEntry
_SpecialGLCode _SpecialGLCode
_FinancialAccountType _FinancialAccountType
_ChartOfAccounts _ChartOfAccounts
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ProfitCenter _ProfitCenter
_CurrentProfitCenter _CurrentProfitCenter
_CompanyCodeCountry _CompanyCodeCountry
_ControllingArea _ControllingArea
_CustomerClassification _CustomerClassification
_FunctionalArea _FunctionalArea
_BusinessArea _BusinessArea
_Segment _Segment
_WBSElementBasicData _WBSElementBasicData
_ProjectBasicData _ProjectBasicData
_WBSElementExternalID _WBSElementExternalID
P_KeyDate
P_LeadingLedgerkeyCompanyCode
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
AccountingDocumentItem AccountingDocumentItem Posting View Item
InvoiceReference InvoiceReference Invoice Reference
InvoiceItemReference InvoiceItemReference Item
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
ClearingDate ClearingDate Clearing Date
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
FinancialAccountType FinancialAccountType Fin. Account Type
Customer Customer Sold-to Party
FollowOnDocumentType FollowOnDocumentType Follow-On Document Type
SpecialGLCode SpecialGLCode Special G/L Ind
SpecialGLTransactionType SpecialGLTransactionType Transact.Type
GLAccount GLAccount General Ledger
RefInvcDocumentDate RefInvcDocumentDate Journal Entry Date
RefInvcFinancialAccountType RefInvcFinancialAccountType Fin. Account Type
RefInvcDebitCreditCode RefInvcDebitCreditCode Single-Character Flag
RefInvcNetPaymentDays RefInvcNetPaymentDays Net Pmt Terms Period
RefInvcInvoiceReference RefInvcInvoiceReference Invoice Reference
RefInvcNetDueDate RefInvcNetDueDate Net Due Date
ProfitCenter ProfitCenter Profit Center
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
Segment Segment Segment number
BillingDocument BillingDocument SD Document
AssignmentReference AssignmentReference Assignment Reference
Reference1IDByBusinessPartner Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner Reference2IDByBusinessPartner Reference Key 2
Reference3IDByBusinessPartner Reference3IDByBusinessPartner Reference Key 3
PaymentMethod PaymentMethod Pymt Meth.
ChartOfAccounts ChartOfAccounts Node Class
ControllingArea ControllingArea Controlling Area
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
NetDueDate NetDueDate Net Due Date
CustomerCountry CustomerCountry
CustomerRegion CustomerRegion
CustomerAccountGroup CustomerAccountGroup Account group
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
CustomerBasicAuthorizationGrp CustomerBasicAuthorizationGrp
CustomerClassification CustomerClassification Customer Class.
CustomerCorporateGroup CustomerCorporateGroup Group
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSElementInternalID WBSElementInternalID WBS Internal ID
ProjectExternalID ProjectExternalID Project def.
ProjectInternalID ProjectInternalID Project Def.
_Customer _Customer
_CompanyCode _CompanyCode
_JournalEntry _JournalEntry
_SpecialGLCode _SpecialGLCode
_FinancialAccountType _FinancialAccountType
_ChartOfAccounts _ChartOfAccounts
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ProfitCenter _ProfitCenter
_CurrentProfitCenter _CurrentProfitCenter
_CompanyCodeCountry _CompanyCodeCountry
_ControllingArea _ControllingArea
_CustomerClassification _CustomerClassification
_FunctionalArea _FunctionalArea
_BusinessArea _BusinessArea
_Segment _Segment
_WBSElementBasicData _WBSElementBasicData
_ProjectBasicData _ProjectBasicData
_WBSElementExternalID _WBSElementExternalID
_ProjectExternalID _ProjectExternalID

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_CC.
-- 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 : vdm_v_key_date, P_LeadingLedger : fins_ledger

CREATE VIEW P_ARJrnlEntrItmOpenRec2_CC AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  AccountingDocumentItem,
  InvoiceReference,
  InvoiceItemReference,
  InvoiceReferenceFiscalYear,
  ClearingDate,
  PostingDate,
  DocumentDate,
  FinancialAccountType,
  Customer,
  FollowOnDocumentType,
  SpecialGLCode,
  SpecialGLTransactionType,
  GLAccount,
  RefInvcDocumentDate,
  RefInvcFinancialAccountType,
  RefInvcDebitCreditCode,
  RefInvcNetPaymentDays,
  RefInvcInvoiceReference,
  RefInvcNetDueDate,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  BillingDocument,
  AssignmentReference,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  PaymentMethod,
  ChartOfAccounts,
  ControllingArea,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency,
  NetDueDate,
  CustomerCountry,
  CustomerRegion,
  CustomerAccountGroup,
  CompanyCodeCountry,
  CustomerBasicAuthorizationGrp,
  CustomerClassification,
  CustomerCorporateGroup,
  WBSElementExternalID,
  WBSElementInternalID,
  ProjectExternalID,
  ProjectInternalID
FROM P_ARJrnlEntrItmOpenRec2_NSJ_CC
-- UNION ALL with additional select branch(es): P_ARJrnlEntrItmOpenRec2_WSJ_CC
;

Learn More