I_ProdAllocationObjectChange

DDL: I_PRODALLOCATIONOBJECTCHANGE Type: view_entity COMPOSITE
27 Fields 2 Data Sources 3 Associations

Product Allocation Object Change

I_ProdAllocationObjectChange is a Composite CDS View that provides data about "Product Allocation Object Change" in SAP S/4HANA. It reads from 2 data sources (I_ChgDocItmWithUUIDTableKey, I_AllProductAllocationObject) and exposes 27 fields with key fields ProductAllocationObjectUUID, ChangeDocument, DatabaseTable, ChangeDocDatabaseTableField, ChangeDocItemChangeType. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ChgDocItmWithUUIDTableKey I_ChgDocItmWithUUIDTableKey inner
I_AllProductAllocationObject Master from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedByUser _CreatedByUser.UserID = $projection.CreatedByUser
[0..1] I_User _ChangeDocumentCreatedByUser _ChangeDocumentCreatedByUser.UserID = $projection.ChangeDocumentCreatedByUser
[0..1] I_User _LastChangedByUser _LastChangedByUser.UserID = $projection.LastChangedByUser

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Product Allocation Object Change view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ProductAllocationObjectUUID I_AllProductAllocationObject ProductAllocationObjectUUID Product Allocation Object UUID
KEY ChangeDocument Chg ChangeDocument Document Number
KEY DatabaseTable Chg DatabaseTable Table Name
KEY ChangeDocDatabaseTableField Chg ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType Chg ChangeDocItemChangeType
ProductAllocationObject I_AllProductAllocationObject ProductAllocationObject Allocation Object
ProdAllocHeaderBasicSearch I_AllProductAllocationObject ProdAllocHeaderBasicSearch
CreatedByUser I_AllProductAllocationObject CreatedByUser User Name
CreationDateTime I_AllProductAllocationObject CreationDateTime Timestamp
CreationDate
LastChangeDateTime I_AllProductAllocationObject LastChangeDateTime Timestamp
LastChangeDate
LastChangedByUser I_AllProductAllocationObject LastChangedByUser User Name
ChangeDocNewFieldValue Chg ChangeDocNewFieldValue
ChgDocNewValBasicSearch Chg ChgDocNewValBasicSearch
ChangeDocPreviousFieldValue Chg ChangeDocPreviousFieldValue
ChgDocPrevValBasicSearch Chg ChgDocPrevValBasicSearch
ChangeDocumentCreatedByUser
ChangeDocCreationDate Chg CreationDate Time Stamp
CreationTime Chg CreationTime Time of Change
ProdAllocationLifecycleStatus I_AllProductAllocationObject ProdAllocationLifecycleStatus Lifecycle Status
IsDeleted I_AllProductAllocationObject IsDeleted TRUE
_CreatedByUser _CreatedByUser
_ChangeDocumentCreatedByUser _ChangeDocumentCreatedByUser
_LastChangedByUser _LastChangedByUser
_ChangeDocChangeIndT Chg _ChangeDocChangeIndT
_ChangeDocFieldNamesT Chg _ChangeDocFieldNamesT

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_ProdAllocationObjectChange.
-- 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_ProdAllocationObjectChange AS
SELECT
  Master.ProductAllocationObjectUUID AS ProductAllocationObjectUUID,
  Chg.ChangeDocument AS ChangeDocument,
  Chg.DatabaseTable AS DatabaseTable,
  Chg.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  Chg.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  Master.ProductAllocationObject AS ProductAllocationObject,
  Master.ProdAllocHeaderBasicSearch AS ProdAllocHeaderBasicSearch,
  Master.CreatedByUser AS CreatedByUser,
  Master.CreationDateTime AS CreationDateTime,
  cast(substring(cast( Master.CreationDateTime as abap.char(32)),1,8) as pal_creationdate) AS CreationDate,
  Master.LastChangeDateTime AS LastChangeDateTime,
  cast(substring(cast(Master.LastChangeDateTime as abap.char(32)),1,8) as pal_lastchangedate) AS LastChangeDate,
  Master.LastChangedByUser AS LastChangedByUser,
  Chg.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  Chg.ChgDocNewValBasicSearch AS ChgDocNewValBasicSearch,
  Chg.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  Chg.ChgDocPrevValBasicSearch AS ChgDocPrevValBasicSearch,
  cast(Chg.CreatedByUser as changedocumentcreatedbyuser preserving type ) AS ChangeDocumentCreatedByUser,
  Chg.CreationDate AS ChangeDocCreationDate,
  Chg.CreationTime AS CreationTime,
  Master.ProdAllocationLifecycleStatus AS ProdAllocationLifecycleStatus,
  Master.IsDeleted AS IsDeleted,
  Chg._ChangeDocChangeIndT AS _ChangeDocChangeIndT,
  Chg._ChangeDocFieldNamesT AS _ChangeDocFieldNamesT
FROM I_AllProductAllocationObject AS Master
INNER JOIN I_ChgDocItmWithUUIDTableKey ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangeDocumentCreatedByUser ON _ChangeDocumentCreatedByUser.UserID = ChangeDocumentCreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
;

Learn More