P_UA_CompanyCodeData

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_UA_CompanyCodeData.
-- 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: PUACOMPANYDATA

CREATE VIEW P_UA_CompanyCodeData AS
SELECT
  I_CompanyCode.CompanyCode AS CompanyCode,
  I_CompanyCode.AddressID AS AddressID,
  CompanyCodeName.OrganizationName AS CompanyName,
  AddlInfoTIN.CompanyCodeParameterValue AS CompanyCodeTIN,
  AddlInfoSPATO.CompanyCodeParameterValue AS CompanyCodeSPATO,
  I_CompanyCode._Address.CareOfName AS CompanyCodeTERR,
  I_CompanyCode._Address.PhoneNumber AS CompanyCodePhoneNum,
  AddlInfoKVED.CompanyCodeParameterValue AS CompanyCodeKVED,
  AddlInfoRUK.CompanyCodeParameterValue AS CompanyCodeRUK,
  AddlInfoBUH.CompanyCodeParameterValue AS CompanyCodeBUH,
  AddlInfoOPFCD.CompanyCodeParameterValue AS CompanyCodeOPFCD,
  AddlInfoUSR.CompanyCodeParameterValue AS CompanyCodeUSR,
  AddlInfoKATOT.CompanyCodeParameterValue AS CompanyCodeKATOTTG,
  substring( AddlInfoSPATO.CompanyCodeParameterValue, 1, 2 ) AS CompanyOBL,
  substring( AddlInfoSPATO.CompanyCodeParameterValue, 3, 3 ) AS CompanyDistCode,
  CONCAT_WITH_SPACE( I_CompanyCode._Address.CityName, CONCAT_WITH_SPACE( I_CompanyCode._Address.StreetName, I_CompanyCode._Address.HouseNumber, 1 ), 1 ) as FirmAdress AS HouseNumber11asFirmAdress
FROM I_CompanyCode
LEFT OUTER JOIN P_UA_OrganizationName AS CompanyCodeName ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoTIN ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoSPATO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoKVED ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoRUK ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoBUH ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoOPFCD ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoUSR ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoKATOT ON /* join condition not captured in parsed metadata */
;