I_ACMSalesOrderItem

DDL: I_ACMSALESORDERITEM SQL: IACMSLSORDERITEM Type: view COMPOSITE
20 Fields 1 Data Sources 5 Associations

Acm Sales Order Item

I_ACMSalesOrderItem is a Composite CDS View that provides data about "Acm Sales Order Item" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItem) and exposes 20 fields with key fields SalesOrder, SalesOrderItem. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentItem I_SalesDocumentItem from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_ACMSalesOrderContractCallOff _ACMSalesOrderContractCallOff
[0..*] I_ACMSalesOrderDelivery _ACMSalesOrdDelivAssignment
[0..*] I_ACMSalesOrderItemUoMCnvrsn _ACMSalesOrdItemUoMCnvrsn
[0..*] I_ACMSalesOrderScheduleLine _ACMSalesOrderScheduleLine
[1] I_ACMSalesOrderItemExtension _ACMSalesOrderItemExtension

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACMSLSORDERITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Acm Sales Order Item view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesDocument SD Document
KEY SalesOrderItem SalesDocumentItem Sales Document Item
OrderQuantity OrderQuantity Quantity
Plant Plant Valuation Area
IncotermsClassification IncotermsClassification Incoterms
IncotermsLocation1 IncotermsLocation1 Inco. Location1
Material Material Vehicle Model
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
OrderQuantityUnit OrderQuantityUnit Sales Unit
SalesDocumentRjcnReason SalesDocumentRjcnReason RejectionReason
ShippingPoint ShippingPoint Shipping Point
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
Route Route Vehicle route
_ACMSalesOrder _ACMSalesOrder
_ACMSalesOrderContractCallOff _ACMSalesOrderContractCallOff
_ACMSalesOrdDelivAssignment _ACMSalesOrdDelivAssignment
_ACMSalesOrdItemUoMCnvrsn _ACMSalesOrdItemUoMCnvrsn
_ACMSalesOrderScheduleLine _ACMSalesOrderScheduleLine
_ACMSalesOrderItemExtension _ACMSalesOrderItemExtension
_OrderQuantityUnit _OrderQuantityUnit

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_ACMSalesOrderItem.
-- 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: IACMSLSORDERITEM

CREATE VIEW I_ACMSalesOrderItem AS
SELECT
  SalesDocument AS SalesOrder,
  SalesDocumentItem AS SalesOrderItem,
  OrderQuantity,
  Plant,
  IncotermsClassification,
  IncotermsLocation1,
  Material,
  CustomerPaymentTerms,
  OrderQuantityUnit,
  SalesDocumentRjcnReason,
  ShippingPoint,
  PurchaseOrderByCustomer,
  Route
FROM I_SalesDocumentItem
LEFT OUTER JOIN I_ACMSalesOrderContractCallOff AS _ACMSalesOrderContractCallOff ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ACMSalesOrderDelivery AS _ACMSalesOrdDelivAssignment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ACMSalesOrderItemUoMCnvrsn AS _ACMSalesOrdItemUoMCnvrsn ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ACMSalesOrderScheduleLine AS _ACMSalesOrderScheduleLine ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ACMSalesOrderItemExtension AS _ACMSalesOrderItemExtension ON /* condition not available in parsed metadata */  -- association [1]
;

Learn More