I_CustomerPriceGroup

DDL: I_CUSTOMERPRICEGROUP SQL: ISDCUSTPRICEGRP Type: view BASIC Package: VDM_SD_MD_MM

Customer Price Group

I_CustomerPriceGroup (Basic)

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

Customer Price Group · Sales

I_CustomerPriceGroup is a Basic CDS View (Dimension) that provides data about "Customer Price Group" in SAP S/4HANA. It reads from 1 data source (t188) and exposes 2 fields with key field CustomerPriceGroup. It has 1 association to related views. It is exposed through 13 OData services (ASQL_F5987, ASQL_F7205A, ASQL_F8712, ...). 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
t188 t188 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CustomerPriceGroupText _Text $projection.CustomerPriceGroup = _Text.CustomerPriceGroup

Annotations (19)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey CustomerPriceGroup view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Customer Price Group view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDCUSTPRICEGRP 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
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name CustomerPriceGroup view

OData Services (13)

ServiceBindingVersionContractRelease
ASQL_F5987 ASQL_F5987 C2 NOT_RELEASED
ASQL_F7205A ASQL_F7205A C2 NOT_RELEASED
ASQL_F8712 ASQL_F8712 C2 NOT_RELEASED
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED
UI_BILLINGDOCUMENT_MANAGE UI_BILLINGDOCUMENT_MANAGE V4 C1 NOT_RELEASED
UI_CREDITMEMOREQUESTMANAGE UI_CREDITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_DEBITMEMOREQUESTMANAGE UI_DEBITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_RFM_PRVSNLSLSCONTR UI_RFM_PRVSNLSLSCONTR V2 C1 NOT_RELEASED
UI_RFM_SLSORD_PRGS_MONITOR UI_RFM_SLSORD_PRGS_MONITOR V2 C1 NOT_RELEASED
UI_SALESCONTRACTMANAGE UI_SALESCONTRACTMANAGE V4 C1 NOT_RELEASED
UI_SALESDOCUMENTMANAGE UI_SALESDOCUMENTMANAGE V4 C1 NOT_RELEASED
UI_SALESQUOTATIONMANAGE UI_SALESQUOTATIONMANAGE V4 C1 NOT_RELEASED
UI_SLSORDERWITHOUTCHARGEMANAGE UI_SLSORDERWITHOUTCHARGEMANAGE V4 C1 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CustomerPriceGroup konda Customer 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_CustomerPriceGroup.
-- 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: ISDCUSTPRICEGRP

CREATE VIEW I_CustomerPriceGroup AS
SELECT
  konda AS CustomerPriceGroup
FROM t188
LEFT OUTER JOIN I_CustomerPriceGroupText AS _Text ON CustomerPriceGroup = _Text.CustomerPriceGroup  -- association [0..*]
;