I_MaterialPricingGroup

DDL: I_MATERIALPRICINGGROUP SQL: ISDMTRLPRCGRP Type: view BASIC Package: VDM_SD_MD_MM
2 Fields 1 Data Sources 1 Associations 5 OData Services

Material Pricing Group

I_MaterialPricingGroup (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Material Pricing Group · Sales

I_MaterialPricingGroup is a Basic CDS View (Dimension) that provides data about "Material Pricing Group" in SAP S/4HANA. It reads from 1 data source (t178) and exposes 2 fields with key field MaterialPricingGroup. It has 1 association to related views. It is exposed through 5 OData services (ASQL_F5987, ASQL_F8712, UI_CREDITMEMOREQUESTMANAGE, ...). Part of development package VDM_SD_MD_MM.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSales
Application ComponentSD-MD-MM-2CL
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Analytical Dimension,Data Source for Search
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSales for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
t178 t178 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MaterialPricingGroupText _Text $projection.MaterialPricingGroup = _Text.MaterialPricingGroup

Annotations (19)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey MaterialPricingGroup view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Material Pricing Group view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDMTRLPRCGRP view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Analytics.dataExtraction.enabled true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name MaterialPricingGroup view

OData Services (5)

ServiceBindingVersionContractRelease
ASQL_F5987 ASQL_F5987 C2 NOT_RELEASED
ASQL_F8712 ASQL_F8712 C2 NOT_RELEASED
UI_CREDITMEMOREQUESTMANAGE UI_CREDITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_DEBITMEMOREQUESTMANAGE UI_DEBITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_SALESDOCUMENTMANAGE UI_SALESDOCUMENTMANAGE V4 C1 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY MaterialPricingGroup kondm Material Price Group
_Text _Text

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 I_MaterialPricingGroup.
-- 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: ISDMTRLPRCGRP

CREATE VIEW I_MaterialPricingGroup AS
SELECT
  kondm AS MaterialPricingGroup
FROM t178
LEFT OUTER JOIN I_MaterialPricingGroupText AS _Text ON MaterialPricingGroup = _Text.MaterialPricingGroup  -- association [0..*]
;

Learn More