P_APCshDiscUtilization5

DDL: P_APCSHDISCUTILIZATION5 SQL: PFIAPCSHDISUTI5 Type: view COMPOSITE
10 Fields 2 Data Sources

P_APCshDiscUtilization5 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocument, I_ChangeDocumentItem) and exposes 10 fields with key fields objectclas, objectid, changenr, tabname, tabkey.

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocument cdhdr from
I_ChangeDocumentItem cdpos inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PFIAPCSHDISUTI5 view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY objectclas I_ChangeDocument ChangeDocObjectClass Change Doc. Object
KEY objectid I_ChangeDocument ChangeDocObject Object Value
KEY changenr I_ChangeDocument ChangeDocument Document Number
KEY tabname I_ChangeDocumentItem DatabaseTable Table Name
KEY tabkey I_ChangeDocumentItem ChangeDocTableKey Table Keys
KEY fname I_ChangeDocumentItem ChangeDocDatabaseTableField User
KEY chngind I_ChangeDocumentItem ChangeDocItemChangeType Change Indicator
udate I_ChangeDocument CreationDate Time Stamp
value_new I_ChangeDocumentItem ChangeDocNewFieldValue New Value
value_old I_ChangeDocumentItem ChangeDocPreviousFieldValue Old Value

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_APCshDiscUtilization5.
-- 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: PFIAPCSHDISUTI5

CREATE VIEW P_APCshDiscUtilization5 AS
SELECT
  cdhdr.ChangeDocObjectClass AS objectclas,
  cdhdr.ChangeDocObject AS objectid,
  cdhdr.ChangeDocument AS changenr,
  cdpos.DatabaseTable AS tabname,
  cdpos.ChangeDocTableKey AS tabkey,
  cdpos.ChangeDocDatabaseTableField AS fname,
  cdpos.ChangeDocItemChangeType AS chngind,
  cdhdr.CreationDate AS udate,
  cdpos.ChangeDocNewFieldValue AS value_new,
  cdpos.ChangeDocPreviousFieldValue AS value_old
FROM I_ChangeDocument AS cdhdr
INNER JOIN I_ChangeDocumentItem AS cdpos ON /* join condition not captured in parsed metadata */
;

Learn More