C_SuplrListMaterialGroupTP_2

DDL: C_SUPLRLISTMATERIALGROUPTP_2 Type: view_entity CONSUMPTION
7 Fields 1 Data Sources 2 OData Services 2 Fiori Apps

Material Group for Supplier List

C_SuplrListMaterialGroupTP_2 is a Consumption CDS View that provides data about "Material Group for Supplier List" in SAP S/4HANA. It reads from 1 data source (R_SupplierListMaterialGroupTP) and exposes 7 fields with key field MaterialGroupUUID. It is exposed through 2 OData services (UI_SRCGSUPPLIERLIST_MANAGE, UI_SUPPLIERLIST_MANAGE). It is used in 2 Fiori applications: Manage Preferred Supplier Lists, Manage Suppliers for Sourcing.

Data Sources (1)

SourceAliasJoin Type
R_SupplierListMaterialGroupTP R_SupplierListMaterialGroupTP projection

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material Group for Supplier List view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

OData Services (2)

ServiceBindingVersionContractRelease
UI_SRCGSUPPLIERLIST_MANAGE UI_SRCGSUPPLIERLIST_MANAGE V2 C1 NOT_RELEASED
UI_SUPPLIERLIST_MANAGE UI_SUPPLIERLIST_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F4333 Manage Preferred Supplier Lists Transactional An application to maintain a list of suppliers for one or more material groups and company codes
F4536 Manage Suppliers for Sourcing Transactional An application to maintain the supplier lists of Soucing project

Manage Preferred Supplier Lists

Business Role: Purchaser

Manage Suppliers for Sourcing

Business Role: Purchaser

With this app, you as a central purchaser, can create and manage lists of suppliers that your company advises you to use during the sourcing process. You can manage standard supplier lists that are available for all users, as well as user-specified supplier lists that you create for your own use.For more information, read:https://help.sap.com/viewer/DRAFT/e296651f454c4284ade361292c633d69/2021.000/en-US/1828e1bd367a49ac859bfbc24d5cbd78.html

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MaterialGroupUUID _SupplierListMaterialGroupTP MaterialGroupUUID Material Group UUID
MaterialGroup _SupplierListMaterialGroupTP MaterialGroup Material Group
SupplierListUUID SupplierListUUID Supplier List UUID
IsDeleted IsDeleted TRUE
MaterialGroupName _MaterialGroupText MaterialGroupName prod Grp Desc.
_MaterialGroup _MaterialGroup
_MaterialGroupText _MaterialGroupText

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_SuplrListMaterialGroupTP_2.
-- 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.

CREATE VIEW C_SuplrListMaterialGroupTP_2 AS
SELECT
  _SupplierListMaterialGroupTP.MaterialGroupUUID AS MaterialGroupUUID,
  _SupplierListMaterialGroupTP.MaterialGroup AS MaterialGroup,
  SupplierListUUID,
  IsDeleted,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName
FROM R_SupplierListMaterialGroupTP
;

Learn More