What is P_Ru_CompanyCustomerData in SAP S/4HANA?

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

Which tables does P_Ru_CompanyCustomerData read from?

P_Ru_CompanyCustomerData reads data from: I_RU_CustomerData.

What VDM layer is P_Ru_CompanyCustomerData?

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

P_Ru_CompanyCustomerData

DDL: P_RU_COMPANYCUSTOMERDATA SQL: PRUCOMPCUSTDATA Type: view COMPOSITE Package: GLO_FIN_IS_RU

30 Fields 1 Data Sources

Customer data for company

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

Data Sources (1)

Source	Alias	Join Type
I_RU_CustomerData	I_RU_CustomerData	from

Annotations (5)

Name	Value	Level
AbapCatalog.sqlViewName	PRUCOMPCUSTDATA	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	Customer	I_RU_CustomerData	Customer	Sold-to Party
	BusinessPartner	I_RU_CustomerData	BusinessPartner	Issuing Authority
	BPIsOrganization	I_RU_CustomerData	BPIsOrganization
	PersonNumber	I_RU_CustomerData	PersonNumber	Person Number
	AddressID	I_RU_CustomerData	AddressID	Ship-to address
	RU_PartnerOrganizationINN	I_RU_CustomerData	RU_PartnerOrganizationINN	BP INN
	RU_PartnerOrganizationKPP	I_RU_CustomerData	RU_PartnerOrganizationKPP	BP KPP
	CustomerName	I_RU_CustomerData	CustomerName	Name of Customer
	RU_PartnerPersonINN	I_RU_CustomerData	RU_PartnerPersonINN	BP Pers. INN
	FirstName	I_RU_CustomerData	FirstName	First Name
	LastName	I_RU_CustomerData	LastName	Last Name
	MiddleName	I_RU_CustomerData	MiddleName	Middle Name
	IsOneTimeAccount	I_RU_CustomerData	IsOneTimeAccount	One-time acct
	CustomerFinsAuthorizationGrp	I_RU_CustomerData	AuthorizationGroup	AuthorizGroup
	CustomerAccountGroup	I_RU_CustomerData	CustomerAccountGroup	Account group
	CustomerIsBusPrpsCmpltd	I_RU_CustomerData	IsBusinessPurposeCompleted	Purpose Completed
	CompanyCode	_CustomerCompany	CompanyCode	Receiver Company Code
	CustomerCompanyAuthznGroup	_CustomerCompany	AuthorizationGroup	AuthorizGroup
	CustCoIsBusPrpsCmpltd	_CustomerCompany	IsBusinessPurposeCompleted	Purpose Completed
	DataControllerSet	I_RU_CustomerData	DataControllerSet	Data Ctrlr. Set
	DataController1	I_RU_CustomerData	DataController1	Data Controller
	DataController2	I_RU_CustomerData	DataController2	Data Controller
	DataController3	I_RU_CustomerData	DataController3	Data Controller
	DataController4	I_RU_CustomerData	DataController4	Data Controller
	DataController5	I_RU_CustomerData	DataController5	Data Controller
	DataController6	I_RU_CustomerData	DataController6	Data Controller
	DataController7	I_RU_CustomerData	DataController7	Data Controller
	DataController8	I_RU_CustomerData	DataController8	Data Controller
	DataController9	I_RU_CustomerData	DataController9	Data Controller
	DataController10	I_RU_CustomerData	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_CompanyCustomerData.
-- 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: PRUCOMPCUSTDATA

CREATE VIEW P_Ru_CompanyCustomerData AS
SELECT
  I_RU_CustomerData.Customer AS Customer,
  I_RU_CustomerData.BusinessPartner AS BusinessPartner,
  I_RU_CustomerData.BPIsOrganization AS BPIsOrganization,
  I_RU_CustomerData.PersonNumber AS PersonNumber,
  I_RU_CustomerData.AddressID AS AddressID,
  I_RU_CustomerData.RU_PartnerOrganizationINN AS RU_PartnerOrganizationINN,
  I_RU_CustomerData.RU_PartnerOrganizationKPP AS RU_PartnerOrganizationKPP,
  I_RU_CustomerData.CustomerName AS CustomerName,
  I_RU_CustomerData.RU_PartnerPersonINN AS RU_PartnerPersonINN,
  I_RU_CustomerData.FirstName AS FirstName,
  I_RU_CustomerData.LastName AS LastName,
  I_RU_CustomerData.MiddleName AS MiddleName,
  I_RU_CustomerData.IsOneTimeAccount AS IsOneTimeAccount,
  I_RU_CustomerData.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  I_RU_CustomerData.CustomerAccountGroup AS CustomerAccountGroup,
  I_RU_CustomerData.IsBusinessPurposeCompleted AS CustomerIsBusPrpsCmpltd,
  _CustomerCompany.CompanyCode AS CompanyCode,
  _CustomerCompany.AuthorizationGroup AS CustomerCompanyAuthznGroup,
  _CustomerCompany.IsBusinessPurposeCompleted AS CustCoIsBusPrpsCmpltd,
  I_RU_CustomerData.DataControllerSet AS DataControllerSet,
  I_RU_CustomerData.DataController1 AS DataController1,
  I_RU_CustomerData.DataController2 AS DataController2,
  I_RU_CustomerData.DataController3 AS DataController3,
  I_RU_CustomerData.DataController4 AS DataController4,
  I_RU_CustomerData.DataController5 AS DataController5,
  I_RU_CustomerData.DataController6 AS DataController6,
  I_RU_CustomerData.DataController7 AS DataController7,
  I_RU_CustomerData.DataController8 AS DataController8,
  I_RU_CustomerData.DataController9 AS DataController9,
  I_RU_CustomerData.DataController10 AS DataController10
FROM I_RU_CustomerData
;

Depth:

P_Ru_CompanyCustomerData view

I_RU_CustomerData view