P_KZ_COMPANYCODEDATA

DDL: P_KZ_COMPANYCODEDATA SQL: PKZCOMPCODEDATA Type: view COMPOSITE
11 Fields 6 Data Sources

P_KZ_COMPANYCODEDATA is a Composite CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 11 fields.

Data Sources (6)

SourceAliasJoin Type
I_AddlCompanyCodeInformation AddlInfoBIN left_outer
I_AddlCompanyCodeInformation AddlInfoCEOName left_outer
I_AddlCompanyCodeInformation AddlInfoChiefAccountant left_outer
I_AddlCompanyCodeInformation AddlInfoIIN left_outer
I_AddlCompanyCodeInformation AddlInfoVATCert left_outer
I_CompanyCode I_CompanyCode from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PKZCOMPCODEDATA view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view

Fields (11)

KeyFieldSource TableSource FieldDescription
CompanyCode I_CompanyCode CompanyCode Receiver Company Code
Name1
Name2
Name3
BusinessPartnerName4111asFullName
IIN I_AddlCompanyCodeInformation CompanyCodeParameterValue Company Code
BIN I_AddlCompanyCodeInformation CompanyCodeParameterValue Company Code
CEOName I_AddlCompanyCodeInformation CompanyCodeParameterValue Company Code
ChiefAccountant I_AddlCompanyCodeInformation CompanyCodeParameterValue Company Code
VATCertSeries
VATCertNum

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_KZ_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: PKZCOMPCODEDATA

CREATE VIEW P_KZ_COMPANYCODEDATA AS
SELECT
  I_CompanyCode.CompanyCode AS CompanyCode,
  Substring( CONCAT_WITH_SPACE( I_CompanyCode._Address.BusinessPartnerName1, CONCAT_WITH_SPACE( I_CompanyCode._Address.BusinessPartnerName2, I_CompanyCode._Address.BusinessPartnerName3, 1 ), 1 ), 1, 27 ) AS Name1,
  Substring( CONCAT_WITH_SPACE( I_CompanyCode._Address.BusinessPartnerName1, CONCAT_WITH_SPACE( I_CompanyCode._Address.BusinessPartnerName2, I_CompanyCode._Address.BusinessPartnerName3, 1 ), 1 ), 28, 35 ) AS Name2,
  Substring( CONCAT_WITH_SPACE( I_CompanyCode._Address.BusinessPartnerName1, CONCAT_WITH_SPACE( I_CompanyCode._Address.BusinessPartnerName2, I_CompanyCode._Address.BusinessPartnerName3, 1 ), 1 ), 63, 35 ) AS Name3,
  CONCAT_WITH_SPACE(I_CompanyCode._Address.BusinessPartnerName1, CONCAT_WITH_SPACE(I_CompanyCode._Address.BusinessPartnerName2, CONCAT_WITH_SPACE (I_CompanyCode._Address.BusinessPartnerName3, I_CompanyCode._Address.BusinessPartnerName4, 1), 1), 1 ) as FullName AS BusinessPartnerName4111asFullName,
  AddlInfoIIN.CompanyCodeParameterValue AS IIN,
  AddlInfoBIN.CompanyCodeParameterValue AS BIN,
  AddlInfoCEOName.CompanyCodeParameterValue AS CEOName,
  AddlInfoChiefAccountant.CompanyCodeParameterValue AS ChiefAccountant,
  Substring( AddlInfoVATCert.CompanyCodeParameterValue, 1, 5) AS VATCertSeries,
  Substring( AddlInfoVATCert.CompanyCodeParameterValue, 6, 7) AS VATCertNum
FROM I_CompanyCode
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoBIN ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoIIN ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoCEOName ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoChiefAccountant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoVATCert ON /* join condition not captured in parsed metadata */
;

Learn More