R_PurchaseOrderScheduleLineTP

DDL: R_PURCHASEORDERSCHEDULELINETP Type: view_entity TRANSACTIONAL

Purchase Order Schedule Line TP view

R_PurchaseOrderScheduleLineTP is a Transactional CDS View that provides data about "Purchase Order Schedule Line TP view" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderScheduleLine) and exposes 35 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine. It has 2 associations to related views.

1 data source(s) 35 fields

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderScheduleLine R_PurchaseOrderScheduleLine from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_PurchaseOrderTP _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..*] R_POSubcontractingComponentTP _SubcontractingComponent

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Order Schedule Line TP view view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY ScheduleLine ScheduleLine
ScheduleLineDeliveryDate ScheduleLineDeliveryDate
SchedLineStscDeliveryDate SchedLineStscDeliveryDate
PerformancePeriodStartDate PerformancePeriodStartDate
PerformancePeriodEndDate PerformancePeriodEndDate
ScheduleLineDeliveryTime ScheduleLineDeliveryTime
Batch Batch
BatchBySupplier BatchBySupplier
ScheduleLineOrderQuantity ScheduleLineOrderQuantity
OpenPurchaseOrderQuantity OpenPurchaseOrderQuantity
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit
Currency Currency
OpenPurchaseOrderNetAmount OpenPurchaseOrderNetAmount
PurchaseRequisition PurchaseRequisition
PurchaseRequisitionItem PurchaseRequisitionItem
DelivDateCategory DelivDateCategory
ScheduleLineOrderDate ScheduleLineOrderDate
ProductAvailabilityDate ProductAvailabilityDate
LoadingDate LoadingDate
LoadingTime LoadingTime
TransportationPlanningDate TransportationPlanningDate
TransportationPlanningTime TransportationPlanningTime
GoodsIssueDate GoodsIssueDate
GoodsIssueTime GoodsIssueTime
RouteSchedule RouteSchedule
ProductAvailabilityTime ProductAvailabilityTime
_SubcontractingComponent _SubcontractingComponent
_Currency _Currency
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_PurchaseOrderQuantityUnit _PurchaseOrderQuantityUnit
_PurchaseRequisition _PurchaseRequisition
_PurchaseRequisitionItem _PurchaseRequisitionItem 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
//@AccessControl.privilegedAssociations: ['_SubcontractingComponent']

@EndUserText.label: 'Purchase Order Schedule Line TP view'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL

define view entity R_PurchaseOrderScheduleLineTP
  as select from R_PurchaseOrderScheduleLine

  association [1..1] to R_PurchaseOrderTP             as _PurchaseOrder     on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
  association        to parent R_PurchaseOrderItemTP  as _PurchaseOrderItem on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                            and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
  composition [1..*] of R_POSubcontractingComponentTP as _SubcontractingComponent
{
      // Keys

  key PurchaseOrder,
  key PurchaseOrderItem,
  key ScheduleLine,

      // Date and Time data

      ScheduleLineDeliveryDate,
      SchedLineStscDeliveryDate,
      PerformancePeriodStartDate,
      PerformancePeriodEndDate,
      ScheduleLineDeliveryTime,

      Batch,
      BatchBySupplier,

      // Quantity and currency data

      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      ScheduleLineOrderQuantity,
      //      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'

      //      RoughGoodsReceiptQty,

      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      @Consumption.hidden: true
      OpenPurchaseOrderQuantity,
      @Consumption.hidden: true
      PurchaseOrderQuantityUnit,
      @Consumption.hidden: true
      Currency,
      @Consumption.hidden: true
      @Semantics.amount.currencyCode: 'Currency'
      OpenPurchaseOrderNetAmount,
      PurchaseRequisition,
      PurchaseRequisitionItem,

      // Fields added for R_*TP development

      DelivDateCategory,
      ScheduleLineOrderDate,
      ProductAvailabilityDate,
      LoadingDate,
      LoadingTime,
      TransportationPlanningDate,
      TransportationPlanningTime,
      GoodsIssueDate,
      GoodsIssueTime,
      RouteSchedule,
      ProductAvailabilityTime,
      //      GoodsReceiptEndDate,

      //      GoodsReceiptEndTime,

      //      CommittedDate,

      //      HandoverDte,

      //      HandoverTme,

      //      GeographicalRoute,


      /* Compositions */
      _SubcontractingComponent,

      /* Associations */
      _Currency,
      _PurchaseOrder,
      _PurchaseOrderItem,
      _PurchaseOrderQuantityUnit,
      _PurchaseRequisition,
      _PurchaseRequisitionItem
}
where
  _PurchaseOrderItem.PurchasingDocumentDeletionCode = ''

Learn More