I_PurOrdScheduleLineTP

DDL: I_PURORDSCHEDULELINETP SQL: IPOSCHEDLINETP Type: view TRANSACTIONAL

Transactional View for PO Schedule Line

I_PurOrdScheduleLineTP is a Transactional CDS View that provides data about "Transactional View for PO Schedule Line" in SAP S/4HANA. It reads from 1 data source (I_PurOrdScheduleLineBasic) and exposes 19 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurOrdScheduleLineBasic Document from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderTP _PurchaseOrderTP _PurchaseOrderTP.PurchaseOrder = $projection.PurchaseOrder
[1..1] I_PurchaseOrderItemTP _PurchaseOrderItemTP _PurchaseOrderItemTP.PurchaseOrder = $projection.PurchaseOrder and _PurchaseOrderItemTP.PurchaseOrderItem = $projection.PurchaseOrderItem
[1..*] I_POSubcontractingComponentTP _SubcontractingComponent _SubcontractingComponent.PurchaseOrder = $projection.PurchaseOrder and _SubcontractingComponent.PurchaseOrderItem = $projection.PurchaseOrderItem and _SubcontractingComponent.ScheduleLine = $projection.ScheduleLine

Annotations (15)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
AbapCatalog.sqlViewName IPOSCHEDLINETP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Transactional View for PO Schedule Line view
ObjectModel.representativeKey ScheduleLine view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence POSCHEDLINETP_D view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurOrdScheduleLineBasic PurchaseOrder
KEY PurchaseOrderItem I_PurOrdScheduleLineBasic PurchaseOrderItem
KEY ScheduleLine I_PurOrdScheduleLineBasic PurchaseOrderScheduleLine
ScheduleLineDeliveryDate I_PurOrdScheduleLineBasic ScheduleLineDeliveryDate
PerformancePeriodStartDate I_PurOrdScheduleLineBasic PerformancePeriodStartDate
PerformancePeriodEndDate I_PurOrdScheduleLineBasic PerformancePeriodEndDate
ScheduleLineOrderQuantity I_PurOrdScheduleLineBasic ScheduleLineOrderQuantity
SchedLineStscDeliveryDate I_PurOrdScheduleLineBasic SchedLineStscDeliveryDate
RoughGoodsReceiptQty I_PurOrdScheduleLineBasic RoughGoodsReceiptQty
PurchaseOrderQuantityUnit I_PurOrdScheduleLineBasic PurchaseOrderQuantityUnit
PurchaseRequisition I_PurOrdScheduleLineBasic PurchaseRequisition
PurchaseRequisitionItem I_PurOrdScheduleLineBasic PurchaseRequisitionItem
Batch I_PurOrdScheduleLineBasic Batch
BatchBySupplier I_PurOrdScheduleLineBasic BatchBySupplier
HighestMessageSeverityLevel
_PurchaseOrderTP _PurchaseOrderTP
_PurchaseOrderItemTP _PurchaseOrderItemTP
_SubcontractingComponent _SubcontractingComponent
_PurchaseRequisitionItem I_PurOrdScheduleLineBasic _PurchaseRequisitionItem
@VDM.viewType: #TRANSACTIONAL
@AbapCatalog.sqlViewName: 'IPOSCHEDLINETP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Transactional View for PO Schedule Line'

@ObjectModel: {
    semanticKey: ['PurchaseOrder', 'PurchaseOrderItem', 'ScheduleLine'],
    representativeKey: 'ScheduleLine',
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    writeDraftPersistence: 'POSCHEDLINETP_D'
}

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_PurOrdScheduleLineTP
  as select from I_PurOrdScheduleLineBasic as Document

  association [1..1] to I_PurchaseOrderTP     as _PurchaseOrderTP     on  _PurchaseOrderTP.PurchaseOrder = $projection.PurchaseOrder
  association [1..1] to I_PurchaseOrderItemTP as _PurchaseOrderItemTP on  _PurchaseOrderItemTP.PurchaseOrder     = $projection.PurchaseOrder
                                                                      and _PurchaseOrderItemTP.PurchaseOrderItem = $projection.PurchaseOrderItem
  association [1..*] to I_POSubcontractingComponentTP as _SubcontractingComponent on  _SubcontractingComponent.PurchaseOrder     = $projection.PurchaseOrder
                                                                      and _SubcontractingComponent.PurchaseOrderItem = $projection.PurchaseOrderItem    
                                                                      and _SubcontractingComponent.ScheduleLine = $projection.ScheduleLine                                                                   

{

      @ObjectModel.foreignKey.association: '_PurchaseOrderTP'
  key Document.PurchaseOrder,
      @ObjectModel.foreignKey.association: '_PurchaseOrderItemTP'
  key Document.PurchaseOrderItem,
  key Document.PurchaseOrderScheduleLine as ScheduleLine,

      Document.ScheduleLineDeliveryDate,

      Document.PerformancePeriodStartDate,

      Document.PerformancePeriodEndDate,
      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }
      Document.ScheduleLineOrderQuantity,

      Document.SchedLineStscDeliveryDate,

      Document.RoughGoodsReceiptQty,

      Document.PurchaseOrderQuantityUnit,

      Document.PurchaseRequisition,

      Document.PurchaseRequisitionItem,
      
      Document.Batch,
      
      Document.BatchBySupplier,
      
      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }
      cast ('' as hghstmsgsvrtylvl)  as  HighestMessageSeverityLevel,

      @ObjectModel.association.type: #TO_COMPOSITION_ROOT
      _PurchaseOrderTP,
      @ObjectModel.association.type: #TO_COMPOSITION_PARENT
      _PurchaseOrderItemTP,
      @ObjectModel.association.type: #TO_COMPOSITION_CHILD      
      _SubcontractingComponent,

      Document._PurchaseRequisitionItem

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURORDSCHEDULELINEBASIC"
],
"ASSOCIATED":
[
"I_POSUBCONTRACTINGCOMPONENTTP",
"I_PURCHASEORDERITEMTP",
"I_PURCHASEORDERTP",
"I_PURCHASEREQUISITIONITEM"
],
"BASE":
[
"I_PURORDSCHEDULELINEBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/