I_ProductAllocationObject

DDL: I_PRODUCTALLOCATIONOBJECT SQL: IPALLOCOBJ Type: view BASIC
35 Fields 1 Data Sources 16 Associations

Product Allocation Object

I_ProductAllocationObject is a Basic CDS View that provides data about "Product Allocation Object" in SAP S/4HANA. It reads from 1 data source (pallocobj) and exposes 35 fields with key field ProductAllocationObjectUUID. It has 16 associations to related views.

Data Sources (1)

SourceAliasJoin Type
pallocobj pallocobj from

Associations (16)

CardinalityTargetAliasCondition
[0..*] I_ProdAllocObjCharcValCombn _ProdAllocObjCharcValCombn $projection.ProductAllocationObjectUUID = _ProdAllocObjCharcValCombn.ProductAllocationObjectUUID
[0..*] I_ProdAllocObjCharcMetaData _ProdAllocObjCharcMetaData $projection.ProductAllocationObjectUUID = _ProdAllocObjCharcMetaData.ProductAllocationObjectUUID
[0..*] I_ProdAllocObjFlxblTmeSers _ProdAllocObjFlxblTmeSers $projection.ProductAllocationObjectUUID = _ProdAllocObjFlxblTmeSers.ProductAllocationObjectUUID
[0..1] I_UnitOfMeasure _ProductAllocQuantityUnit $projection.ProductAllocationQuantityUnit = _ProductAllocQuantityUnit.UnitOfMeasure
[0..1] I_CollectiveAllocationType _CollectiveAllocationType $projection.CollectiveAllocationType = _CollectiveAllocationType.CollectiveAllocationType
[0..1] I_ProdAllocLifecycleStatus _ProdAllocLifecycleStatus $projection.ProdAllocationLifecycleStatus = _ProdAllocLifecycleStatus.ProdAllocationLifecycleStatus
[0..1] I_ProdAllocConsistencyStatus _ProdAllocConsistencyStatus $projection.ProdAllocConsistencyStatus = _ProdAllocConsistencyStatus.ProdAllocConsistencyStatus
[0..*] I_ProductAllocationObjectText _Text $projection.ProductAllocationObjectUUID = _Text.ProductAllocationObjectUUID
[0..1] I_ProdAllocAsyncUpldStatus _ProdAllocAsyncUpldStatus $projection.ProdAllocAsyncUpldStatus = _ProdAllocAsyncUpldStatus.ProdAllocAsyncUpldStatus
[0..1] I_ProdAllocCheckDateTimeType _ProdAllocCheckDateTimeType $projection.ProdAllocCheckDateTimeType = _ProdAllocCheckDateTimeType.ProdAllocCheckDateTimeType
[0..1] I_ProductAllocationPeriodType _ProductAllocationPeriodType $projection.ProductAllocationPeriodType = _ProductAllocationPeriodType.ProductAllocationPeriodType
[0..1] I_ProdAllocPerdTimeZoneDetn _ProdAllocPerdTimeZoneDetn $projection.ProdAllocPeriodTimeZoneDetn = _ProdAllocPerdTimeZoneDetn.ProdAllocPeriodTimeZoneDetn
[0..1] I_TimeZone _ProdAllocPeriodTimeZone $projection.ProdAllocationPeriodTimeZone = _ProdAllocPeriodTimeZone.TimeZoneID
[0..1] I_FactoryCalendar _FactoryCalendar $projection.FactoryCalendar = _FactoryCalendar.FactoryCalendar
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (16)

