I_PE_ElectronicDocument

DDL: I_PE_ELECTRONICDOCUMENT Type: view_entity COMPOSITE Package: GLO-EDO-PE
41 Fields 1 Data Sources

Peru eDocument

I_PE_ElectronicDocument is a Composite CDS View that provides data about "Peru eDocument" in SAP S/4HANA. It reads from 1 data source (I_ElectronicDoc) and exposes 41 fields with key field ElectronicDocUUID. Part of development package GLO-EDO-PE.

Data Sources (1)

SourceAliasJoin Type
I_ElectronicDoc _ElectronicDoc from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Peru eDocument view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID I_ElectronicDoc ElectronicDocUUID eDocument GUID
ElectronicDocSequenceNmbr I_ElectronicDoc ElectronicDocSequenceNmbr Value Number
ElectronicDocCompanyCode I_ElectronicDoc ElectronicDocCompanyCode Value
ElectronicDocCountry I_ElectronicDoc ElectronicDocCountry CtryReg ISO Cd
ElectronicDocSourceType I_ElectronicDoc ElectronicDocSourceType SRVC Source Type
ElectronicDocSourceKey I_ElectronicDoc ElectronicDocSourceKey Source System Key
ElectronicDocType I_ElectronicDoc ElectronicDocType eDoc Type
ElectronicDocProcessStatus I_ElectronicDoc ElectronicDocProcessStatus Work Item ID
ElectronicDocLogicalSystem I_ElectronicDoc ElectronicDocLogicalSystem Source system
ElectronicDocLastChangedByUser I_ElectronicDoc ElectronicDocLastChangedByUser User Name
ElectronicDocLastChangeDate I_ElectronicDoc ElectronicDocLastChangeDate Time Stamp
ElectronicDocLastChangeTime I_ElectronicDoc ElectronicDocLastChangeTime Time Stamp
ElectronicDocCreatedByUser I_ElectronicDoc ElectronicDocCreatedByUser Version Created By
ElectronicDocCreationDate I_ElectronicDoc ElectronicDocCreationDate Time Stamp
ElectronicDocCreationTime I_ElectronicDoc ElectronicDocCreationTime Time
ElectronicDocSrceCreatedByUser I_ElectronicDoc ElectronicDocSrceCreatedByUser Source Crted By
ElectronicDocProcess I_ElectronicDoc ElectronicDocProcess Trans.
ElectronicDocLastProcStep I_ElectronicDoc ElectronicDocLastProcStep Last ProcStep
ElectronicDocLastProcStepVar I_ElectronicDoc ElectronicDocLastProcStepVar Last Variant
ElectronicDocHasError I_ElectronicDoc ElectronicDocHasError Error Flag
ElectronicDocProcessVersion I_ElectronicDoc ElectronicDocProcessVersion Process Version
ElectronicDocRefSqncNmbr I_ElectronicDoc ElectronicDocRefSqncNmbr Doc.Ref. SeqNr
ElectronicDocStatus I_ElectronicDoc ElectronicDocStatus Workflow Status
ElectronicDocPostingDate I_ElectronicDoc ElectronicDocPostingDate Posting Date
ElectronicDocIsContingency I_ElectronicDoc ElectronicDocIsContingency Contingency
ElectronicDocReferenceProcess I_ElectronicDoc ElectronicDocReferenceProcess Reference Proc.
ElectronicDocClassName I_ElectronicDoc ElectronicDocClassName eDoc.Class Name
ElectronicDocIsArchPrprocgDone I_ElectronicDoc ElectronicDocIsArchPrprocgDone Arch. Preproc.
ElectronicDocInterfaceType I_ElectronicDoc ElectronicDocInterfaceType Plug-In Interface Tp
ElectronicDocApprovalIDValue I_ElectronicDoc ElectronicDocApprovalIDValue Approval ID
ElectronicDocInterfaceUUID I_ElectronicDoc ElectronicDocInterfaceUUID Interface GUID
ElectronicDocFileUUID I_ElectronicDoc ElectronicDocFileUUID File GUID
ElectronicDocResponseCodeValue I_ElectronicDoc ElectronicDocResponseCodeValue Response Code
ElectronicDocInterfaceID I_ElectronicDoc ElectronicDocInterfaceID Interface ID
ElectronicDocInterfaceVersion I_ElectronicDoc ElectronicDocInterfaceVersion Version
ElectronicDocIsCntdInArchive I_ElectronicDoc ElectronicDocIsCntdInArchive Arch. Counter
ElectronicDocMetaStatus I_ElectronicDoc ElectronicDocMetaStatus Status
ElectronicDocProcessForStatus I_ElectronicDoc ElectronicDocProcessForStatus
PE_EDocNumberelseendasPE_EDocIDNumber
_ElectronicDocInvc _ElectronicDocInvc
_ElectronicDocWhldgTaxCert _ElectronicDocWhldgTaxCert

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 I_PE_ElectronicDocument.
-- 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 I_PE_ElectronicDocument AS
SELECT
  _ElectronicDoc.ElectronicDocUUID AS ElectronicDocUUID,
  _ElectronicDoc.ElectronicDocSequenceNmbr AS ElectronicDocSequenceNmbr,
  _ElectronicDoc.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  _ElectronicDoc.ElectronicDocCountry AS ElectronicDocCountry,
  _ElectronicDoc.ElectronicDocSourceType AS ElectronicDocSourceType,
  _ElectronicDoc.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  _ElectronicDoc.ElectronicDocType AS ElectronicDocType,
  _ElectronicDoc.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  _ElectronicDoc.ElectronicDocLogicalSystem AS ElectronicDocLogicalSystem,
  _ElectronicDoc.ElectronicDocLastChangedByUser AS ElectronicDocLastChangedByUser,
  _ElectronicDoc.ElectronicDocLastChangeDate AS ElectronicDocLastChangeDate,
  _ElectronicDoc.ElectronicDocLastChangeTime AS ElectronicDocLastChangeTime,
  _ElectronicDoc.ElectronicDocCreatedByUser AS ElectronicDocCreatedByUser,
  _ElectronicDoc.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  _ElectronicDoc.ElectronicDocCreationTime AS ElectronicDocCreationTime,
  _ElectronicDoc.ElectronicDocSrceCreatedByUser AS ElectronicDocSrceCreatedByUser,
  _ElectronicDoc.ElectronicDocProcess AS ElectronicDocProcess,
  _ElectronicDoc.ElectronicDocLastProcStep AS ElectronicDocLastProcStep,
  _ElectronicDoc.ElectronicDocLastProcStepVar AS ElectronicDocLastProcStepVar,
  _ElectronicDoc.ElectronicDocHasError AS ElectronicDocHasError,
  _ElectronicDoc.ElectronicDocProcessVersion AS ElectronicDocProcessVersion,
  _ElectronicDoc.ElectronicDocRefSqncNmbr AS ElectronicDocRefSqncNmbr,
  _ElectronicDoc.ElectronicDocStatus AS ElectronicDocStatus,
  _ElectronicDoc.ElectronicDocPostingDate AS ElectronicDocPostingDate,
  _ElectronicDoc.ElectronicDocIsContingency AS ElectronicDocIsContingency,
  _ElectronicDoc.ElectronicDocReferenceProcess AS ElectronicDocReferenceProcess,
  _ElectronicDoc.ElectronicDocClassName AS ElectronicDocClassName,
  _ElectronicDoc.ElectronicDocIsArchPrprocgDone AS ElectronicDocIsArchPrprocgDone,
  _ElectronicDoc.ElectronicDocInterfaceType AS ElectronicDocInterfaceType,
  _ElectronicDoc.ElectronicDocApprovalIDValue AS ElectronicDocApprovalIDValue,
  _ElectronicDoc.ElectronicDocInterfaceUUID AS ElectronicDocInterfaceUUID,
  _ElectronicDoc.ElectronicDocFileUUID AS ElectronicDocFileUUID,
  _ElectronicDoc.ElectronicDocResponseCodeValue AS ElectronicDocResponseCodeValue,
  _ElectronicDoc.ElectronicDocInterfaceID AS ElectronicDocInterfaceID,
  _ElectronicDoc.ElectronicDocInterfaceVersion AS ElectronicDocInterfaceVersion,
  _ElectronicDoc.ElectronicDocIsCntdInArchive AS ElectronicDocIsCntdInArchive,
  _ElectronicDoc.ElectronicDocMetaStatus AS ElectronicDocMetaStatus,
  _ElectronicDoc.ElectronicDocProcessForStatus AS ElectronicDocProcessForStatus,
  case _ElectronicDoc.ElectronicDocProcess when 'PEINV' then concat(concat(_ElectronicDocInvc.PE_EDocDocumentType, _ElectronicDocInvc.PE_EDocSeries), _ElectronicDocInvc.PE_EDocNumber) when 'PEWTC' then concat(concat(_ElectronicDocWhldgTaxCert.PE_EDocDocumentType, _ElectronicDocWhldgTaxCert.PE_EDocSeries), _ElectronicDocWhldgTaxCert.PE_EDocNumber) else '' end as PE_EDocIDNumber AS PE_EDocNumberelseendasPE_EDocIDNumber
FROM I_ElectronicDoc AS _ElectronicDoc
;

Learn More