C_ACMMntnPrcgLotFeeDetsOvw

DDL: C_ACMMNTNPRCGLOTFEEDETSOVW SQL: CPRCNGLOTFEEDETS Type: view CONSUMPTION
39 Fields 1 Data Sources

Pricing Lot Fee Details Overview

C_ACMMntnPrcgLotFeeDetsOvw is a Consumption CDS View that provides data about "Pricing Lot Fee Details Overview" in SAP S/4HANA. It reads from 1 data source (I_ACMTrdgContrPriceLotFeeOvw) and exposes 39 fields with key fields ACMFeeFrameworkDocTypeRef, TradingContractNumber, TradingContractItem, PricingConditionTerm, ACMFeeFrameworkRefDocYear.

Data Sources (1)

SourceAliasJoin Type
I_ACMTrdgContrPriceLotFeeOvw PriceLotFee from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPRCNGLOTFEEDETS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Pricing Lot Fee Details Overview view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY ACMFeeFrameworkDocTypeRef ACMFeeFrameworkDocTypeRef Document Level
KEY TradingContractNumber Fee Document Id
KEY TradingContractItem Fee Document Item
KEY PricingConditionTerm
KEY ACMFeeFrameworkRefDocYear ACMFeeFrameworkRefDocYear Document Year
KEY ACMFeeFrameworkRefDocSqncNmbr ACMFeeFrameworkRefDocSqncNmbr Sequence Number
KEY FeeFrameworkFeeID FeeFrameworkFeeID Fee ID
KEY FeeVersion FeeVersion Fee Version
FeeDocumentLevelName FeeDocumentLevelName Short Description
FeeFrameworkFeeName FeeFrameworkFeeName
ACMFeeFrameworkAllocationMode ACMFeeFrameworkAllocationMode Allocation Mode
ACMFeeType ACMFeeType Fee Type
ACMFeeTypeName ACMFeeTypeName Fee Type Name
FeeAllocationModeName FeeAllocationModeName Fee Allocation Mode Name
ACMFeeValidStatus ACMFeeValidStatus Fee Valid Status
ACMFeeValidStatusName ACMFeeValidStatusName Short Description
ACMFeeCurrency ACMFeeCurrency Currency
ACMFeeAmount ACMFeeAmount Fee Rate
ACMFeeUoM ACMFeeUoM UoM
ACMFeeQuantity ACMFeeQuantity Quantity
ACMFeeStopOnPrvsnlSettlmt ACMFeeStopOnPrvsnlSettlmt Stop Settlement on Provisional
ACMFeeStopOnFinalSettlmt ACMFeeStopOnFinalSettlmt Stop Settlement on Final
ACMFeeInchargeAmount ACMFeeInchargeAmount Incharge Rate
ACMInChargeAmtCrcy ACMInChargeAmtCrcy Incharge Currency
ACMInchargeQty ACMInchargeQty Incharge Quantity
ACMInchargeQtyUoM ACMInchargeQtyUoM In Charge Unit of Measure
ACMFeeRecrrgChrgAmount ACMFeeRecrrgChrgAmount Recurring Charge Rate
ACMFeeRecrrgChrgCrcy ACMFeeRecrrgChrgCrcy Recurring Charge Currency
ACMFeeRecrrgChrgQty ACMFeeRecrrgChrgQty Recurring Charge Quantity
ACMFeeRecrrgChrgUoM ACMFeeRecrrgChrgUoM Recurring Charge Unit of Measure
ACMFeeMaxChargeAmount ACMFeeMaxChargeAmount Maximum Charge Rate
ACMFeeMaxChrgCrcy ACMFeeMaxChrgCrcy Maximum Charge Currency
ACMFeeMaxChargeQuantity ACMFeeMaxChargeQuantity Maximum Charge Quantity
ACMFeeMaxChargeUoM ACMFeeMaxChargeUoM Maximum Charge Unit of Measurement
ACMFeePremCrdtAmount ACMFeePremCrdtAmount Premium Credit Rate
ACMFeePremCrdtCrcy ACMFeePremCrdtCrcy Premium Credit Currency
ACMFeePremCrdtQty ACMFeePremCrdtQty Premium Credit Quantity
ACMFeePremCrdtUoM ACMFeePremCrdtUoM Premium Credit Unit of Measure
ACMNoPrcgFeeIdfr ACMNoPrcgFeeIdfr

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 C_ACMMntnPrcgLotFeeDetsOvw.
-- 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.
-- SQL view name: CPRCNGLOTFEEDETS

CREATE VIEW C_ACMMntnPrcgLotFeeDetsOvw AS
SELECT
  ACMFeeFrameworkDocTypeRef,
  cast(ACMFeeFrameworkRefDocID as tkonn ) AS TradingContractNumber,
  cast(ACMFeeFrameworkRefDocumentItem as tposn ) AS TradingContractItem,
  cast(ACMFeeFrameworkRefDocSubItem as cpet_termno ) AS PricingConditionTerm,
  ACMFeeFrameworkRefDocYear,
  ACMFeeFrameworkRefDocSqncNmbr,
  FeeFrameworkFeeID,
  FeeVersion,
  FeeDocumentLevelName,
  FeeFrameworkFeeName,
  ACMFeeFrameworkAllocationMode,
  ACMFeeType,
  ACMFeeTypeName,
  FeeAllocationModeName,
  ACMFeeValidStatus,
  ACMFeeValidStatusName,
  ACMFeeCurrency,
  ACMFeeAmount,
  ACMFeeUoM,
  ACMFeeQuantity,
  ACMFeeStopOnPrvsnlSettlmt,
  ACMFeeStopOnFinalSettlmt,
  ACMFeeInchargeAmount,
  ACMInChargeAmtCrcy,
  ACMInchargeQty,
  ACMInchargeQtyUoM,
  ACMFeeRecrrgChrgAmount,
  ACMFeeRecrrgChrgCrcy,
  ACMFeeRecrrgChrgQty,
  ACMFeeRecrrgChrgUoM,
  ACMFeeMaxChargeAmount,
  ACMFeeMaxChrgCrcy,
  ACMFeeMaxChargeQuantity,
  ACMFeeMaxChargeUoM,
  ACMFeePremCrdtAmount,
  ACMFeePremCrdtCrcy,
  ACMFeePremCrdtQty,
  ACMFeePremCrdtUoM,
  ACMNoPrcgFeeIdfr
FROM I_ACMTrdgContrPriceLotFeeOvw AS PriceLotFee
;

Learn More