A_POSubcontractingComponent
Subcontracting Components
A_POSubcontractingComponent is a Composite CDS View that provides data about "Subcontracting Components" in SAP S/4HANA. It reads from 1 data source (R_POSubcontractingComponent) and exposes 18 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine, ReservationItem, RecordType. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_POSubcontractingComponent | R_POSubcontractingComponent | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | A_PurchaseOrder | _PurchaseOrder | $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder |
| [1..1] | A_PurchaseOrderItem | _PurchaseOrderItem | $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | APURORDSUBCOMP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| EndUserText.label | Subcontracting Components | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| OData.entitySet.name | A_POSubcontractingComponent | view |
Fields (18)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseOrder | PurchaseOrder | ||
| KEY | PurchaseOrderItem | PurchaseOrderItem | ||
| KEY | ScheduleLine | PurchaseOrderScheduleLine | ||
| KEY | ReservationItem | ReservationItem | ||
| KEY | RecordType | RecordType | ||
| Material | Material | |||
| BOMItemDescription | ||||
| RequiredQuantity | RequiredQuantity | |||
| BaseUnit | BaseUnit | |||
| RequirementDate | RequirementDate | |||
| QuantityInEntryUnit | QuantityInEntryUnit | |||
| EntryUnit | EntryUnit | |||
| WithdrawnQuantity | WithdrawnQuantity | |||
| Plant | Plant | |||
| Batch | Batch | |||
| _PurchaseOrder | _PurchaseOrder | |||
| _PurchaseOrderItem | _PurchaseOrderItem | |||
| _ScheduleLine | _ScheduleLine |
@AbapCatalog.sqlViewName: 'APURORDSUBCOMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Subcontracting Components'
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@OData.entitySet.name : 'A_POSubcontractingComponent'
////@Objectmodel.representativeKey: 'ReservationItem'
////@Objectmodel: {
// createEnabled: true,
// updateEnabled: true,
// deleteEnabled: true
//}
define view A_POSubcontractingComponent
as select from R_POSubcontractingComponent
association to parent A_PurchaseOrderScheduleLine as _ScheduleLine on $projection.PurchaseOrder = _ScheduleLine.PurchasingDocument
and $projection.PurchaseOrderItem = _ScheduleLine.PurchasingDocumentItem
and $projection.ScheduleLine = _ScheduleLine.ScheduleLine
association [1..1] to A_PurchaseOrder as _PurchaseOrder on $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
association [1..1] to A_PurchaseOrderItem as _PurchaseOrderItem on $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder
and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
{
key PurchaseOrder,
key PurchaseOrderItem,
key PurchaseOrderScheduleLine as ScheduleLine,
//@Objectmodel.readOnly: null
key ReservationItem,
//@Objectmodel.readOnly: null
key RecordType,
Material,
//BillOfMaterialItemNumber, // default value is 9999
//@Objectmodel.readOnly: null
cast(BOMItemDescription as potx1_ll preserving type ) as BOMItemDescription,
//@Objectmodel.readOnly: null
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
RequiredQuantity,
//@Objectmodel.readOnly: null
@Semantics.unitOfMeasure: true
BaseUnit,
@Semantics.businessDate.at:true
RequirementDate,
@Semantics.quantity.unitOfMeasure: 'EntryUnit'
QuantityInEntryUnit,
@Semantics.unitOfMeasure: true
EntryUnit,
//@Objectmodel.readOnly: null
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
WithdrawnQuantity,
Plant,
//@Objectmodel.readOnly: null
Batch,
//@Objectmodel.association.type: #TO_COMPOSITION_ROOT
_PurchaseOrder,
_PurchaseOrderItem,
//@Objectmodel.association.type: #TO_COMPOSITION_PARENT
_ScheduleLine
} where _PurchaseOrderItem.PurchaseOrderItemCategory = '3' and _PurchaseOrderItem.PurchasingDocumentDeletionCode = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_PURCHASEORDERITEM",
"R_POSUBCONTRACTINGCOMPONENT"
],
"ASSOCIATED":
[
"A_PURCHASEORDER",
"A_PURCHASEORDERITEM",
"A_PURCHASEORDERSCHEDULELINE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA