P_NmbrOfIncmpltFldForSDDoc

DDL: P_NMBROFINCMPLTFLDFORSDDOC SQL: PSDNMBRINMPLTFLD Type: view CONSUMPTION
2 Fields 1 Data Sources

Number of Incomplete Fields for SD Document

P_NmbrOfIncmpltFldForSDDoc is a Consumption CDS View that provides data about "Number of Incomplete Fields for SD Document" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentIncompletionLog) and exposes 2 fields with key field SDDocument.

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentIncompletionLog I_SDDocumentIncompletionLog from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSDNMBRINMPLTFLD view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Number of Incomplete Fields for SD Document view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY SDDocument SDDocument SD Document
NumberOfIncompleteFields

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_NmbrOfIncmpltFldForSDDoc.
-- 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: PSDNMBRINMPLTFLD

CREATE VIEW P_NmbrOfIncmpltFldForSDDoc AS
SELECT
  SDDocument,
  cast(count(*) as number_of_incomplete_fields preserving type) AS NumberOfIncompleteFields
FROM I_SDDocumentIncompletionLog
;

Learn More