I_SlsOrdFlfmtScheduleLine

DDL: I_SLSORDFLFMTSCHEDULELINE SQL: ISOFSCHEDLINE Type: view COMPOSITE Package: VDM_SD_SOF_OLD

SOFM Sales Order Scheduleline

I_SlsOrdFlfmtScheduleLine is a Composite CDS View that provides data about "SOFM Sales Order Scheduleline" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentScheduleLine) and exposes 21 fields with key fields SalesOrder, SalesOrderItem, ScheduleLine. Part of development package VDM_SD_SOF_OLD.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentScheduleLine SO_SL from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label SOFM Sales Order Scheduleline view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ISOFSCHEDLINE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesDocument
KEY SalesOrderItem SalesDocumentItem
KEY ScheduleLine ScheduleLine
_SalesDocumentItem _SalesDocumentItem
SalesOrderType
SalesOrganization
DistributionChannel
OrganizationDivision
IsRequestedDelivSchedLine
RequestedDeliveryDate
ScheduleLineOrderQuantity ScheduleLineOrderQuantity
IsConfirmedDelivSchedLine
ConfirmedDeliveryDate
ConfdOrderQtyByMatlAvailCheck ConfdOrderQtyByMatlAvailCheck
ProductAvailabilityDate ProductAvailabilityDate
DelivBlockReasonForSchedLine DelivBlockReasonForSchedLine
_DelivBlockReasonForSchedLine _DelivBlockReasonForSchedLine
OpenConfdDelivQtyInOrdQtyUnit OpenConfdDelivQtyInOrdQtyUnit
DeliveredQtyInOrderQtyUnit DeliveredQtyInOrderQtyUnit
OrderQuantityUnit OrderQuantityUnit
_OrderQuantityUnit _OrderQuantityUnit 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'SOFM Sales Order Scheduleline'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ISOFSCHEDLINE' 


define view I_SlsOrdFlfmtScheduleLine 
as 
select from I_SalesDocumentScheduleLine as SO_SL

{
  //Key

  key SalesDocument as SalesOrder,
  key SalesDocumentItem as SalesOrderItem,
  key ScheduleLine,
  
  _SalesDocumentItem, 
     
  //Category 

  _SalesDocumentItem._SalesDocument.SalesDocumentType as SalesOrderType,
  
  //Organization

  _SalesDocumentItem._SalesDocument.SalesOrganization,
  _SalesDocumentItem._SalesDocument.DistributionChannel,
  _SalesDocumentItem._SalesDocument.OrganizationDivision,   
  
  //Requested

  cast( IsRequestedDelivSchedLine as reqd_deliv) as IsRequestedDelivSchedLine ,
  cast(RequestedDeliveryDate as reqd_deliv_date) as RequestedDeliveryDate,
  ScheduleLineOrderQuantity,
  
  //Confirmed

  cast(IsConfirmedDelivSchedLine as confd_deliv) as IsConfirmedDelivSchedLine,
  cast(ConfirmedDeliveryDate as confd_deliv_date) as ConfirmedDeliveryDate,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
  ConfdOrderQtyByMatlAvailCheck, 
    
  //Availibility

  ProductAvailabilityDate,
  
  //Shipping

  @ObjectModel.foreignKey.association: '_DelivBlockReasonForSchedLine'
  DelivBlockReasonForSchedLine,
  _DelivBlockReasonForSchedLine, 
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
  OpenConfdDelivQtyInOrdQtyUnit,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
  DeliveredQtyInOrderQtyUnit, 
   
  cast ( case when IsRequestedDelivSchedLine = 'X'
          then RequestedDeliveryDate  
          else ConfirmedDeliveryDate
  end as lfdat_v ) as DeliveryDate,

  //Sales

  @Semantics.unitOfMeasure:true
  @ObjectModel.foreignKey.association: '_OrderQuantityUnit' 
  OrderQuantityUnit,
  _OrderQuantityUnit
} 

where ( _SalesDocumentItem._SalesDocument.SDDocumentCategory = 'C' or   --> Order
        _SalesDocumentItem._SalesDocument.SDDocumentCategory = 'I' or   --> Order w/o charge
        _SalesDocumentItem._SalesDocument.SDDocumentCategory = 'L' )    --> Debit Memo Request
 ;

Learn More