R_RU_ExprtCstmsDeclnItemDraft

DDL: R_RU_EXPRTCSTMSDECLNITEMDRAFT SQL: RRUCCDIDR Type: view BASIC
33 Fields 1 Data Sources

Export Customs Declaration Item Draft

R_RU_ExprtCstmsDeclnItemDraft is a Basic CDS View that provides data about "Export Customs Declaration Item Draft" in SAP S/4HANA. It reads from 1 data source (j_3rs_exp_itm_d) and exposes 33 fields with key fields CustomsDeclaration, RU_ExprtCustomsDeclarationItem, CustomsDeclarationSubitem.

Data Sources (1)

SourceAliasJoin Type
j_3rs_exp_itm_d j_3rs_exp_itm_d from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName RRUCCDIDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Export Customs Declaration Item Draft view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view

Fields (33)

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
RU_ContractDocument ru_contractdocument Contract Number
TradingContractItem tradingcontractitem Item Number
RU_TemporaryCustomsDeclaration ru_temporarycustomsdeclaration Reference CDec
RU_TmpCstmsDeclarationItem ru_tmpcstmsdeclarationitem Ref. CDec Item
SalesOrder salesorder SD Document
SalesOrderItem salesorderitem Sales Order 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
CstmsDeclnHasFollowUpDocument cstmsdeclnhasfollowupdocument Follow-Up
CompanyCode companycode Receiver Company Code
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_RU_ExprtCstmsDeclnItemDraft.
-- 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: RRUCCDIDR

CREATE VIEW R_RU_ExprtCstmsDeclnItemDraft AS
SELECT
  CustomsDeclaration,
  RU_ExprtCustomsDeclarationItem,
  CustomsDeclarationSubitem,
  Material,
  RU_ContractDocument,
  TradingContractItem,
  RU_TemporaryCustomsDeclaration,
  RU_TmpCstmsDeclarationItem,
  SalesOrder,
  SalesOrderItem,
  CstmsDeclnItemQuantity,
  UnitOfMeasure,
  DeliveryDocument,
  DeliveryDocumentItem,
  BillingDocument,
  BillingDocumentItem,
  BillingQuantity,
  BillingQuantityUnit,
  ExportConfirmationSubitemDate,
  GoodsIssueDate,
  CstmsDeclnSubItemQuantity,
  CstmsDeclnSubItemSalesUnit,
  TotalConfirmedQuantity,
  SalesUnit,
  OpenQuantity,
  CstmsDeclnHasFollowUpDocument,
  CompanyCode,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM j_3rs_exp_itm_d
;

Learn More