I_PurOrdScheduleLineAPI01
Schedule Line in Purchase Order
I_PurOrdScheduleLineAPI01 is a Basic CDS View that provides data about "Schedule Line in Purchase Order" in SAP S/4HANA. It reads from 1 data source (I_PurOrdScheduleLineBasic) and exposes 36 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseOrderScheduleLine. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurOrdScheduleLineBasic | I_PurOrdScheduleLineBasic | 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 |
| [0..*] | I_POSubcontractingCompAPI01 | _SubcontractingComponent | $projection.PurchaseOrder = _SubcontractingComponent.PurchaseOrder and $projection.PurchaseOrderItem = _SubcontractingComponent.PurchaseOrderItem and $projection.PurchaseOrderScheduleLine = _SubcontractingComponent.PurchaseOrderScheduleLine |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.sqlViewName | IMMPURORDSLAPI01 | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #BASIC | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| EndUserText.label | Schedule Line in Purchase Order | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.representativeKey | PurchaseOrderScheduleLine | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (36)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseOrder | PurchaseOrder | ||
| KEY | PurchaseOrderItem | PurchaseOrderItem | ||
| KEY | PurchaseOrderScheduleLine | PurchaseOrderScheduleLine | ||
| PerformancePeriodStartDate | PerformancePeriodStartDate | |||
| PerformancePeriodEndDate | PerformancePeriodEndDate | |||
| DelivDateCategory | DelivDateCategory | |||
| ScheduleLineDeliveryDate | ScheduleLineDeliveryDate | |||
| SchedLineStscDeliveryDate | SchedLineStscDeliveryDate | |||
| ScheduleLineDeliveryTime | ScheduleLineDeliveryTime | |||
| ScheduleLineOrderQuantity | ScheduleLineOrderQuantity | |||
| RoughGoodsReceiptQty | RoughGoodsReceiptQty | |||
| PurchaseOrderQuantityUnit | PurchaseOrderQuantityUnit | |||
| PurchaseRequisition | PurchaseRequisition | |||
| PurchaseRequisitionItem | PurchaseRequisitionItem | |||
| SourceOfCreation | SourceOfCreation | |||
| PrevDelivQtyOfScheduleLine | PrevDelivQtyOfScheduleLine | |||
| NoOfRemindersOfScheduleLine | NoOfRemindersOfScheduleLine | |||
| ScheduleLineIsFixed | ScheduleLineIsFixed | |||
| ScheduleLineCommittedQuantity | ScheduleLineCommittedQuantity | |||
| Reservation | Reservation | |||
| ProductAvailabilityDate | ProductAvailabilityDate | |||
| MaterialStagingTime | MaterialStagingTime | |||
| TransportationPlanningDate | TransportationPlanningDate | |||
| TransportationPlanningTime | TransportationPlanningTime | |||
| LoadingDate | LoadingDate | |||
| LoadingTime | LoadingTime | |||
| GoodsIssueDate | GoodsIssueDate | |||
| GoodsIssueTime | GoodsIssueTime | |||
| STOLatestPossibleGRDate | STOLatestPossibleGRDate | |||
| STOLatestPossibleGRTime | STOLatestPossibleGRTime | |||
| StockTransferDeliveredQuantity | StockTransferDeliveredQuantity | |||
| ScheduleLineIssuedQuantity | ScheduleLineIssuedQuantity | |||
| Batch | Batch | |||
| _PurchaseOrder | _PurchaseOrder | |||
| _PurchaseOrderItem | _PurchaseOrderItem | |||
| _SubcontractingComponent | _SubcontractingComponent |
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IMMPURORDSLAPI01'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType : #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'Schedule Line in Purchase Order'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.representativeKey: 'PurchaseOrderScheduleLine'
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations:true
define view I_PurOrdScheduleLineAPI01
as select from I_PurOrdScheduleLineBasic
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 [0..*] to I_POSubcontractingCompAPI01 as _SubcontractingComponent on $projection.PurchaseOrder = _SubcontractingComponent.PurchaseOrder
and $projection.PurchaseOrderItem = _SubcontractingComponent.PurchaseOrderItem
and $projection.PurchaseOrderScheduleLine = _SubcontractingComponent.PurchaseOrderScheduleLine
{
@ObjectModel.foreignKey.association: '_PurchaseOrder'
key PurchaseOrder,
@ObjectModel.foreignKey.association: '_PurchaseOrderItem'
key PurchaseOrderItem,
key PurchaseOrderScheduleLine,
PerformancePeriodStartDate,
PerformancePeriodEndDate,
DelivDateCategory,
ScheduleLineDeliveryDate,
SchedLineStscDeliveryDate, //3477025
ScheduleLineDeliveryTime,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
ScheduleLineOrderQuantity,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
RoughGoodsReceiptQty,
@Semantics.unitOfMeasure: true
PurchaseOrderQuantityUnit,
PurchaseRequisition,
PurchaseRequisitionItem,
SourceOfCreation,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
PrevDelivQtyOfScheduleLine,
NoOfRemindersOfScheduleLine,
ScheduleLineIsFixed,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
ScheduleLineCommittedQuantity,
Reservation,
ProductAvailabilityDate,
MaterialStagingTime,
TransportationPlanningDate,
TransportationPlanningTime,
LoadingDate,
LoadingTime,
GoodsIssueDate,
GoodsIssueTime,
STOLatestPossibleGRDate,
STOLatestPossibleGRTime,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
StockTransferDeliveredQuantity,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
ScheduleLineIssuedQuantity,
Batch,
_PurchaseOrder,
_PurchaseOrderItem,
_SubcontractingComponent
}
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