P_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_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.

CREATE VIEW P_BusinessPlace AS
SELECT
  BP.bukrs AS bukrs,
  BP.branch AS branch,
  BP.adrnr AS adrnr,
  BP.validfrom AS validfrom,
  BP.validto AS validto,
  BP.stcd1 AS stcd1,
  BP.stcd2 AS stcd2,
  BP.stcd5 AS stcd5,
  '' AS vkbur,
  BP.kr_repres AS kr_repres,
  BP.kr_bustype AS kr_bustype,
  BP.kr_indtype AS kr_indtype,
  BP.kr_taxoff AS kr_taxoff,
  BP.person_name AS person_name,
  BP.represn AS represn,
  BP.indtypn AS indtypn,
  BP.gestyp AS gestyp,
  BP.ntsnumber AS ntsnumber,
  BP.cgc_branch AS cgc_branch,
  BP.state_insc AS state_insc,
  BP.munic_insc AS munic_insc,
  BP.industry AS industry,
  BP.single AS single,
  BP.nfdec AS nfdec,
  BP.suframa AS suframa,
  BP.nire AS nire,
  BP.niredt AS niredt,
  BP.spedactind AS spedactind,
  BP.cnae AS cnae,
  BP.legalnat AS legalnat,
  BP.crtn AS crtn,
  BP.icmstaxpay AS icmstaxpay,
  BP.indtyp AS indtyp,
  BP.tdt AS tdt,
  BP.comsize AS comsize,
  BP.decregpc AS decregpc,
  BP.prefix AS prefix,
  BP.pac01 AS pac01,
  BP.vdp01 AS vdp01,
  BP.pac02 AS pac02,
  BP.vdp02 AS vdp02,
  BP.cnbp_enabled AS cnbp_enabled,
  BP.tax_reg_nmbr AS tax_reg_nmbr,
  cast( BP.valid_from as glo_bupla_validfrom_cn preserving type ) AS valid_from,
  cast( BP.valid_to as glo_bupla_validto_cn preserving type ) AS valid_to,
  cast( BP.branch_long as glo_bupla_bupla_th ) AS branch_long,
  BP.gstin AS gstin,
  BP.bupla_class AS bupla_class,
  BP.idsign AS idsign,
  BP.buscode AS buscode,
  BP.gstcd AS gstcd
FROM j_1bbranch AS BP
LEFT OUTER JOIN j_1bbrancht AS _text ON bukrs = _text.bukrs AND branch = _text.branch AND _text.language = $session.system_language AND _text.bupla_type = ''  -- association [0..1]
LEFT OUTER JOIN P_BusinessPlaceSalesOffice AS _SalesOfficeMap ON branch = _SalesOfficeMap.bupla  -- association [0..*]
;