C_InventoryPriceChangeTP

DDL: C_INVENTORYPRICECHANGETP Type: view_entity CONSUMPTION Package: ODATA_ML_CHANGEMATERIALPRICES
12 Fields 1 Data Sources 3 OData Services 1 Fiori Apps

CHMP Price Change Header

C_InventoryPriceChangeTP is a Consumption CDS View that provides data about "CHMP Price Change Header" in SAP S/4HANA. It reads from 1 data source (R_InventoryPriceChangeTP) and exposes 12 fields with key field ChangeDocTableKeyUUID. It is exposed through 3 OData services (ASQL_F6489, FML_CHANGE_MATERIAL_PRICES, UI_FML_CHG_MATERIAL_PRICES). It is used in 1 Fiori application: Change Material Prices. Part of development package ODATA_ML_CHANGEMATERIALPRICES.

Data Sources (1)

SourceAliasJoin Type
R_InventoryPriceChangeTP R_InventoryPriceChangeTP projection

Annotations (7)

NameValueLevelField
EndUserText.label CHMP Price Change Header view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F6489 ASQL_F6489 C2 NOT_RELEASED
FML_CHANGE_MATERIAL_PRICES FML_CHANGE_MATERIAL_PRICES V4 C1 NOT_RELEASED
UI_FML_CHG_MATERIAL_PRICES UI_FML_CHG_MATERIAL_PRICES V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6489 Change Material Prices Transactional With this app, you create, analyze, simulate, and post material price changes. It allows you to change inventory prices, including sales order stock and project stock. You can change current material valuation prices retroactively or at the current date. To do so, enter the posting date and company code in the selection screen. You can change the price for a single reference valuation, then convert those changes to some or all valuations of the same material, or change prices for valuations individually. As you make changes, you can see the impact of the changes on price and valuation as percentages. You can also simulate material price changes to check for errors, warnings, and inconsistencies before posting.

Change Material Prices

Business Role: Cost Accountant - Inventory

With this feature, you create, analyze, simulate, and post material price changes. It allows you to change inventory prices, including sales order stock and project stock. You can change the price for a single reference valuation, then convert those changes to some or all valuations of the same material, or change prices for valuations individually. As you make changes, you can see the impact of the changes on price and valuation as percentages. You can also simulate material price changes to check for errors, warnings, and inconsistencies before posting.You can only use Change Material Prices if you have activated the business function Universal Parallel Accounting (FINS_PARALLEL_ACCOUNTING_BF, short: UPA). If you have not activated the UPA business function, you can use Change Material Prices (MR21) instead.

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocTableKeyUUID ChangeDocTableKeyUUID Change Document Table Key Universally Unique Identifier
MaterialPriceChangedByUser MaterialPriceChangedByUser User Name
DocumentHeaderText DocumentHeaderText Doc.Header Text
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
PostingDate PostingDate Posting Date for GR
ExternalReferenceDocumentID ExternalReferenceDocumentID Reference
ValuationAreaType ValuationAreaType Valuation area
MatlPrChgAcctDetnDiffntnRsn MatlPrChgAcctDetnDiffntnRsn Reason
MatlPrChgAcctDetnDiffntnRsnTxt

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_InventoryPriceChangeTP.
-- 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.

CREATE VIEW C_InventoryPriceChangeTP AS
SELECT
  ChangeDocTableKeyUUID,
  MaterialPriceChangedByUser,
  DocumentHeaderText,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  Plant,
  _Plant.PlantName AS PlantName,
  PostingDate,
  ExternalReferenceDocumentID,
  ValuationAreaType,
  MatlPrChgAcctDetnDiffntnRsn,
  _ChangeReason._Text[1: Language = $session.system_language].MatlPrChgAcctDetnDiffntnRsnTxt AS MatlPrChgAcctDetnDiffntnRsnTxt
FROM R_InventoryPriceChangeTP
;

Learn More