R_ACMTrdgContrPrcgMasterTP

DDL: R_ACMTRDGCONTRPRCGMASTERTP SQL: RCONTRPRCGMASTER Type: view TRANSACTIONAL
24 Fields 1 Data Sources

Transactional Processing View for Pricing Master data

R_ACMTrdgContrPrcgMasterTP is a Transactional CDS View that provides data about "Transactional Processing View for Pricing Master data" in SAP S/4HANA. It reads from 1 data source (I_ACMTrdgContrPrcgMaster) and exposes 24 fields with key field ACMPriceMethodProgramID.

Data Sources (1)

SourceAliasJoin Type
I_ACMTrdgContrPrcgMaster I_ACMTrdgContrPrcgMaster from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName RCONTRPRCGMASTER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transactional Processing View for Pricing Master data view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY ACMPriceMethodProgramID ACMPriceMethodProgramID Program ID
ACMPriceMethodProgram ACMPriceMethodProgram Program Name
ACMPriceMethodProgramName ACMPriceMethodProgramName External Code
ACMPriceMethodProgramFamily ACMPriceMethodProgramFamily Program Family
ACMPriceMethodProgramType ACMPriceMethodProgramType Program Type
ACMPriceMethodProgramTypeName ACMPriceMethodProgramTypeName Program Type (Code)
ACMPrcMethSignUpStartDate ACMPrcMethSignUpStartDate Signup Start Date
ACMPrcMethSignUpEndDate ACMPrcMethSignUpEndDate Signup End Date
PlngDataPricingPeriodStartDate PlngDataPricingPeriodStartDate Pricing Start Date
PlngDataPricingPeriodEndDate PlngDataPricingPeriodEndDate Pricing End Date
DerivativeContractMaturityCode DerivativeContractMaturityCode Contr. Maturity Code
ACMPrcMethCropYear ACMPrcMethCropYear Crop Year
ACMPrcMethMarketingTiming ACMPrcMethMarketingTiming Market Timing
ACMPrcMethPriceFutures ACMPrcMethPriceFutures Futures Pricing
Currency Currency Valuation Crcy
ACMPricingUnitOfMeasure ACMPricingUnitOfMeasure Unit of Measure
TrdgContrPurgNetPriceQuantity TrdgContrPurgNetPriceQuantity Price Unit
ACMTrdgContrPrcgStatusText ACMTrdgContrPrcgStatusText Workflow Status
ACMPricingMethodStatusName ACMPricingMethodStatusName Status Text
ACMSettlmtDocPaytSpltCreatedBy ACMSettlmtDocPaytSpltCreatedBy Version Created By
TradingContrCreatedOnDate TradingContrCreatedOnDate Variant created on
GrantCreatedOnDateTime GrantCreatedOnDateTime Time Stamp
ChangedBy ChangedBy User Name
GrantChangedOnDateTime GrantChangedOnDateTime Time Stamp

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 R_ACMTrdgContrPrcgMasterTP.
-- 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: RCONTRPRCGMASTER

CREATE VIEW R_ACMTrdgContrPrcgMasterTP AS
SELECT
  ACMPriceMethodProgramID,
  ACMPriceMethodProgram,
  ACMPriceMethodProgramName,
  ACMPriceMethodProgramFamily,
  ACMPriceMethodProgramType,
  ACMPriceMethodProgramTypeName,
  ACMPrcMethSignUpStartDate,
  ACMPrcMethSignUpEndDate,
  PlngDataPricingPeriodStartDate,
  PlngDataPricingPeriodEndDate,
  DerivativeContractMaturityCode,
  ACMPrcMethCropYear,
  ACMPrcMethMarketingTiming,
  ACMPrcMethPriceFutures,
  Currency,
  ACMPricingUnitOfMeasure,
  TrdgContrPurgNetPriceQuantity,
  ACMTrdgContrPrcgStatusText,
  ACMPricingMethodStatusName,
  ACMSettlmtDocPaytSpltCreatedBy,
  TradingContrCreatedOnDate,
  GrantCreatedOnDateTime,
  ChangedBy,
  GrantChangedOnDateTime
FROM I_ACMTrdgContrPrcgMaster
;

Learn More