P_RU_ExportCustomsDeclnHdr

DDL: P_RU_EXPORTCUSTOMSDECLNHDR SQL: PRUEXPDECHDR Type: view TRANSACTIONAL

P_RU_ExportCustomsDeclnHdr is a Transactional CDS View in SAP S/4HANA. It reads from 2 data sources (I_RU_CustomsDeclarationHeader, I_RU_CustomsDeclarationHeader) and exposes 31 fields with key field CustomsDeclaration.

Data Sources (2)

SourceAliasJoin Type
I_RU_CustomsDeclarationHeader Header from
I_RU_CustomsDeclarationHeader Header union

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRUEXPDECHDR view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.private true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CustomsDeclaration I_RU_CustomsDeclarationHeader CustomsDeclaration Cus. Decl. No.
CompanyCode I_RU_CustomsDeclarationHeader CompanyCode Receiver Company Code
CustomsDeclarationType I_RU_CustomsDeclarationHeader CustomsDeclarationType Worklist Type
Currency I_RU_CustomsDeclarationHeader Currency Valuation Crcy
CustomsOffice I_RU_CustomsDeclarationHeader CustomsOffice Reg. Cust. Off.
RU_RegistrationInvoiceDate I_RU_CustomsDeclarationHeader RU_RegistrationInvoiceDate CDec Reg. Date
CustomsDeclarationExtNmbr I_RU_CustomsDeclarationHeader CustomsDeclarationExtNmbr CDec Ext. No.
ShipToParty I_RU_CustomsDeclarationHeader ShipToParty Ship-To Party (obsolete)
Customer I_RU_CustomsDeclarationHeader Customer Sold-to Party
GoodsIssueAllowedDate I_RU_CustomsDeclarationHeader GoodsIssueAllowedDate Issue Date
RU_TransportationType I_RU_CustomsDeclarationHeader RU_TransportationType
RU_TranspDocumentType I_RU_CustomsDeclarationHeader RU_TranspDocumentType
CreatedByName I_RU_CustomsDeclarationHeader CreatedByName Version Created By
ChangedByName I_RU_CustomsDeclarationHeader ChangedByName Changed By
CreatedOnDateTime I_RU_CustomsDeclarationHeader CreatedOnDateTime Created On
CustomsDeclaration Cus. Decl. No.
CompanyCode I_RU_CustomsDeclarationHeader CompanyCode Receiver Company Code
CustomsDeclarationType I_RU_CustomsDeclarationHeader CustomsDeclarationType Worklist Type
Currency I_RU_CustomsDeclarationHeader Currency Valuation Crcy
CustomsOffice I_RU_CustomsDeclarationHeader CustomsOffice Reg. Cust. Off.
RU_RegistrationInvoiceDate I_RU_CustomsDeclarationHeader RU_RegistrationInvoiceDate CDec Reg. Date
CustomsDeclarationExtNmbr I_RU_CustomsDeclarationHeader CustomsDeclarationExtNmbr CDec Ext. No.
ShipToParty I_RU_CustomsDeclarationHeader ShipToParty Ship-To Party (obsolete)
Customer I_RU_CustomsDeclarationHeader Customer Sold-to Party
GoodsIssueAllowedDate I_RU_CustomsDeclarationHeader GoodsIssueAllowedDate Issue Date
RU_TransportationType I_RU_CustomsDeclarationHeader RU_TransportationType
RU_TranspDocumentType I_RU_CustomsDeclarationHeader RU_TranspDocumentType
CreatedByName I_RU_CustomsDeclarationHeader CreatedByName Version Created By
ChangedByName I_RU_CustomsDeclarationHeader ChangedByName Changed By
CreatedOnDateTime I_RU_CustomsDeclarationHeader CreatedOnDateTime Created On
ChangedOnDateTime I_RU_CustomsDeclarationHeader ChangedOnDateTime Last Changed At

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_ExportCustomsDeclnHdr.
-- 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: PRUEXPDECHDR

CREATE VIEW P_RU_ExportCustomsDeclnHdr AS
SELECT
  Header.CustomsDeclaration AS CustomsDeclaration,
  Header.CompanyCode AS CompanyCode,
  Header.CustomsDeclarationType AS CustomsDeclarationType,
  Header.Currency AS Currency,
  Header.CustomsOffice AS CustomsOffice,
  Header.RU_RegistrationInvoiceDate AS RU_RegistrationInvoiceDate,
  Header.CustomsDeclarationExtNmbr AS CustomsDeclarationExtNmbr,
  Header.ShipToParty AS ShipToParty,
  Header.Customer AS Customer,
  Header.GoodsIssueAllowedDate AS GoodsIssueAllowedDate,
  Header.RU_TransportationType AS RU_TransportationType,
  Header.RU_TranspDocumentType AS RU_TranspDocumentType,
  Header.CreatedByName AS CreatedByName,
  Header.ChangedByName AS ChangedByName,
  Header.CreatedOnDateTime AS CreatedOnDateTime,
  Header.ChangedOnDateTime AS ChangedOnDateTime
FROM I_RU_CustomsDeclarationHeader AS Header
-- UNION with additional select branch(es): I_RU_CustomsDeclarationHeader
;