I_PurOrdScheduleLineAPI01

DDL: I_PURORDSCHEDULELINEAPI01 SQL: IMMPURORDSLAPI01 Type: view BASIC

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)

SourceAliasJoin Type
I_PurOrdScheduleLineBasic I_PurOrdScheduleLineBasic from

Associations (3)

CardinalityTargetAliasCondition
[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)

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

KeyFieldSource TableSource FieldDescription
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
}