P_RU_SupplierData

DDL: P_RU_SUPPLIERDATA SQL: PRUSUPPLDATA Type: view COMPOSITE Package: GLO_FIN_IS_RU
25 Fields 1 Data Sources 1 Associations

RU Supplier Data

P_RU_SupplierData is a Composite CDS View that provides data about "RU Supplier Data" in SAP S/4HANA. It reads from 1 data source (P_RU_SupplierData1) and exposes 25 fields with key field Supplier. It has 1 association to related views. Part of development package GLO_FIN_IS_RU.

Data Sources (1)

SourceAliasJoin Type
P_RU_SupplierData1 SupplierData from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Businesspartnertaxnumber _BPTaxNumber _BPTaxNumber.BusinessPartner = SupplierData.BusinessPartner

Annotations (7)

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

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY Supplier P_RU_SupplierData1 Supplier Supplier
BusinessPartner P_RU_SupplierData1 BusinessPartner Issuing Authority
IsNaturalPerson P_RU_SupplierData1 IsNaturalPerson Natural person
TaxNumber1
TaxNumber3
BusinessPartnerCategory P_RU_SupplierData1 BusinessPartnerCategory Partner Cat.
PersonNumber P_RU_SupplierData1 PersonNumber Person Number
AddressID P_RU_SupplierData1 AddressID Ship-to address
Country P_RU_SupplierData1 Country Venue: Ctry/Reg
IsOneTimeAccount P_RU_SupplierData1 IsOneTimeAccount One-time acct
AuthorizationGroup P_RU_SupplierData1 AuthorizationGroup AuthorizGroup
SupplierAccountGroup P_RU_SupplierData1 SupplierAccountGroup Account group
IsBusinessPurposeCompleted P_RU_SupplierData1 IsBusinessPurposeCompleted Purpose Completed
_SupplierCompany P_RU_SupplierData1 _SupplierCompany
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

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_SupplierData.
-- 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: PRUSUPPLDATA

CREATE VIEW P_RU_SupplierData AS
SELECT
  SupplierData.Supplier AS Supplier,
  SupplierData.BusinessPartner AS BusinessPartner,
  SupplierData.IsNaturalPerson AS IsNaturalPerson,
  coalesce( _BPTaxNumber[ BPTaxType = 'RU1' ].BPTaxNumber, '' ) AS TaxNumber1,
  coalesce( _BPTaxNumber[ BPTaxType = 'RU3' ].BPTaxNumber, '' ) AS TaxNumber3,
  SupplierData.BusinessPartnerCategory AS BusinessPartnerCategory,
  SupplierData.PersonNumber AS PersonNumber,
  SupplierData.AddressID AS AddressID,
  SupplierData.Country AS Country,
  SupplierData.IsOneTimeAccount AS IsOneTimeAccount,
  SupplierData.AuthorizationGroup AS AuthorizationGroup,
  SupplierData.SupplierAccountGroup AS SupplierAccountGroup,
  SupplierData.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  SupplierData._SupplierCompany AS _SupplierCompany,
  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
FROM P_RU_SupplierData1 AS SupplierData
LEFT OUTER JOIN I_Businesspartnertaxnumber AS _BPTaxNumber ON _BPTaxNumber.BusinessPartner = SupplierData.BusinessPartner  -- association [0..1]
;

Learn More