What is I_ProcmtHubSupplier in SAP S/4HANA?

I_ProcmtHubSupplier is a basic CDS view in SAP S/4HANA. Basic view for backend supplier It contains 12 fields.

Which tables does I_ProcmtHubSupplier read from?

I_ProcmtHubSupplier reads data from: mmpur_ext_lfa1.

What VDM layer is I_ProcmtHubSupplier?

I_ProcmtHubSupplier is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_ProcmtHubSupplier

DDL: I_PROCMTHUBSUPPLIER SQL: IHUBSUPLR Type: view BASIC Package: APPL_PROC_HUB_GF

12 Fields 1 Data Sources 2 Associations

Basic view for backend supplier

I_ProcmtHubSupplier is a Basic CDS View that provides data about "Basic view for backend supplier" in SAP S/4HANA. It reads from 1 data source (mmpur_ext_lfa1) and exposes 12 fields with key fields ProcurementHubSourceSystem, ProcmtHubFixedSupplier. It has 2 associations to related views. Part of development package APPL_PROC_HUB_GF.

Data Sources (1)

Source	Alias	Join Type
mmpur_ext_lfa1	mmpur_ext_lfa1	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	I_ProcmtHubSuplrByCompanyCode	_SupplierCompany	`$projection.ProcmtHubFixedSupplier = _SupplierCompany.ProcmtHubFixedSupplier and _SupplierCompany.ProcurementHubSourceSystem = $projection.ProcurementHubSourceSystem`
[0..*]	I_ProcmtHubSupplierPurgOrg	_SupplierPurchasingOrg	`$projection.ProcmtHubFixedSupplier = _SupplierPurchasingOrg.ProcmtHubFixedSupplier and _SupplierPurchasingOrg.ProcurementHubSourceSystem = $projection.ProcurementHubSourceSystem`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	IHUBSUPLR	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Basic view for backend supplier	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view

Fields (12)

Key	Field	Source Field	Description
KEY	ProcurementHubSourceSystem	extsourcesystem	Connected System ID
KEY	ProcmtHubFixedSupplier	supplier	Supplier
	ProcmtHubSupplierName	suppliername	Supplier Name
	CityName	cityname	Name
	PostalCode	postalcode	Postal Code
	Country	country	Venue: Ctry/Reg
	SupplierAccountGroup	supplieraccountgroup	Account group
	AuthorizationGroup	authorizationgroup	AuthorizGroup
	Region	region	Venue Region
	StreetName	streetname	Text
	_SupplierCompany	_SupplierCompany
	_SupplierPurchasingOrg	_SupplierPurchasingOrg

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_ProcmtHubSupplier.
-- 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: IHUBSUPLR

CREATE VIEW I_ProcmtHubSupplier AS
SELECT
  extsourcesystem AS ProcurementHubSourceSystem,
  supplier AS ProcmtHubFixedSupplier,
  suppliername AS ProcmtHubSupplierName,
  CityName,
  PostalCode,
  Country,
  SupplierAccountGroup,
  AuthorizationGroup,
  Region,
  StreetName
FROM mmpur_ext_lfa1
LEFT OUTER JOIN I_ProcmtHubSuplrByCompanyCode AS _SupplierCompany ON ProcmtHubFixedSupplier = _SupplierCompany.ProcmtHubFixedSupplier AND _SupplierCompany.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..*]
LEFT OUTER JOIN I_ProcmtHubSupplierPurgOrg AS _SupplierPurchasingOrg ON ProcmtHubFixedSupplier = _SupplierPurchasingOrg.ProcmtHubFixedSupplier AND _SupplierPurchasingOrg.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..*]
;

Depth:

I_ProcmtHubSupplier view

mmpur_ext_lfa1