I_IN_BusinessPlace

DDL: I_IN_BUSINESSPLACE SQL: IINBUPLAVH Type: view BASIC

Value help Business Places in India

I_IN_BusinessPlace is a Basic CDS View (Dimension) that provides data about "Value help Business Places in India" in SAP S/4HANA. It reads from 1 data source (j_1bbranch) and exposes 7 fields with key fields CompanyCode, Branch. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
j_1bbranch j_1bbranch from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Branch _Branch _Branch.CompanyCode = j_1bbranch.bukrs and _Branch.Branch = j_1bbranch.branch
[0..1] I_CompanyCode _CompCode _CompCode.CompanyCode = $projection.CompanyCode

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IINBUPLAVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
ObjectModel.representativeKey Branch view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.buffering.status #NOT_ALLOWED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #B view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Search.searchable true view
EndUserText.label Value help Business Places in India view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY Branch branch Repository branch
BranchName _Branch BranchName
AddressID _Branch AddressID Ship-to address
IN_GSTIdentificationNumber gstin Taxpayer GSTIN
_Branch _Branch
_CompCode _CompCode

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_IN_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: IINBUPLAVH

CREATE VIEW I_IN_BusinessPlace AS
SELECT
  bukrs AS CompanyCode,
  Branch,
  _Branch.BranchName AS BranchName,
  _Branch.AddressID AS AddressID,
  gstin AS IN_GSTIdentificationNumber
FROM j_1bbranch
LEFT OUTER JOIN I_Branch AS _Branch ON _Branch.CompanyCode = j_1bbranch.bukrs AND _Branch.Branch = j_1bbranch.branch  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON _CompCode.CompanyCode = CompanyCode  -- association [0..1]
;