P_PhysInvtryConcatForReporting

DDL: P_PHYSINVTRYCONCATFORREPORTING Type: view_entity BASIC Package: MM_IM_RAP_PI
10 Fields 1 Data Sources

Concat PI fields for Reporting

P_PhysInvtryConcatForReporting is a Basic CDS View that provides data about "Concat PI fields for Reporting" in SAP S/4HANA. It reads from 1 data source (iseg) and exposes 10 fields with key fields FiscalYear, PhysicalInventoryDocument, PhysicalInventoryDocumentItem. Part of development package MM_IM_RAP_PI.

Data Sources (1)

SourceAliasJoin Type
iseg iseg from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Concat PI fields for Reporting view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY FiscalYear iseg gjahr Settlement Year
KEY PhysicalInventoryDocument
KEY PhysicalInventoryDocumentItem
Keys
viafields
status
DocumentDate ikpf bldat Journal Entry Date
PhysicalInventoryLastCountDate iseg zldat Count Date
PostingDate iseg budat Posting Date
Dates

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_PhysInvtryConcatForReporting.
-- 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 P_PhysInvtryConcatForReporting AS
SELECT
  iseg.gjahr AS FiscalYear,
  cast(iseg.iblnr as pi_item_document preserving type) AS PhysicalInventoryDocument,
  cast(iseg.zeili as pi_item_number preserving type) AS PhysicalInventoryDocumentItem,
  cast( concat( iseg.gjahr, concat( ',', concat( iseg.iblnr, concat( ',', iseg.zeili ) ) ) ) as abap.char( 17 )) AS Keys,
  cast( concat( iseg.created_via, concat( ',', concat( iseg.counted_via, concat( ',', iseg.posted_via ) ) ) ) as abap.char( 20 ) ) AS viafields,
  cast( concat( iseg.xzael, concat( ',', concat( iseg.xdiff, concat( ',', concat( iseg.xnzae, concat( ',', iseg.xloek ) ) ) ) ) ) as abap.char( 20 ) ) AS status,
  ikpf.bldat AS DocumentDate,
  iseg.zldat AS PhysicalInventoryLastCountDate,
  iseg.budat AS PostingDate,
  cast( concat( ikpf.bldat, concat( ',', concat( iseg.zldat, concat( ',', iseg.budat ) ) ) ) as abap.char( 26 )) AS Dates
FROM iseg
;

Learn More