P_ACMApplicationItemDat

DDL: P_ACMAPPLICATIONITEMDAT Type: view_entity COMPOSITE
48 Fields 2 Data Sources

P_ACMApplicationItemDat is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_ACMApplDocData, I_PhysCmmdtyForMaterial) and exposes 48 fields with key fields ApplicationDocument, ApplicationDocumentItem, Side, SubItem.

Data Sources (2)

SourceAliasJoin Type
I_ACMApplDocData AppData from
I_PhysCmmdtyForMaterial PhyComm inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (48)

KeyFieldSource TableSource FieldDescription
keyMandt
KEY ApplicationDocument I_ACMApplDocData ApplicationDocument Appl. Document No.
KEY ApplicationDocumentItem
KEY Side I_ACMApplDocData Side Side
KEY SubItem I_ACMApplDocData SubItem Subitem Number
ItemCategory I_ACMApplDocData ItemCategory Item Category
ApplicationItemUUID I_ACMApplDocData ApplicationItemUUID Push ItemGU
RootItem I_ACMApplDocData RootItem x
ParentItem I_ACMApplDocData ParentItem Parent Item
ApplicationStatusObject I_ACMApplDocData ApplicationStatusObject Object number
ApplStatusCode
SettlementStatusObject I_ACMApplDocData SettlementStatusObject Object number
StlStatusCode
StorageStartDate I_ACMApplDocData StorageStartDate Storage Start Date
StorageEndDate I_ACMApplDocData StorageEndDate Storage End Date
WarehouseReceiptType I_ACMApplDocData WarehouseReceiptType WHR Type
WarehouseReceiptNo I_ACMApplDocData WarehouseReceiptNo WHR Number
WarehouseStartDate I_ACMApplDocData WarehouseStartDate Warehouse Start Date
WarehouseEndDate I_ACMApplDocData WarehouseEndDate WHR End Date
ObligationType I_ACMApplDocData ObligationType Obligation Type
Plant I_ACMApplDocData Plant Valuation Area
StorageLocation I_ACMApplDocData StorageLocation StorageLocation
MaterialGroup I_ACMApplDocData MaterialGroup Product Group
LoadDataCaptureObjectID I_ACMApplDocData LoadDataCaptureObjectID LDC ID
LoadDataObjectUUID I_ACMApplDocData LoadDataObjectUUID LDC Key
LoadDataObjectType I_ACMApplDocData LoadDataObjectType LDC Type
Material I_ACMApplDocData Material Vehicle Model
PostingDate I_ACMApplDocData PostingDate Posting Date for GR
Supplier I_ACMApplDocData Supplier Supplier
LDCApplInstructionValue I_ACMApplDocData LDCApplInstructionValue Application Instr.
CommodityQuantityInBaseUnit I_ACMApplDocData CommodityQuantityInBaseUnit ItemQty Mat UoM
ToBeAppliedQuantity I_ACMApplDocData ToBeAppliedQuantity Open Quantity
ToBeAppliedQuantityUnit I_ACMApplDocData ToBeAppliedQuantityUnit Open Qty UoM
CommodityUnit I_ACMApplDocData CommodityUnit Order Unit
CompanyCode I_ACMApplDocData CompanyCode Receiver Company Code
StockIsNotPhysicallyReceived I_ACMApplDocData StockIsNotPhysicallyReceived No Ph. Receipt
ApplItemCreatedOnDateTime I_ACMApplDocData ApplItemCreatedOnDateTime
ApplItemChangedOnDateTime I_ACMApplDocData ApplItemChangedOnDateTime
ApplicationItemCreatedOnDate I_ACMApplDocData ApplicationItemCreatedOnDate
ApplicationItemChangedOnDate I_ACMApplDocData ApplicationItemChangedOnDate
ApplicationDocType I_ACMApplDocData ApplicationDocType VAT Document Type
ReferenceApplicationDocument I_ACMApplDocData ACMRefApplicationDocNumber Appl. Document No.
ApplChangeDate I_ACMApplDocData ApplicationItemChangedOnDate
StockIsInTransit I_ACMApplDocData StockIsInTransit In Transit
ApplicationSideIsOwner I_ACMApplDocData ApplicationSideIsOwner Itm Owner
ChangeDocumentStatusDate StlStatus ChangeDocumentStatusDate
ChangeDocumentStatusTime StlStatus ChangeDocumentStatusTime
PhysicalCommodity I_PhysCmmdtyForMaterial PhysicalCommodity Commodity Code

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 P_ACMApplicationItemDat.
-- 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 P_ACMApplicationItemDat AS
SELECT
  AppData.ApplicationDocument AS ApplicationDocument,
  lpad(AppData.ApplicationDocumentItem, 10, '0') AS ApplicationDocumentItem,
  AppData.Side AS Side,
  AppData.SubItem AS SubItem,
  AppData.ItemCategory AS ItemCategory,
  AppData.ApplicationItemUUID AS ApplicationItemUUID,
  AppData.RootItem AS RootItem,
  AppData.ParentItem AS ParentItem,
  AppData.ApplicationStatusObject AS ApplicationStatusObject,
  cast( AppStatus.StatusCode as /accgo/e_recon_appl_status) AS ApplStatusCode,
  AppData.SettlementStatusObject AS SettlementStatusObject,
  cast(StlStatus.StatusCode as /accgo/e_recon_settlmt_status) AS StlStatusCode,
  AppData.StorageStartDate AS StorageStartDate,
  AppData.StorageEndDate AS StorageEndDate,
  AppData.WarehouseReceiptType AS WarehouseReceiptType,
  AppData.WarehouseReceiptNo AS WarehouseReceiptNo,
  AppData.WarehouseStartDate AS WarehouseStartDate,
  AppData.WarehouseEndDate AS WarehouseEndDate,
  AppData.ObligationType AS ObligationType,
  AppData.Plant AS Plant,
  AppData.StorageLocation AS StorageLocation,
  AppData.MaterialGroup AS MaterialGroup,
  AppData.LoadDataCaptureObjectID AS LoadDataCaptureObjectID,
  AppData.LoadDataObjectUUID AS LoadDataObjectUUID,
  AppData.LoadDataObjectType AS LoadDataObjectType,
  AppData.Material AS Material,
  AppData.PostingDate AS PostingDate,
  AppData.Supplier AS Supplier,
  AppData.LDCApplInstructionValue AS LDCApplInstructionValue,
  AppData.CommodityQuantityInBaseUnit AS CommodityQuantityInBaseUnit,
  AppData.ToBeAppliedQuantity AS ToBeAppliedQuantity,
  AppData.ToBeAppliedQuantityUnit AS ToBeAppliedQuantityUnit,
  AppData.CommodityUnit AS CommodityUnit,
  AppData.CompanyCode AS CompanyCode,
  AppData.StockIsNotPhysicallyReceived AS StockIsNotPhysicallyReceived,
  AppData.ApplItemCreatedOnDateTime AS ApplItemCreatedOnDateTime,
  AppData.ApplItemChangedOnDateTime AS ApplItemChangedOnDateTime,
  AppData.ApplicationItemCreatedOnDate AS ApplicationItemCreatedOnDate,
  AppData.ApplicationItemChangedOnDate AS ApplicationItemChangedOnDate,
  AppData.ApplicationDocType AS ApplicationDocType,
  AppData.ACMRefApplicationDocNumber AS ReferenceApplicationDocument,
  AppData.ApplicationItemChangedOnDate AS ApplChangeDate,
  AppData.StockIsInTransit AS StockIsInTransit,
  AppData.ApplicationSideIsOwner AS ApplicationSideIsOwner,
  StlStatus.ChangeDocumentStatusDate AS ChangeDocumentStatusDate,
  StlStatus.ChangeDocumentStatusTime AS ChangeDocumentStatusTime,
  PhyComm.PhysicalCommodity AS PhysicalCommodity
FROM I_ACMApplDocData AS AppData
INNER JOIN I_PhysCmmdtyForMaterial AS PhyComm ON /* join condition not captured in parsed metadata */
;

Learn More