C_SlsDocFlfmtPurOrdSchedLine

DDL: C_SLSDOCFLFMTPURORDSCHEDLINE SQL: CSOFPURORDSCHDL Type: view CONSUMPTION Package: ODATA_SD_SOF

Purchase Order Schedule Line

C_SlsDocFlfmtPurOrdSchedLine is a Consumption CDS View that provides data about "Purchase Order Schedule Line" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderScheduleLine) and exposes 10 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine. Part of development package ODATA_SD_SOF.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderScheduleLine I_PurchaseOrderScheduleLine from

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey ScheduleLine view
EndUserText.label Purchase Order Schedule Line view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
Search.searchable false view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CSOFPURORDSCHDL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY ScheduleLine ScheduleLine
ScheduleLineDeliveryDate ScheduleLineDeliveryDate
RoughGoodsReceiptQty RoughGoodsReceiptQty
ScheduleLineOrderQuantity ScheduleLineOrderQuantity
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit
_PurchaseOrderQuantityUnit _PurchaseOrderQuantityUnit
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.semanticKey: ['PurchaseOrder', 'PurchaseOrderItem', 'ScheduleLine']
@ObjectModel.representativeKey: 'ScheduleLine'

@EndUserText.label: 'Purchase Order Schedule Line'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@Search.searchable: false
@AccessControl.authorizationCheck: #CHECK
@Metadata.allowExtensions: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'CSOFPURORDSCHDL'

define view C_SlsDocFlfmtPurOrdSchedLine

as select from I_PurchaseOrderScheduleLine

 {

   // Key

   key PurchaseOrder,
   key PurchaseOrderItem,
   key ScheduleLine,
  
   // Date   

   ScheduleLineDeliveryDate,
   
   // Quantity  

   @DefaultAggregation: #NONE
   @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'  
   RoughGoodsReceiptQty,

   @DefaultAggregation: #NONE
   @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
   ScheduleLineOrderQuantity, 
 
   @Semantics.unitOfMeasure: true   
   @ObjectModel.foreignKey.association: '_PurchaseOrderQuantityUnit'
   PurchaseOrderQuantityUnit, 
    
   _PurchaseOrderQuantityUnit,
   _PurchaseOrder, 
   _PurchaseOrderItem            
}

where  _PurchaseOrderItem.PurchasingDocumentDeletionCode <> 'X' and _PurchaseOrderItem.PurchasingDocumentDeletionCode <> 'L'

Learn More