P_SK_CADocumentSourceBase

DDL: P_SK_CADOCUMENTSOURCEBASE Type: view_entity COMPOSITE Package: FKK_ID_SK_REP
19 Fields 1 Data Sources 1 Associations

CA Document Source Base

P_SK_CADocumentSourceBase is a Composite CDS View that provides data about "CA Document Source Base" in SAP S/4HANA. It reads from 1 data source (I_CADocument) and exposes 19 fields with key field CADocumentNumber. It has 1 association to related views. Part of development package FKK_ID_SK_REP.

Data Sources (1)

SourceAliasJoin Type
I_CADocument I_CADocument from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CAInvcgDocPosting _CAInvcDocPosting $projection.CADocumentNumber = _CAInvcDocPosting.CADocumentNumber and _CAInvcDocPosting.CAInvcgIsPostedInCurrentInvcg = 'X'

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 (19)

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 CAPostingDate Posting Date
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 _CAInvcDocPosting CAInvoicingDocument Invoic. Doc.
CAReferenceDocumentType CAInvcgRefPostingDocType Ref. Doc. Type

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_CADocumentSourceBase.
-- 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_CADocumentSourceBase AS
SELECT
  CADocumentNumber,
  CAReconciliationKey,
  CADocumentType,
  CADocumentOriginCode,
  CreatedByUser,
  CreationDate,
  CreationTime,
  TransactionCurrency,
  DocumentDate,
  CAPostingDate AS PostingDate,
  CAReferenceDocument,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  CAReversedDocumentNumber,
  CAReversalDocumentNumber,
  LogicalSystem,
  TaxReportingDate,
  _CAInvcDocPosting.CAInvoicingDocument AS CAInvoicingDocument,
  CAInvcgRefPostingDocType AS CAReferenceDocumentType
FROM I_CADocument
LEFT OUTER JOIN I_CAInvcgDocPosting AS _CAInvcDocPosting ON CADocumentNumber = _CAInvcDocPosting.CADocumentNumber AND _CAInvcDocPosting.CAInvcgIsPostedInCurrentInvcg = 'X'  -- association [0..1]
;

Learn More