I_POSubcontractingCompAPI01
Subcontracting Component in PurOrd
I_POSubcontractingCompAPI01 is a Basic CDS View that provides data about "Subcontracting Component in PurOrd" in SAP S/4HANA. It reads from 1 data source (R_POSubcontractingComponent) and exposes 69 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseOrderScheduleLine, ReservationItem, RecordType. It has 3 associations to related views. Part of development package VDM_MM_PUR_PO_PUBLIC.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_POSubcontractingComponent | R_POSubcontractingComponent | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_PurchaseOrderAPI01 | _PurchaseOrder | $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder |
| [1..1] | I_PurchaseOrderItemAPI01 | _PurchaseOrderItem | $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem |
| [1..1] | I_PurOrdScheduleLineAPI01 | _ScheduleLine | $projection.PurchaseOrder = _ScheduleLine.PurchaseOrder and $projection.PurchaseOrderItem = _ScheduleLine.PurchaseOrderItem and $projection.PurchaseOrderScheduleLine = _ScheduleLine.PurchaseOrderScheduleLine |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.sqlViewName | IMMPOSUBCOMP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| VDM.viewType | #BASIC | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Subcontracting Component in PurOrd | view |
Fields (69)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseOrder | PurchaseOrder | ||
| KEY | PurchaseOrderItem | PurchaseOrderItem | ||
| KEY | PurchaseOrderScheduleLine | PurchaseOrderScheduleLine | ||
| KEY | ReservationItem | ReservationItem | ||
| KEY | RecordType | RecordType | ||
| Reservation | Reservation | |||
| Material | Material | |||
| BaseUnit | BaseUnit | |||
| RequiredQuantity | RequiredQuantity | |||
| WithdrawnQuantity | WithdrawnQuantity | |||
| QuantityIsFixed | QuantityIsFixed | |||
| RequirementDate | RequirementDate | |||
| RequirementTime | RequirementTime | |||
| Plant | Plant | |||
| LatestRequirementDate | LatestRequirementDate | |||
| OrderLevelValue | OrderLevelValue | |||
| OrderPathValue | OrderPathValue | |||
| BillOfMaterialItemNumber | ||||
| BillOfMaterialItemNumber_2 | BillOfMaterialItemNumber | |||
| SortField | SortField | |||
| BOMItemCategory | BOMItemCategory | |||
| MaterialComponentIsPhantomItem | MaterialComponentIsPhantomItem | |||
| IsBulkMaterialComponent | IsBulkMaterialComponent | |||
| AccountAssignmentCategory | AccountAssignmentCategory | |||
| InventorySpecialStockType | InventorySpecialStockType | |||
| ConsumptionPosting | ConsumptionPosting | |||
| InventorySpecialStockValnType | InventorySpecialStockValnType | |||
| IsMaterialProvision | IsMaterialProvision | |||
| MaterialProvisionType | MaterialProvisionType | |||
| SalesOrder | SalesOrder | |||
| SalesOrderItem | SalesOrderItem | |||
| WBSElementInternalID | WBSElementInternalID | |||
| DebitCreditCode | DebitCreditCode | |||
| ReservationIsFinallyIssued | ReservationIsFinallyIssued | |||
| EntryUnit | EntryUnit | |||
| QuantityInEntryUnit | QuantityInEntryUnit | |||
| MaterialQtyToBaseQtyNmrtr | MaterialQtyToBaseQtyNmrtr | |||
| MaterialQtyToBaseQtyDnmntr | MaterialQtyToBaseQtyDnmntr | |||
| ComponentScrapInPercent | ComponentScrapInPercent | |||
| OperationScrapInPercent | OperationScrapInPercent | |||
| IsNetScrap | IsNetScrap | |||
| LeadTimeOffset | LeadTimeOffset | |||
| QuantityDistributionKey | QuantityDistributionKey | |||
| MaterialRevisionLevel | ||||
| MaterialRevisionLevel_2 | MaterialRevisionLevel | |||
| MaterialCompIsVariableSized | MaterialCompIsVariableSized | |||
| NumberOfVariableSizeComponents | NumberOfVariableSizeComponents | |||
| VariableSizeItemUnit | VariableSizeItemUnit | |||
| VariableSizeItemQuantity | VariableSizeItemQuantity | |||
| VariableSizeComponentUnit | VariableSizeComponentUnit | |||
| VariableSizeComponentQuantity | VariableSizeComponentQuantity | |||
| UnitOfMeasureForSize1To3 | UnitOfMeasureForSize1To3 | |||
| Size1 | Size1 | |||
| Size2 | Size2 | |||
| Size3 | Size3 | |||
| FormulaKey | FormulaKey | |||
| StorageLocation | StorageLocation | |||
| ProductionSupplyArea | ProductionSupplyArea | |||
| Batch | Batch | |||
| BOMItemDescription | BOMItemDescription | |||
| BOMItemText2 | BOMItemText2 | |||
| ChangeNumber | ChangeNumber | |||
| _PurchaseOrder | _PurchaseOrder | |||
| _PurchaseOrderItem | _PurchaseOrderItem | |||
| _ScheduleLine | _ScheduleLine | |||
| _VariableSize1To3Unit | _VariableSize1To3Unit | |||
| _VariableSizeCompUnit | _VariableSizeCompUnit | |||
| _BaseUnit | _BaseUnit | |||
| _EntryUnit | _EntryUnit |
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IMMPOSUBCOMP'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations:true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Subcontracting Component in PurOrd'
define view I_POSubcontractingCompAPI01
as select from R_POSubcontractingComponent
association [1..1] to I_PurchaseOrderAPI01 as _PurchaseOrder on $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
association [1..1] to I_PurchaseOrderItemAPI01 as _PurchaseOrderItem on $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder
and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
association [1..1] to I_PurOrdScheduleLineAPI01 as _ScheduleLine on $projection.PurchaseOrder = _ScheduleLine.PurchaseOrder
and $projection.PurchaseOrderItem = _ScheduleLine.PurchaseOrderItem
and $projection.PurchaseOrderScheduleLine = _ScheduleLine.PurchaseOrderScheduleLine
{
@ObjectModel.foreignKey.association: '_PurchaseOrder'
key PurchaseOrder,
@ObjectModel.foreignKey.association: '_PurchaseOrderItem'
key PurchaseOrderItem,
@ObjectModel.foreignKey.association: '_ScheduleLine'
key PurchaseOrderScheduleLine,
key ReservationItem,
key RecordType,
Reservation,
Material,
@Semantics.unitOfMeasure: true
BaseUnit,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
RequiredQuantity,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
WithdrawnQuantity,
QuantityIsFixed,
RequirementDate,
RequirementTime,
Plant,
LatestRequirementDate,
OrderLevelValue,
OrderPathValue,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'BillOfMaterialItemNumber_2'
cast (BillOfMaterialItemNumber as aposn preserving type ) as BillOfMaterialItemNumber,
BillOfMaterialItemNumber as BillOfMaterialItemNumber_2,
SortField,
BOMItemCategory,
MaterialComponentIsPhantomItem,
IsBulkMaterialComponent,
AccountAssignmentCategory,
InventorySpecialStockType,
ConsumptionPosting,
InventorySpecialStockValnType,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'MaterialProvisionType'
IsMaterialProvision,
MaterialProvisionType,
SalesOrder,
SalesOrderItem,
WBSElementInternalID,
DebitCreditCode,
ReservationIsFinallyIssued,
@Semantics.unitOfMeasure: true
EntryUnit,
@Semantics.quantity.unitOfMeasure: 'EntryUnit'
QuantityInEntryUnit,
MaterialQtyToBaseQtyNmrtr,
MaterialQtyToBaseQtyDnmntr,
ComponentScrapInPercent,
OperationScrapInPercent,
IsNetScrap,
LeadTimeOffset,
QuantityDistributionKey,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'MaterialRevisionLevel_2'
cast (MaterialRevisionLevel as revlv preserving type ) as MaterialRevisionLevel,
MaterialRevisionLevel as MaterialRevisionLevel_2,
MaterialCompIsVariableSized,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'VariableSizeItemQuantity'
NumberOfVariableSizeComponents,
@Semantics.unitOfMeasure: true
VariableSizeItemUnit,
@Semantics.quantity.unitOfMeasure: 'VariableSizeItemUnit'
VariableSizeItemQuantity,
@Semantics.unitOfMeasure: true
VariableSizeComponentUnit,
@Semantics.quantity.unitOfMeasure: 'VariableSizeComponentUnit'
VariableSizeComponentQuantity,
@Semantics.unitOfMeasure: true
UnitOfMeasureForSize1To3,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
Size1,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
Size2,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
Size3,
FormulaKey,
StorageLocation,
ProductionSupplyArea,
Batch,
BOMItemDescription,
BOMItemText2,
ChangeNumber,
_PurchaseOrder,
_PurchaseOrderItem,
_ScheduleLine,
_VariableSize1To3Unit,
_VariableSizeCompUnit,
_BaseUnit,
_EntryUnit
}
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