P_RO_SAFTCACTGPARTNER_ROX

DDL: P_RO_SAFTCACTGPARTNER_ROX Type: view_entity CONSUMPTION
16 Fields 1 Data Sources 2 Associations

P_RO_SAFTCACTGPARTNER_ROX is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 16 fields with key field BusinessPartner. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner BP from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_RO_SAFTCActgStdPartAddrTxNr _BPStdAddrTax $projection.BusinessPartner = _BPStdAddrTax.BusinessPartner
[0..1] P_RO_SAFTCActgStdPartAddr _BPStdAddr $projection.BusinessPartner = _BPStdAddr.BusinessPartner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerCategory I_BusinessPartner BusinessPartnerCategory Partner Cat.
BPTaxType _BPStdAddrTax BPTaxType Category
CountryISOCode _BPStdAddrTax CountryISOCode
IsEuropeanUnionMember _BPStdAddrTax IsEuropeanUnionMember
BPTaxNumber _BPStdAddrTax BPTaxNumber Tax Number
BPTaxLongNumber _BPStdAddrTax BPTaxLongNumber Tax Number Long
VATRegistration _BPStdAddrTax VATRegistration VAT Registration No.
AddressID _BPStdAddr AddressID Ship-to address
CompanyName _BPStdAddr CompanyName Text
StreetName _BPStdAddr StreetName Text
HouseNumber _BPStdAddr HouseNumber House Number
CityName _BPStdAddr CityName Name
PostalCode _BPStdAddr PostalCode Postal Code
Region _BPStdAddr Region Venue Region
Country _BPStdAddr Country Venue: Ctry/Reg

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_RO_SAFTCACTGPARTNER_ROX.
-- 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.

CREATE VIEW P_RO_SAFTCACTGPARTNER_ROX AS
SELECT
  BP.BusinessPartner AS BusinessPartner,
  BP.BusinessPartnerCategory AS BusinessPartnerCategory,
  _BPStdAddrTax.BPTaxType AS BPTaxType,
  _BPStdAddrTax.CountryISOCode AS CountryISOCode,
  _BPStdAddrTax.IsEuropeanUnionMember AS IsEuropeanUnionMember,
  _BPStdAddrTax.BPTaxNumber AS BPTaxNumber,
  _BPStdAddrTax.BPTaxLongNumber AS BPTaxLongNumber,
  _BPStdAddrTax.VATRegistration AS VATRegistration,
  _BPStdAddr.AddressID AS AddressID,
  _BPStdAddr.CompanyName AS CompanyName,
  _BPStdAddr.StreetName AS StreetName,
  _BPStdAddr.HouseNumber AS HouseNumber,
  _BPStdAddr.CityName AS CityName,
  _BPStdAddr.PostalCode AS PostalCode,
  _BPStdAddr.Region AS Region,
  _BPStdAddr.Country AS Country
FROM I_BusinessPartner AS BP
LEFT OUTER JOIN P_RO_SAFTCActgStdPartAddrTxNr AS _BPStdAddrTax ON BusinessPartner = _BPStdAddrTax.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN P_RO_SAFTCActgStdPartAddr AS _BPStdAddr ON BusinessPartner = _BPStdAddr.BusinessPartner  -- association [0..1]
;

Learn More