I_ProdAllocObjAddlMetaDataTP

DDL: I_PRODALLOCOBJADDLMETADATATP Type: view_entity TRANSACTIONAL
10 Fields 1 Data Sources 2 Associations

Prod Allocation Object Additional Characteristic Meta Data

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

Data Sources (1)

SourceAliasJoin Type
I_ProdAllocObjAddlMetaData Document from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProdAllocationObjectTP _ProdAllocationObjectTP _ProdAllocationObjectTP.ProductAllocationObjectUUID = $projection.ProductAllocationObjectUUID
[0..1] I_ProdAllocCharcCatalogPath _ProdAllocCharcCatalogPath _ProdAllocCharcCatalogPath.ProdAllocCharcCtlgPathUUID = $projection.ProdAllocCharcCtlgPathUUID

Annotations (10)

NameValueLevelField
EndUserText.label Prod Allocation Object Additional Characteristic Meta Data view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
ObjectModel.representativeKey AddlCharcsMetaDataUUID view
Analytics.technicalName IPAOBJ_ACHARCTP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY AddlCharcsMetaDataUUID I_ProdAllocObjAddlMetaData AddlCharcsMetaDataUUID Additional Characteristic Meta Data UUID
CharacteristicsMetaDataUUID I_ProdAllocObjAddlMetaData CharacteristicsMetaDataUUID Characteristic Meta Data UUID
ProductAllocationObjectUUID I_ProdAllocObjAddlMetaData ProductAllocationObjectUUID Product Allocation Object UUID
ProdAllocCharcCtlgPathUUID I_ProdAllocObjAddlMetaData ProdAllocCharcCtlgPathUUID Product Allocation Characteristic Catalog Path UUID
ProdAllocCharcCtlgPathIntID I_ProdAllocObjAddlMetaData ProdAllocCharcCtlgPathIntID Catalog Path Internal ID
ProductAllocationOrderType I_ProdAllocObjAddlMetaData ProductAllocationOrderType Order Type
_ProdAllocationObjectTP _ProdAllocationObjectTP
_ProdAllocCharcMetaDataTP _ProdAllocCharcMetaDataTP
_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_ProdAllocObjAddlMetaDataTP.
-- 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_ProdAllocObjAddlMetaDataTP AS
SELECT
  Document.AddlCharcsMetaDataUUID AS AddlCharcsMetaDataUUID,
  Document.CharacteristicsMetaDataUUID AS CharacteristicsMetaDataUUID,
  Document.ProductAllocationObjectUUID AS ProductAllocationObjectUUID,
  Document.ProdAllocCharcCtlgPathUUID AS ProdAllocCharcCtlgPathUUID,
  Document.ProdAllocCharcCtlgPathIntID AS ProdAllocCharcCtlgPathIntID,
  Document.ProductAllocationOrderType AS ProductAllocationOrderType
FROM I_ProdAllocObjAddlMetaData AS Document
LEFT OUTER JOIN I_ProdAllocationObjectTP AS _ProdAllocationObjectTP ON _ProdAllocationObjectTP.ProductAllocationObjectUUID = ProductAllocationObjectUUID  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _ProdAllocCharcCatalogPath ON _ProdAllocCharcCatalogPath.ProdAllocCharcCtlgPathUUID = ProdAllocCharcCtlgPathUUID  -- association [0..1]
;

Learn More