P_SK_CADocumentSource

DDL: P_SK_CADOCUMENTSOURCE Type: view_entity COMPOSITE
24 Fields 1 Data Sources 2 Associations

P_SK_CADocumentSource is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_SK_CADocumentSourceBase) and exposes 24 fields with key field CADocumentNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_SK_CADocumentSourceBase P_SK_CADocumentSourceBase from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CAInvcgDocHeader _CAInvcgDocHeader $projection.CASourceDocument = _CAInvcgDocHeader.CAInvoicingDocument
[0..1] I_BillingDocumentBasic _BillingDocumentBasic $projection.CASourceDocument = _BillingDocumentBasic.BillingDocument

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber Document Number
CAReconciliationKey CAReconciliationKey Reconcil. Key
CADocumentType CADocumentType Document Type
CADocumentOriginCode CADocumentOriginCode Document Origin
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
TransactionCurrency TransactionCurrency Transaction Currency
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
CAReferenceDocument CAReferenceDocument Reference
ReferenceDocumentType ReferenceDocumentType Reference Document Type
OriginalReferenceDocument OriginalReferenceDocument Reference Key
CAReversedDocumentNumber CAReversedDocumentNumber Rev. Doc. For
CAReversalDocumentNumber CAReversalDocumentNumber Revers.document
LogicalSystem LogicalSystem Logical System
TaxReportingDate TaxReportingDate Tax Reporting Date
CAInvoicingDocument CAInvoicingDocument Invoic. Doc.
CAReferenceDocumentType CAReferenceDocumentType Ref. Doc. Type
CASourceDocumentCategory CASourceDocumentCategory
CASourceDocumentType CASourceDocumentType
CASourceDocument CASourceDocument
IsReversal
IsReversed

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_SK_CADocumentSource.
-- 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.

CREATE VIEW P_SK_CADocumentSource AS
SELECT
  CADocumentNumber,
  CAReconciliationKey,
  CADocumentType,
  CADocumentOriginCode,
  CreatedByUser,
  CreationDate,
  CreationTime,
  TransactionCurrency,
  DocumentDate,
  PostingDate,
  CAReferenceDocument,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  CAReversedDocumentNumber,
  CAReversalDocumentNumber,
  LogicalSystem,
  TaxReportingDate,
  CAInvoicingDocument,
  CAReferenceDocumentType,
  CASourceDocumentCategory,
  CASourceDocumentType,
  CASourceDocument,
  case when CAReversedDocumentNumber <> '' then 'X' else '' end AS IsReversal,
  case when CAReversalDocumentNumber <> '' then 'X' else '' end AS IsReversed
FROM P_SK_CADocumentSourceBase
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgDocHeader ON CASourceDocument = _CAInvcgDocHeader.CAInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentBasic AS _BillingDocumentBasic ON CASourceDocument = _BillingDocumentBasic.BillingDocument  -- association [0..1]
;

Learn More