C_EmbargoedCountry

DDL: C_EMBARGOEDCOUNTRY SQL: CEMBCNTRY Type: view CONSUMPTION
15 Fields 1 Data Sources

C_EmbargoedCountry is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_EmbargoedCountry) and exposes 15 fields with key fields LegalRegulation, EmbargoedCountry, ValidityStartDate.

Data Sources (1)

SourceAliasJoin Type
I_EmbargoedCountry I_EmbargoedCountry from

Annotations (18)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CEMBCNTRY view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey EmbargoedCountry view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.sizeCategory M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
UI.headerInfo.typeName Country/Region Under Embargo view
UI.headerInfo.typeNamePlural Countries/Regions Under Embargo view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value EmbargoedCountry view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value TEXT: EmbargoedCountry view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY LegalRegulation LegalRegulation Legal Regulation
KEY EmbargoedCountry EmbargoedCountry
KEY ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_LegalRegulation _LegalRegulation
_LegalRegulationText _LegalRegulationText
_Country _Country
_CountryText _CountryText
_Date _Date
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_EmbargoedCountry.
-- 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: CEMBCNTRY

CREATE VIEW C_EmbargoedCountry AS
SELECT
  LegalRegulation,
  EmbargoedCountry,
  ValidityStartDate,
  ValidityEndDate,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_EmbargoedCountry
;

Learn More