R_POSubcontractingComponentTP
PO Subcontracting Components TP view
R_POSubcontractingComponentTP is a Transactional CDS View that provides data about "PO Subcontracting Components TP view" in SAP S/4HANA. It reads from 1 data source (R_POSubcontractingComponent) and exposes 65 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] | R_PurchaseOrderTP | _PurchaseOrder | $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder |
| [1..1] | R_PurchaseOrderItemTP | _PurchaseOrderItem | $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| EndUserText.label | PO Subcontracting Components TP view | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| VDM.viewType | #TRANSACTIONAL | view |
Fields (65)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseOrder | PurchaseOrder | ||
| KEY | PurchaseOrderItem | PurchaseOrderItem | ||
| KEY | ScheduleLine | PurchaseOrderScheduleLine | ||
| KEY | ReservationItem | ReservationItem | ||
| KEY | RecordType | RecordType | ||
| Material | Material | |||
| IsMaterialProvision | IsMaterialProvision | |||
| MaterialProvisionType | MaterialProvisionType | |||
| MaterialQtyToBaseQtyNmrtr | MaterialQtyToBaseQtyNmrtr | |||
| MaterialQtyToBaseQtyDnmntr | MaterialQtyToBaseQtyDnmntr | |||
| MaterialRevisionLevel | ||||
| MaterialCompIsVariableSized | MaterialCompIsVariableSized | |||
| MaterialComponentIsPhantomItem | MaterialComponentIsPhantomItem | |||
| Reservation | Reservation | |||
| RequiredQuantity | RequiredQuantity | |||
| RequirementDate | RequirementDate | |||
| RequirementTime | RequirementTime | |||
| ReservationIsFinallyIssued | ReservationIsFinallyIssued | |||
| BaseUnit | BaseUnit | |||
| QuantityInEntryUnit | QuantityInEntryUnit | |||
| EntryUnit | EntryUnit | |||
| VariableSizeItemQuantity | VariableSizeItemQuantity | |||
| VariableSizeItemUnit | VariableSizeItemUnit | |||
| VariableSizeComponentUnit | VariableSizeComponentUnit | |||
| VariableSizeComponentQuantity | VariableSizeComponentQuantity | |||
| UnitOfMeasureForSize1To3 | UnitOfMeasureForSize1To3 | |||
| Size1 | Size1 | |||
| Size2 | Size2 | |||
| Size3 | Size3 | |||
| Plant | Plant | |||
| LatestRequirementDate | LatestRequirementDate | |||
| OrderLevelValue | OrderLevelValue | |||
| OrderPathValue | OrderPathValue | |||
| BillOfMaterialItemNumber | ||||
| MatlCompFreeDefinedAttribute | SortField | |||
| BOMItemCategory | BOMItemCategory | |||
| IsBulkMaterialComponent | IsBulkMaterialComponent | |||
| AccountAssignmentCategory | AccountAssignmentCategory | |||
| InventorySpecialStockType | InventorySpecialStockType | |||
| ConsumptionPosting | ConsumptionPosting | |||
| InventorySpecialStockValnType | InventorySpecialStockValnType | |||
| DebitCreditCode | DebitCreditCode | |||
| WithdrawnQuantity | WithdrawnQuantity | |||
| QuantityIsFixed | QuantityIsFixed | |||
| ComponentScrapInPercent | ComponentScrapInPercent | |||
| OperationScrapInPercent | OperationScrapInPercent | |||
| IsNetScrap | IsNetScrap | |||
| LeadTimeOffset | LeadTimeOffset | |||
| QuantityDistributionKey | QuantityDistributionKey | |||
| FormulaKey | FormulaKey | |||
| StorageLocation | StorageLocation | |||
| ProductionSupplyArea | ProductionSupplyArea | |||
| Batch | Batch | |||
| BOMItemDescription | BOMItemDescription | |||
| BOMItemText2 | BOMItemText2 | |||
| ChangeNumber | ChangeNumber | |||
| _BaseUnit | _BaseUnit | |||
| _EntryUnit | _EntryUnit | |||
| _Material | _Material | |||
| _Product | _Product | |||
| _PurchaseOrder | _PurchaseOrder | |||
| _PurchaseOrderItem | _PurchaseOrderItem | |||
| _ScheduleLine | _ScheduleLine | |||
| _VariableSize1To3Unit | _VariableSize1To3Unit | |||
| _VariableSizeCompUnit | _VariableSizeCompUnit |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: { authorizationCheck: #CHECK}
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'PO Subcontracting Components TP view'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
define view entity R_POSubcontractingComponentTP
as select from R_POSubcontractingComponent
association [1..1] to R_PurchaseOrderTP as _PurchaseOrder on $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
association [1..1] to R_PurchaseOrderItemTP as _PurchaseOrderItem on $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder
and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
association to parent R_PurchaseOrderScheduleLineTP as _ScheduleLine on $projection.PurchaseOrder = _ScheduleLine.PurchaseOrder
and $projection.PurchaseOrderItem = _ScheduleLine.PurchaseOrderItem
and $projection.ScheduleLine = _ScheduleLine.ScheduleLine
{
// Keys
key PurchaseOrder,
key PurchaseOrderItem,
key PurchaseOrderScheduleLine as ScheduleLine,
key ReservationItem,
key RecordType,
// Material data
Material,
@Semantics.booleanIndicator: true
IsMaterialProvision,
MaterialProvisionType,
MaterialQtyToBaseQtyNmrtr,
MaterialQtyToBaseQtyDnmntr,
cast( MaterialRevisionLevel as vdm_qm_revlv preserving type ) as MaterialRevisionLevel,
MaterialCompIsVariableSized,
MaterialComponentIsPhantomItem,
// Reservation and Requirements
Reservation,
RequiredQuantity,
RequirementDate,
RequirementTime,
ReservationIsFinallyIssued,
// Amount and Units
BaseUnit,
QuantityInEntryUnit,
EntryUnit,
VariableSizeItemQuantity,
VariableSizeItemUnit,
VariableSizeComponentUnit,
VariableSizeComponentQuantity,
UnitOfMeasureForSize1To3,
Size1,
Size2,
Size3,
// The other fields
Plant,
LatestRequirementDate,
OrderLevelValue,
OrderPathValue,
cast( BillOfMaterialItemNumber as vdm_sposn preserving type ) as BillOfMaterialItemNumber,
SortField as MatlCompFreeDefinedAttribute,
BOMItemCategory,
IsBulkMaterialComponent,
AccountAssignmentCategory,
InventorySpecialStockType,
ConsumptionPosting,
InventorySpecialStockValnType,
DebitCreditCode,
WithdrawnQuantity,
QuantityIsFixed,
ComponentScrapInPercent,
OperationScrapInPercent,
IsNetScrap,
LeadTimeOffset,
QuantityDistributionKey,
FormulaKey,
StorageLocation,
ProductionSupplyArea,
Batch,
BOMItemDescription,
BOMItemText2,
ChangeNumber,
// TODO's
// Fields exist in POPARTNER (BAPIEKKOP) and should be added to CDS view
// ENTRY_UOM_ISO
// CHANGE_ID
// MATERIAL_EXTERNAL
// MATERIAL_GUID
// MATERIAL_VERSION
// BASE_UOM
// BASE_UOM_ISO
// REQ_SEGMENT
// MATERIAL_LONG
// REQ_SEG_LONG
/* Associations */
_BaseUnit,
_EntryUnit,
_Material,
_Product,
_PurchaseOrder,
_PurchaseOrderItem,
_ScheduleLine,
_VariableSize1To3Unit,
_VariableSizeCompUnit
}
where
_PurchaseOrderItem.PurchasingDocumentDeletionCode = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_POSUBCONTRACTINGCOMPONENT",
"R_PURCHASEORDERITEMTP"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_PRODUCT",
"I_UNITOFMEASURE",
"R_PURCHASEORDERITEMTP",
"R_PURCHASEORDERSCHEDULELINETP",
"R_PURCHASEORDERTP"
],
"BASE":
[
"R_POSUBCONTRACTINGCOMPONENT"
],
"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