P_RU_CustomerData

DDL: P_RU_CUSTOMERDATA SQL: PRUCUSTOMERDATA Type: view COMPOSITE
12 Fields 1 Data Sources 1 Associations

P_RU_CustomerData is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_RU_CustomerData1) and exposes 12 fields with key field Customer. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_RU_CustomerData1 CustomerData from

Associations (1)

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

Annotations (7)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Customer P_RU_CustomerData1 Customer Sold-to Party
BusinessPartner P_RU_CustomerData1 BusinessPartner Issuing Authority
IsNaturalPerson P_RU_CustomerData1 IsNaturalPerson Natural person
TaxNumber1
TaxNumber3
BusinessPartnerCategory P_RU_CustomerData1 BusinessPartnerCategory Partner Cat.
PersonNumber P_RU_CustomerData1 PersonNumber Person Number
AddressID P_RU_CustomerData1 AddressID Ship-to address
Country P_RU_CustomerData1 Country Venue: Ctry/Reg
IsOneTimeAccount P_RU_CustomerData1 IsOneTimeAccount One-time acct
AuthorizationGroup P_RU_CustomerData1 AuthorizationGroup AuthorizGroup
_CustomerCompany P_RU_CustomerData1 _CustomerCompany

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_CustomerData.
-- 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: PRUCUSTOMERDATA

CREATE VIEW P_RU_CustomerData AS
SELECT
  CustomerData.Customer AS Customer,
  CustomerData.BusinessPartner AS BusinessPartner,
  CustomerData.IsNaturalPerson AS IsNaturalPerson,
  coalesce( _BPTaxNumber[ BPTaxType = 'RU1' ].BPTaxNumber, '' ) AS TaxNumber1,
  coalesce( _BPTaxNumber[ BPTaxType = 'RU3' ].BPTaxNumber, '' ) AS TaxNumber3,
  CustomerData.BusinessPartnerCategory AS BusinessPartnerCategory,
  CustomerData.PersonNumber AS PersonNumber,
  CustomerData.AddressID AS AddressID,
  CustomerData.Country AS Country,
  CustomerData.IsOneTimeAccount AS IsOneTimeAccount,
  CustomerData.AuthorizationGroup AS AuthorizationGroup,
  CustomerData._CustomerCompany AS _CustomerCompany
FROM P_RU_CustomerData1 AS CustomerData
LEFT OUTER JOIN I_Businesspartnertaxnumber AS _BPTaxNumber ON _BPTaxNumber.BusinessPartner = CustomerData.BusinessPartner  -- association [0..1]
;

Learn More