I_ACMSalesOrderScheduleLine

DDL: I_ACMSALESORDERSCHEDULELINE SQL: IACMSOSCHEDLINE Type: view BASIC
9 Fields 1 Data Sources 1 Associations

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.

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 Schedule Line
ScheduleLineCategory ettyp Schedule line category
RequestedDeliveryTime ezeit Time
LoadingDate lddat Loading Date
DeliveryDate edatu Schedule line date
_ACMSalesOrderItem _ACMSalesOrderItem
_ACMSalesOrder _ACMSalesOrder

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ACMSalesOrderScheduleLine.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IACMSOSCHEDLINE

CREATE VIEW I_ACMSalesOrderScheduleLine AS
SELECT
  cast(ACMSalesOrderScheduleLine.vbeln as vbeln_va) AS SalesOrder,
  cast( right(ACMSalesOrderScheduleLine.posnr, 6) as abap.numc(6)) AS SalesOrderItem,
  etenr AS ScheduleLine,
  ettyp AS ScheduleLineCategory,
  ezeit AS RequestedDeliveryTime,
  lddat AS LoadingDate,
  edatu AS DeliveryDate
FROM vbep AS ACMSalesOrderScheduleLine
LEFT OUTER JOIN I_ACMSalesOrder AS _ACMSalesOrder ON SalesOrder = _ACMSalesOrder.SalesOrder  -- association [1..1]
;

Learn More