I_PURORDSCHEDULELINEBASIC

CDS View

Purchasing Document Schedule Line Basic

I_PURORDSCHEDULELINEBASIC is a CDS View in S/4HANA. Purchasing Document Schedule Line Basic. It contains 15 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 15 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_OverduePurchaseOrder view from CONSUMPTION
C_POMassUpdtDelivSchedItm view from CONSUMPTION Delivery Schedule Lines
I_PurOrdScheduleLineAPI01 view from BASIC Schedule Line in Purchase Order
I_PurOrdScheduleLineTP view from TRANSACTIONAL Transactional View for PO Schedule Line
P_NumberOfScheduleLines view from CONSUMPTION Retrieves the number of schedule lines

Fields (15)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 1
KEY PurchaseOrderItem PurchaseOrderItem 1
KEY PurchaseOrderScheduleLine ScheduleLine 1
_PurchaseRequisitionItem _PurchaseRequisitionItem 1
Batch Batch 1
BatchBySupplier BatchBySupplier 1
PerformancePeriodEndDate PerformancePeriodEndDate 1
PerformancePeriodStartDate PerformancePeriodStartDate 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 1
PurchaseRequisition PurchaseRequisition 1
PurchaseRequisitionItem PurchaseRequisitionItem 1
RoughGoodsReceiptQty RoughGoodsReceiptQty 1
SchedLineStscDeliveryDate SchedLineStscDeliveryDate 1
ScheduleLineDeliveryDate ScheduleLineDeliveryDate 1
ScheduleLineOrderQuantity ScheduleLineOrderQuantity 1 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Purchasing Document Schedule Line Basic'
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IMMPURORDSLBASIC'
@AccessControl.authorizationCheck: #CHECK
@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,
      Batch,
      BatchBySupplier,
      
      _PurchaseRequisition,
      _PurchaseRequisitionItem,
      _DeliveryDateCategory,
      _PurchaseOrder,
      _PurchaseOrderItem,
      _OrderQuantityUnit as _PurchaseOrderQuantityUnit

}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER",
"I_PURGDOCSCHEDULELINEBASIC"
],
"ASSOCIATED":
[
"I_DELIVERYDATECATEGORY",
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM",
"I_PURCHASEREQUISITION",
"I_PURCHASEREQUISITIONITEM",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_PURGDOCSCHEDULELINEBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More