C_POSubcontractingComponentTP

DDL: C_POSUBCONTRACTINGCOMPONENTTP Type: view CONSUMPTION
17 Fields 1 Data Sources 5 Associations

Consumption view for Subcontracting Components in PO

C_POSubcontractingComponentTP is a Consumption CDS View that provides data about "Consumption view for Subcontracting Components in PO" in SAP S/4HANA. It reads from 1 data source (I_POSubcontractingComponentTP) and exposes 17 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine, ReservationItem, RecordType. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_POSubcontractingComponentTP I_POSubcontractingComponentTP from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_PurchaseOrderTP _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] C_PurchaseOrderItemTP _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
[1..1] C_PurOrdScheduleLineTP _ScheduleLine $projection.PurchaseOrder = _ScheduleLine.PurchaseOrder and $projection.PurchaseOrderItem = _ScheduleLine.PurchaseOrderItem and $projection.ScheduleLine = _ScheduleLine.ScheduleLine
[0..1] C_MM_MaterialValueHelp _MaterialValueHelp $projection.Plant = _MaterialValueHelp.Plant and $projection.Material = _MaterialValueHelp.Material
[0..1] C_MM_PlantBasicValueHelp _PlantBasicValueHelp $projection.Plant = _PlantBasicValueHelp.Plant

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CMMPOSUBCOMPTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
UI.headerInfo.typeName Purchase Order Subcontracting view
UI.headerInfo.typeNamePlural Purchase Order Subcontracting view
UI.headerInfo.title.value ReservationItem view
UI.headerInfo.description.value ReservationItem view
Search.searchable true view
VDM.viewType #CONSUMPTION view
EndUserText.label Consumption view for Subcontracting Components in PO view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY ScheduleLine ScheduleLine Schedule Line
KEY ReservationItem ReservationItem Reservation Item
KEY RecordType RecordType Reservation Record Type
Material Material Vehicle Model
BOMItemDescription Item Text
RequirementDate RequirementDate Requirement Date
EntryUnit EntryUnit Unit of Entry
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
Plant Plant Valuation Area
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_ScheduleLine _ScheduleLine
_PlantBasicValueHelp _PlantBasicValueHelp
_MaterialValueHelp _MaterialValueHelp
_EntryUnit _EntryUnit

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_POSubcontractingComponentTP.
-- 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 C_POSubcontractingComponentTP AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  ScheduleLine,
  ReservationItem,
  RecordType,
  Material,
  cast(BOMItemDescription as potx1_ll preserving type ) AS BOMItemDescription,
  RequirementDate,
  EntryUnit,
  QuantityInEntryUnit,
  Plant
FROM I_POSubcontractingComponentTP
LEFT OUTER JOIN C_PurchaseOrderTP AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderItemTP AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_PurOrdScheduleLineTP AS _ScheduleLine ON PurchaseOrder = _ScheduleLine.PurchaseOrder AND PurchaseOrderItem = _ScheduleLine.PurchaseOrderItem AND ScheduleLine = _ScheduleLine.ScheduleLine  -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialValueHelp ON Plant = _MaterialValueHelp.Plant AND Material = _MaterialValueHelp.Material  -- association [0..1]
LEFT OUTER JOIN C_MM_PlantBasicValueHelp AS _PlantBasicValueHelp ON Plant = _PlantBasicValueHelp.Plant  -- association [0..1]
;

Learn More