I_AllProdAllocCharcValCombn

DDL: I_ALLPRODALLOCCHARCVALCOMBN Type: view_entity COMPOSITE Package: PRODUCT_ALLOCATION_OBJECT
54 Fields 2 Data Sources

All Allocation Characteristic Value Combination

I_AllProdAllocCharcValCombn is a Composite CDS View that provides data about "All Allocation Characteristic Value Combination" in SAP S/4HANA. It reads from 2 data sources (I_DeltdProdAllocCharcValCombn, I_ProdAllocObjCharcValCombn) and exposes 54 fields with key fields DeletedChangeDocument, CharcValueCombinationUUID, CharcValueCombinationUUID. Part of development package PRODUCT_ALLOCATION_OBJECT.

Data Sources (2)

SourceAliasJoin Type
I_DeltdProdAllocCharcValCombn I_DeltdProdAllocCharcValCombn from
I_ProdAllocObjCharcValCombn I_ProdAllocObjCharcValCombn union_all

Annotations (9)

NameValueLevelField
VDM.viewType #COMPOSITE view
Search.searchable true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label All Allocation Characteristic Value Combination view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY DeletedChangeDocument Document Number
KEY CharcValueCombinationUUID CharcValueCombinationUUID Characteristic Value Combination UUID
ProductAllocationObjectUUID ProductAllocationObjectUUID Product Allocation Object UUID
ProductAllocationObject ProductAllocationObject Allocation Object
ProdAllocHeaderBasicSearch ProdAllocHeaderBasicSearch Allocation Object
CharcValAuthznGroup CharcValAuthznGroup Authorization Group
ProdAllocationActivationStatus ProdAllocationActivationStatus Activation Status
ProdAllocCharcValBasicSearch01 ProdAllocCharcValBasicSearch01 Characteristic Value 1
ProdAllocCharc01 ProdAllocCharc01 Characteristic Value 1
ProdAllocCharcValBasicSearch02 ProdAllocCharcValBasicSearch02 Characteristic Value 2
ProdAllocCharc02 ProdAllocCharc02 Characteristic Value 2
ProdAllocCharcValBasicSearch03 ProdAllocCharcValBasicSearch03 Characteristic Value 3
ProdAllocCharc03 ProdAllocCharc03 Characteristic Value 3
ProdAllocCharcValBasicSearch04 ProdAllocCharcValBasicSearch04 Characteristic Value 4
ProdAllocCharc04 ProdAllocCharc04 Characteristic Value 4
ProdAllocCharcValBasicSearch05 ProdAllocCharcValBasicSearch05 Characteristic Value 5
ProdAllocCharc05 ProdAllocCharc05 Characteristic Value 5
ProdAllocCharcValBasicSearch06 ProdAllocCharcValBasicSearch06 Characteristic Value 6
ProdAllocCharc06 ProdAllocCharc06 Characteristic Value 6
ProdAllocCharcValBasicSearch07 ProdAllocCharcValBasicSearch07 Characteristic Value 7
ProdAllocCharc07 ProdAllocCharc07 Characteristic Value 7
ProdAllocCharcValBasicSearch08 ProdAllocCharcValBasicSearch08 Characteristic Value 8
ProdAllocCharc08 ProdAllocCharc08 Characteristic Value 8
ProdAllocCharcValBasicSearch09 ProdAllocCharcValBasicSearch09 Characteristic Value 9
ProdAllocCharc09 ProdAllocCharc09 Characteristic Value 9
ProdAllocCharcValBasicSearch10 ProdAllocCharcValBasicSearch10 Characteristic Value 10
ProdAllocCharc10 ProdAllocCharc10 Characteristic Value 10
KEY CharcValueCombinationUUID CharcValueCombinationUUID Characteristic Value Combination UUID
ProductAllocationObjectUUID ProductAllocationObjectUUID Product Allocation Object UUID
ProductAllocationObject ProductAllocationObject Allocation Object
ProdAllocHeaderBasicSearch Allocation Object
CharcValAuthznGroup CharcValAuthznGroup Authorization Group
ProdAllocationActivationStatus ProdAllocationActivationStatus Activation Status
ProdAllocCharcValBasicSearch01 Characteristic Value 1
ProdAllocCharc01 ProdAllocCharc01 Characteristic Value 1
ProdAllocCharcValBasicSearch02 Characteristic Value 2
ProdAllocCharc02 ProdAllocCharc02 Characteristic Value 2
ProdAllocCharcValBasicSearch03 Characteristic Value 3
ProdAllocCharc03 ProdAllocCharc03 Characteristic Value 3
ProdAllocCharcValBasicSearch04 Characteristic Value 4
ProdAllocCharc04 ProdAllocCharc04 Characteristic Value 4
ProdAllocCharcValBasicSearch05 Characteristic Value 5
ProdAllocCharc05 ProdAllocCharc05 Characteristic Value 5
ProdAllocCharcValBasicSearch06 Characteristic Value 6
ProdAllocCharc06 ProdAllocCharc06 Characteristic Value 6
ProdAllocCharcValBasicSearch07 Characteristic Value 7
ProdAllocCharc07 ProdAllocCharc07 Characteristic Value 7
ProdAllocCharcValBasicSearch08 Characteristic Value 8
ProdAllocCharc08 ProdAllocCharc08 Characteristic Value 8
ProdAllocCharcValBasicSearch09 Characteristic Value 9
ProdAllocCharc09 ProdAllocCharc09 Characteristic Value 9
ProdAllocCharcValBasicSearch10 Characteristic Value 10
ProdAllocCharc10 ProdAllocCharc10 Characteristic Value 10
IsDeleted

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_AllProdAllocCharcValCombn.
-- 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_AllProdAllocCharcValCombn AS
SELECT
  cast(ChangeDocument as deletedchangedocument preserving type ) AS DeletedChangeDocument,
  CharcValueCombinationUUID,
  ProductAllocationObjectUUID,
  ProductAllocationObject,
  ProdAllocHeaderBasicSearch,
  CharcValAuthznGroup,
  ProdAllocationActivationStatus,
  ProdAllocCharcValBasicSearch01,
  ProdAllocCharc01,
  ProdAllocCharcValBasicSearch02,
  ProdAllocCharc02,
  ProdAllocCharcValBasicSearch03,
  ProdAllocCharc03,
  ProdAllocCharcValBasicSearch04,
  ProdAllocCharc04,
  ProdAllocCharcValBasicSearch05,
  ProdAllocCharc05,
  ProdAllocCharcValBasicSearch06,
  ProdAllocCharc06,
  ProdAllocCharcValBasicSearch07,
  ProdAllocCharc07,
  ProdAllocCharcValBasicSearch08,
  ProdAllocCharc08,
  ProdAllocCharcValBasicSearch09,
  ProdAllocCharc09,
  ProdAllocCharcValBasicSearch10,
  ProdAllocCharc10,
  cast( ' ' as lkenz preserving type ) AS IsDeleted
FROM I_DeltdProdAllocCharcValCombn
-- UNION ALL with additional select branch(es): I_ProdAllocObjCharcValCombn
;

Learn More