P_ACMPrcReconFillRprtingData
P_ACMPrcReconFillRprtingData is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ACMMappgCndnTypesToGrpData) and exposes 76 fields with key fields ContractNum, TradingContractItem, ContractSubItem, ApplicationDocument, ApplicationDocumentItem.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_ACMMappgCndnTypesToGrpData | P_ACMMappgCndnTypesToGrpData | from |
Parameters (4)
| Name | Type | Default |
|---|---|---|
| P_FromDateInSystemTimeZone | aedat | |
| P_ToDateInSystemTimeZone | aedat | |
| P_FromTimeInSystemTimeZone | aezeit | |
| P_ToTimeInSystemTimeZone | aezeit |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| 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 (76)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ContractNum | BaseData | ContractNum | |
| KEY | TradingContractItem | BaseData | TradingContractItem | Item Number |
| KEY | ContractSubItem | BaseData | ContractSubItem | |
| KEY | ApplicationDocument | BaseData | ApplicationDocument | |
| KEY | ApplicationDocumentItem | BaseData | ApplicationDocumentItem | |
| KEY | Side | BaseData | Side | Side |
| KEY | ApplicationSubItem | BaseData | ApplicationSubItem | |
| KEY | TrdgContrPrcgAspectSrceLotID | BaseData | TrdgContrPrcgAspectSrceLotID | |
| KEY | ConditionTermRateFixation | BaseData | ConditionTermRateFixation | |
| KEY | RecnclnRecordType | BaseData | RecnclnRecordType | |
| KEY | PricingKey | ReportingData | PricingKey | Pricing Key |
| KEY | Version | ReportingData | Version | XML Vers. |
| KEY | PricingDocumentItem | ReportingData | ACMPricingDocumentItem | |
| KEY | ConditionType | ReportingData | ConditionType | Condition type |
| KEY | SubConditionType | ReportingData | SubConditionType | |
| MTMDataSourceType | ReportingData | MTMDataSourceType | Type of Data Record | |
| TradingContractType | BaseData | TradingContractType | ||
| ApplicationDocType | BaseData | ApplicationDocType | ||
| ApplStatusCode | BaseData | ApplStatusCode | ||
| StlStatusCode | BaseData | StlStatusCode | ||
| ContractMaterial | BaseData | ContractMaterial | ||
| ContractPlant | BaseData | ContractPlant | ||
| CompanyCode | BaseData | CompanyCode | Receiver Company Code | |
| StorageLocation | BaseData | StorageLocation | StorageLocation | |
| TradingContractCreatedBy | BaseData | TradingContractCreatedBy | ||
| SalesOrganization | BaseData | SalesOrganization | Sales Organization | |
| DistributionChannel | BaseData | DistributionChannel | RefDistCh-Cust/Mat. | |
| Division | BaseData | Division | Internal Division ID | |
| PurchasingOrganization | BaseData | PurchasingOrganization | Purchasing Organization | |
| PurchasingGroup | BaseData | PurchasingGroup | Purchasing Group | |
| Commodity | BaseData | Commodity | Commodity Code | |
| CustomerName | BaseData | CustomerName | Name of Customer | |
| SupplierName | BaseData | SupplierName | Supplier Name | |
| PricingDocument | BaseData | PricingDocument | Document Condition | |
| PricingStatus | BaseData | PricingStatus | ||
| PricingProcedure | BaseData | PricingProcedure | Procedure | |
| ConditionItem | BaseData | ConditionItem | ||
| ACMPricingConditionType | BaseData | ACMPricingConditionType | Condition Type | |
| ACMPrcgCndnFormulaPrice | BaseData | ACMPrcgCndnFormulaPrice | ||
| ACMPrcgCndnFormulaRateCrcy | BaseData | ACMPrcgCndnFormulaRateCrcy | Term Currency | |
| ACMPrcgCndnFormulaRateQty | BaseData | ACMPrcgCndnFormulaRateQty | Term Price Unit | |
| ACMPrcgCndnFormulaRateQtyUnit | BaseData | ACMPrcgCndnFormulaRateQtyUnit | Term UoM | |
| PricingConditionTerm | BaseData | PricingConditionTerm | Term Number | |
| ACMPrcgCndnDocumentCrcy | BaseData | ACMPrcgCndnDocumentCrcy | ||
| Quantity | BaseData | Quantity | Value | |
| UnitOfMeasure | BaseData | UnitOfMeasure | Unit Protected Qty | |
| ACMTermCalcType | BaseData | ACMTermCalcType | ||
| DerivativeContrSpecification | BaseData | DerivativeContrSpecification | DCS ID | |
| MarketIdentifierCode | BaseData | MarketIdentifierCode | MIC | |
| ACMPrcgCndnTermInputPrice | BaseData | ACMPrcgCndnTermInputPrice | ||
| PrcgConditionTermFixedRateCrcy | BaseData | PrcgConditionTermFixedRateCrcy | Currency Fixed Rate | |
| PrcgConditionTermFixedRateQty | BaseData | PrcgConditionTermFixedRateQty | PrcUnit Fixed Value | |
| PrcgCndnTermFixedRateQtyUnit | BaseData | PrcgCndnTermFixedRateQtyUnit | UoM for Fixed Value | |
| QuotationKeyType | BaseData | QuotationKeyType | ||
| MaturityKeyDate | ||||
| PrcgCndnTrmPrSettingMethodUUID | BaseData | PrcgCndnTrmPrSettingMethodUUID | ||
| BasisType | BaseData | BasisType | Basis Type | |
| ACMPricingFXRate | BaseData | ACMPricingFXRate | ||
| RecnclnTransaclDelivFromDate | BaseData | RecnclnTransaclDelivFromDate | ||
| RecnclnTransaclDelivToDate | BaseData | RecnclnTransaclDelivToDate | ||
| ConditionTermRateendasConditionTermRate | ||||
| ConditionTermRateCurrency | ReportingData | ConditionTermRateCurrency | ||
| ConditionTermRateQuantity | ReportingData | ConditionTermRateQuantity | ||
| ConditionTermRateQuantityUnit | ReportingData | ConditionTermRateQuantityUnit | ||
| RecnclnReportingPricingStatus | ReportingData | PricingStatus | ||
| TargetConversionFactor | ReportingData | TargetConversionFactor | ||
| SourceConversionFactor | ReportingData | SourceConversionFactor | ||
| SourceCurrency | ||||
| TargetCurrency | ||||
| RecnclnRptgMaturityKeyDate | ||||
| RecnclnRptgDelivFromDate | ReportingData | DeliveryPeriodStartDate | ||
| RecnclnRptgDelivToDate | ReportingData | DeliveryPeriodEndDate | ||
| OpenContractQty | BaseData | OpenContractQty | ||
| MaterialBaseUnit | BaseData | MaterialBaseUnit | Valuation Unit | |
| DistrToPrcLotApplItemQty | BaseData | DistrToPrcLotApplItemQty | ||
| ThreasholdUpperLimit | BaseData | ThreasholdUpperLimit |
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_ACMPrcReconFillRprtingData.
-- 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_ACMPrcReconFillRprtingData AS
SELECT
BaseData.ContractNum AS ContractNum,
BaseData.TradingContractItem AS TradingContractItem,
BaseData.ContractSubItem AS ContractSubItem,
BaseData.ApplicationDocument AS ApplicationDocument,
BaseData.ApplicationDocumentItem AS ApplicationDocumentItem,
BaseData.Side AS Side,
BaseData.ApplicationSubItem AS ApplicationSubItem,
BaseData.TrdgContrPrcgAspectSrceLotID AS TrdgContrPrcgAspectSrceLotID,
BaseData.ConditionTermRateFixation AS ConditionTermRateFixation,
BaseData.RecnclnRecordType AS RecnclnRecordType,
ReportingData.PricingKey AS PricingKey,
ReportingData.Version AS Version,
ReportingData.ACMPricingDocumentItem AS PricingDocumentItem,
ReportingData.ConditionType AS ConditionType,
ReportingData.SubConditionType AS SubConditionType,
ReportingData.MTMDataSourceType AS MTMDataSourceType,
BaseData.TradingContractType AS TradingContractType,
BaseData.ApplicationDocType AS ApplicationDocType,
BaseData.ApplStatusCode AS ApplStatusCode,
BaseData.StlStatusCode AS StlStatusCode,
BaseData.ContractMaterial AS ContractMaterial,
BaseData.ContractPlant AS ContractPlant,
BaseData.CompanyCode AS CompanyCode,
BaseData.StorageLocation AS StorageLocation,
BaseData.TradingContractCreatedBy AS TradingContractCreatedBy,
BaseData.SalesOrganization AS SalesOrganization,
BaseData.DistributionChannel AS DistributionChannel,
BaseData.Division AS Division,
BaseData.PurchasingOrganization AS PurchasingOrganization,
BaseData.PurchasingGroup AS PurchasingGroup,
BaseData.Commodity AS Commodity,
BaseData.CustomerName AS CustomerName,
BaseData.SupplierName AS SupplierName,
BaseData.PricingDocument AS PricingDocument,
BaseData.PricingStatus AS PricingStatus,
BaseData.PricingProcedure AS PricingProcedure,
BaseData.ConditionItem AS ConditionItem,
BaseData.ACMPricingConditionType AS ACMPricingConditionType,
BaseData.ACMPrcgCndnFormulaPrice AS ACMPrcgCndnFormulaPrice,
BaseData.ACMPrcgCndnFormulaRateCrcy AS ACMPrcgCndnFormulaRateCrcy,
BaseData.ACMPrcgCndnFormulaRateQty AS ACMPrcgCndnFormulaRateQty,
BaseData.ACMPrcgCndnFormulaRateQtyUnit AS ACMPrcgCndnFormulaRateQtyUnit,
BaseData.PricingConditionTerm AS PricingConditionTerm,
BaseData.ACMPrcgCndnDocumentCrcy AS ACMPrcgCndnDocumentCrcy,
BaseData.Quantity AS Quantity,
BaseData.UnitOfMeasure AS UnitOfMeasure,
BaseData.ACMTermCalcType AS ACMTermCalcType,
BaseData.DerivativeContrSpecification AS DerivativeContrSpecification,
BaseData.MarketIdentifierCode AS MarketIdentifierCode,
BaseData.ACMPrcgCndnTermInputPrice AS ACMPrcgCndnTermInputPrice,
BaseData.PrcgConditionTermFixedRateCrcy AS PrcgConditionTermFixedRateCrcy,
BaseData.PrcgConditionTermFixedRateQty AS PrcgConditionTermFixedRateQty,
BaseData.PrcgCndnTermFixedRateQtyUnit AS PrcgCndnTermFixedRateQtyUnit,
BaseData.QuotationKeyType AS QuotationKeyType,
cast( BaseData.MaturityKeyDate as /accgo/e_recon_tran_keydate ) AS MaturityKeyDate,
BaseData.PrcgCndnTrmPrSettingMethodUUID AS PrcgCndnTrmPrSettingMethodUUID,
BaseData.BasisType AS BasisType,
BaseData.ACMPricingFXRate AS ACMPricingFXRate,
BaseData.RecnclnTransaclDelivFromDate AS RecnclnTransaclDelivFromDate,
BaseData.RecnclnTransaclDelivToDate AS RecnclnTransaclDelivToDate,
case AS ConditionTermRateendasConditionTermRate,
ReportingData.ConditionTermRateCurrency AS ConditionTermRateCurrency,
ReportingData.ConditionTermRateQuantity AS ConditionTermRateQuantity,
ReportingData.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
ReportingData.PricingStatus AS RecnclnReportingPricingStatus,
ReportingData.TargetConversionFactor AS TargetConversionFactor,
ReportingData.SourceConversionFactor AS SourceConversionFactor,
' ' AS SourceCurrency,
' ' AS TargetCurrency,
cast(ReportingData.MaturityKeyDate as /accgo/e_recon_rep_keydate) AS RecnclnRptgMaturityKeyDate,
ReportingData.DeliveryPeriodStartDate AS RecnclnRptgDelivFromDate,
ReportingData.DeliveryPeriodEndDate AS RecnclnRptgDelivToDate,
BaseData.OpenContractQty AS OpenContractQty,
BaseData.MaterialBaseUnit AS MaterialBaseUnit,
BaseData.DistrToPrcLotApplItemQty AS DistrToPrcLotApplItemQty,
BaseData.ThreasholdUpperLimit AS ThreasholdUpperLimit
FROM P_ACMMappgCndnTypesToGrpData
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA