C_NoCompanyCodeSupplier

DDL: C_NOCOMPANYCODESUPPLIER SQL: CGRCNOCOCODESUP Type: view CONSUMPTION Package: FINS_FIS_GRC_APPS
24 Fields 1 Data Sources

No Company Code Assignment Supplier

C_NoCompanyCodeSupplier is a Consumption CDS View that provides data about "No Company Code Assignment Supplier" in SAP S/4HANA. It reads from 1 data source (I_Supplier) and exposes 24 fields with key field Supplier. Part of development package FINS_FIS_GRC_APPS.

Data Sources (1)

SourceAliasJoin Type
I_Supplier _Supplier from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CGRCNOCOCODESUP view
EndUserText.label No Company Code Assignment Supplier view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Supplier I_Supplier Supplier Supplier
SupplierName I_Supplier SupplierName Supplier Name
SupplierAccountGroup I_Supplier SupplierAccountGroup Account group
CreatedByUser I_Supplier CreatedByUser User Name
CreationDate I_Supplier CreationDate Time Stamp
IsOneTimeAccount I_Supplier IsOneTimeAccount One-time acct
AccountIsBlockedForPosting I_Supplier AccountIsBlockedForPosting Posting Block
IsBusinessPurposeCompleted I_Supplier IsBusinessPurposeCompleted Purpose Completed
CityName I_Supplier CityName Name
Country I_Supplier Country Venue: Ctry/Reg
DeletionIndicator I_Supplier DeletionIndicator Deletion Ind.
CompanyCode _SupplierCompany CompanyCode Receiver Company Code
AuthorizationGroup I_Supplier AuthorizationGroup AuthorizGroup
DataControllerSet I_Supplier DataControllerSet Data Ctrlr. Set
DataController1 I_Supplier DataController1 Data Controller
DataController2 I_Supplier DataController2 Data Controller
DataController3 I_Supplier DataController3 Data Controller
DataController4 I_Supplier DataController4 Data Controller
DataController5 I_Supplier DataController5 Data Controller
DataController6 I_Supplier DataController6 Data Controller
DataController7 I_Supplier DataController7 Data Controller
DataController8 I_Supplier DataController8 Data Controller
DataController9 I_Supplier DataController9 Data Controller
DataController10 I_Supplier DataController10 Data Controller

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_NoCompanyCodeSupplier.
-- 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: CGRCNOCOCODESUP

CREATE VIEW C_NoCompanyCodeSupplier AS
SELECT
  _Supplier.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.CreatedByUser AS CreatedByUser,
  _Supplier.CreationDate AS CreationDate,
  _Supplier.IsOneTimeAccount AS IsOneTimeAccount,
  _Supplier.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  _Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Supplier.CityName AS CityName,
  _Supplier.Country AS Country,
  _Supplier.DeletionIndicator AS DeletionIndicator,
  _SupplierCompany.CompanyCode AS CompanyCode,
  _Supplier.AuthorizationGroup AS AuthorizationGroup,
  _Supplier.DataControllerSet AS DataControllerSet,
  _Supplier.DataController1 AS DataController1,
  _Supplier.DataController2 AS DataController2,
  _Supplier.DataController3 AS DataController3,
  _Supplier.DataController4 AS DataController4,
  _Supplier.DataController5 AS DataController5,
  _Supplier.DataController6 AS DataController6,
  _Supplier.DataController7 AS DataController7,
  _Supplier.DataController8 AS DataController8,
  _Supplier.DataController9 AS DataController9,
  _Supplier.DataController10 AS DataController10
FROM I_Supplier AS _Supplier
;

Learn More