What is P_Ru_CompanySupplierData in SAP S/4HANA?

P_Ru_CompanySupplierData is a composite CDS view in SAP S/4HANA. Supplier data for company It contains 30 fields.

Which tables does P_Ru_CompanySupplierData read from?

P_Ru_CompanySupplierData reads data from: I_RU_SupplierData.

What VDM layer is P_Ru_CompanySupplierData?

P_Ru_CompanySupplierData is classified as a Composite view that combines data from multiple basic views.

P_Ru_CompanySupplierData

DDL: P_RU_COMPANYSUPPLIERDATA SQL: PRUCOMPSUPPLDATA Type: view COMPOSITE Package: GLO_FIN_IS_RU

30 Fields 1 Data Sources

Supplier data for company

P_Ru_CompanySupplierData is a Composite CDS View that provides data about "Supplier data for company" in SAP S/4HANA. It reads from 1 data source (I_RU_SupplierData) and exposes 30 fields with key field Supplier. Part of development package GLO_FIN_IS_RU.

Data Sources (1)

Source	Alias	Join Type
I_RU_SupplierData	I_RU_SupplierData	from

Annotations (5)

Name	Value	Level
AbapCatalog.sqlViewName	PRUCOMPSUPPLDATA	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view

Fields (30)

Key	Field	Source Table	Source Field	Description
KEY	Supplier	I_RU_SupplierData	Supplier	Supplier
	BusinessPartner	I_RU_SupplierData	BusinessPartner	Issuing Authority
	BPIsOrganization	I_RU_SupplierData	BPIsOrganization
	PersonNumber	I_RU_SupplierData	PersonNumber	Person Number
	AddressID	I_RU_SupplierData	AddressID	Ship-to address
	RU_PartnerOrganizationINN	I_RU_SupplierData	RU_PartnerOrganizationINN	BP INN
	RU_PartnerOrganizationKPP	I_RU_SupplierData	RU_PartnerOrganizationKPP	BP KPP
	SupplierName	I_RU_SupplierData	SupplierName	Supplier Name
	RU_PartnerPersonINN	I_RU_SupplierData	RU_PartnerPersonINN	BP Pers. INN
	FirstName	I_RU_SupplierData	FirstName	First Name
	LastName	I_RU_SupplierData	LastName	Last Name
	MiddleName	I_RU_SupplierData	MiddleName	Middle Name
	IsOneTimeAccount	I_RU_SupplierData	IsOneTimeAccount	One-time acct
	SupplierFinsAuthorizationGrp	I_RU_SupplierData	AuthorizationGroup	AuthorizGroup
	SupplierAccountGroup	I_RU_SupplierData	SupplierAccountGroup	Account group
	SupplierIsBusPrpsCmpltd	I_RU_SupplierData	IsBusinessPurposeCompleted	Purpose Completed
	CompanyCode	_SupplierCompany	CompanyCode	Receiver Company Code
	SupplierCompanyAuthznGroup	_SupplierCompany	AuthorizationGroup	AuthorizGroup
	SuplrCoIsBusPrpsCmpltd	_SupplierCompany	IsBusinessPurposeCompleted	Purpose Completed
	DataControllerSet	I_RU_SupplierData	DataControllerSet	Data Ctrlr. Set
	DataController1	I_RU_SupplierData	DataController1	Data Controller
	DataController2	I_RU_SupplierData	DataController2	Data Controller
	DataController3	I_RU_SupplierData	DataController3	Data Controller
	DataController4	I_RU_SupplierData	DataController4	Data Controller
	DataController5	I_RU_SupplierData	DataController5	Data Controller
	DataController6	I_RU_SupplierData	DataController6	Data Controller
	DataController7	I_RU_SupplierData	DataController7	Data Controller
	DataController8	I_RU_SupplierData	DataController8	Data Controller
	DataController9	I_RU_SupplierData	DataController9	Data Controller
	DataController10	I_RU_SupplierData	DataController10	Data Controller

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 P_Ru_CompanySupplierData.
-- 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: PRUCOMPSUPPLDATA

CREATE VIEW P_Ru_CompanySupplierData AS
SELECT
  I_RU_SupplierData.Supplier AS Supplier,
  I_RU_SupplierData.BusinessPartner AS BusinessPartner,
  I_RU_SupplierData.BPIsOrganization AS BPIsOrganization,
  I_RU_SupplierData.PersonNumber AS PersonNumber,
  I_RU_SupplierData.AddressID AS AddressID,
  I_RU_SupplierData.RU_PartnerOrganizationINN AS RU_PartnerOrganizationINN,
  I_RU_SupplierData.RU_PartnerOrganizationKPP AS RU_PartnerOrganizationKPP,
  I_RU_SupplierData.SupplierName AS SupplierName,
  I_RU_SupplierData.RU_PartnerPersonINN AS RU_PartnerPersonINN,
  I_RU_SupplierData.FirstName AS FirstName,
  I_RU_SupplierData.LastName AS LastName,
  I_RU_SupplierData.MiddleName AS MiddleName,
  I_RU_SupplierData.IsOneTimeAccount AS IsOneTimeAccount,
  I_RU_SupplierData.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  I_RU_SupplierData.SupplierAccountGroup AS SupplierAccountGroup,
  I_RU_SupplierData.IsBusinessPurposeCompleted AS SupplierIsBusPrpsCmpltd,
  _SupplierCompany.CompanyCode AS CompanyCode,
  _SupplierCompany.AuthorizationGroup AS SupplierCompanyAuthznGroup,
  _SupplierCompany.IsBusinessPurposeCompleted AS SuplrCoIsBusPrpsCmpltd,
  I_RU_SupplierData.DataControllerSet AS DataControllerSet,
  I_RU_SupplierData.DataController1 AS DataController1,
  I_RU_SupplierData.DataController2 AS DataController2,
  I_RU_SupplierData.DataController3 AS DataController3,
  I_RU_SupplierData.DataController4 AS DataController4,
  I_RU_SupplierData.DataController5 AS DataController5,
  I_RU_SupplierData.DataController6 AS DataController6,
  I_RU_SupplierData.DataController7 AS DataController7,
  I_RU_SupplierData.DataController8 AS DataController8,
  I_RU_SupplierData.DataController9 AS DataController9,
  I_RU_SupplierData.DataController10 AS DataController10
FROM I_RU_SupplierData
;

Depth:

P_Ru_CompanySupplierData view

I_RU_SupplierData view