C_RU_ExprtCstmsDeclnItemTP

DDL: C_RU_EXPRTCSTMSDECLNITEMTP Type: view_entity CONSUMPTION Package: GLO_FIN_IS_RU_EXPRT_CSTMS_DECL
27 Fields 1 Data Sources 1 OData Services

Export Customs Declaration Item C

C_RU_ExprtCstmsDeclnItemTP is a Consumption CDS View that provides data about "Export Customs Declaration Item C" in SAP S/4HANA. It reads from 1 data source (R_RU_ExprtCstmsDeclnItemTP) and exposes 27 fields with key fields CustomsDeclaration, RU_ExprtCustomsDeclarationItem, CustomsDeclarationSubitem. It is exposed through 1 OData service (UI_RU_EXPRTCSTMSDECLN_MANAGE). Part of development package GLO_FIN_IS_RU_EXPRT_CSTMS_DECL.

Data Sources (1)

SourceAliasJoin Type
R_RU_ExprtCstmsDeclnItemTP R_RU_ExprtCstmsDeclnItemTP projection

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RU_EXPRTCSTMSDECLN_MANAGE UI_RU_EXPRTCSTMSDEC_MANAGE V2 C1 NOT_RELEASED

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY CustomsDeclaration CustomsDeclaration Cus. Decl. No.
KEY RU_ExprtCustomsDeclarationItem RU_ExprtCustomsDeclarationItem CDec Item No.
KEY CustomsDeclarationSubitem CustomsDeclarationSubitem Subitem Number
Material Material Vehicle Model
MaterialNameasMaterialNamelocalized
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
RU_ContractDocument RU_ContractDocument Contract Number
TradingContractItem TradingContractItem Item Number
RU_TemporaryCustomsDeclaration RU_TemporaryCustomsDeclaration Reference CDec
RU_TmpCstmsDeclarationItem RU_TmpCstmsDeclarationItem Ref. CDec Item
CstmsDeclnItemQuantity CstmsDeclnItemQuantity CDec Item Qty
UnitOfMeasure UnitOfMeasure Unit Protected Qty
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
BillingDocument BillingDocument SD Document
BillingDocumentItem BillingDocumentItem Item
BillingQuantity BillingQuantity Invoiced Qty
BillingQuantityUnit BillingQuantityUnit Sales Unit
ExportConfirmationSubitemDate ExportConfirmationSubitemDate Export Confirm. Date
GoodsIssueDate GoodsIssueDate Goods Issue Date CCD
CstmsDeclnSubItemQuantity CstmsDeclnSubItemQuantity Subitem Qty
CstmsDeclnSubItemSalesUnit CstmsDeclnSubItemSalesUnit Sales Unit
TotalConfirmedQuantity TotalConfirmedQuantity Total to Be Confirmed
SalesUnit SalesUnit Unit
OpenQuantity OpenQuantity PBE Entry Open Qty
CompanyCode CompanyCode Receiver Company Code

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_RU_ExprtCstmsDeclnItemTP.
-- 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.

CREATE VIEW C_RU_ExprtCstmsDeclnItemTP AS
SELECT
  CustomsDeclaration,
  RU_ExprtCustomsDeclarationItem,
  CustomsDeclarationSubitem,
  Material,
  _MaterialText.MaterialName as MaterialName : localized AS MaterialNameasMaterialNamelocalized,
  SalesOrder,
  SalesOrderItem,
  RU_ContractDocument,
  TradingContractItem,
  RU_TemporaryCustomsDeclaration,
  RU_TmpCstmsDeclarationItem,
  CstmsDeclnItemQuantity,
  UnitOfMeasure,
  DeliveryDocument,
  DeliveryDocumentItem,
  BillingDocument,
  BillingDocumentItem,
  BillingQuantity,
  BillingQuantityUnit,
  ExportConfirmationSubitemDate,
  GoodsIssueDate,
  CstmsDeclnSubItemQuantity,
  CstmsDeclnSubItemSalesUnit,
  TotalConfirmedQuantity,
  SalesUnit,
  OpenQuantity,
  CompanyCode
FROM R_RU_ExprtCstmsDeclnItemTP
;

Learn More