P_RU_SupplierCompanyData

DDL: P_RU_SUPPLIERCOMPANYDATA SQL: PRUSUPPLCOMPDATA Type: view CONSUMPTION Package: GLO_FIN_IS_RU
23 Fields 2 Data Sources

RU Supplier Company data

P_RU_SupplierCompanyData is a Consumption CDS View that provides data about "RU Supplier Company data" in SAP S/4HANA. It reads from 2 data sources (I_SupplierCompany, P_RU_SupplierData1) and exposes 23 fields with key fields Supplier, CompanyCode. Part of development package GLO_FIN_IS_RU.

Data Sources (2)

SourceAliasJoin Type
I_SupplierCompany SupplierCompany inner
P_RU_SupplierData1 SupplierData from

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUSUPPLCOMPDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY Supplier P_RU_SupplierData1 Supplier Supplier
KEY CompanyCode I_SupplierCompany CompanyCode Receiver Company Code
BusinessPartner P_RU_SupplierData1 BusinessPartner Issuing Authority
SupplierName
BusinessPartnerCategory P_RU_SupplierData1 BusinessPartnerCategory Partner Cat.
PersonNumber P_RU_SupplierData1 PersonNumber Person Number
AddressID P_RU_SupplierData1 AddressID Ship-to address
SupplierFinsAuthorizationGrp P_RU_SupplierData1 AuthorizationGroup AuthorizGroup
SupplierAccountGroup P_RU_SupplierData1 SupplierAccountGroup Account group
SupplierIsBusPrpsCmpltd P_RU_SupplierData1 IsBusinessPurposeCompleted Purpose Completed
DataControllerSet P_RU_SupplierData1 DataControllerSet Data Ctrlr. Set
DataController1 P_RU_SupplierData1 DataController1 Data Controller
DataController2 P_RU_SupplierData1 DataController2 Data Controller
DataController3 P_RU_SupplierData1 DataController3 Data Controller
DataController4 P_RU_SupplierData1 DataController4 Data Controller
DataController5 P_RU_SupplierData1 DataController5 Data Controller
DataController6 P_RU_SupplierData1 DataController6 Data Controller
DataController7 P_RU_SupplierData1 DataController7 Data Controller
DataController8 P_RU_SupplierData1 DataController8 Data Controller
DataController9 P_RU_SupplierData1 DataController9 Data Controller
DataController10 P_RU_SupplierData1 DataController10 Data Controller
SupplierCompanyAuthznGroup I_SupplierCompany AuthorizationGroup AuthorizGroup
SuplrCoIsBusPrpsCmpltd I_SupplierCompany IsBusinessPurposeCompleted Purpose Completed

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_SupplierCompanyData.
-- 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: PRUSUPPLCOMPDATA

CREATE VIEW P_RU_SupplierCompanyData AS
SELECT
  SupplierData.Supplier AS Supplier,
  SupplierCompany.CompanyCode AS CompanyCode,
  SupplierData.BusinessPartner AS BusinessPartner,
  coalesce( coalesce( PersCyrillicAddress.PersonName, OrgCyrillicAddress.OrganizationName ), SupplierData.BPSupplierName ) AS SupplierName,
  SupplierData.BusinessPartnerCategory AS BusinessPartnerCategory,
  SupplierData.PersonNumber AS PersonNumber,
  SupplierData.AddressID AS AddressID,
  SupplierData.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  SupplierData.SupplierAccountGroup AS SupplierAccountGroup,
  SupplierData.IsBusinessPurposeCompleted AS SupplierIsBusPrpsCmpltd,
  SupplierData.DataControllerSet AS DataControllerSet,
  SupplierData.DataController1 AS DataController1,
  SupplierData.DataController2 AS DataController2,
  SupplierData.DataController3 AS DataController3,
  SupplierData.DataController4 AS DataController4,
  SupplierData.DataController5 AS DataController5,
  SupplierData.DataController6 AS DataController6,
  SupplierData.DataController7 AS DataController7,
  SupplierData.DataController8 AS DataController8,
  SupplierData.DataController9 AS DataController9,
  SupplierData.DataController10 AS DataController10,
  SupplierCompany.AuthorizationGroup AS SupplierCompanyAuthznGroup,
  SupplierCompany.IsBusinessPurposeCompleted AS SuplrCoIsBusPrpsCmpltd
FROM P_RU_SupplierData1 AS SupplierData
INNER JOIN I_SupplierCompany AS SupplierCompany ON /* join condition not captured in parsed metadata */
;

Learn More