I_ProdAllocTmeSersChange

DDL: I_PRODALLOCTMESERSCHANGE Type: view_entity COMPOSITE
42 Fields 3 Data Sources 1 Associations

Product Allocation Time Series Change

I_ProdAllocTmeSersChange is a Composite CDS View that provides data about "Product Allocation Time Series Change" in SAP S/4HANA. It reads from 3 data sources (I_ChgDocItmWithUUIDTableKey, I_AllProdAllocObjTmeSers, I_AllProdAllocCharcValCombn) and exposes 42 fields with key fields DeletedChangeDocument, ProdAllocationTimeSeriesUUID, ChangeDocument, DatabaseTable, ChangeDocDatabaseTableField. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_ChgDocItmWithUUIDTableKey I_ChgDocItmWithUUIDTableKey inner
I_AllProdAllocObjTmeSers Master from
I_AllProdAllocCharcValCombn Parent inner

Associations (1)

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

Annotations (7)

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

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY DeletedChangeDocument I_AllProdAllocObjTmeSers DeletedChangeDocument
KEY ProdAllocationTimeSeriesUUID I_AllProdAllocObjTmeSers ProdAllocationTimeSeriesUUID Product Allocation Time SeriesUUID
KEY ChangeDocument Chg ChangeDocument Document Number
KEY DatabaseTable Chg DatabaseTable Table Name
KEY ChangeDocDatabaseTableField Chg ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType Chg ChangeDocItemChangeType
ProductAllocationObjectUUID I_AllProdAllocObjTmeSers ProductAllocationObjectUUID Product Allocation Object UUID
CharcValueCombinationUUID I_AllProdAllocObjTmeSers CharcValueCombinationUUID Characteristic Value Combination UUID
CharcValAuthznGroup I_AllProdAllocCharcValCombn CharcValAuthznGroup Authorization Group
ProdAllocCharc01 I_AllProdAllocCharcValCombn ProdAllocCharc01 Characteristic Value 1
ProdAllocCharcValBasicSearch01 I_AllProdAllocCharcValCombn ProdAllocCharcValBasicSearch01
ProdAllocCharc02 I_AllProdAllocCharcValCombn ProdAllocCharc02 Characteristic Value 2
ProdAllocCharcValBasicSearch02 I_AllProdAllocCharcValCombn ProdAllocCharcValBasicSearch02
ProdAllocCharc03 I_AllProdAllocCharcValCombn ProdAllocCharc03 Characteristic Value 3
ProdAllocCharcValBasicSearch03 I_AllProdAllocCharcValCombn ProdAllocCharcValBasicSearch03
ProdAllocCharc04 I_AllProdAllocCharcValCombn ProdAllocCharc04 Characteristic Value 4
ProdAllocCharcValBasicSearch04 I_AllProdAllocCharcValCombn ProdAllocCharcValBasicSearch04
ProdAllocCharc05 I_AllProdAllocCharcValCombn ProdAllocCharc05 Characteristic Value 5
ProdAllocCharcValBasicSearch05 I_AllProdAllocCharcValCombn ProdAllocCharcValBasicSearch05
ProdAllocCharc06 I_AllProdAllocCharcValCombn ProdAllocCharc06 Characteristic Value 6
ProdAllocCharcValBasicSearch06 I_AllProdAllocCharcValCombn ProdAllocCharcValBasicSearch06
ProdAllocCharc07 I_AllProdAllocCharcValCombn ProdAllocCharc07 Characteristic Value 7
ProdAllocCharcValBasicSearch07 I_AllProdAllocCharcValCombn ProdAllocCharcValBasicSearch07
ProdAllocCharc08 I_AllProdAllocCharcValCombn ProdAllocCharc08 Characteristic Value 8
ProdAllocCharcValBasicSearch08 I_AllProdAllocCharcValCombn ProdAllocCharcValBasicSearch08
ProdAllocCharc09 I_AllProdAllocCharcValCombn ProdAllocCharc09 Characteristic Value 9
ProdAllocCharcValBasicSearch09 I_AllProdAllocCharcValCombn ProdAllocCharcValBasicSearch09
ProdAllocCharc10 I_AllProdAllocCharcValCombn ProdAllocCharc10 Characteristic Value 10
ProdAllocCharcValBasicSearch10 I_AllProdAllocCharcValCombn ProdAllocCharcValBasicSearch10
ProdAllocationPeriodStartDate I_AllProdAllocObjTmeSers ProdAllocationPeriodStartDate Period Start Date
ChangeDocNewFieldValue Chg ChangeDocNewFieldValue
ChgDocNewValBasicSearch Chg ChgDocNewValBasicSearch
ChangeDocPreviousFieldValue Chg ChangeDocPreviousFieldValue
ChgDocPrevValBasicSearch Chg ChgDocPrevValBasicSearch
ChangeDocNewUnit Chg ChangeDocNewUnit
ChangeDocPreviousUnit Chg ChangeDocPreviousUnit
CreatedByUser Chg CreatedByUser User Name
CreationDate Chg CreationDate Time Stamp
CreationTime Chg CreationTime Time of Change
_ChangeDocChangeIndT Chg _ChangeDocChangeIndT
_ChangeDocFieldNamesT Chg _ChangeDocFieldNamesT
_CreatedByUser _CreatedByUser

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_ProdAllocTmeSersChange.
-- 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_ProdAllocTmeSersChange AS
SELECT
  Master.DeletedChangeDocument AS DeletedChangeDocument,
  Master.ProdAllocationTimeSeriesUUID AS ProdAllocationTimeSeriesUUID,
  Chg.ChangeDocument AS ChangeDocument,
  Chg.DatabaseTable AS DatabaseTable,
  Chg.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  Chg.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  Master.ProductAllocationObjectUUID AS ProductAllocationObjectUUID,
  Master.CharcValueCombinationUUID AS CharcValueCombinationUUID,
  Parent.CharcValAuthznGroup AS CharcValAuthznGroup,
  Parent.ProdAllocCharc01 AS ProdAllocCharc01,
  Parent.ProdAllocCharcValBasicSearch01 AS ProdAllocCharcValBasicSearch01,
  Parent.ProdAllocCharc02 AS ProdAllocCharc02,
  Parent.ProdAllocCharcValBasicSearch02 AS ProdAllocCharcValBasicSearch02,
  Parent.ProdAllocCharc03 AS ProdAllocCharc03,
  Parent.ProdAllocCharcValBasicSearch03 AS ProdAllocCharcValBasicSearch03,
  Parent.ProdAllocCharc04 AS ProdAllocCharc04,
  Parent.ProdAllocCharcValBasicSearch04 AS ProdAllocCharcValBasicSearch04,
  Parent.ProdAllocCharc05 AS ProdAllocCharc05,
  Parent.ProdAllocCharcValBasicSearch05 AS ProdAllocCharcValBasicSearch05,
  Parent.ProdAllocCharc06 AS ProdAllocCharc06,
  Parent.ProdAllocCharcValBasicSearch06 AS ProdAllocCharcValBasicSearch06,
  Parent.ProdAllocCharc07 AS ProdAllocCharc07,
  Parent.ProdAllocCharcValBasicSearch07 AS ProdAllocCharcValBasicSearch07,
  Parent.ProdAllocCharc08 AS ProdAllocCharc08,
  Parent.ProdAllocCharcValBasicSearch08 AS ProdAllocCharcValBasicSearch08,
  Parent.ProdAllocCharc09 AS ProdAllocCharc09,
  Parent.ProdAllocCharcValBasicSearch09 AS ProdAllocCharcValBasicSearch09,
  Parent.ProdAllocCharc10 AS ProdAllocCharc10,
  Parent.ProdAllocCharcValBasicSearch10 AS ProdAllocCharcValBasicSearch10,
  Master.ProdAllocationPeriodStartDate AS ProdAllocationPeriodStartDate,
  Chg.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  Chg.ChgDocNewValBasicSearch AS ChgDocNewValBasicSearch,
  Chg.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  Chg.ChgDocPrevValBasicSearch AS ChgDocPrevValBasicSearch,
  Chg.ChangeDocNewUnit AS ChangeDocNewUnit,
  Chg.ChangeDocPreviousUnit AS ChangeDocPreviousUnit,
  Chg.CreatedByUser AS CreatedByUser,
  Chg.CreationDate AS CreationDate,
  Chg.CreationTime AS CreationTime,
  Chg._ChangeDocChangeIndT AS _ChangeDocChangeIndT,
  Chg._ChangeDocFieldNamesT AS _ChangeDocFieldNamesT
FROM I_AllProdAllocObjTmeSers AS Master
INNER JOIN I_ChgDocItmWithUUIDTableKey ON /* join condition not captured in parsed metadata */
INNER JOIN I_AllProdAllocCharcValCombn AS Parent ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
;

Learn More