I_EntProjTeamChgDocItem

DDL: I_ENTPROJTEAMCHGDOCITEM Type: view COMPOSITE
23 Fields 9 Data Sources

Chg Doc items for Team tab of Ent Proj

I_EntProjTeamChgDocItem is a Composite CDS View that provides data about "Chg Doc items for Team tab of Ent Proj" in SAP S/4HANA. It reads from 9 data sources and exposes 23 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey.

Data Sources (9)

SourceAliasJoin Type
I_ChangeDocumentItem cd_bp_j inner
I_ChangeDocumentItem cd_bp_j inner
I_ChangeDocumentItem cd_en_d union_all
I_ChangeDocumentItem cd_en_j from
I_ChangeDocumentItem cd_en_j inner
I_ChangeDocumentItem cd_ent_role_j inner
I_ChangeDocumentItem cd_ent_role_j inner
I_ChangeDocumentItem cd_role_j inner
I_ChangeDocumentItem cd_role_j inner

Annotations (12)

NameValueLevelField
EndUserText.label Chg Doc items for Team tab of Ent Proj view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.sqlViewName IPROJTEAMCDITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject I_ChangeDocumentItem ChangeDocObject Object Value
KEY ChangeDocObjectClass I_ChangeDocumentItem ChangeDocObjectClass Change Doc. Object
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument Document Number
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable Table Name
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey Table Keys
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField User
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType Change Indicator
ChangeDocNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue Old Value
ChangeDocPreviousFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue New Value
BusinessPartnerUUID
mandt
mandt
ChangeDocObject Object Value
KEY ChangeDocObjectClass I_ChangeDocumentItem ChangeDocObjectClass Change Doc. Object
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument Document Number
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable Table Name
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey Table Keys
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField User
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType Change Indicator
ChangeDocNewFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue Old Value
ChangeDocPreviousFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue New Value
BusinessPartnerUUID
BusinessPartnerRoleName

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_EntProjTeamChgDocItem.
-- 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_EntProjTeamChgDocItem AS
SELECT
  cd_en_j.ChangeDocObject AS ChangeDocObject,
  cd_en_j.ChangeDocObjectClass AS ChangeDocObjectClass,
  cd_en_j.ChangeDocument AS ChangeDocument,
  cd_en_j.DatabaseTable AS DatabaseTable,
  cd_en_j.ChangeDocTableKey AS ChangeDocTableKey,
  cd_en_j.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  cd_en_j.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  cd_en_j.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  cd_en_j.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  cast (cd_bp_j.ChangeDocNewFieldValue as sysuuid_c) AS BusinessPartnerUUID,
  cast (cd_role_j.ChangeDocNewFieldValue as /s4ppm/tv_role_name) as BusinessPartnerRoleName AS mandt,
  cast (cd_role_j.ChangeDocNewFieldValue as /s4ppm/tv_role_name) AS BusinessPartnerRoleName
FROM I_ChangeDocumentItem AS cd_en_j
INNER JOIN I_ChangeDocumentItem AS cd_bp_j ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChangeDocumentItem AS cd_ent_role_j ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChangeDocumentItem AS cd_role_j ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChangeDocumentItem AS cd_en_j ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_ChangeDocumentItem
;

Learn More