P_CL_SalesElectronicDocument

DDL: P_CL_SALESELECTRONICDOCUMENT Type: view_entity CONSUMPTION Package: GLO_FIN_IS_CL
7 Fields 2 Data Sources

Sales Electronic Documents for Chile

P_CL_SalesElectronicDocument is a Consumption CDS View that provides data about "Sales Electronic Documents for Chile" in SAP S/4HANA. It reads from 2 data sources (R_CL_ElectronicDocumentDTE, I_ElectronicDoc) and exposes 7 fields with key field ElectronicDocUUID. Part of development package GLO_FIN_IS_CL.

Data Sources (2)

SourceAliasJoin Type
R_CL_ElectronicDocumentDTE DTE inner
I_ElectronicDoc EDocHeader from

Annotations (6)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID I_ElectronicDoc ElectronicDocUUID eDocument GUID
CL_SIIEDocFolioNumber R_CL_ElectronicDocumentDTE CL_SIIEDocFolioNumber Folio Number
CL_SIIElectronicDocumentType R_CL_ElectronicDocumentDTE CL_SIIElectronicDocumentType DTE Type
ElectronicDocCompanyCode I_ElectronicDoc ElectronicDocCompanyCode Value
ElectronicDocSourceKey I_ElectronicDoc ElectronicDocSourceKey Source System Key
ElectronicDocSourceType I_ElectronicDoc ElectronicDocSourceType SRVC Source Type
ElectronicDocPostingDate I_ElectronicDoc ElectronicDocPostingDate Posting Date

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_CL_SalesElectronicDocument.
-- 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_CL_SalesElectronicDocument AS
SELECT
  EDocHeader.ElectronicDocUUID AS ElectronicDocUUID,
  DTE.CL_SIIEDocFolioNumber AS CL_SIIEDocFolioNumber,
  DTE.CL_SIIElectronicDocumentType AS CL_SIIElectronicDocumentType,
  EDocHeader.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  EDocHeader.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  EDocHeader.ElectronicDocSourceType AS ElectronicDocSourceType,
  EDocHeader.ElectronicDocPostingDate AS ElectronicDocPostingDate
FROM I_ElectronicDoc AS EDocHeader
INNER JOIN R_CL_ElectronicDocumentDTE AS DTE ON /* join condition not captured in parsed metadata */
;

Learn More