I_RU_ImportCstmsDeclnNumberVH

DDL: I_RU_IMPORTCSTMSDECLNNUMBERVH SQL: IRUIMCDNUMVH Type: view COMPOSITE
10 Fields 1 Data Sources

Ru_CustomsDeclaration Value Help

I_RU_ImportCstmsDeclnNumberVH is a Composite CDS View that provides data about "Ru_CustomsDeclaration Value Help" in SAP S/4HANA. It reads from 1 data source (I_RU_ImprtCstmsDeclnHdr) and exposes 10 fields with key field RU_CustomsDeclaration.

Data Sources (1)

SourceAliasJoin Type
I_RU_ImprtCstmsDeclnHdr I_RU_ImprtCstmsDeclnHdr from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IRUIMCDNUMVH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey RU_CustomsDeclaration view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Ru_CustomsDeclaration Value Help view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY RU_CustomsDeclaration RU_CustomsDeclaration
ImportCustomsDecln ImportCustomsDecln
CompanyCode CompanyCode Receiver Company Code
RU_EntryCustomsOffice RU_EntryCustomsOffice
CustomsDeclarationDate CustomsDeclarationDate
Supplier Supplier Supplier
RU_CustomsDeclarationOrigin RU_CustomsDeclarationOrigin
RU_CustomsDeclarationType RU_CustomsDeclarationType
SupplierAuthznGrp SupplierAuthznGrp Authorization
SupplierCompanyAuthznGroup SupplierCompanyAuthznGroup AuthorizGroup

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 I_RU_ImportCstmsDeclnNumberVH.
-- 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: IRUIMCDNUMVH

CREATE VIEW I_RU_ImportCstmsDeclnNumberVH AS
SELECT
  RU_CustomsDeclaration,
  ImportCustomsDecln,
  CompanyCode,
  RU_EntryCustomsOffice,
  CustomsDeclarationDate,
  Supplier,
  RU_CustomsDeclarationOrigin,
  RU_CustomsDeclarationType,
  SupplierAuthznGrp,
  SupplierCompanyAuthznGroup
FROM I_RU_ImprtCstmsDeclnHdr
;

Learn More