NameValueLevelField
EndUserText.label Product Allocation Object view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.sqlViewName IPALLOCOBJ view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
ObjectModel.semanticKey ProductAllocationObject view
ObjectModel.representativeKey ProductAllocationObjectUUID view
ObjectModel.compositionRoot true view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.sapObjectNodeType.name ProductAllocationObject view
ObjectModel.entityChangeStateId LastChangeDateTime view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY ProductAllocationObjectUUID productallocationobjectuuid Product Allocation Object UUID
ProductAllocationObject productallocationobject Allocation Object
ProductAllocationPeriodType productallocationperiodtype Period Type
ProdAllocPeriodTimeZoneDetn prodallocperiodtimezonedetn Period Time Zone Determination
ProdAllocationPeriodTimeZone prodallocationperiodtimezone Period Time Zone
FactoryCalendar factorycalendar Factory Calendar
ProdAllocCheckDateTimeType prodalloccheckdatetimetype Check Date Time Type
ProductAllocationQuantityUnit productallocationquantityunit Quantity Unit
CollectiveAllocationType collectiveallocationtype Collective
IsSalesOrderAllocObj issalesorderallocobj Sales Document
IsStockTransferOrderAllocObj isstocktransferorderallocobj Stock Transport
ProdAllocAsyncUpldStatus prodallocasyncupldstatus Asynchronous Upload Status
ProdAllocObjPeriodAgedToDate prodallocobjperiodagedtodate Periods Aged Until Date
ProdAllocationLifecycleStatus prodallocationlifecyclestatus Lifecycle Status
ProdAllocConsistencyStatus prodallocconsistencystatus Consistency Status
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
_ProdAllocObjCharcValCombn _ProdAllocObjCharcValCombn
_ProdAllocObjCharcMetaData _ProdAllocObjCharcMetaData
_ProdAllocObjFlxblTmeSers _ProdAllocObjFlxblTmeSers
_Text _Text
_ProductAllocationPeriodType _ProductAllocationPeriodType
_ProductAllocQuantityUnit _ProductAllocQuantityUnit
_CollectiveAllocationType _CollectiveAllocationType
_ProdAllocLifecycleStatus _ProdAllocLifecycleStatus
_ProdAllocConsistencyStatus _ProdAllocConsistencyStatus
_ProdAllocCheckDateTimeType _ProdAllocCheckDateTimeType
_ProdAllocAsyncUpldStatus _ProdAllocAsyncUpldStatus
_ProdAllocPerdTimeZoneDetn _ProdAllocPerdTimeZoneDetn
_ProdAllocPeriodTimeZone _ProdAllocPeriodTimeZone
_FactoryCalendar _FactoryCalendar
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_ProductAllocationObject.
-- 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: IPALLOCOBJ

CREATE VIEW I_ProductAllocationObject AS
SELECT
  ProductAllocationObjectUUID,
  ProductAllocationObject,
  ProductAllocationPeriodType,
  ProdAllocPeriodTimeZoneDetn,
  ProdAllocationPeriodTimeZone,
  FactoryCalendar,
  ProdAllocCheckDateTimeType,
  ProductAllocationQuantityUnit,
  CollectiveAllocationType,
  IsSalesOrderAllocObj,
  IsStockTransferOrderAllocObj,
  ProdAllocAsyncUpldStatus,
  ProdAllocObjPeriodAgedToDate,
  ProdAllocationLifecycleStatus,
  ProdAllocConsistencyStatus,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM pallocobj
LEFT OUTER JOIN I_ProdAllocObjCharcValCombn AS _ProdAllocObjCharcValCombn ON ProductAllocationObjectUUID = _ProdAllocObjCharcValCombn.ProductAllocationObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_ProdAllocObjCharcMetaData AS _ProdAllocObjCharcMetaData ON ProductAllocationObjectUUID = _ProdAllocObjCharcMetaData.ProductAllocationObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_ProdAllocObjFlxblTmeSers AS _ProdAllocObjFlxblTmeSers ON ProductAllocationObjectUUID = _ProdAllocObjFlxblTmeSers.ProductAllocationObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductAllocQuantityUnit ON ProductAllocationQuantityUnit = _ProductAllocQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CollectiveAllocationType AS _CollectiveAllocationType ON CollectiveAllocationType = _CollectiveAllocationType.CollectiveAllocationType  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocLifecycleStatus AS _ProdAllocLifecycleStatus ON ProdAllocationLifecycleStatus = _ProdAllocLifecycleStatus.ProdAllocationLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocConsistencyStatus AS _ProdAllocConsistencyStatus ON ProdAllocConsistencyStatus = _ProdAllocConsistencyStatus.ProdAllocConsistencyStatus  -- association [0..1]
LEFT OUTER JOIN I_ProductAllocationObjectText AS _Text ON ProductAllocationObjectUUID = _Text.ProductAllocationObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_ProdAllocAsyncUpldStatus AS _ProdAllocAsyncUpldStatus ON ProdAllocAsyncUpldStatus = _ProdAllocAsyncUpldStatus.ProdAllocAsyncUpldStatus  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCheckDateTimeType AS _ProdAllocCheckDateTimeType ON ProdAllocCheckDateTimeType = _ProdAllocCheckDateTimeType.ProdAllocCheckDateTimeType  -- association [0..1]
LEFT OUTER JOIN I_ProductAllocationPeriodType AS _ProductAllocationPeriodType ON ProductAllocationPeriodType = _ProductAllocationPeriodType.ProductAllocationPeriodType  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocPerdTimeZoneDetn AS _ProdAllocPerdTimeZoneDetn ON ProdAllocPeriodTimeZoneDetn = _ProdAllocPerdTimeZoneDetn.ProdAllocPeriodTimeZoneDetn  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _ProdAllocPeriodTimeZone ON ProdAllocationPeriodTimeZone = _ProdAllocPeriodTimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;

Learn More