P_TH_BUSINESSPLACE_ADDR2J

DDL: P_TH_BUSINESSPLACE_ADDR2J SQL: PTHBPDETAIL2J Type: view CONSUMPTION
30 Fields 1 Data Sources

P_TH_BUSINESSPLACE_ADDR2J is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_TH_BUSINESSPLACE_ADDR2P) and exposes 30 fields with key fields AddressID, CompanyCode, Branch.

Data Sources (1)

SourceAliasJoin Type
P_TH_BUSINESSPLACE_ADDR2P P_TH_BUSINESSPLACE_ADDR2P from

Parameters (1)

NameTypeDefault
P_Language ad_nation

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PTHBPDETAIL2J view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_Address AddressID Ship-to address
KEY CompanyCode I_Address CompanyCode Receiver Company Code
KEY Branch I_Address Branch Repository branch
BusinessPlaceName I_Address BusinessPlaceName
BranchLongCode I_Address BranchLongCode
VATRegistration I_Address VATRegistration VAT Registration No.
AddressRepresentationCode I_Address AddressRepresentationCode Address Version
AddressObjectType I_Address AddressObjectType Address Type
OrganizationName1 I_Address OrganizationName1 Name
OrganizationName2 I_Address OrganizationName2 Name 2
OrganizationName3 I_Address OrganizationName3 Name 3
OrganizationName4 I_Address OrganizationName4 Name 4
TaxPayerName I_Address TaxPayerName
District I_Address District District Court
HomeCityName I_Address HomeCityName Different City
PostalCode I_Address PostalCode Postal Code
Street I_Address Street Street Code
StreetName I_Address StreetName Text
StreetPrefixName I_Address StreetPrefixName Street 2
AdditionalStreetPrefixName I_Address AdditionalStreetPrefixName Street 3
StreetSuffixName I_Address StreetSuffixName Street 4
HouseNumber I_Address HouseNumber House Number
Building I_Address Building Building code
Floor I_Address Floor Floor
RoomNumber I_Address RoomNumber Room Number
Country I_Address Country Venue: Ctry/Reg
Region I_Address Region Venue Region
CityName I_Address CityName Name
AddressCreatedByUser I_Address AddressCreatedByUser Created By
PhoneNumber I_Address PhoneNumber Telephone no.

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_TH_BUSINESSPLACE_ADDR2J.
-- 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: PTHBPDETAIL2J
-- Parameters: P_Language : ad_nation

CREATE VIEW P_TH_BUSINESSPLACE_ADDR2J AS
SELECT
  I_Address.AddressID AS AddressID,
  I_Address.CompanyCode AS CompanyCode,
  I_Address.Branch AS Branch,
  I_Address.BusinessPlaceName AS BusinessPlaceName,
  I_Address.BranchLongCode AS BranchLongCode,
  I_Address.VATRegistration AS VATRegistration,
  I_Address.AddressRepresentationCode AS AddressRepresentationCode,
  I_Address.AddressObjectType AS AddressObjectType,
  I_Address.OrganizationName1 AS OrganizationName1,
  I_Address.OrganizationName2 AS OrganizationName2,
  I_Address.OrganizationName3 AS OrganizationName3,
  I_Address.OrganizationName4 AS OrganizationName4,
  I_Address.TaxPayerName AS TaxPayerName,
  I_Address.District AS District,
  I_Address.HomeCityName AS HomeCityName,
  I_Address.PostalCode AS PostalCode,
  I_Address.Street AS Street,
  I_Address.StreetName AS StreetName,
  I_Address.StreetPrefixName AS StreetPrefixName,
  I_Address.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  I_Address.StreetSuffixName AS StreetSuffixName,
  I_Address.HouseNumber AS HouseNumber,
  I_Address.Building AS Building,
  I_Address.Floor AS Floor,
  I_Address.RoomNumber AS RoomNumber,
  I_Address.Country AS Country,
  I_Address.Region AS Region,
  I_Address.CityName AS CityName,
  I_Address.AddressCreatedByUser AS AddressCreatedByUser,
  I_Address.PhoneNumber AS PhoneNumber
FROM P_TH_BUSINESSPLACE_ADDR2P
;

Learn More