I_AdditionalCustomerGroup5

DDL: I_ADDITIONALCUSTOMERGROUP5 SQL: ISDADDLCUSTGRP5 Type: view BASIC Package: VDM_SD_MD_MM

Additional Customer Group 5

I_AdditionalCustomerGroup5 (Basic)

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

Additional Customer Group 5 · Sales

I_AdditionalCustomerGroup5 is a Basic CDS View (Dimension) that provides data about "Additional Customer Group 5" in SAP S/4HANA. It reads from 1 data source (tvv5) and exposes 2 fields with key field AdditionalCustomerGroup5. It has 1 association to related views. It is exposed through 10 OData services (ASQL_F7205A, ASQL_F8712, C_SALESORDERMANAGE_SD, ...). 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 for Defining CDS Entities,Analytical Dimension,Association Target for Defining CDS Entities,Data Provider for Value Help,Data Source in SQL Select
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
tvv5 tvv5 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_AdditionalCustomerGroup5Text _Text $projection.AdditionalCustomerGroup5 = _Text.AdditionalCustomerGroup5

Annotations (19)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey AdditionalCustomerGroup5 view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
EndUserText.label Additional Customer Group 5 view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDADDLCUSTGRP5 view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name AdditionalCustomerGroup5 view
Search.searchable true view
Consumption.ranked true view
ObjectModel.dataCategory #VALUE_HELP view

OData Services (10)

ServiceBindingVersionContractRelease
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_INBOUNDDELIVERYMANAGE UI_INBOUNDDELIVERYMANAGE 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_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 AdditionalCustomerGroup5 kvgr5 Customer Group 5
_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_AdditionalCustomerGroup5.
-- 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: ISDADDLCUSTGRP5

CREATE VIEW I_AdditionalCustomerGroup5 AS
SELECT
  kvgr5 AS AdditionalCustomerGroup5
FROM tvv5
LEFT OUTER JOIN I_AdditionalCustomerGroup5Text AS _Text ON AdditionalCustomerGroup5 = _Text.AdditionalCustomerGroup5  -- association [0..*]
;