C_NotInCoCodeCntryCustomer

DDL: C_NOTINCOCODECNTRYCUSTOMER SQL: CGRCCUSCNTRY Type: view CONSUMPTION
26 Fields 1 Data Sources

Customer not registered in CountryRegion

C_NotInCoCodeCntryCustomer is a Consumption CDS View that provides data about "Customer not registered in CountryRegion" in SAP S/4HANA. It reads from 1 data source (I_CustomerCompany) and exposes 26 fields with key fields Customer, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_CustomerCompany I_CustomerCompany from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CGRCCUSCNTRY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Customer not registered in CountryRegion view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer Sold-to Party
KEY CompanyCode CompanyCode Receiver Company Code
CustomerName _Customer CustomerName Name of Customer
CompanyCodeName _CompanyCode CompanyCodeName Company Name
CustomerCountry
CompanyCodeCountry
PostingIsBlocked _Customer PostingIsBlocked Posting Block
CustomerAccountGroup _Customer CustomerAccountGroup Account group
CreatedByUser _Customer CreatedByUser User Name
CreationDate _Customer CreationDate Time Stamp
IsOneTimeAccount _Customer IsOneTimeAccount One-time acct
VATRegistration _Customer VATRegistration VAT Registration No.
Supplier _Customer Supplier Supplier
AddressID _Customer AddressID Ship-to address
Region _Customer Region Venue Region
OrganizationBPName1 _Customer OrganizationBPName1 Name 1
OrganizationBPName2 _Customer OrganizationBPName2 Name 2
CityName _Customer CityName Name
PostalCode _Customer PostalCode Postal Code
StreetName _Customer StreetName Text
DeletionIndicator _Customer DeletionIndicator Deletion Ind.
AuthorizationGroup AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
_Customer _Customer
_CompanyCode _CompanyCode
_Country _CompanyCode _Country

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_NotInCoCodeCntryCustomer.
-- 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: CGRCCUSCNTRY

CREATE VIEW C_NotInCoCodeCntryCustomer AS
SELECT
  Customer,
  CompanyCode,
  _Customer.CustomerName AS CustomerName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast(_Customer.Country as fis_customer_country preserving type ) AS CustomerCountry,
  cast(_CompanyCode.Country as fis_company_code_country preserving type ) AS CompanyCodeCountry,
  _Customer.PostingIsBlocked AS PostingIsBlocked,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _Customer.CreatedByUser AS CreatedByUser,
  _Customer.CreationDate AS CreationDate,
  _Customer.IsOneTimeAccount AS IsOneTimeAccount,
  _Customer.VATRegistration AS VATRegistration,
  _Customer.Supplier AS Supplier,
  _Customer.AddressID AS AddressID,
  _Customer.Region AS Region,
  _Customer.OrganizationBPName1 AS OrganizationBPName1,
  _Customer.OrganizationBPName2 AS OrganizationBPName2,
  _Customer.CityName AS CityName,
  _Customer.PostalCode AS PostalCode,
  _Customer.StreetName AS StreetName,
  _Customer.DeletionIndicator AS DeletionIndicator,
  AuthorizationGroup,
  IsBusinessPurposeCompleted,
  _CompanyCode._Country AS _Country
FROM I_CustomerCompany
;

Learn More