I_RU_IMPRTCSTMSDECLN

CDS View

FI RU Import Customs Declaration

I_RU_IMPRTCSTMSDECLN is a CDS View in S/4HANA. FI RU Import Customs Declaration. It contains 12 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
P_RU_GtdFromImCD view inner COMPOSITE FI RU determine GTD from ImCD
P_RU_GtdFromImCD1 view inner CONSUMPTION FI RU determine GTD from ImCD & Country
P_RU_GtdFromPOMM view left_outer COMPOSITE FI RU determine GTD from PO or MM docs
P_RU_GtdFromPOMM3 view inner COMPOSITE FI RU determine GTD from PO or MM docs 3
P_RU_GtdFromPOMM34 view from COMPOSITE s
P_RU_GtdFromPOMM34 view union_all COMPOSITE s
P_RU_GtdFromPOMM4 view inner COMPOSITE FI RU determine GTD from PO or MM docs 4
P_RU_ImprtSupplier4 view inner CONSUMPTION S/P Ledgers: Import Supplier4

Fields (12)

KeyField CDS FieldsUsed in Views
CompanyCode CompanyCode 1
CustomsDeclaration CustomsDeclaration 5
CustomsDeclarationDate CustomsDeclarationDate 5
EntryCustomsOffice EntryCustomsOffice 5
ImportCustomsDecln ImportCustomsDecln 5
ImportCustomsDeclnItem ImportCustomsDeclnItem 5
ImportCustomsDeclnPrintItem ImportCustomsDeclnPrintItem 5
MaterialDocument MaterialDocument 1
MaterialDocumentYear MaterialDocumentYear 1
PurchaseOrder PurchaseOrder 1
PurchaseOrderItem PurchaseOrderItem 1
Supplier Supplier 5

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- FI RU Import Customs Declaration
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RU_IMPRTCSTMSDECLN (
    COMPANYCODE,
    CUSTOMSDECLARATION,
    CUSTOMSDECLARATIONDATE,
    ENTRYCUSTOMSOFFICE,
    IMPORTCUSTOMSDECLN,
    IMPORTCUSTOMSDECLNITEM,
    IMPORTCUSTOMSDECLNPRINTITEM,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTYEAR,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    SUPPLIER
);