P_RU_CompanyCodeData_Lang

DDL: P_RU_COMPANYCODEDATA_LANG SQL: PRUCOMPANYDATAL Type: view COMPOSITE Package: GLO_FIN_IS_RU
10 Fields 6 Data Sources

Company Code Data in Logon Language

P_RU_CompanyCodeData_Lang is a Composite CDS View that provides data about "Company Code Data in Logon Language" in SAP S/4HANA. It reads from 6 data sources and exposes 10 fields with key field CompanyCode. Part of development package GLO_FIN_IS_RU.

Data Sources (6)

SourceAliasJoin Type
I_AddlCompanyCodeInformation AddlInfoOKFS left_outer
I_AddlCompanyCodeInformation AddlInfoOKOPF left_outer
I_AddlCompanyCodeInformation AddlInfoOKPO left_outer
I_AddlCompanyCodeInformation AddlInfoOKVED left_outer
I_OrganizationAddress Address left_outer
P_RU_CompanyCodeData1_Lang P_RU_CompanyCodeData1_Lang from

Parameters (1)

NameTypeDefault
P_PeriodEndDate datum

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRUCOMPANYDATAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
VDM.private true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_RU_CompanyCodeData1_Lang CompanyCode Receiver Company Code
AddressID P_RU_CompanyCodeData1_Lang AddressID Ship-to address
CompanyCodeName P_RU_CompanyCodeData1_Lang CompanyCodeName Company Name
RU_CompanyCodeINN P_RU_CompanyCodeData1_Lang RU_CompanyCodeINN
RU_CompanyCodeKPP P_RU_CompanyCodeData1_Lang RU_CompanyCodeKPP
RU_CompanyCodeOKVED I_AddlCompanyCodeInformation CompanyCodeParameterValue Company Code
RU_CompanyCodeOKPO I_AddlCompanyCodeInformation CompanyCodeParameterValue Company Code
RU_CompanyCodeOKFS I_AddlCompanyCodeInformation CompanyCodeParameterValue Company Code
RU_CompanyCodeOKOPF I_AddlCompanyCodeInformation CompanyCodeParameterValue Company Code
Region I_OrganizationAddress Region Venue Region

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_RU_CompanyCodeData_Lang.
-- 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: PRUCOMPANYDATAL
-- Parameters: P_PeriodEndDate : datum

CREATE VIEW P_RU_CompanyCodeData_Lang AS
SELECT
  P_RU_CompanyCodeData1_Lang.CompanyCode AS CompanyCode,
  P_RU_CompanyCodeData1_Lang.AddressID AS AddressID,
  P_RU_CompanyCodeData1_Lang.CompanyCodeName AS CompanyCodeName,
  P_RU_CompanyCodeData1_Lang.RU_CompanyCodeINN AS RU_CompanyCodeINN,
  P_RU_CompanyCodeData1_Lang.RU_CompanyCodeKPP AS RU_CompanyCodeKPP,
  AddlInfoOKVED.CompanyCodeParameterValue AS RU_CompanyCodeOKVED,
  AddlInfoOKPO.CompanyCodeParameterValue AS RU_CompanyCodeOKPO,
  AddlInfoOKFS.CompanyCodeParameterValue AS RU_CompanyCodeOKFS,
  AddlInfoOKOPF.CompanyCodeParameterValue AS RU_CompanyCodeOKOPF,
  Address.Region AS Region
FROM P_RU_CompanyCodeData1_Lang
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoOKVED ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoOKPO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoOKFS ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS AddlInfoOKOPF ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrganizationAddress AS Address ON /* join condition not captured in parsed metadata */
;

Learn More