E_CUSCO_D

DDL: E_CUSCO_D SQL: ECUSCOC Type: view EXTENSION
3 Fields 1 Data Sources

Extensibility Customer Company Code Core

E_CUSCO_D is a Extension CDS View that provides data about "Extensibility Customer Company Code Core" in SAP S/4HANA. It reads from 1 data source (knb1) and exposes 3 fields with key fields Customer, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
knb1 Persistence from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ECUSCOC view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #EXTENSION view
EndUserText.label Extensibility Customer Company Code Core view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Customer knb1 kunnr Stock customer
KEY CompanyCode knb1 bukrs Value
IsActiveEntity

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 E_CUSCO_D.
-- 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: ECUSCOC

CREATE VIEW E_CUSCO_D AS
SELECT
  Persistence.kunnr AS Customer,
  Persistence.bukrs AS CompanyCode,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity
FROM knb1 AS Persistence
;

Learn More