I_ProdAllocationSqncAssgmtChg

DDL: I_PRODALLOCATIONSQNCASSGMTCHG Type: view_entity COMPOSITE
28 Fields 2 Data Sources 2 Associations

Product Allocation Sequence Assignment Change

I_ProdAllocationSqncAssgmtChg is a Composite CDS View that provides data about "Product Allocation Sequence Assignment Change" in SAP S/4HANA. It reads from 2 data sources (I_ChgDocItmWithUUIDTableKey, I_AllProdAllocationSqncAssgmt) and exposes 28 fields with key fields DeletedChangeDocument, ProdAllocSqncAssignmentUUID, ChangeDocument, DatabaseTable, ChangeDocDatabaseTableField. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ChgDocItmWithUUIDTableKey I_ChgDocItmWithUUIDTableKey inner
I_AllProdAllocationSqncAssgmt Master from

Associations (2)

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

Annotations (7)

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

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY DeletedChangeDocument I_AllProdAllocationSqncAssgmt DeletedChangeDocument
KEY ProdAllocSqncAssignmentUUID I_AllProdAllocationSqncAssgmt ProdAllocSqncAssignmentUUID Product Allocation Sequence Assignment UUID
KEY ChangeDocument Chg ChangeDocument Document Number
KEY DatabaseTable Chg DatabaseTable Table Name
KEY ChangeDocDatabaseTableField Chg ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType Chg ChangeDocItemChangeType
ProductAllocationSequenceUUID I_AllProdAllocationSqncAssgmt ProductAllocationSequenceUUID Product Allocation Sequence UUID
ProductAllocationSequence I_AllProdAllocationSqncAssgmt ProductAllocationSequence Allocation Sequence
ProdAllocHeaderBasicSearch I_AllProdAllocationSqncAssgmt ProdAllocHeaderBasicSearch
Material I_AllProdAllocationSqncAssgmt Material Vehicle Model
ProdAllocMaterialBasicSearch I_AllProdAllocationSqncAssgmt ProdAllocMaterialBasicSearch
Plant I_AllProdAllocationSqncAssgmt Plant Valuation Area
ProdAllocPlantBasicSearch I_AllProdAllocationSqncAssgmt ProdAllocPlantBasicSearch
ValidityStartUTCDateTime I_AllProdAllocationSqncAssgmt ValidityStartUTCDateTime Validity Start
ValidityEndUTCDateTime I_AllProdAllocationSqncAssgmt ValidityEndUTCDateTime Validity End
IsDeleted I_AllProdAllocationSqncAssgmt IsDeleted TRUE
ChangeDocumentCreatedByUser
ChangeDocNewFieldValue Chg ChangeDocNewFieldValue
ChgDocNewValBasicSearch Chg ChgDocNewValBasicSearch
ChangeDocPreviousFieldValue Chg ChangeDocPreviousFieldValue
ChgDocPrevValBasicSearch Chg ChgDocPrevValBasicSearch
CreatedByUser Chg CreatedByUser User Name
ChangeDocCreationDate Chg CreationDate Time Stamp
CreationTime Chg CreationTime Time of Change
_ChangeDocChangeIndT Chg _ChangeDocChangeIndT
_ChangeDocFieldNamesT Chg _ChangeDocFieldNamesT
_CreatedByUser _CreatedByUser
_ChangeDocumentCreatedByUser _ChangeDocumentCreatedByUser

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_ProdAllocationSqncAssgmtChg.
-- 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_ProdAllocationSqncAssgmtChg AS
SELECT
  Master.DeletedChangeDocument AS DeletedChangeDocument,
  Master.ProdAllocSqncAssignmentUUID AS ProdAllocSqncAssignmentUUID,
  Chg.ChangeDocument AS ChangeDocument,
  Chg.DatabaseTable AS DatabaseTable,
  Chg.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  Chg.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  Master.ProductAllocationSequenceUUID AS ProductAllocationSequenceUUID,
  Master.ProductAllocationSequence AS ProductAllocationSequence,
  Master.ProdAllocHeaderBasicSearch AS ProdAllocHeaderBasicSearch,
  Master.Material AS Material,
  Master.ProdAllocMaterialBasicSearch AS ProdAllocMaterialBasicSearch,
  Master.Plant AS Plant,
  Master.ProdAllocPlantBasicSearch AS ProdAllocPlantBasicSearch,
  Master.ValidityStartUTCDateTime AS ValidityStartUTCDateTime,
  Master.ValidityEndUTCDateTime AS ValidityEndUTCDateTime,
  Master.IsDeleted AS IsDeleted,
  cast(Chg.CreatedByUser as changedocumentcreatedbyuser preserving type ) AS ChangeDocumentCreatedByUser,
  Chg.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  Chg.ChgDocNewValBasicSearch AS ChgDocNewValBasicSearch,
  Chg.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  Chg.ChgDocPrevValBasicSearch AS ChgDocPrevValBasicSearch,
  Chg.CreatedByUser AS CreatedByUser,
  Chg.CreationDate AS ChangeDocCreationDate,
  Chg.CreationTime AS CreationTime,
  Chg._ChangeDocChangeIndT AS _ChangeDocChangeIndT,
  Chg._ChangeDocFieldNamesT AS _ChangeDocFieldNamesT
FROM I_AllProdAllocationSqncAssgmt 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]
;

Learn More