P_TH_BusinessPlace

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.
-- 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: PTHBUSINESSPLACE

CREATE VIEW P_TH_BusinessPlace AS
SELECT
  I_Branch.CompanyCode AS CompanyCode,
  I_Branch.Branch AS Branch,
  case when P_PlantAbroadDetails.TaxNumber <> '' then P_PlantAbroadDetails.TaxNumber else I_CompanyCode.VATRegistration end as VATRegistration AS VATRegistrationendasVATRegistration,
  I_Branch.BranchName AS BusinessPlaceName,
  case when I_Branch.AddressID <> '' then I_Branch.AddressID else case when P_PlantAbroadDetails.AddressID <> '' then P_PlantAbroadDetails.AddressID else I_CompanyCode.AddressID end end as AddressID AS AddressIDendendasAddressID
FROM I_Branch
;