SAP Table IV_RVSAAREI

Generated Table for View

IV_RVSAAREI (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link IV_RVSAAREI to other SAP tables.

IV_RVSAAREI table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EXNUM Number of foreign trade data in MM and SD documents EXNUM EIKP CHAR 10 0
EXPOS Internal item number for foreign trade data in MM and SD EXPOS EIPO NUMC 6 0
AHBAS Basis document category for foreign trade processing AHBAS CHAR 3 0
1AH Receipt / Import: Foreign Trade document - Import
1LI Receipt/Import: Vendor Master
1BE Receipt/Import: Purchase Order Document
1LA Receipt/Import: Inbound Delivery
1WE Receipt/Import: Goods Receipt Document
2AH Dispatch / Export: Foreign Trade Document - Export
2KU Dispatch/Export: Customer Master
2VA Dispatch/Export: Sales Document
2LI Dispatch/Export: Outbound Delivery Document
2FA Dispatch/Export: Billing Document
AHAPP Basis application for communication in foreign trade AHAPP CHAR 2 0
DE Communication: Printing - Export
EE Communication: EDI - Export
EI Communication: EDI - Import
ME Declarations to Authorities: EXTRASTAT
MI Declarations to Authorities: INTRASTAT
MJ Declarations to Authorities: NITI (Japan)
MK Declarations to Authorities: KOBRA
MS Declarations to Authorities: SED/AERP
MV Declarations to Authorities: VAR (Switzerland
KAPPL Application KAPPL T681A CHAR 2 0
KSCHL Output Type NA_KSCHL T685 CHAR 4 0
VTEXT Name VTXTK CHAR 20 0
SPRAS Language Key SPRAS T002 LANG 1 0
DOKNU Foreign Trade: Printing - Document Number DOKNU CHAR 25 0
REFNR Sales and Distribution Document Number VBELN CHAR 10 0
REFPS Item number of the SD document POSNR NUMC 6 0
NACAR Verification documents: Type of certificate for import NACAR T610NA CHAR 10 0
PREFA Preference: Preference type for foreign trade PREFA T610PA CHAR 10 0
AHDMA Number of reminder days for communication in foreign trade AHDMA DEC 3 0
FTPTY Foreign trade: Classification of foreign trade document FTPTY CHAR 4 0
NULL Not specified
A Export document - General
AAAU Export document - Incomplete export declaration
AAAV Export document - Complete export declaration
E Refund on exports - Application
G Application for export/import license
GDE National Enhancement Sheet Germany (import/export license)
P Preference document - General
PEUR Preference document - EUR1
PATR Preference document - ATR
V Shipping document - General
VT1 Shipping document - T1 document
VT2 Shipping document - T2 document
VT2L Shipping document - T2L document
VT5 Shipping document - T5 document
BEHOE Issuing authority for relevant Foreign Trade document BEHOE T610O CHAR 10 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
MABJJ Reporting year of declaration to authorities DATUMJAHR NUMC 4 0
MABMM Reporting month of declaration to authorities DATUMMONA NUMC 2 0
MABWR Indicator: Goods direction for declarations to authorities VEREI NUMC 1 0
1 Receipt / Import
2 Dispatch / Export
MABNR Sequential number for Intrastat declaration LFDNR_VEIA NUMC 7 0
STADU Foreign Trade: Print Status for Foreign Trade Document STADU CHAR 2 0
NULL No problems with printing
01 Hardware / Other errors such as torn paper
LAND1 Country of Destination LLAND T005 CHAR 3 0
WAERK SD Document Currency WAERK TCURC CUKY 5 0
NETWR Net Value in Document Currency NETWR CURR 15 2
KVEWE Usage of the condition table KVEWE T681V CHAR 1 0
KUNAG Sold-to party KUNAG KNA1 CHAR 10 0

IV_RVSAAREI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
IV_RVSAAREI BEHOE IV_RVSAAREI MANDT T610O Foreign Trade: Authorities MANDT
IV_RVSAAREI BEHOE IV_RVSAAREI BEHOE T610O Foreign Trade: Authorities BEHOE
IV_RVSAAREI EXNUM IV_RVSAAREI MANDT EIKP Foreign Trade: Export/Import Header Data MANDT
IV_RVSAAREI EXNUM IV_RVSAAREI EXNUM EIKP Foreign Trade: Export/Import Header Data EXNUM
IV_RVSAAREI EXPOS IV_RVSAAREI MANDT EIPO Foreign Trade: Export/Import: Item Data MANDT
IV_RVSAAREI EXPOS IV_RVSAAREI EXNUM EIPO Foreign Trade: Export/Import: Item Data EXNUM
IV_RVSAAREI EXPOS IV_RVSAAREI EXPOS EIPO Foreign Trade: Export/Import: Item Data EXPOS
IV_RVSAAREI KAPPL IV_RVSAAREI KAPPL T681A Conditions: Applications KAPPL
IV_RVSAAREI KSCHL 'B' T685 Conditions: Types KVEWE
IV_RVSAAREI KSCHL 'V3' T685 Conditions: Types KAPPL
IV_RVSAAREI KSCHL IV_RVSAAREI KSCHL T685 Conditions: Types KSCHL
IV_RVSAAREI KSCHL IV_RVSAAREI MANDT T685 Conditions: Types MANDT
IV_RVSAAREI KUNAG IV_RVSAAREI KUNAG KNA1 General Data in Customer Master KUNNR
IV_RVSAAREI KUNAG IV_RVSAAREI MANDT KNA1 General Data in Customer Master MANDT
IV_RVSAAREI KVEWE IV_RVSAAREI KVEWE T681V Conditions: Usages KVEWE
IV_RVSAAREI LAND1 IV_RVSAAREI MANDT T005 Countries MANDT
IV_RVSAAREI LAND1 IV_RVSAAREI LAND1 T005 Countries LAND1
IV_RVSAAREI MANDT IV_RVSAAREI MANDT T000 Clients MANDT
IV_RVSAAREI NACAR IV_RVSAAREI MANDT T610NA Import Processing: Verification Documents MANDT
IV_RVSAAREI NACAR EIKP ALAND T610NA Import Processing: Verification Documents LAND1
IV_RVSAAREI NACAR IV_RVSAAREI NACAR T610NA Import Processing: Verification Documents NACAR
IV_RVSAAREI PREFA IV_RVSAAREI MANDT T610PA Foreign Trade: Preference Type MANDT
IV_RVSAAREI PREFA EIKP ALAND T610PA Foreign Trade: Preference Type EILAN
IV_RVSAAREI PREFA IV_RVSAAREI PREFA T610PA Foreign Trade: Preference Type PREFA
IV_RVSAAREI SPRAS IV_RVSAAREI SPRAS T002 Language Keys (Component BC-I18) SPRAS
IV_RVSAAREI WAERK IV_RVSAAREI MANDT TCURC Currency Codes MANDT
IV_RVSAAREI WAERK IV_RVSAAREI WAERK TCURC Currency Codes WAERS