I_SalesOfficeSalesGroup

DDL: I_SALESOFFICESALESGROUP SQL: ISDSLSOFFICEGRP Type: view BASIC Package: VDM_SD_MD_ORG
4 Fields 1 Data Sources

Sales Groups for Sales office

I_SalesOfficeSalesGroup (Basic)

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

Sales

I_SalesOfficeSalesGroup is a Basic CDS View that provides data about "Sales Groups for Sales office" in SAP S/4HANA. It reads from 1 data source (tvbvk) and exposes 4 fields with key fields SalesOffice, SalesGroup. Part of development package VDM_SD_MD_ORG.

SAP Help Documentation

CategoryOrganizational Units
StatusReleased
Purpose
This CDS view retrieves sales groups of each sales office.

Structure
Main input parameters This view has no input parameters. Measures and attributes The view provides the following attributes: Sales office Sales group

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSales
Application ComponentSD-CRF-ORG-2CL
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSales for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view retrieves sales groups of each sales office.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
tvbvk tvbvk from

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Sales Groups for Sales office view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDSLSOFFICEGRP view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SalesOffice vkbur Sales Office
KEY SalesGroup vkgrp Sales Group
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup

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_SalesOfficeSalesGroup.
-- 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: ISDSLSOFFICEGRP

CREATE VIEW I_SalesOfficeSalesGroup AS
SELECT
  vkbur AS SalesOffice,
  vkgrp AS SalesGroup
FROM tvbvk
;

Learn More