I_RU_ImprtCstmsDecln

DDL: I_RU_IMPRTCSTMSDECLN SQL: IRUIMCUSTDECLN Type: view BASIC Package: GLO_FIN_IS_RU
16 Fields 2 Data Sources

FI RU Import Customs Declaration

I_RU_ImprtCstmsDecln is a Basic CDS View that provides data about "FI RU Import Customs Declaration" in SAP S/4HANA. It reads from 2 data sources (j_3rfgtd_header, j_3rfgtd_item) and exposes 16 fields with key fields ImportCustomsDecln, ImportCustomsDeclnItem. Part of development package GLO_FIN_IS_RU.

Data Sources (2)

SourceAliasJoin Type
j_3rfgtd_header header from
j_3rfgtd_item item inner

Annotations (9)

NameValueLevelField
EndUserText.label FI RU Import Customs Declaration view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IRUIMCUSTDECLN view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ImportCustomsDecln j_3rfgtd_header gtd_id Int. CustDecl No
KEY ImportCustomsDeclnItem posnr WBS Element
ImportCustomsDeclnPrintItem gtdpos Customs Dec. Item No
CompanyCode bukrs Value
EntryCustomsOffice customs Customs Status
CustomsDeclarationDate gtddate Cust. Decl. Date
CustomsDeclaration gtdnumber Cust. Decl. No.
Supplier lifnr Vendor no.
Country herkl C/R of Origin
TaxCode mwskz Tax Code
PurchaseOrder ordernum Purchasing Doc.
PurchaseOrderItem orderpos Item
MaterialDocument mmdocnum Material Doc.
MaterialDocumentYear mmdocjahr Mat. Doc. Year
DocumentCurrency waers Transaction Currency
InvoiceGrossAmount netwr Value

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_ImprtCstmsDecln.
-- 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: IRUIMCUSTDECLN

CREATE VIEW I_RU_ImprtCstmsDecln AS
SELECT
  header.gtd_id AS ImportCustomsDecln,
  posnr AS ImportCustomsDeclnItem,
  gtdpos AS ImportCustomsDeclnPrintItem,
  bukrs AS CompanyCode,
  customs AS EntryCustomsOffice,
  gtddate AS CustomsDeclarationDate,
  gtdnumber AS CustomsDeclaration,
  lifnr AS Supplier,
  herkl AS Country,
  mwskz AS TaxCode,
  ordernum AS PurchaseOrder,
  orderpos AS PurchaseOrderItem,
  mmdocnum AS MaterialDocument,
  mmdocjahr AS MaterialDocumentYear,
  waers AS DocumentCurrency,
  netwr AS InvoiceGrossAmount
FROM j_3rfgtd_header AS header
INNER JOIN j_3rfgtd_item AS item ON /* join condition not captured in parsed metadata */
;

Learn More