I_AdditionalMaterialGroup1

DDL: I_ADDITIONALMATERIALGROUP1 SQL: ISDADDLMATLGRP1 Type: view BASIC Package: VDM_SD_MD_MM
2 Fields 1 Data Sources 1 Associations 7 OData Services

Additional Material Group 1

I_AdditionalMaterialGroup1 (Basic)

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

Additional Product Group 1 · Sales

I_AdditionalMaterialGroup1 is a Basic CDS View (Dimension) that provides data about "Additional Material Group 1" in SAP S/4HANA. It reads from 1 data source (tvm1) and exposes 2 fields with key field AdditionalMaterialGroup1. It has 1 association to related views. It is exposed through 7 OData services (ASQL_F8712, C_SALESORDERMANAGE_SD, UI_BILLINGDOCUMENT_MANAGE, ...). 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
tvm1 tvm1 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_AdditionalMaterialGroup1Text _Text $projection.AdditionalMaterialGroup1 = _Text.AdditionalMaterialGroup1

Annotations (18)

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

OData Services (7)

ServiceBindingVersionContractRelease
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_SLSORD_PRGS_MONITOR UI_RFM_SLSORD_PRGS_MONITOR V2 C1 NOT_RELEASED
UI_SALESDOCUMENTMANAGE UI_SALESDOCUMENTMANAGE V4 C1 NOT_RELEASED
UI_SLSORDERWITHOUTCHARGEMANAGE UI_SLSORDERWITHOUTCHARGEMANAGE V4 C1 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY AdditionalMaterialGroup1 mvgr1 Material Group 1
_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_AdditionalMaterialGroup1.
-- 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: ISDADDLMATLGRP1

CREATE VIEW I_AdditionalMaterialGroup1 AS
SELECT
  mvgr1 AS AdditionalMaterialGroup1
FROM tvm1
LEFT OUTER JOIN I_AdditionalMaterialGroup1Text AS _Text ON AdditionalMaterialGroup1 = _Text.AdditionalMaterialGroup1  -- association [0..*]
;

Learn More