C_NotInCoCodeCntrySupplier

DDL: C_NOTINCOCODECNTRYSUPPLIER SQL: CGRCSUPCNTRY Type: view CONSUMPTION Package: FINS_FIS_GRC_APPS

Supplier not registered in CountryRegion

C_NotInCoCodeCntrySupplier is a Consumption CDS View that provides data about "Supplier not registered in CountryRegion" in SAP S/4HANA. It reads from 1 data source (I_SupplierCompany) and exposes 26 fields with key fields Supplier, CompanyCode. Part of development package FINS_FIS_GRC_APPS.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_SupplierCompany I_SupplierCompany from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CGRCSUPCNTRY 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 Supplier not registered in CountryRegion view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier
KEY CompanyCode CompanyCode
SupplierName _Supplier SupplierName
CompanyCodeName CompanyCodeName
SupplierCountry
CompanyCodeCountry
PostingIsBlocked _Supplier PostingIsBlocked
SupplierAccountGroup _Supplier SupplierAccountGroup
CreatedByUser _Supplier CreatedByUser
CreationDate _Supplier CreationDate
IsOneTimeAccount _Supplier IsOneTimeAccount
VATRegistration _Supplier VATRegistration
Customer _Supplier Customer
AddressID _Supplier AddressID
Region _Supplier Region
OrganizationBPName1 _Supplier OrganizationBPName1
OrganizationBPName2 _Supplier OrganizationBPName2
CityName _Supplier CityName
PostalCode _Supplier PostalCode
StreetName _Supplier StreetName
DeletionIndicator _Supplier DeletionIndicator
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
_Supplier _Supplier
_CompanyCode _CompanyCode
_Country _CompanyCode _Country 
@AbapCatalog.sqlViewName: 'CGRCSUPCNTRY'
@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: 'Supplier not registered in CountryRegion'
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view C_NotInCoCodeCntrySupplier
  as select from I_SupplierCompany


{


      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_Supplier_VH',
                     element: 'Supplier' }
        }]

      @ObjectModel.foreignKey.association: '_Supplier'
  key Supplier,

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
      _Supplier.SupplierName,

      @Consumption.hidden: true
      CompanyCodeName,
      
//      @EndUserText.label: 'Supplier CountryRegion'

      cast(_Supplier.Country as fis_supplier_country preserving type )   as SupplierCountry,
      
//      @EndUserText.label: 'Company Code CountryRegion'

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

      _Supplier,
      _CompanyCode,
      _CompanyCode._Country

}

where
  _Supplier.Country <> _CompanyCode.Country

Learn More