C_StrpCompanyCodeQ

DDL: C_STRPCOMPANYCODEQ SQL: CSRCOMPCODEQ Type: view CONSUMPTION
26 Fields 1 Data Sources

Consumption View for CompanyCode Details

C_StrpCompanyCodeQ is a Consumption CDS View that provides data about "Consumption View for CompanyCode Details" in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 26 fields with key field CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode from

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CSRCOMPCODEQ view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Consumption View for CompanyCode Details view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode Receiver Company Code
CompanyCodeName I_CompanyCode CompanyCodeName Company Name
BusinessPartnerName1
BusinessPartnerName2
BusinessPartnerName3
BusinessPartnerName4
HouseNumber
StreetPrefixName
StreetName
CityName
HomeCityName
Region
Country
PostalCode
District
AdditionalStreetPrefixName
StreetSuffixName
Building
Floor
RoomNumber
VATRegistration I_CompanyCode VATRegistration VAT Registration No.
PostalCodeasCompanyCodeAddress
PhoneNumber
CompanyCodeCurrency I_CompanyCode Currency Valuation Crcy
AddressID I_CompanyCode AddressID Ship-to address
_Address _Address

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 C_StrpCompanyCodeQ.
-- 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: CSRCOMPCODEQ

CREATE VIEW C_StrpCompanyCodeQ AS
SELECT
  I_CompanyCode.CompanyCode AS CompanyCode,
  I_CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_CompanyCode._Address.BusinessPartnerName1 AS BusinessPartnerName1,
  I_CompanyCode._Address.BusinessPartnerName2 AS BusinessPartnerName2,
  I_CompanyCode._Address.BusinessPartnerName3 AS BusinessPartnerName3,
  I_CompanyCode._Address.BusinessPartnerName4 AS BusinessPartnerName4,
  I_CompanyCode._Address.HouseNumber AS HouseNumber,
  I_CompanyCode._Address.StreetPrefixName AS StreetPrefixName,
  I_CompanyCode._Address.StreetName AS StreetName,
  I_CompanyCode._Address.CityName AS CityName,
  I_CompanyCode._Address.HomeCityName AS HomeCityName,
  I_CompanyCode._Address.Region AS Region,
  I_CompanyCode._Address.Country AS Country,
  I_CompanyCode._Address.PostalCode AS PostalCode,
  I_CompanyCode._Address.District AS District,
  I_CompanyCode._Address.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  I_CompanyCode._Address.StreetSuffixName AS StreetSuffixName,
  I_CompanyCode._Address.Building AS Building,
  I_CompanyCode._Address.Floor AS Floor,
  I_CompanyCode._Address.RoomNumber AS RoomNumber,
  I_CompanyCode.VATRegistration AS VATRegistration,
  concat(concat(concat(I_CompanyCode._Address.HouseNumber, ', '), concat(I_CompanyCode._Address.StreetName, ', ')), concat(concat(I_CompanyCode._Address.CityName, ', ' ), I_CompanyCode._Address.PostalCode) ) as CompanyCodeAddress AS PostalCodeasCompanyCodeAddress,
  I_CompanyCode._Address.PhoneNumber AS PhoneNumber,
  I_CompanyCode.Currency AS CompanyCodeCurrency,
  I_CompanyCode.AddressID AS AddressID
FROM I_CompanyCode
;

Learn More