I_BusinessPlace

DDL: I_BUSINESSPLACE SQL: IBUSINESSPLACE Type: view BASIC
12 Fields 1 Data Sources 4 Associations

Business Place Information

I_BusinessPlace (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Business Place · Country or Region-Specific Functions for Finance

I_BusinessPlace is a Basic CDS View that provides data about "Business Place Information" in SAP S/4HANA. It reads from 1 data source (P_BusinessPlace) and exposes 12 fields with key fields CompanyCode, BusinessPlace. It has 4 associations to related views.

SAP Help Documentation

CategoryGeneral Functions
Purpose
This CDS view provides master data information about business places (branches or locations) within a company code, including their addresses, tax numbers, validity periods, and descriptions. It serves as a basic interface view for accessing business place configuration data. This CDS view provides the data to answer the following business questions: What business places (branches) are configured for each company code? What is the address information for a specific business place? What are the tax identification numbers (TaxNumber1, TaxNumber2, TaxNumber5) assigned to each business place? What is the validity period (start and end dates) for each business place? What is the description or name of a specific business place? Which business places are currently active based on their validity dates? How many business places does a company code operate? What is the complete master data profile for a given business place including its address details? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: BUKRS_BUPLA (Company Code/Business Place) The restriction type is edited in the Maintain Business Roles app. You can use the Display Restriction Types app to find out in which business catalogs the restriction type is included.

Structure
Important Fields Important fields in this view include the following: Field Name Description CompanyCode Company Code BusinessPlace Business Place AddressID Address BusinessPlaceStartDate Business Place Valid From BusinessPlaceEndDate Business Place Valid To TaxNumber1 Tax Number 1 TaxNumber2 Tax Number 2 TaxNumber5 Tax Number 5 BusinessPlaceDescription Name

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCountry or Region-Specific Functions for Finance
Application ComponentFI-LOC-BUP
CapabilitiesData Structure, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Hierarchies in Analytics, Data Source for Data Extraction
PackageCountry or Region-Specific Functions for Finance for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
P_BusinessPlace P_BusinessPlace from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_BusinessPlaceText _Text $projection.CompanyCode = _Text.CompanyCode and $projection.BusinessPlace = _Text.BusinessPlace
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_Address_2 _Address $projection.AddressID = _Address.AddressID and _Address.AddressPersonID = '' and _Address.AddressRepresentationCode = ''
[1..1] E_BusinessPlace _Extension $projection.CompanyCode = _Extension.CompanyCode and $projection.BusinessPlace = _Extension.BusinessPlace

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBUSINESSPLACE view
EndUserText.label Business Place Information view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey BusinessPlace view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #DATA_STRUCTURE view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name BusinessPlace view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Company Code
KEY BusinessPlace branch Repository branch
AddressID adrnr Sold-To Address
BusinessPlaceStartDate validfrom Business Place Valid From
BusinessPlaceEndDate validto Business Place Valid To
TaxNumber1 stcd1 Tax Number 1
TaxNumber2 stcd2 Tax Number 2
TaxNumber5 stcd5 Tax Number 5
BusinessPlaceDescription name Zone name
_Text _Text
_CompanyCode _CompanyCode
_Address _Address

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 I_BusinessPlace.
-- 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: IBUSINESSPLACE

CREATE VIEW I_BusinessPlace AS
SELECT
  bukrs AS CompanyCode,
  branch AS BusinessPlace,
  adrnr AS AddressID,
  validfrom AS BusinessPlaceStartDate,
  validto AS BusinessPlaceEndDate,
  stcd1 AS TaxNumber1,
  stcd2 AS TaxNumber2,
  stcd5 AS TaxNumber5,
  name AS BusinessPlaceDescription
FROM P_BusinessPlace
LEFT OUTER JOIN I_BusinessPlaceText AS _Text ON CompanyCode = _Text.CompanyCode AND BusinessPlace = _Text.BusinessPlace  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Address_2 AS _Address ON AddressID = _Address.AddressID AND _Address.AddressPersonID = '' AND _Address.AddressRepresentationCode = ''  -- association [0..1]
LEFT OUTER JOIN E_BusinessPlace AS _Extension ON CompanyCode = _Extension.CompanyCode AND BusinessPlace = _Extension.BusinessPlace  -- association [1..1]
;

Learn More