P_RU_ExprtCstmsDeclnSubDrftAct

DDL: P_RU_EXPRTCSTMSDECLNSUBDRFTACT SQL: PRUCCDIDSUB Type: view COMPOSITE
15 Fields 2 Data Sources

P_RU_ExprtCstmsDeclnSubDrftAct is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_RU_CustomsDeclarationSubitem, R_RU_ExprtCstmsDeclnItemDraft) and exposes 15 fields with key fields CustomsDeclaration, RU_ExprtCustomsDeclarationItem, CustomsDeclarationSubitem, RU_ExprtCustomsDeclarationItem, CustomsDeclarationSubitem.

Data Sources (2)

SourceAliasJoin Type
I_RU_CustomsDeclarationSubitem Active from
R_RU_ExprtCstmsDeclnItemDraft Draft union

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRUCCDIDSUB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CustomsDeclaration I_RU_CustomsDeclarationSubitem CustomsDeclaration Cus. Decl. No.
KEY RU_ExprtCustomsDeclarationItem I_RU_CustomsDeclarationSubitem CustomsDeclarationItem CDec Item No.
KEY CustomsDeclarationSubitem I_RU_CustomsDeclarationSubitem CustomsDeclarationSubitem Subitem Number
BillingDocument I_RU_CustomsDeclarationSubitem BillingDocument SD Document
BillingDocumentItem I_RU_CustomsDeclarationSubitem BillingDocumentItem Item
CstmsDeclnSubItemQuantity I_RU_CustomsDeclarationSubitem Quantity Subitem Qty
IsActiveEntity
CustomsDeclaration Cus. Decl. No.
KEY RU_ExprtCustomsDeclarationItem R_RU_ExprtCstmsDeclnItemDraft RU_ExprtCustomsDeclarationItem CDec Item No.
KEY CustomsDeclarationSubitem R_RU_ExprtCstmsDeclnItemDraft CustomsDeclarationSubitem Subitem Number
BillingDocument R_RU_ExprtCstmsDeclnItemDraft BillingDocument SD Document
BillingDocumentItem R_RU_ExprtCstmsDeclnItemDraft BillingDocumentItem Item
CstmsDeclnSubItemQuantity R_RU_ExprtCstmsDeclnItemDraft CstmsDeclnSubItemQuantity Subitem Qty
HasDraftEntity
IsActiveEntity

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 P_RU_ExprtCstmsDeclnSubDrftAct.
-- 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: PRUCCDIDSUB

CREATE VIEW P_RU_ExprtCstmsDeclnSubDrftAct AS
SELECT
  Active.CustomsDeclaration AS CustomsDeclaration,
  Active.CustomsDeclarationItem AS RU_ExprtCustomsDeclarationItem,
  Active.CustomsDeclarationSubitem AS CustomsDeclarationSubitem,
  Active.BillingDocument AS BillingDocument,
  Active.BillingDocumentItem AS BillingDocumentItem,
  Active.Quantity AS CstmsDeclnSubItemQuantity,
  'X' AS IsActiveEntity,
  ' ' AS HasDraftEntity
FROM I_RU_CustomsDeclarationSubitem AS Active
-- UNION with additional select branch(es): R_RU_ExprtCstmsDeclnItemDraft
;

Learn More