I_PurOrdScheduleLineBasic

DDL: I_PURORDSCHEDULELINEBASIC SQL: IMMPURORDSLBASIC Type: view BASIC Package: VDM_MM_PUR_PO

Purchasing Document Schedule Line Basic

I_PurOrdScheduleLineBasic is a Basic CDS View that provides data about "Purchasing Document Schedule Line Basic" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseOrder, I_PurgDocScheduleLineBasic) and exposes 43 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseOrderScheduleLine. It has 2 associations to related views. Part of development package VDM_MM_PUR_PO.

2 data source(s) 43 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchaseOrder I_PurchaseOrder inner
I_PurgDocScheduleLineBasic I_PurgDocScheduleLineBasic from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] I_PurchaseOrderItem _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (13)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Purchasing Document Schedule Line Basic view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IMMPURORDSLBASIC view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey PurchaseOrderScheduleLine view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchasingDocument
KEY PurchaseOrderItem PurchasingDocumentItem
KEY PurchaseOrderScheduleLine ScheduleLine
ScheduleLine ScheduleLine
DelivDateCategory DelivDateCategory
ScheduleLineDeliveryDate ScheduleLineDeliveryDate
SchedLineStscDeliveryDate SchedLineStscDeliveryDate
PerformancePeriodStartDate PerformancePeriodStartDate
PerformancePeriodEndDate PerformancePeriodEndDate
ScheduleLineDeliveryTime ScheduleLineDeliveryTime
ScheduleLineOrderQuantity ScheduleLineOrderQuantity
RoughGoodsReceiptQty RoughGoodsReceiptQty
PurchaseOrderQuantityUnit OrderQuantityUnit
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
MRPRelevantQuantity MRPRelevantQuantity
Batch Batch
BatchBySupplier BatchBySupplier
_PurchaseRequisition _PurchaseRequisition
_PurchaseRequisitionItem _PurchaseRequisitionItem
_DeliveryDateCategory _DeliveryDateCategory
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_PurchaseOrderQuantityUnit _OrderQuantityUnit
_PurchaseOrderQuantityUnitText _OrderQuantityUnitText 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Purchasing Document Schedule Line Basic'
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IMMPURORDSLBASIC'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.representativeKey: 'PurchaseOrderScheduleLine'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_PurOrdScheduleLineBasic
  as select from I_PurgDocScheduleLineBasic
  inner join I_PurchaseOrder on I_PurgDocScheduleLineBasic.PurchasingDocument = I_PurchaseOrder.PurchaseOrder 

  association [1..1] to I_PurchaseOrder           as _PurchaseOrder             on  $projection.PurchaseOrder        = _PurchaseOrder.PurchaseOrder
  association [1..1] to I_PurchaseOrderItem       as _PurchaseOrderItem         on  $projection.PurchaseOrder        = _PurchaseOrderItem.PurchaseOrder
                                                                                and $projection.PurchaseOrderItem    = _PurchaseOrderItem.PurchaseOrderItem
 
 {
  key PurchasingDocument     as PurchaseOrder,
  key PurchasingDocumentItem as PurchaseOrderItem,
  key ScheduleLine as PurchaseOrderScheduleLine,
ScheduleLine,

      @ObjectModel: { foreignKey.association: '_DeliveryDateCategory'}
      DelivDateCategory,
      ScheduleLineDeliveryDate,
      SchedLineStscDeliveryDate,
      PerformancePeriodStartDate,
      PerformancePeriodEndDate,
      ScheduleLineDeliveryTime,
      ScheduleLineOrderQuantity,
      RoughGoodsReceiptQty,

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_PurchaseOrderQuantityUnit'
      OrderQuantityUnit as PurchaseOrderQuantityUnit,

      @ObjectModel.foreignKey.association: '_PurchaseRequisition'
       PurchaseRequisition,

      @ObjectModel.foreignKey.association: '_PurchaseRequisitionItem'
      PurchaseRequisitionItem,

      SourceOfCreation,
      PrevDelivQtyOfScheduleLine,
      NoOfRemindersOfScheduleLine,
      ScheduleLineIsFixed,
      ScheduleLineCommittedQuantity,
      Reservation,
      ProductAvailabilityDate, 
      MaterialStagingTime,
      TransportationPlanningDate,
      TransportationPlanningTime, 
      LoadingDate,
      LoadingTime,
      GoodsIssueDate,
      GoodsIssueTime,
      STOLatestPossibleGRDate,
      STOLatestPossibleGRTime, 
      StockTransferDeliveredQuantity,
      ScheduleLineIssuedQuantity,
      MRPRelevantQuantity,
      Batch,
      BatchBySupplier,
      
      _PurchaseRequisition,
      _PurchaseRequisitionItem,
      _DeliveryDateCategory,
      _PurchaseOrder,
      _PurchaseOrderItem,
      _OrderQuantityUnit as _PurchaseOrderQuantityUnit,
      
      // Text associations for CustomUI

      _OrderQuantityUnitText as _PurchaseOrderQuantityUnitText

}

Learn More