I_PhysInvtryDocPrintCount

DDL: I_PHYSINVTRYDOCPRINTCOUNT Type: view_entity COMPOSITE
4 Fields 1 Data Sources

Counter Printed PI Documents

I_PhysInvtryDocPrintCount is a Composite CDS View that provides data about "Counter Printed PI Documents" in SAP S/4HANA. It reads from 1 data source (R_PhysInvtryOutpRequestItem) and exposes 4 fields.

Data Sources (1)

SourceAliasJoin Type
R_PhysInvtryOutpRequestItem R_PhysInvtryOutpRequestItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Counter Printed PI Documents view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (4)

KeyFieldSource TableSource FieldDescription
PhysicalInventoryDocument PhysicalInventoryDocument Physical Inventory Document
FiscalYear FiscalYear G/L Fiscal Year
PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem Physical Inventory Document Item
NumberOfPrintedPhysInvtryDocs

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_PhysInvtryDocPrintCount.
-- 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_PhysInvtryDocPrintCount AS
SELECT
  PhysicalInventoryDocument,
  FiscalYear,
  PhysicalInventoryDocumentItem,
  cast( count( * ) as mmim_pi_doc_printed_counter) AS NumberOfPrintedPhysInvtryDocs
FROM R_PhysInvtryOutpRequestItem
;

Learn More