I_ACMSalesOrderScheduleLine

DDL: I_ACMSALESORDERSCHEDULELINE SQL: IACMSOSCHEDLINE Type: view BASIC

ACM Sales Order Schedule Line

I_ACMSalesOrderScheduleLine is a Basic CDS View that provides data about "ACM Sales Order Schedule Line" in SAP S/4HANA. It reads from 1 data source (vbep) and exposes 9 fields with key fields SalesOrder, SalesOrderItem, ScheduleLine. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
vbep ACMSalesOrderScheduleLine from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ACMSalesOrder _ACMSalesOrder $projection.SalesOrder = _ACMSalesOrder.SalesOrder

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACMSOSCHEDLINE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label ACM Sales Order Schedule Line view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder
KEY SalesOrderItem
KEY ScheduleLine etenr
ScheduleLineCategory ettyp
RequestedDeliveryTime ezeit
LoadingDate lddat
DeliveryDate edatu
_ACMSalesOrderItem _ACMSalesOrderItem
_ACMSalesOrder _ACMSalesOrder 
@AbapCatalog.sqlViewName: 'IACMSOSCHEDLINE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{
               usageType: {
                 dataClass: #TRANSACTIONAL,
                 serviceQuality: #C,
                 sizeCategory: #M
               }
}
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@EndUserText.label: 'ACM Sales Order Schedule Line'
define view I_ACMSalesOrderScheduleLine
  as select from vbep as ACMSalesOrderScheduleLine
  association        to parent I_ACMSalesOrderItem as _ACMSalesOrderItem on  $projection.SalesOrder     = _ACMSalesOrderItem.SalesOrder
                                                                         and $projection.SalesOrderItem = _ACMSalesOrderItem.SalesOrderItem

  association [1..1] to I_ACMSalesOrder            as _ACMSalesOrder     on  $projection.SalesOrder = _ACMSalesOrder.SalesOrder

{
  key cast(ACMSalesOrderScheduleLine.vbeln as  vbeln_va)               as SalesOrder,
  key cast( right(ACMSalesOrderScheduleLine.posnr, 6) as abap.numc(6)) as SalesOrderItem,
  key etenr                                                            as ScheduleLine,
      ettyp                                                            as ScheduleLineCategory,
      ezeit                                                            as RequestedDeliveryTime,
      lddat                                                            as LoadingDate,
      edatu                                                            as DeliveryDate,
      //timestamp for Schedule line delivery date

      cast(dats_tims_to_tstmp( edatu,
                          ezeit,
                          abap_system_timezone( $session.client,'NULL' ),
                          $session.client,
                         'NULL' ) as timestamp)                        as ScheduledBatchStartDateTime,
      //Association

      _ACMSalesOrderItem,
      _ACMSalesOrder

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VBEP"
],
"ASSOCIATED":
[
"I_ACMSALESORDER",
"I_ACMSALESORDERITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More