A_ACMPurOrderDelivUoMCnvrsn

DDL: A_ACMPURORDERDELIVUOMCNVRSN Type: view_entity CONSUMPTION

ACM Purchase Order Delivery UoM Conversion TP

A_ACMPurOrderDelivUoMCnvrsn is a Consumption CDS View that provides data about "ACM Purchase Order Delivery UoM Conversion TP" in SAP S/4HANA. It reads from 1 data source (R_ACMPurOrderDelivUoMCnvrsnTP) and exposes 8 fields with key fields PurchaseOrder, PurchaseOrderItem, LoadDataCaptureObjId, PreferredUnitOfMeasure.

Data Sources (1)

SourceAliasJoin Type
R_ACMPurOrderDelivUoMCnvrsnTP R_ACMPurOrderDelivUoMCnvrsnTP projection

Annotations (8)

NameValueLevelField
OData.entityType.name AACMPODeliveryUoMCnv_Type view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label ACM Purchase Order Delivery UoM Conversion TP view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY LoadDataCaptureObjId LoadDataCaptureObjId
KEY PreferredUnitOfMeasure PreferredUnitOfMeasure
ACMDeliveredQuantity ACMDeliveredQuantity
ACMOverFillTotalQuantity ACMOverFillTotalQuantity
ACMUnderFillTotalQuantity ACMUnderFillTotalQuantity
ACMDeliveredAdjustedQuantity ACMDeliveredAdjustedQuantity

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 A_ACMPurOrderDelivUoMCnvrsn.
-- 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.

CREATE VIEW A_ACMPurOrderDelivUoMCnvrsn AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  LoadDataCaptureObjId,
  PreferredUnitOfMeasure,
  ACMDeliveredQuantity,
  ACMOverFillTotalQuantity,
  ACMUnderFillTotalQuantity,
  ACMDeliveredAdjustedQuantity
FROM R_ACMPurOrderDelivUoMCnvrsnTP
;