A_PurchaseOrderScheduleLine
Schedule Lines
A_PurchaseOrderScheduleLine is a Composite CDS View that provides data about "Schedule Lines" in SAP S/4HANA. It reads from 1 data source (I_PurgDocScheduleLine) and exposes 18 fields with key fields PurchasingDocument, PurchasingDocumentItem, ScheduleLine. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurgDocScheduleLine | I_PurgDocScheduleLine | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | A_PurchaseOrder | _PurchaseOrder | $projection.PurchasingDocument = _PurchaseOrder.PurchaseOrder |
| [0..*] | A_POSubcontractingComponent | _SubcontractingComponent | |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.sqlViewName | APURORDSCHEDULE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| EndUserText.label | Schedule Lines | 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_PurchaseOrderScheduleLine | view |
Fields (18)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchasingDocument | I_PurgDocScheduleLine | PurchasingDocument | |
| KEY | PurchasingDocumentItem | I_PurgDocScheduleLine | PurchasingDocumentItem | |
| KEY | ScheduleLine | ScheduleLine | ||
| DelivDateCategory | DelivDateCategory | |||
| ScheduleLineDeliveryDate | ScheduleLineDeliveryDate | |||
| PurchaseOrderQuantityUnit | _PurchaseOrderItem | PurchaseOrderQuantityUnit | ||
| ScheduleLineOrderQuantity | ScheduleLineOrderQuantity | |||
| ScheduleLineDeliveryTime | ScheduleLineDeliveryTime | |||
| SchedLineStscDeliveryDate | SchedLineStscDeliveryDate | |||
| PurchaseRequisition | PurchaseRequisition | |||
| PurchaseRequisitionItem | PurchaseRequisitionItem | |||
| ScheduleLineCommittedQuantity | ScheduleLineCommittedQuantity | |||
| PerformancePeriodStartDate | PerformancePeriodStartDate | |||
| PerformancePeriodEndDate | PerformancePeriodEndDate | |||
| PurchaseOrderItemCategory | _PurchaseOrderItem | PurchaseOrderItemCategory | ||
| _PurchaseOrder | _PurchaseOrder | |||
| _PurchaseOrderItem | _PurchaseOrderItem | |||
| _SubcontractingComponent | _SubcontractingComponent |
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'APURORDSCHEDULE'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Schedule Lines'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@OData.entitySet.name : 'A_PurchaseOrderScheduleLine'
//@ObjectModel: {
// createEnabled: true,
// updateEnabled: true,
// deleteEnabled: true
//}
define view A_PurchaseOrderScheduleLine
as select from I_PurgDocScheduleLine
association to parent A_PurchaseOrderItem as _PurchaseOrderItem on $projection.PurchasingDocument = _PurchaseOrderItem.PurchaseOrder
and $projection.PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem
association [1..1] to A_PurchaseOrder as _PurchaseOrder on $projection.PurchasingDocument = _PurchaseOrder.PurchaseOrder
composition [0..*] of A_POSubcontractingComponent as _SubcontractingComponent
// association [1..*] to A_POSubcontractingComponent as _SubcontractingComponent on $projection.PurchasingDocument = _SubcontractingComponent.PurchaseOrder
// and $projection.PurchasingDocumentItem = _SubcontractingComponent.PurchaseOrderItem
// and $projection.ScheduleLine = _SubcontractingComponent.ScheduleLine
// and $projection.PurchaseOrderItemCategory = '3'
{
key I_PurgDocScheduleLine.PurchasingDocument,
key I_PurgDocScheduleLine.PurchasingDocumentItem,
key ScheduleLine,
//LPEIN
DelivDateCategory,
//EINDT
ScheduleLineDeliveryDate,
//ELPEI
//EEIND
//MENGE
// @ObjectModel.readOnly: true
@Semantics.unitOfMeasure: true
_PurchaseOrderItem.PurchaseOrderQuantityUnit,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
ScheduleLineOrderQuantity,
//UZEIT
ScheduleLineDeliveryTime,
//SLFDT
SchedLineStscDeliveryDate,
//BANFN
PurchaseRequisition,
//BNFPO
PurchaseRequisitionItem,
// ScheduleLineOrderDate,
// RouteSchedule,
//ProductAvailabilityDate,
//ProductAvailabilityTime,
// LoadingDate,
// LoadingTime,
// TransportationPlanningDate,
// TransportationPlanningTime,
// GoodsIssueDate,
// GoodsIssueTime,
//PurchasingDocumentDeletionCode
// IsClosed,
//GoodsReceiptEndDate,
//GoodsReceiptEndTime,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
ScheduleLineCommittedQuantity,
//CommittedDate,
//HandoverDte,
//HandoverTme,
//DAT01
//GEO_ROUTE
//ROUTE_GTS
//GTS_IND
//TSP
//CD_LOCNO
//CD_LOCTYPE
//HANDOVERDATE
//HANDOVERTIME
//Start -- Limit PO API - 1802
PerformancePeriodStartDate,
PerformancePeriodEndDate,
//End -- Limit PO API - 1802
@Consumption.hidden: true
_PurchaseOrderItem.PurchaseOrderItemCategory as PurchaseOrderItemCategory,
// @ObjectModel.association.type: #TO_COMPOSITION_ROOT
_PurchaseOrder,
// @ObjectModel.association.type: #TO_COMPOSITION_PARENT
_PurchaseOrderItem,
// @ObjectModel.association.type: #TO_COMPOSITION_CHILD
_SubcontractingComponent
} where _PurchaseOrderItem.PurchasingDocumentDeletionCode = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_PURCHASEORDERITEM",
"I_PURGDOCSCHEDULELINE"
],
"ASSOCIATED":
[
"A_POSUBCONTRACTINGCOMPONENT",
"A_PURCHASEORDER",
"A_PURCHASEORDERITEM"
],
"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