C_ElectronicDocMetaStatusSum

DDL: C_ELECTRONICDOCMETASTATUSSUM Type: view_entity CONSUMPTION Package: ODATA_GCO_DASHBOARD
9 Fields 1 Data Sources 3 Associations 2 OData Services 1 Fiori Apps

eDocument Metastatus Summary

C_ElectronicDocMetaStatusSum is a Consumption CDS View that provides data about "eDocument Metastatus Summary" in SAP S/4HANA. It reads from 1 data source (I_ElectronicDoc) and exposes 9 fields with key field ElectronicDocUUID. It has 3 associations to related views. It is exposed through 2 OData services (ASQL_F5218, UI_GCO_DASHBOARD). It is used in 1 Fiori application: Manage Document and Reporting Compliance. Part of development package ODATA_GCO_DASHBOARD.

Data Sources (1)

SourceAliasJoin Type
I_ElectronicDoc I_ElectronicDoc from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ElectronicDocCockpitActvProc _ElectronicDocCockpitActvProc $projection.ElectronicDocProcess = _ElectronicDocCockpitActvProc.ElectronicDocProcess
[0..1] I_ElectronicDocProcess _ElectronicDocProcess $projection.ElectronicDocProcess = _ElectronicDocProcess.ElectronicDocProcess
[0..*] I_ElectronicDocProcessText _ElectronicDocProcessText $projection.ElectronicDocProcess = _ElectronicDocProcessText.ElectronicDocProcess

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label eDocument Metastatus Summary view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F5218 ASQL_F5218 C2 NOT_RELEASED
UI_GCO_DASHBOARD UI_GCO_DASHBOARD V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5218 Manage Document and Reporting Compliance Transactional You can use this app to get an overview of the overall status, due dates, and pending activities of periodic reports, and to display the status of electronic documents. You can also further navigate to the corresponding tasks and documents to process the details.

Manage Document and Reporting Compliance

Business Role: Tax Accountant - Legal Reporting

This feature enhances the current functionality of the Manage Document and Reporting Compliance dashboard as described belowReports - Monthly Calendar With this new card, the user can check all reports and statuses within a month using a calendar view. The user can filter results by Country/Region, Report Name, and Reporting Entity Name to help the search for specific information in the new card. The other filters (Report Due Date and Reporting Year) are irrelevant for the Reports - Monthly Calendar card. The user can navigate to the Run Statutory Reports app when selecting one of the reports listed on the card. Reports - Upcoming Deadlines With this new card, the user can check the periodic reports they must send in the next 30 days. You can use the filters Country/Region, Report Name, and Reporting Entity Name to help the search for specific information in the new card. The other filters (Report Due Date and Reporting Year) are irrelevant for the Upcoming Deadlines card. You can navigate to the Run Statutory Reports when selecting one of the reports listed on the card. The dashboard only displays periodic reports with Due Soon and Due Later statuses.

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID I_ElectronicDoc ElectronicDocUUID eDocument GUID
ElectronicDocCompanyCode I_ElectronicDoc ElectronicDocCompanyCode Value
ElectronicDocCreationDate I_ElectronicDoc ElectronicDocCreationDate Time Stamp
ElectronicDocProcess I_ElectronicDoc ElectronicDocProcess Trans.
Country I_ElectronicDoc ElectronicDocCountry CtryReg ISO Cd
NumberOfActnRqdElectronicDocs
ElectronicDocIsActive _ElectronicDocCockpitActvProc ElectronicDocIsActive
_ElectronicDocProcessText _ElectronicDocProcessText
_ElectronicDocProcess _ElectronicDocProcess

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 C_ElectronicDocMetaStatusSum.
-- 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 C_ElectronicDocMetaStatusSum AS
SELECT
  I_ElectronicDoc.ElectronicDocUUID AS ElectronicDocUUID,
  I_ElectronicDoc.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  I_ElectronicDoc.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  I_ElectronicDoc.ElectronicDocProcess AS ElectronicDocProcess,
  I_ElectronicDoc.ElectronicDocCountry AS Country,
  cast(1 as abap.int4) AS NumberOfActnRqdElectronicDocs,
  _ElectronicDocCockpitActvProc.ElectronicDocIsActive AS ElectronicDocIsActive
FROM I_ElectronicDoc
LEFT OUTER JOIN I_ElectronicDocCockpitActvProc AS _ElectronicDocCockpitActvProc ON ElectronicDocProcess = _ElectronicDocCockpitActvProc.ElectronicDocProcess  -- association [0..1]
LEFT OUTER JOIN I_ElectronicDocProcess AS _ElectronicDocProcess ON ElectronicDocProcess = _ElectronicDocProcess.ElectronicDocProcess  -- association [0..1]
LEFT OUTER JOIN I_ElectronicDocProcessText AS _ElectronicDocProcessText ON ElectronicDocProcess = _ElectronicDocProcessText.ElectronicDocProcess  -- association [0..*]
;

Learn More