A_ACMAppDocOverview

DDL: A_ACMAPPDOCOVERVIEW Type: view_entity CONSUMPTION
49 Fields 1 Data Sources

Application Document Overview

A_ACMAppDocOverview is a Consumption CDS View that provides data about "Application Document Overview" in SAP S/4HANA. It reads from 1 data source (R_ACMApplicationOverviewDetTP) and exposes 49 fields with key fields ApplicationDocument, ReferenceApplicationItem.

Data Sources (1)

SourceAliasJoin Type
R_ACMApplicationOverviewDetTP R_ACMApplicationOverviewDetTP projection

Annotations (8)

NameValueLevelField
OData.entityType.name AppDocOverview_Type view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Application Document Overview view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY ApplicationDocument ApplicationDocument
KEY ReferenceApplicationItem ReferenceApplicationItem
ContractApplicationUUID ContractApplicationUUID
ContractApplicationVersion ContractApplicationVersion
ApplicationDocType ApplicationDocType
ReferenceApplicationSide ReferenceApplicationSide
ReferenceApplicationSubItem ReferenceApplicationSubItem
DeliveryDate DeliveryDate Delivery Date
TradingContractNumber TradingContractNumber Trading Contract
TradingContractItem TradingContractItem Item Number
LoadDataCaptureObjId LoadDataCaptureObjId
ACMLoadDataCaptureEventKeyUUID ACMLoadDataCaptureEventKeyUUID
EventDate EventDate
Plant Plant Valuation Area
BillOfLading BillOfLading
BillOfLadingDate BillOfLadingDate
Material Material Vehicle Model
Commodity Commodity Commodity Code
ACMScaleTicketNumber ACMScaleTicketNumber
ACMAppDocStatus ACMAppDocStatus
ACMAppDocSettlementStatus ACMAppDocSettlementStatus
ACMAppDocStorageStatus ACMAppDocStorageStatus
Counterparty Counterparty Supplier
ApplDocumentCreatedBy ApplDocumentCreatedBy
ApplDocumentCreatedByName ApplDocumentCreatedByName
ApplicationItemCreatedOnDate ApplicationItemCreatedOnDate
ApplDocumentChangedBy ApplDocumentChangedBy
ApplDocumentChangedByName ApplDocumentChangedByName
ApplicationItemChangedOnDate ApplicationItemChangedOnDate
TradingContractType TradingContractType
CompanyCode CompanyCode Receiver Company Code
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
ACMLoadDataCapQuantity ACMLoadDataCapQuantity
UnitOfMeasure UnitOfMeasure Unit Protected Qty
ACMLoadDataCaptureConvertQty ACMLoadDataCaptureConvertQty
ACMDecimalGrossQuantity ACMDecimalGrossQuantity
ACMNetQuantity ACMNetQuantity
ACMOverfillQuantity ACMOverfillQuantity
ACMUnderFillQuantity ACMUnderFillQuantity
ACMLoadDtaCaptureGrossQuantity ACMLoadDtaCaptureGrossQuantity
ACMLoadDtaCaptrCnvrtdGrssQty ACMLoadDtaCaptrCnvrtdGrssQty
ACMAppDocBaseUoM ACMAppDocBaseUoM
ACMApplOvwSpotFlag ACMApplOvwSpotFlag
ACMApplOvwSpotFlagDesc ACMApplOvwSpotFlagDesc
ACMLoadDataCaptureUoM ACMLoadDataCaptureUoM

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_ACMAppDocOverview.
-- 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_ACMAppDocOverview AS
SELECT
  ApplicationDocument,
  ReferenceApplicationItem,
  ContractApplicationUUID,
  ContractApplicationVersion,
  ApplicationDocType,
  ReferenceApplicationSide,
  ReferenceApplicationSubItem,
  DeliveryDate,
  TradingContractNumber,
  TradingContractItem,
  LoadDataCaptureObjId,
  ACMLoadDataCaptureEventKeyUUID,
  EventDate,
  Plant,
  BillOfLading,
  BillOfLadingDate,
  Material,
  Commodity,
  ACMScaleTicketNumber,
  ACMAppDocStatus,
  ACMAppDocSettlementStatus,
  ACMAppDocStorageStatus,
  Counterparty,
  ApplDocumentCreatedBy,
  ApplDocumentCreatedByName,
  ApplicationItemCreatedOnDate,
  ApplDocumentChangedBy,
  ApplDocumentChangedByName,
  ApplicationItemChangedOnDate,
  TradingContractType,
  CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  PurchasingOrganization,
  PurchasingGroup,
  ACMLoadDataCapQuantity,
  UnitOfMeasure,
  ACMLoadDataCaptureConvertQty,
  ACMDecimalGrossQuantity,
  ACMNetQuantity,
  ACMOverfillQuantity,
  ACMUnderFillQuantity,
  ACMLoadDtaCaptureGrossQuantity,
  ACMLoadDtaCaptrCnvrtdGrssQty,
  ACMAppDocBaseUoM,
  ACMApplOvwSpotFlag,
  ACMApplOvwSpotFlagDesc,
  ACMLoadDataCaptureUoM
FROM R_ACMApplicationOverviewDetTP
;

Learn More