I_ProdAllocObjAddlMetaData

DDL: I_PRODALLOCOBJADDLMETADATA SQL: IPAOBJ_ACHARC Type: view BASIC Package: PRODUCT_ALLOCATION_OBJECT

Prod Allocation Object Additional Characteristic Meta Data

I_ProdAllocObjAddlMetaData is a Basic CDS View that provides data about "Prod Allocation Object Additional Characteristic Meta Data" in SAP S/4HANA. It reads from 1 data source (paobj_acharc) and exposes 10 fields with key field AddlCharcsMetaDataUUID. It has 4 associations to related views. Part of development package PRODUCT_ALLOCATION_OBJECT.

Data Sources (1)

SourceAliasJoin Type
paobj_acharc paobj_acharc from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ProductAllocationObject _ProductAllocationObject $projection.ProductAllocationObjectUUID = _ProductAllocationObject.ProductAllocationObjectUUID
[1..1] I_ProdAllocObjCharcMetaData _ProdAllocObjCharcMetaData $projection.CharacteristicsMetaDataUUID = _ProdAllocObjCharcMetaData.CharacteristicsMetaDataUUID
[1..1] I_ProdAllocCharcCatalogPath _ProdAllocCharcCatalogPath $projection.ProdAllocCharcCtlgPathUUID = _ProdAllocCharcCatalogPath.ProdAllocCharcCtlgPathUUID
[0..1] I_ProductAllocationOrderType _ProductAllocationOrderType $projection.ProductAllocationOrderType = _ProductAllocationOrderType.ProductAllocationOrderType

Annotations (12)

NameValueLevelField
EndUserText.label Prod Allocation Object Additional Characteristic Meta Data view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.sqlViewName IPAOBJ_ACHARC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
ObjectModel.representativeKey AddlCharcsMetaDataUUID view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY AddlCharcsMetaDataUUID addlcharcsmetadatauuid Additional Characteristic Meta Data UUID
ProductAllocationObjectUUID productallocationobjectuuid Product Allocation Object UUID
CharacteristicsMetaDataUUID characteristicsmetadatauuid Characteristic Meta Data UUID
ProdAllocCharcCtlgPathUUID prodalloccharcctlgpathuuid Product Allocation Characteristic Catalog Path UUID
ProdAllocCharcCtlgPathIntID prodalloccharcctlgpathintid Catalog Path Internal ID
ProductAllocationOrderType productallocationordertype Order Type
_ProductAllocationObject _ProductAllocationObject
_ProdAllocObjCharcMetaData _ProdAllocObjCharcMetaData
_ProdAllocCharcCatalogPath _ProdAllocCharcCatalogPath
_ProductAllocationOrderType _ProductAllocationOrderType

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_ProdAllocObjAddlMetaData.
-- 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.
-- SQL view name: IPAOBJ_ACHARC

CREATE VIEW I_ProdAllocObjAddlMetaData AS
SELECT
  AddlCharcsMetaDataUUID,
  ProductAllocationObjectUUID,
  CharacteristicsMetaDataUUID,
  ProdAllocCharcCtlgPathUUID,
  ProdAllocCharcCtlgPathIntID,
  ProductAllocationOrderType
FROM paobj_acharc
LEFT OUTER JOIN I_ProductAllocationObject AS _ProductAllocationObject ON ProductAllocationObjectUUID = _ProductAllocationObject.ProductAllocationObjectUUID  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocObjCharcMetaData AS _ProdAllocObjCharcMetaData ON CharacteristicsMetaDataUUID = _ProdAllocObjCharcMetaData.CharacteristicsMetaDataUUID  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _ProdAllocCharcCatalogPath ON ProdAllocCharcCtlgPathUUID = _ProdAllocCharcCatalogPath.ProdAllocCharcCtlgPathUUID  -- association [1..1]
LEFT OUTER JOIN I_ProductAllocationOrderType AS _ProductAllocationOrderType ON ProductAllocationOrderType = _ProductAllocationOrderType.ProductAllocationOrderType  -- association [0..1]
;