C_PurchasingGroupValueHelp

DDL: C_PURCHASINGGROUPVALUEHELP SQL: CPURGRP_VH Type: view CONSUMPTION Package: ODATA_MM_COMMONS_VH

Purchasing Group Value Help

C_PurchasingGroupValueHelp is a Consumption CDS View that provides data about "Purchasing Group Value Help" in SAP S/4HANA. It reads from 1 data source (I_PurchasingGroup) and exposes 7 fields with key field PurchasingGroup. It is exposed through 95 OData services (ASQL_F0343, ASQL_F0354, ASQL_F0547B, ...). Part of development package ODATA_MM_COMMONS_VH.

Data Sources (1)

SourceAliasJoin Type
I_PurchasingGroup PurchasingGroup from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPURGRP_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.semanticKey PurchasingGroup view
ObjectModel.representativeKey PurchasingGroup view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label Purchasing Group Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

OData Services (95)

ServiceBindingVersionContractRelease
ASQL_F0343 ASQL_F0343 C2 NOT_RELEASED
ASQL_F0354 ASQL_F0354 C2 NOT_RELEASED
ASQL_F0547B ASQL_F0547B C2 NOT_RELEASED
ASQL_F0574 ASQL_F0574 C2 NOT_RELEASED
ASQL_F0575 ASQL_F0575 C2 NOT_RELEASED
ASQL_F1048A ASQL_F1048A C2 NOT_RELEASED
ASQL_F1378 ASQL_F1378 C2 NOT_RELEASED
ASQL_F1660 ASQL_F1660 C2 NOT_RELEASED
ASQL_F1661 ASQL_F1661 C2 NOT_RELEASED
ASQL_F1663 ASQL_F1663 C2 NOT_RELEASED
ASQL_F1664 ASQL_F1664 C2 NOT_RELEASED
ASQL_F1861 ASQL_F1861 C2 NOT_RELEASED
ASQL_F1990 ASQL_F1990 C2 NOT_RELEASED
ASQL_F2014 ASQL_F2014 C2 NOT_RELEASED
ASQL_F2015 ASQL_F2015 C2 NOT_RELEASED
ASQL_F2016 ASQL_F2016 C2 NOT_RELEASED
ASQL_F2017 ASQL_F2017 C2 NOT_RELEASED
ASQL_F2018 ASQL_F2018 C2 NOT_RELEASED
ASQL_F2101A ASQL_F2101A C2 NOT_RELEASED
ASQL_F2309 ASQL_F2309 C2 NOT_RELEASED
ASQL_F2312 ASQL_F2312 C2 NOT_RELEASED
ASQL_F2358 ASQL_F2358 C2 NOT_RELEASED
ASQL_F2359 ASQL_F2359 C2 NOT_RELEASED
ASQL_F2420 ASQL_F2420 C2 NOT_RELEASED
ASQL_F2421 ASQL_F2421 C2 NOT_RELEASED
ASQL_F2422 ASQL_F2422 C2 NOT_RELEASED
ASQL_F2504 ASQL_F2504 C2 NOT_RELEASED
ASQL_F2593 ASQL_F2593 C2 NOT_RELEASED
ASQL_F2594 ASQL_F2594 C2 NOT_RELEASED
ASQL_F2667 ASQL_F2667 C2 NOT_RELEASED
ASQL_F2668 ASQL_F2668 C2 NOT_RELEASED
ASQL_F2669 ASQL_F2669 C2 NOT_RELEASED
ASQL_F2704 ASQL_F2704 C2 NOT_RELEASED
ASQL_F2705 ASQL_F2705 C2 NOT_RELEASED
ASQL_F2705A ASQL_F2705A C2 NOT_RELEASED
ASQL_F2827 ASQL_F2827 C2 NOT_RELEASED
ASQL_F2872 ASQL_F2872 C2 NOT_RELEASED
ASQL_F2877 ASQL_F2877 C2 NOT_RELEASED
ASQL_F2948 ASQL_F2948 C2 NOT_RELEASED
ASQL_F2988 ASQL_F2988 C2 NOT_RELEASED
ASQL_F3043 ASQL_F3043 C2 NOT_RELEASED
ASQL_F3044 ASQL_F3044 C2 NOT_RELEASED
ASQL_F3065 ASQL_F3065 C2 NOT_RELEASED
ASQL_F3095 ASQL_F3095 C2 NOT_RELEASED
ASQL_F3143 ASQL_F3143 C2 NOT_RELEASED
ASQL_F3173 ASQL_F3173 C2 NOT_RELEASED
ASQL_F3232 ASQL_F3232 C2 NOT_RELEASED
ASQL_F3254 ASQL_F3254 C2 NOT_RELEASED
ASQL_F3293 ASQL_F3293 C2 NOT_RELEASED
ASQL_F3294 ASQL_F3294 C2 NOT_RELEASED
ASQL_F3295 ASQL_F3295 C2 NOT_RELEASED
ASQL_F3316 ASQL_F3316 C2 NOT_RELEASED
ASQL_F3401 ASQL_F3401 C2 NOT_RELEASED
ASQL_F3480 ASQL_F3480 C2 NOT_RELEASED
ASQL_F3492 ASQL_F3492 C2 NOT_RELEASED
ASQL_F3658A ASQL_F3658A C2 NOT_RELEASED
ASQL_F3676 ASQL_F3676 C2 NOT_RELEASED
ASQL_F3680 ASQL_F3680 C2 NOT_RELEASED
ASQL_F3681 ASQL_F3681 C2 NOT_RELEASED
ASQL_F3792 ASQL_F3792 C2 NOT_RELEASED
ASQL_F3794 ASQL_F3794 C2 NOT_RELEASED
ASQL_F3900 ASQL_F3900 C2 NOT_RELEASED
ASQL_F3980 ASQL_F3980 C2 NOT_RELEASED
ASQL_F4021 ASQL_F4021 C2 NOT_RELEASED
ASQL_F4562 ASQL_F4562 C2 NOT_RELEASED
ASQL_F4578 ASQL_F4578 C2 NOT_RELEASED
ASQL_F4630 ASQL_F4630 C2 NOT_RELEASED
ASQL_F4760 ASQL_F4760 C2 NOT_RELEASED
ASQL_F5039 ASQL_F5039 C2 NOT_RELEASED
ASQL_F5241 ASQL_F5241 C2 NOT_RELEASED
ASQL_F5289 ASQL_F5289 C2 NOT_RELEASED
ASQL_F5513 ASQL_F5513 C2 NOT_RELEASED
ASQL_F5514 ASQL_F5514 C2 NOT_RELEASED
ASQL_F5711 ASQL_F5711 C2 NOT_RELEASED
ASQL_F5716 ASQL_F5716 C2 NOT_RELEASED
ASQL_F6096 ASQL_F6096 C2 NOT_RELEASED
ASQL_F6194 ASQL_F6194 C2 NOT_RELEASED
ASQL_F6215 ASQL_F6215 C2 NOT_RELEASED
ASQL_F6635 ASQL_F6635 C2 NOT_RELEASED
ASQL_F6884 ASQL_F6884 C2 NOT_RELEASED
ASQL_F7204A ASQL_F7204A C2 NOT_RELEASED
ASQL_F7276 ASQL_F7276 C2 NOT_RELEASED
ASQL_F7349 ASQL_F7349 C2 NOT_RELEASED
ASQL_F7439 ASQL_F7439 C2 NOT_RELEASED
ASQL_F7441 ASQL_F7441 C2 NOT_RELEASED
ASQL_F7442 ASQL_F7442 C2 NOT_RELEASED
ASQL_F7465 ASQL_F7465 C2 NOT_RELEASED
ASQL_F8685 ASQL_F8685 C2 NOT_RELEASED
ASQL_F8755 ASQL_F8755 C2 NOT_RELEASED
ASQL_F8756 ASQL_F8756 C2 NOT_RELEASED
ASQL_F8757 ASQL_F8757 C2 NOT_RELEASED
ASQL_F8764 ASQL_F8764 C2 NOT_RELEASED
MM_PUR_PROCESS_PR_V4 MM_PUR_PR_PROCESS_V4 V4 C1 NOT_RELEASED
UI_QLTYCMPLAGNSTSUPLRMNG UI_QLTYCMPLAGNSTSUPLRMNG V4 C1 NOT_RELEASED
UI_TRDGCONTR_MANAGEV4 UI_TRDGCONTR_MANAGEV4 V4 C1 NOT_RELEASED

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchasingGroup I_PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName I_PurchasingGroup PurchasingGroupName Purchasing Grp. Name
PurchasingGroupPhoneNumber I_PurchasingGroup PurchasingGroupPhoneNumber Tel. No. of Purchasing Grp.
PhoneNumber I_PurchasingGroup PhoneNumber Tel. No. with Dialing Code
PhoneNumberExtension I_PurchasingGroup PhoneNumberExtension Extension
FaxNumber I_PurchasingGroup FaxNumber Fax
EmailAddress I_PurchasingGroup EmailAddress Email 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 C_PurchasingGroupValueHelp.
-- 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: CPURGRP_VH

CREATE VIEW C_PurchasingGroupValueHelp AS
SELECT
  PurchasingGroup.PurchasingGroup AS PurchasingGroup,
  PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  PurchasingGroup.PurchasingGroupPhoneNumber AS PurchasingGroupPhoneNumber,
  PurchasingGroup.PhoneNumber AS PhoneNumber,
  PurchasingGroup.PhoneNumberExtension AS PhoneNumberExtension,
  PurchasingGroup.FaxNumber AS FaxNumber,
  PurchasingGroup.EmailAddress AS EmailAddress
FROM I_PurchasingGroup AS PurchasingGroup
;