I_ProdAllocCharcValCombnChg

DDL: I_PRODALLOCCHARCVALCOMBNCHG Type: view_entity COMPOSITE Package: PRODUCT_ALLOCATION_OBJECT
42 Fields 2 Data Sources 1 Associations

Product Allocation Characteristic Value Combination Change

I_ProdAllocCharcValCombnChg is a Composite CDS View that provides data about "Product Allocation Characteristic Value Combination Change" in SAP S/4HANA. It reads from 2 data sources (I_ChgDocItmWithUUIDTableKey, I_AllProdAllocCharcValCombn) and exposes 42 fields with key fields DeletedChangeDocument, CharcValueCombinationUUID, ChangeDocument, DatabaseTable, ChangeDocDatabaseTableField. It has 1 association to related views. Part of development package PRODUCT_ALLOCATION_OBJECT.

Data Sources (2)

SourceAliasJoin Type
I_ChgDocItmWithUUIDTableKey I_ChgDocItmWithUUIDTableKey inner
I_AllProdAllocCharcValCombn Master from

Associations (1)

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

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Product Allocation Characteristic Value Combination 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_AllProdAllocCharcValCombn DeletedChangeDocument
KEY CharcValueCombinationUUID I_AllProdAllocCharcValCombn CharcValueCombinationUUID Characteristic Value Combination UUID
KEY ChangeDocument Chg ChangeDocument Document Number
KEY DatabaseTable Chg DatabaseTable Table Name
KEY ChangeDocDatabaseTableField Chg ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType Chg ChangeDocItemChangeType
ProductAllocationObject I_AllProdAllocCharcValCombn ProductAllocationObject Allocation Object
ProdAllocHeaderBasicSearch I_AllProdAllocCharcValCombn ProdAllocHeaderBasicSearch
ProductAllocationObjectUUID I_AllProdAllocCharcValCombn ProductAllocationObjectUUID Product Allocation Object UUID
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
CharcValAuthznGroup I_AllProdAllocCharcValCombn CharcValAuthznGroup Authorization Group
ProdAllocationActivationStatus I_AllProdAllocCharcValCombn ProdAllocationActivationStatus Activation Status
ChangeDocNewFieldValue Chg ChangeDocNewFieldValue
ChgDocNewValBasicSearch Chg ChgDocNewValBasicSearch
ChangeDocPreviousFieldValue Chg ChangeDocPreviousFieldValue
ChgDocPrevValBasicSearch Chg ChgDocPrevValBasicSearch
CreatedByUser Chg CreatedByUser User Name
CreationDate Chg CreationDate Time Stamp
CreationTime Chg CreationTime Time of Change
IsDeleted I_AllProdAllocCharcValCombn IsDeleted TRUE
_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_ProdAllocCharcValCombnChg.
-- 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_ProdAllocCharcValCombnChg AS
SELECT
  Master.DeletedChangeDocument AS DeletedChangeDocument,
  Master.CharcValueCombinationUUID AS CharcValueCombinationUUID,
  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.ProductAllocationObjectUUID AS ProductAllocationObjectUUID,
  Master.ProdAllocCharc01 AS ProdAllocCharc01,
  Master.ProdAllocCharcValBasicSearch01 AS ProdAllocCharcValBasicSearch01,
  Master.ProdAllocCharc02 AS ProdAllocCharc02,
  Master.ProdAllocCharcValBasicSearch02 AS ProdAllocCharcValBasicSearch02,
  Master.ProdAllocCharc03 AS ProdAllocCharc03,
  Master.ProdAllocCharcValBasicSearch03 AS ProdAllocCharcValBasicSearch03,
  Master.ProdAllocCharc04 AS ProdAllocCharc04,
  Master.ProdAllocCharcValBasicSearch04 AS ProdAllocCharcValBasicSearch04,
  Master.ProdAllocCharc05 AS ProdAllocCharc05,
  Master.ProdAllocCharcValBasicSearch05 AS ProdAllocCharcValBasicSearch05,
  Master.ProdAllocCharc06 AS ProdAllocCharc06,
  Master.ProdAllocCharcValBasicSearch06 AS ProdAllocCharcValBasicSearch06,
  Master.ProdAllocCharc07 AS ProdAllocCharc07,
  Master.ProdAllocCharcValBasicSearch07 AS ProdAllocCharcValBasicSearch07,
  Master.ProdAllocCharc08 AS ProdAllocCharc08,
  Master.ProdAllocCharcValBasicSearch08 AS ProdAllocCharcValBasicSearch08,
  Master.ProdAllocCharc09 AS ProdAllocCharc09,
  Master.ProdAllocCharcValBasicSearch09 AS ProdAllocCharcValBasicSearch09,
  Master.ProdAllocCharc10 AS ProdAllocCharc10,
  Master.ProdAllocCharcValBasicSearch10 AS ProdAllocCharcValBasicSearch10,
  Master.CharcValAuthznGroup AS CharcValAuthznGroup,
  Master.ProdAllocationActivationStatus AS ProdAllocationActivationStatus,
  Chg.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  Chg.ChgDocNewValBasicSearch AS ChgDocNewValBasicSearch,
  Chg.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  Chg.ChgDocPrevValBasicSearch AS ChgDocPrevValBasicSearch,
  Chg.CreatedByUser AS CreatedByUser,
  Chg.CreationDate AS CreationDate,
  Chg.CreationTime AS CreationTime,
  Master.IsDeleted AS IsDeleted,
  Chg._ChangeDocChangeIndT AS _ChangeDocChangeIndT,
  Chg._ChangeDocFieldNamesT AS _ChangeDocFieldNamesT
FROM I_AllProdAllocCharcValCombn 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]
;

Learn More