A_PurchaseOrderScheduleLine

DDL: A_PURCHASEORDERSCHEDULELINE SQL: APURORDSCHEDULE Type: view COMPOSITE

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)

SourceAliasJoin Type
I_PurgDocScheduleLine I_PurgDocScheduleLine from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_PurchaseOrder _PurchaseOrder $projection.PurchasingDocument = _PurchaseOrder.PurchaseOrder
[0..*] A_POSubcontractingComponent _SubcontractingComponent

Annotations (14)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/