C_NotInCoCodeCntryCustomer

DDL: C_NOTINCOCODECNTRYCUSTOMER SQL: CGRCCUSCNTRY Type: view CONSUMPTION Package: FINS_FIS_GRC_APPS

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. Part of development package FINS_FIS_GRC_APPS.

1 data source(s) 26 fields

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
KEY CompanyCode CompanyCode
CustomerName _Customer CustomerName
CompanyCodeName _CompanyCode CompanyCodeName
CustomerCountry
CompanyCodeCountry
PostingIsBlocked _Customer PostingIsBlocked
CustomerAccountGroup _Customer CustomerAccountGroup
CreatedByUser _Customer CreatedByUser
CreationDate _Customer CreationDate
IsOneTimeAccount _Customer IsOneTimeAccount
VATRegistration _Customer VATRegistration
Supplier _Customer Supplier
AddressID _Customer AddressID
Region _Customer Region
OrganizationBPName1 _Customer OrganizationBPName1
OrganizationBPName2 _Customer OrganizationBPName2
CityName _Customer CityName
PostalCode _Customer PostalCode
StreetName _Customer StreetName
DeletionIndicator _Customer DeletionIndicator
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
_Customer _Customer
_CompanyCode _CompanyCode
_Country _CompanyCode _Country 
@AbapCatalog.sqlViewName: 'CGRCCUSCNTRY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@OData.publish: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'Customer not registered in CountryRegion'
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view C_NotInCoCodeCntryCustomer
  as select from I_CustomerCompany


{

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_Customer_VH',
                     element: 'Customer' }
        }]
      @ObjectModel.foreignKey.association: '_Customer'
  key Customer,

      @Consumption.valueHelpDefinition: [
      { entity:  { name:    'I_CompanyCodeStdVH',
                   element: 'CompanyCode' }
      }]

      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
      _Customer.CustomerName,
      _CompanyCode.CompanyCodeName,
      
//      @EndUserText.label: 'Customer CountryRegion'

      cast(_Customer.Country as fis_customer_country preserving type )   as CustomerCountry,
      
//      @EndUserText.label: 'Company Code CountryRegion'

      cast(_CompanyCode.Country as fis_company_code_country preserving type ) as CompanyCodeCountry,
      _Customer.PostingIsBlocked,
      _Customer.CustomerAccountGroup,
      _Customer.CreatedByUser,
      _Customer.CreationDate,
      _Customer.IsOneTimeAccount,
      _Customer.VATRegistration,
      _Customer.Supplier,
      _Customer.AddressID,
      _Customer.Region,
      _Customer.OrganizationBPName1,
      _Customer.OrganizationBPName2,
      _Customer.CityName,
      _Customer.PostalCode,
      _Customer.StreetName,
      _Customer.DeletionIndicator,
      AuthorizationGroup,
      IsBusinessPurposeCompleted,

      _Customer,
      _CompanyCode,
      _CompanyCode._Country

}

where
  _Customer.Country <> _CompanyCode.Country

Learn More