I_RU_CustomsDeclarationItem

DDL: I_RU_CUSTOMSDECLARATIONITEM SQL: IRUCCDITEM Type: view BASIC Package: GLO_FIN_IS_VAT_RU_EXP_CONF_REG
12 Fields 1 Data Sources

CCD Item

I_RU_CustomsDeclarationItem is a Basic CDS View that provides data about "CCD Item" in SAP S/4HANA. It reads from 1 data source (j_3rsccditem) and exposes 12 fields with key fields CustomsDeclaration, CustomsDeclarationItem. Part of development package GLO_FIN_IS_VAT_RU_EXP_CONF_REG.

Data Sources (1)

SourceAliasJoin Type
j_3rsccditem j_3rsccditem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRUCCDITEM view
VDM.viewType #BASIC view
EndUserText.label CCD Item view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CustomsDeclaration ccd Cus. Decl. No.
KEY CustomsDeclarationItem item Task ID
CommodityCode stawn Commodity Code
Material matnr Vehicle Model
SalesOrder ord_bln Order Number
SalesOrderItem ord_psnr Order Item
RU_ContractDocument cntr_bln Contract Number
TradingContractItem cntr_psnr Contract Item
RU_TemporaryCustomsDeclaration src_ccd Reference CDec
RU_TmpCstmsDeclarationItem src_item Ref. CDec Item
UnitOfMeasure vrkme UoM for SubItm CCD
Quantity lsmeng Subitem Qty

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_CustomsDeclarationItem.
-- 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: IRUCCDITEM

CREATE VIEW I_RU_CustomsDeclarationItem AS
SELECT
  ccd AS CustomsDeclaration,
  item AS CustomsDeclarationItem,
  stawn AS CommodityCode,
  matnr AS Material,
  ord_bln AS SalesOrder,
  ord_psnr AS SalesOrderItem,
  cntr_bln AS RU_ContractDocument,
  cntr_psnr AS TradingContractItem,
  src_ccd AS RU_TemporaryCustomsDeclaration,
  src_item AS RU_TmpCstmsDeclarationItem,
  vrkme AS UnitOfMeasure,
  lsmeng AS Quantity
FROM j_3rsccditem
;

Learn More