P_ACMQtyReconAllFinalData

DDL: P_ACMQTYRECONALLFINALDATA Type: view_entity COMPOSITE
48 Fields 1 Data Sources

P_ACMQtyReconAllFinalData is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ACMQtyReconFillErrFieldsData) and exposes 48 fields with key fields ContractNum, PricingDocument, TradingContractItem, ContractSubItem, ApplicationDocument.

Data Sources (1)

SourceAliasJoin Type
P_ACMQtyReconFillErrFieldsData P_ACMQtyReconFillErrFieldsData from

Parameters (4)

NameTypeDefault
P_FromDateInSystemTimeZone aedat
P_ToDateInSystemTimeZone aedat
P_FromTimeInSystemTimeZone aezeit
P_ToTimeInSystemTimeZone aezeit

Annotations (7)

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

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY ContractNum ContractNum
KEY PricingDocument BaseData PricingDocument Document Condition
KEY TradingContractItem TradingContractItem Item Number
KEY ContractSubItem ContractSubItem
KEY ApplicationDocument ApplicationDocument
KEY ApplicationDocumentItem ApplicationDocumentItem
KEY DocumentSide DocumentSide
KEY ACMApplicationDocumentSubItem ApplicationSubItem
KEY TrdgContrPrcgAspectSrceLotID TrdgContrPrcgAspectSrceLotID
KEY ConditionTermRateFixation BaseData ConditionTermRateFixation
KEY RecnclnRecordType ReconciliationRecordType
KEY PricingKey PricingKey Pricing Key
KEY Version Version XML Vers.
KEY PricingDocumentItem PricingDocumentItem Item
KEY ConditionType ConditionType Condition type
KEY SubConditionType SubConditionType
KEY VersStockRecordUUID VersStockRecordUUID
MTMDataSourceType MTMDataSourceType Type of Data Record
TradingContractType TradingContractType
ApplicationDocType ApplicationDocType
ApplicationStatus ApplStatusCode
ACMSettlementStatus StlStatusCode
ContractMaterial ContractMaterial
ContractPlant ContractPlant
CompanyCode CompanyCode Receiver Company Code
StorageLocation StorageLocation StorageLocation
ACMReportingStorageLocation ACMReportingStorageLocation
DocumentDate DocumentDate Journal Entry Date
TradingContractCreatedBy TradingContractCreatedBy
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Commodity Commodity Commodity Code
CustomerName CustomerName Name of Customer
SupplierName SupplierName Supplier Name
RelatedDocumentNumber RelatedDocumentNumber
RelatedDocumentItemNumber RelatedDocumentItemNumber
ContractIsMirrorContr ContractIsMirrorContr
PhysicalCommodity BaseData PhysicalCommodity
ACMPricingUnitOfMeasure CmmdtyPriceExpsrUnit
RecnclnReportingQty
RecnclnReportingPricingStatus
RecnclnTransaclPricingStatus RecnclnTransaclPricingStatus
ACMErrFlagIsSetStorageLocation ACMErrFlagIsSetStorageLocation
DisplayOnlyError DisplayOnlyError
DisplayUnitOfMeasure DisplayUnitOfMeasure

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_ACMQtyReconAllFinalData.
-- 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.
-- Parameters: P_FromDateInSystemTimeZone : aedat, P_ToDateInSystemTimeZone : aedat, P_FromTimeInSystemTimeZone : aezeit, P_ToTimeInSystemTimeZone : aezeit

CREATE VIEW P_ACMQtyReconAllFinalData AS
SELECT
  ContractNum,
  BaseData.PricingDocument AS PricingDocument,
  TradingContractItem,
  ContractSubItem,
  ApplicationDocument,
  ApplicationDocumentItem,
  DocumentSide,
  ApplicationSubItem AS ACMApplicationDocumentSubItem,
  TrdgContrPrcgAspectSrceLotID,
  BaseData.ConditionTermRateFixation AS ConditionTermRateFixation,
  ReconciliationRecordType AS RecnclnRecordType,
  PricingKey,
  Version,
  PricingDocumentItem,
  ConditionType,
  SubConditionType,
  VersStockRecordUUID,
  MTMDataSourceType,
  TradingContractType,
  ApplicationDocType,
  ApplStatusCode AS ApplicationStatus,
  StlStatusCode AS ACMSettlementStatus,
  ContractMaterial,
  ContractPlant,
  CompanyCode,
  StorageLocation,
  ACMReportingStorageLocation,
  DocumentDate,
  TradingContractCreatedBy,
  SalesOrganization,
  DistributionChannel,
  Division,
  PurchasingOrganization,
  PurchasingGroup,
  Commodity,
  CustomerName,
  SupplierName,
  RelatedDocumentNumber,
  RelatedDocumentItemNumber,
  ContractIsMirrorContr,
  BaseData.PhysicalCommodity AS PhysicalCommodity,
  CmmdtyPriceExpsrUnit AS ACMPricingUnitOfMeasure,
  cast(BaseData.ReportingQuantity as /accgo/e_recon_reporting_qty) AS RecnclnReportingQty,
  cast(RecnclnReportingPricingStatus as /accgo/e_rep_prcngstat) AS RecnclnReportingPricingStatus,
  RecnclnTransaclPricingStatus,
  ACMErrFlagIsSetStorageLocation,
  DisplayOnlyError,
  DisplayUnitOfMeasure
FROM P_ACMQtyReconFillErrFieldsData
;

Learn More