P_ACMPrcReconQtyCnvToPMVUnit

DDL: P_ACMPRCRECONQTYCNVTOPMVUNIT Type: view_entity COMPOSITE
70 Fields 1 Data Sources

P_ACMPrcReconQtyCnvToPMVUnit is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ACMPrcReconFillPMVUnit) and exposes 70 fields with key fields ContractNum, TradingContractItem, ContractSubItem, ApplicationDocument, ApplicationDocumentItem.

Data Sources (1)

SourceAliasJoin Type
P_ACMPrcReconFillPMVUnit P_ACMPrcReconFillPMVUnit 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 #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (70)

KeyFieldSource TableSource FieldDescription
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 BaseData PricingKey Pricing Key
KEY Version BaseData Version XML Vers.
KEY PricingDocumentItem BaseData PricingDocumentItem Item
KEY ConditionType BaseData ConditionType Condition type
KEY SubConditionType BaseData SubConditionType
MTMDataSourceType BaseData 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
ACMPricingConditionType BaseData ACMPricingConditionType Condition Type
ACMPrcgCndnFormulaPrice BaseData ACMPrcgCndnFormulaPrice
ACMPrcgCndnFormulaRateCrcy BaseData ACMPrcgCndnFormulaRateCrcy Term Currency
ACMPrcgCndnFormulaRateQty BaseData ACMPrcgCndnFormulaRateQty Term Price Unit
ACMPrcgCndnFormulaRateQtyUnit BaseData ACMPrcgCndnFormulaRateQtyUnit Term UoM
PricingProcedure BaseData PricingProcedure Procedure
RecnclnReportingPricingStatus BaseData RecnclnReportingPricingStatus
TransaclDCS BaseData DerivativeContrSpecification DCS ID
TransaclMarketIdentifierCode BaseData MarketIdentifierCode MIC
curr158endasRecnclnTransaclPrice
ACMTermCalcType BaseData ACMTermCalcType
ACMPrcgCndnTermInputPrice BaseData ACMPrcgCndnTermInputPrice
RecnclnTransaclRateCrcy BaseData PrcgConditionTermFixedRateCrcy Currency Fixed Rate
dec3114endasRecnclnTransaclRateQty
RecnclnTransaclRateQtyUnit BaseData PrcgCndnTermFixedRateQtyUnit UoM for Fixed Value
QuotationKeyType BaseData QuotationKeyType
RecnclnTransaclMaturityKeyDate BaseData MaturityKeyDate Maturity Key Date
PrcgCndnTrmPrSettingMethodUUID BaseData PrcgCndnTrmPrSettingMethodUUID
BasisType BaseData BasisType Basis Type
ACMPricingFXRateendasTransaclFixedFX
RecnclnTransaclDelivFromDate BaseData RecnclnTransaclDelivFromDate
RecnclnTransaclDelivToDate BaseData RecnclnTransaclDelivToDate
RecnclnReportingPrice BaseData ConditionTermRate
RecnclnReportingRateCrcy BaseData ConditionTermRateCurrency
RecnclnReportingRateQty
RecnclnReportingRateQtyUnit BaseData ConditionTermRateQuantityUnit
RecnclnRptgMaturityKeyDate BaseData RecnclnRptgMaturityKeyDate
RecnclnRptgDelivFromDate BaseData RecnclnRptgDelivFromDate
RecnclnRptgDelivToDate BaseData RecnclnRptgDelivToDate
OpenContractQty BaseData OpenContractQty
DistrToPrcLotApplItemQty BaseData DistrToPrcLotApplItemQty
ThreasholdUpperLimit BaseData ThreasholdUpperLimit
dec313asDistrApplItemQtyInPhysUnit
dec313asDistrApplItemQtyInMassUnit
dec313asDistrApplItemQtyInVolUnit

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_ACMPrcReconQtyCnvToPMVUnit.
-- 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_ACMPrcReconQtyCnvToPMVUnit 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,
  BaseData.PricingKey AS PricingKey,
  BaseData.Version AS Version,
  BaseData.PricingDocumentItem AS PricingDocumentItem,
  BaseData.ConditionType AS ConditionType,
  BaseData.SubConditionType AS SubConditionType,
  BaseData.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.ACMPricingConditionType AS ACMPricingConditionType,
  BaseData.ACMPrcgCndnFormulaPrice AS ACMPrcgCndnFormulaPrice,
  BaseData.ACMPrcgCndnFormulaRateCrcy AS ACMPrcgCndnFormulaRateCrcy,
  BaseData.ACMPrcgCndnFormulaRateQty AS ACMPrcgCndnFormulaRateQty,
  BaseData.ACMPrcgCndnFormulaRateQtyUnit AS ACMPrcgCndnFormulaRateQtyUnit,
  BaseData.PricingProcedure AS PricingProcedure,
  BaseData.RecnclnReportingPricingStatus AS RecnclnReportingPricingStatus,
  BaseData.DerivativeContrSpecification AS TransaclDCS,
  BaseData.MarketIdentifierCode AS TransaclMarketIdentifierCode,
  case when BaseData.ACMPrcgCndnTermInputPrice is initial or BaseData.ACMPrcgCndnTermInputPrice is null then cast(0 as abap.curr(15,8)) else cast(BaseData.ACMPrcgCndnTermInputPrice as abap.curr(15,8)) end as RecnclnTransaclPrice AS curr158endasRecnclnTransaclPrice,
  BaseData.ACMTermCalcType AS ACMTermCalcType,
  BaseData.ACMPrcgCndnTermInputPrice AS ACMPrcgCndnTermInputPrice,
  BaseData.PrcgConditionTermFixedRateCrcy AS RecnclnTransaclRateCrcy,
  case when BaseData.PrcgConditionTermFixedRateQty is initial or BaseData.PrcgConditionTermFixedRateQty is null then cast( 1 as abap.dec( 31, 14 )) else cast(BaseData.PrcgConditionTermFixedRateQty as abap.dec(31,14)) end as RecnclnTransaclRateQty AS dec3114endasRecnclnTransaclRateQty,
  BaseData.PrcgCndnTermFixedRateQtyUnit AS RecnclnTransaclRateQtyUnit,
  BaseData.QuotationKeyType AS QuotationKeyType,
  BaseData.MaturityKeyDate AS RecnclnTransaclMaturityKeyDate,
  BaseData.PrcgCndnTrmPrSettingMethodUUID AS PrcgCndnTrmPrSettingMethodUUID,
  BaseData.BasisType AS BasisType,
  case when BaseData.ACMPricingFXRate = 0 and BaseData.ACMPrcgCndnDocumentCrcy = BaseData.PrcgConditionTermFixedRateCrcy then 1 else BaseData.ACMPricingFXRate end as TransaclFixedFX AS ACMPricingFXRateendasTransaclFixedFX,
  BaseData.RecnclnTransaclDelivFromDate AS RecnclnTransaclDelivFromDate,
  BaseData.RecnclnTransaclDelivToDate AS RecnclnTransaclDelivToDate,
  BaseData.ConditionTermRate AS RecnclnReportingPrice,
  BaseData.ConditionTermRateCurrency AS RecnclnReportingRateCrcy,
  cast(BaseData.ConditionTermRateQuantity as abap.dec( 31, 14) ) AS RecnclnReportingRateQty,
  BaseData.ConditionTermRateQuantityUnit AS RecnclnReportingRateQtyUnit,
  BaseData.RecnclnRptgMaturityKeyDate AS RecnclnRptgMaturityKeyDate,
  BaseData.RecnclnRptgDelivFromDate AS RecnclnRptgDelivFromDate,
  BaseData.RecnclnRptgDelivToDate AS RecnclnRptgDelivToDate,
  BaseData.OpenContractQty AS OpenContractQty,
  BaseData.DistrToPrcLotApplItemQty AS DistrToPrcLotApplItemQty,
  BaseData.ThreasholdUpperLimit AS ThreasholdUpperLimit,
  cast( case when (PConvFactor.QuantityNumerator is not initial and PConvFactor.QuantityNumerator is not null) and (PConvFactor.QuantityDenominator is not initial and PConvFactor.QuantityDenominator is not null) then division((BaseData.DistrToPrcLotApplItemQty * PConvFactor.QuantityDenominator) , PConvFactor.QuantityNumerator, 3 ) else case when (SameDimConv1.SourceUnitOfMeasureNumerator is not initial and SameDimConv1.SourceUnitOfMeasureNumerator is not null ) and (SameDimConv1.SourceUnitOfMeasureDenominator is not initial and SameDimConv1.SourceUnitOfMeasureDenominator is not null ) then division(cast((cast(BaseData.DistrToPrcLotApplItemQty as abap.dec(15,3)) * SameDimConv1.SourceUnitOfMeasureNumerator ) as abap.dec( 31, 9 )), SameDimConv1.SourceUnitOfMeasureDenominator, 3) end end as abap.dec( 31, 3 )) as DistrApplItemQtyInPhysUnit AS dec313asDistrApplItemQtyInPhysUnit,
  cast( case when (MConvFactor.QuantityNumerator is not initial and MConvFactor.QuantityNumerator is not null) and (MConvFactor.QuantityDenominator is not initial and MConvFactor.QuantityDenominator is not null) then division((BaseData.DistrToPrcLotApplItemQty * MConvFactor.QuantityDenominator) , MConvFactor.QuantityNumerator, 3 ) else case when (SameDimConv2.SourceUnitOfMeasureNumerator is not initial and SameDimConv2.SourceUnitOfMeasureNumerator is not null ) and (SameDimConv2.SourceUnitOfMeasureDenominator is not initial and SameDimConv2.SourceUnitOfMeasureDenominator is not null ) then division(cast((cast(BaseData.DistrToPrcLotApplItemQty as abap.dec(15,3)) * SameDimConv2.SourceUnitOfMeasureNumerator ) as abap.dec( 31, 9 )), SameDimConv2.SourceUnitOfMeasureDenominator, 3) end end as abap.dec( 31, 3 )) as DistrApplItemQtyInMassUnit AS dec313asDistrApplItemQtyInMassUnit,
  cast( case when (VConvFactor.QuantityNumerator is not initial and VConvFactor.QuantityNumerator is not null) and (VConvFactor.QuantityDenominator is not initial and VConvFactor.QuantityDenominator is not null) then division((BaseData.DistrToPrcLotApplItemQty * VConvFactor.QuantityDenominator) , VConvFactor.QuantityNumerator, 3 ) else case when (SameDimConv3.SourceUnitOfMeasureNumerator is not initial and SameDimConv3.SourceUnitOfMeasureNumerator is not null ) and (SameDimConv3.SourceUnitOfMeasureDenominator is not initial and SameDimConv3.SourceUnitOfMeasureDenominator is not null ) then division(cast((cast(BaseData.DistrToPrcLotApplItemQty as abap.dec(15,3)) * SameDimConv3.SourceUnitOfMeasureNumerator ) as abap.dec( 31, 9 )), SameDimConv3.SourceUnitOfMeasureDenominator, 3) end end as abap.dec( 31, 3 )) as DistrApplItemQtyInVolUnit AS dec313asDistrApplItemQtyInVolUnit
FROM P_ACMPrcReconFillPMVUnit
;

Learn More