I_PurchasingGroup

DDL: I_PURCHASINGGROUP SQL: IMMPURCHGROUP Type: view BASIC
7 Fields 1 Data Sources

Purchasing Group

I_PurchasingGroup (Basic)

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

PurchasingGroup · Database & Data Management

I_PurchasingGroup is a Basic CDS View (Dimension) that provides data about "Purchasing Group" in SAP S/4HANA. It reads from 1 data source (t024) and exposes 7 fields with key field PurchasingGroup.

SAP API Hub

StateC1
Line of BusinessDatabase & Data Management
Application ComponentMM
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Analytical Dimension, Data Source for Data Extraction
PackageDatabase & Data Management for SAP S/4HANA Cloud Private Edition
Description <p>These CDS views are app independent, and are available for all external consumers who want to extract the data to SAP Business Warehouse (SAP BW) or other external systems.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
t024 t024 from

Annotations (18)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey PurchasingGroup view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.sapObjectNodeType.name PurchasingGroup view
AbapCatalog.sqlViewName IMMPURCHGROUP view
AbapCatalog.preserveKey true view
EndUserText.label Purchasing Group view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataExtraction.enabled true view
Search.searchable true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchasingGroup t024 ekgrp Sub. purchasing grp
PurchasingGroupName Purchasing Group Name
PurchasingGroupPhoneNumber t024 ektel Telephone number of purchasing group (buyer group)
FaxNumber t024 telfx Fax number of purchasing (buyer) group
PhoneNumber t024 tel_number Telephone No.: Dialing Code and Number
PhoneNumberExtension t024 tel_extens Telephone no.: Extension
EmailAddress t024 smtp_addr E-Mail Address

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_PurchasingGroup.
-- 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: IMMPURCHGROUP

CREATE VIEW I_PurchasingGroup AS
SELECT
  t024.ekgrp AS PurchasingGroup,
  cast(t024.eknam as mm_a_purg_grp_name preserving type ) AS PurchasingGroupName,
  t024.ektel AS PurchasingGroupPhoneNumber,
  t024.telfx AS FaxNumber,
  t024.tel_number AS PhoneNumber,
  t024.tel_extens AS PhoneNumberExtension,
  t024.smtp_addr AS EmailAddress
FROM t024
;

Learn More