I_ElectronicDocCockpitList

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_ElectronicDocCockpitList.
-- 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.
-- SQL view name: IEDODCCLIST

CREATE VIEW I_ElectronicDocCockpitList AS
SELECT
  ElectronicDocUUID,
  ElectronicDocSequenceNmbr,
  ElectronicDocCompanyCode,
  ElectronicDocCountry,
  ElectronicDocSourceType,
  ElectronicDocSourceKey,
  substring(ElectronicDocSourceKey, 1, 4) AS CompanyCode,
  substring(ElectronicDocSourceKey, 5, 10) AS AccountingDocument,
  cast(substring(ElectronicDocSourceKey, 15, 4) as fis_gjahr) AS FiscalYear,
  cast('' as abap.char( 10 )) AS SupplierInvoice,
  cast(substring(ElectronicDocSourceKey, 5, 14) as rerainvno) AS REInvoiceNumber,
  substring(ElectronicDocSourceKey, 1, 10) AS DeliveryDocument,
  cast(substring(ElectronicDocSourceKey, 1, 10) as mblnr) AS MaterialDocument,
  cast(substring(ElectronicDocSourceKey, 11, 4) as gjahr) AS MaterialDocumentYear,
  ElectronicDocType,
  ElectronicDocProcessStatus,
  ElectronicDocLogicalSystem,
  ElectronicDocLastChangedByUser,
  ElectronicDocLastChangeDate,
  ElectronicDocLastChangeTime,
  ElectronicDocCreatedByUser,
  ElectronicDocCreationDate,
  ElectronicDocCreationTime,
  ElectronicDocSrceCreatedByUser,
  ElectronicDocProcess,
  ElectronicDocLastProcStep,
  ElectronicDocLastProcStepVar,
  ElectronicDocHasError,
  ElectronicDocProcessVersion,
  ElectronicDocRefSqncNmbr,
  ElectronicDocStatus,
  ElectronicDocPostingDate,
  ElectronicDocIsContingency,
  ElectronicDocReferenceProcess,
  ElectronicDocClassName,
  ElectronicDocIsArchPrprocgDone,
  ElectronicDocInterfaceType,
  ElectronicDocInterfaceUUID,
  ElectronicDocFileUUID,
  ElectronicDocInterfaceID,
  ElectronicDocInterfaceVersion,
  ElectronicDocIsCntdInArchive,
  ElectronicDocMetaStatus,
  ElectronicDocTaxReportingDate
FROM I_ElectronicDoc
LEFT OUTER JOIN C_ElectronicDocAttachment AS _ElectronicDocAttachment ON ElectronicDocUUID = _ElectronicDocAttachment.ElectronicDocUUID  -- association [1..*]
LEFT OUTER JOIN C_ElectronicDocCockpitHistory AS _ElectronicDocCockpitHistory ON ElectronicDocUUID = _ElectronicDocCockpitHistory.ElectronicDocUUID  -- association [1..*]
-- UNION with additional select branch(es): I_ElectronicDoc
;