P_KR_I18NBusinessPlace

DDL: P_KR_I18NBUSINESSPLACE SQL: PKRI18NBUPA Type: view COMPOSITE
26 Fields 1 Data Sources

P_KR_I18NBusinessPlace is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_KR_BusinessPlace) and exposes 26 fields with key fields Branch, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
P_KR_BusinessPlace bp_temp from

Annotations (7)

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

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Branch P_KR_BusinessPlace Branch Repository branch
KEY CompanyCode P_KR_BusinessPlace CompanyCode Receiver Company Code
TaxNumber1 P_KR_BusinessPlace TaxNumber1 VAT Reg. No.
TaxNumber2 P_KR_BusinessPlace TaxNumber2 Tax Number 2
CompanyName CompanyName Text
CorporationNumber P_KR_BusinessPlace CorporationNumber Company Code
TaxInvoiceRepresentativeName P_KR_BusinessPlace TaxInvoiceRepresentativeName Rep's Name
IndustryType P_KR_BusinessPlace IndustryType Type of Industry
BusinessType P_KR_BusinessPlace BusinessType Type of Business
DistrictTaxOffice P_KR_BusinessPlace DistrictTaxOffice
BusinessPlaceName P_KR_BusinessPlace BusinessPlaceName
PostalCode P_KR_BusinessPlace PostalCode Postal Code
PhoneNumber P_KR_BusinessPlace PhoneNumber Telephone no.
CityName P_KR_BusinessPlace CityName Name
StreetName P_KR_BusinessPlace StreetName Text
HouseNumber P_KR_BusinessPlace HouseNumber House Number
HouseNumberSupplementText P_KR_BusinessPlace HouseNumberSupplementText Supplement
ResponsibleDepartmentName P_KR_BusinessPlace ResponsibleDepartmentName
ResponsiblePersonName P_KR_BusinessPlace ResponsiblePersonName User
ResponsiblePersonEmailAddress P_KR_BusinessPlace ResponsiblePersonEmailAddress
NatlTaxServiceRegnNumber P_KR_BusinessPlace NatlTaxServiceRegnNumber
TaxInvoiceRepresentativeName1 P_KR_BusinessPlace TaxInvoiceRepresentativeName1
IndustryTypeList P_KR_BusinessPlace IndustryTypeList
BusinessTypeList P_KR_BusinessPlace BusinessTypeList
MobilePhoneNumber P_KR_BusinessPlace MobilePhoneNumber Telephone
KR_TaxBusinessCode P_KR_BusinessPlace KR_TaxBusinessCode

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_KR_I18NBusinessPlace.
-- 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: PKRI18NBUPA

CREATE VIEW P_KR_I18NBusinessPlace AS
SELECT
  bp_temp.Branch AS Branch,
  bp_temp.CompanyCode AS CompanyCode,
  bp_temp.TaxNumber1 AS TaxNumber1,
  bp_temp.TaxNumber2 AS TaxNumber2,
  CompanyName,
  bp_temp.CorporationNumber AS CorporationNumber,
  bp_temp.TaxInvoiceRepresentativeName AS TaxInvoiceRepresentativeName,
  bp_temp.IndustryType AS IndustryType,
  bp_temp.BusinessType AS BusinessType,
  bp_temp.DistrictTaxOffice AS DistrictTaxOffice,
  bp_temp.BusinessPlaceName AS BusinessPlaceName,
  bp_temp.PostalCode AS PostalCode,
  bp_temp.PhoneNumber AS PhoneNumber,
  bp_temp.CityName AS CityName,
  bp_temp.StreetName AS StreetName,
  bp_temp.HouseNumber AS HouseNumber,
  bp_temp.HouseNumberSupplementText AS HouseNumberSupplementText,
  bp_temp.ResponsibleDepartmentName AS ResponsibleDepartmentName,
  bp_temp.ResponsiblePersonName AS ResponsiblePersonName,
  bp_temp.ResponsiblePersonEmailAddress AS ResponsiblePersonEmailAddress,
  bp_temp.NatlTaxServiceRegnNumber AS NatlTaxServiceRegnNumber,
  bp_temp.TaxInvoiceRepresentativeName1 AS TaxInvoiceRepresentativeName1,
  bp_temp.IndustryTypeList AS IndustryTypeList,
  bp_temp.BusinessTypeList AS BusinessTypeList,
  bp_temp.MobilePhoneNumber AS MobilePhoneNumber,
  bp_temp.KR_TaxBusinessCode AS KR_TaxBusinessCode
FROM P_KR_BusinessPlace AS bp_temp
;

Learn More