C_AllocTblItemObjPgSuplgDC

DDL: C_ALLOCTBLITEMOBJPGSUPLGDC SQL: CALCTBLITOBPSUDC Type: view CONSUMPTION
16 Fields 1 Data Sources

Allocation Table Item Object Page - Supplying DCs

C_AllocTblItemObjPgSuplgDC is a Consumption CDS View that provides data about "Allocation Table Item Object Page - Supplying DCs" in SAP S/4HANA. It reads from 1 data source (I_AllocTableItemSuplgDistrCtr) and exposes 16 fields with key fields AllocationTable, AllocationTableItem, DistributionCenter.

Data Sources (1)

SourceAliasJoin Type
I_AllocTableItemSuplgDistrCtr I_AllocTableItemSuplgDistrCtr from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CALCTBLITOBPSUDC view
EndUserText.label Allocation Table Item Object Page - Supplying DCs view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey DistributionCenter view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
UI.presentationVariant.sortOrder.by DistributionCenter view
UI.presentationVariant.sortOrder.direction #ASC view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AllocationTable AllocationTable Alloc. Table
_AllocationTable _AllocationTable
KEY AllocationTableItem AllocationTableItem Item
_AllocationTableItem _AllocationTableItem
KEY DistributionCenter DistributionCenter Distr. Center
_DistributionCenter _DistributionCenter
SiteName _DistributionCenter SiteName
PlannedQuantity PlannedQuantity Plan Quantity
ConfirmedQuantity ConfirmedQuantity Quantity in UnE
QuantityUnit QuantityUnit Unit of measure
_QuantityUnit _QuantityUnit
Supplier Supplier Supplier
_Supplier _Supplier
SupplierName _Supplier SupplierName Supplier Name
DistributionProcessingMethod DistributionProcessingMethod Method
_ProcessingMethod _ProcessingMethod

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 C_AllocTblItemObjPgSuplgDC.
-- 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: CALCTBLITOBPSUDC

CREATE VIEW C_AllocTblItemObjPgSuplgDC AS
SELECT
  AllocationTable,
  AllocationTableItem,
  DistributionCenter,
  _DistributionCenter.SiteName AS SiteName,
  PlannedQuantity,
  ConfirmedQuantity,
  QuantityUnit,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  DistributionProcessingMethod
FROM I_AllocTableItemSuplgDistrCtr
;

Learn More