MANDT
Client
CLNT
3
0
T000
MANDT
DATUMJAHR
Reporting year of declaration to authorities
NUMC
4
0
DATUMJAHR
DATUMMONA
Reporting month of declaration to authorities
NUMC
2
0
DATUMMONA
ARRIVDEPA
Direction (Receipt, Dispatch)
NUMC
1
0
VEREI
Possible values
LFDNRVEIA
Sequential number for Intrastat declaration
NUMC
7
0
LFDNR_VEIA
USERNNAME
Name of Person Responsible for Creating the Object
CHAR
12
0
ERNAM
SATZERDAT
Date on which the record was created
DATS
8
0
ERDAT
NUMMBUKRS
Company Code
CHAR
4
0
T001
BUKRS
VERKAUFOR
Sales Organization
CHAR
4
0
TVKO
VKORG
EIGENUINR
ID number of trader
CHAR
20
0
EIGENUINR
EIGENBLND
Federal State of Tax Office
CHAR
2
0
EIGENBLND
BELEGNUMR
Document number
CHAR
10
0
*
BELEGNUMR
HAUPTPOSI
Item
NUMC
6
0
*
HAUPTPOSI
MATERIALN
Material Number
CHAR
6
0
MATNR_INTR
FAKTDATUM
Billing Date
DATS
8
0
FKDAT
VERSENDER
Importer HQ / Exporter HQ
CHAR
1
0
VERSENDER
Possible values
1
Importer/Exporter in Hamburg
3
Importer/Exporter in Bremen
4
From a warehouse in Bremen (special trade)
5
Exporter in Bremen (general commodity trade)
6
Importer in Berlin
7
Importer in the Saarland/Exporter in Lübeck
8
Importer in Lübeck
BESTILAND
Destination Country/Region of Material
CHAR
3
0
T005
BESTILAND
BESTIREGI
Destination region
CHAR
3
0
*
BESTIREGI
LIEFERBED
Incoterms (Part 1)
CHAR
3
0
TINC
INCO1
ARTGESCHA
Business Transaction Type
CHAR
2
0
T605
EXART
VERKEHRZW
Mode of Transport at the Border (Intrastat)
CHAR
1
0
T618
EXPVZ
EINLADFGH
Customs Office: Office of Exit/Entry for Foreign Trade
CHAR
6
0
T615
DZOLLS
STATWAREN
Commodity Code
CHAR
17
0
T604
STAWN
URSPRSLND
Country/Region of Origin of Material (Non-Preferential Ori.)
CHAR
3
0
T005
HERKL
URSPRSREG
Region of origin
CHAR
3
0
*
URSPRSREG
VERFAHREN
Procedure
CHAR
8
0
T616
EXPRF
EIGENMASS
Tare mass in kilograms
NUMC
15
0
EIGENMASS
BESONMASS
Supplementary unit
NUMC
15
0
BESONMASS
RECHNWERT
Invoice value
NUMC
15
0
RECHNWERT
KUNDEUINR
Customer VAT Registration Number
CHAR
20
0
KUNDEUINR
LIEFRUINR
Supplier VAT Registration Number
CHAR
20
0
LIEFRUINR
GRENZWERT
Statistical value
NUMC
15
0
GRENZWERT
SPANIENID
Indicator: Domestic / Foreign
CHAR
1
0
INAUKZ
LIEFERWAE
Declarations to the authorities: Currency key of the vendor
CUKY
5
0
TCURC
LIEFERWAE
ZUSATZNUM
Foreign Trade: Additional no. for decl. to authorities
NUMC
3
0
INZNR
NLDBOCODE
BOE code (only relevant for The Netherlands)
NUMC
2
0
NLDBOCODE
EINKAUFOR
Purchasing organization
CHAR
4
0
T024E
EKORG
BELEGIDEN
SD Document Category
CHAR
4
0
VBTYPL
Possible values
#
Revenue Recognition (Temporary)
$
(AFS)
&
Warehouse Document
*
Pick Order
+
Journal Entry (Temporary)
,
Shipment Document
-
Journal Entry (Temporary)
.
Service Notification
0
Master Contract
1
Sales Activities (CAS)
2
External Transaction
3
Invoice List
4
Credit Memo List
5
Intercompany Invoice
6
Intercompany Credit Memo
7
Delivery/Shipping Notification
8
Shipment
:
Service Order
A
Inquiry
a
Shipment Costs
b
CRM Opportunity
B
Quotation
BOS
Service Entry Sheet
C
Order
c
Unverified Delivery
CEM
ETM Shipping Document
CMMA
Customer Management Master Agreement
CSCO
Customer Management Service Confirmation
CSCT
Customer Management Service Contract
CSVO
Customer Management Service Order
D
Item Proposal
d
Trading Contract
e
Allocation Table
E
Scheduling Agreement
EBDR
Billing Document Request
F
Scheduling Agreement with External Service Agent
f001
Period-End Invoice
f002
Period-End Credit Memo
f003
Period-End Invoice (Intercompany Billing)
f004
Period-End Credit Memo (Intercompany Billing)
G
Contract
g
Rough Goods Receipt (only IS-Retail)
GBRQ
Grants Management Billing Request
h
Cancel Goods Issue
H
Returns
i
Goods Receipt
I
Order Without Charge
J
Delivery
j
JIT Call
K
Credit Memo Request
k
Settlement Management Document
L
Debit Memo Request
M
Invoice
N
Invoice Cancellation
n
Reserved
O
Credit Memo
o
Reserved
P
Debit Memo
p
Goods Movement (Documentation)
PBD
Preliminary Billing Document
PBDR
Billing Document Request for Prof. Serv.
PBRQ
Project Billing Request
q
Reserved
Q
WMS Transfer Order
R
Goods Movement
r
TD Transport (Only IS-Oil)
S
Credit Memo Cancellation
s
Load Confirmation, Reposting (Only IS-Oil)
SBRQ
Subscription Billing Request
SOLO
Solution Order
t
Gain / Loss (Only IS-Oil)
T
Returns Delivery for Order
TMFO
Freight Order
TMFU
Freight Unit
U
Pro Forma Invoice
u
Reentry into Storage (Only IS-Oil)
v
Data Collation (Only IS-Oil)
V
Purchase Order
W
Independent Reqts Plan
w
Reservation (Only IS-Oil)
X
Handling Unit
x
Load Confirmation, Goods Receipt (Only IS-Oil)
Y
Rebate Agreement
^
Reserved
|
Reserved
~
Revenue Cancellation (Temporary)
§
Revenue Recognition/New View (Temporary)
RETOURCOD
Returns ID for official declarations
CHAR
1
0
RETOURCOD
GESAMANZA
Total number of items in a declaration
NUMC
5
0
GESAMANZA
NUMMWERKS
Plant
CHAR
4
0
T001W
WERKS_D
WERKSLAND
Declaration to authorities: Country of Plant
CHAR
3
0
T005
WERKSLAND
THIERISCH
Creation Type
CHAR
1
0
THIERISCH
Possible values
Automatically Created Item
F
Manually Created Item
M
Automatically Created Item, Changed Manually
IFREMDWER
Invoice value in foreign currency
NUMC
15
0
IFREMDWER
ISESSIONE
Indicator for normal business transactions and correction
CHAR
1
0
ISESSIONE
Possible values
1
Section 1
2
Section 2
3
Section 3
4
Section 4
IREFMONAT
Reference month for correction
NUMC
2
0
IREFMONAT
IREFEJAHR
Reference year for correction
NUMC
4
0
IREFEJAHR
ICORFORTZ
Plus/minus for value field in correction
CHAR
1
0
ICORFORTZ
Possible values
+
Positive sign
-
Negative sign
IREFBELEG
Reference document
CHAR
10
0
*
IREFBELEG
IREFPOSIT
Reference item
NUMC
6
0
*
IREFPOSIT
IREFWERKS
Reference plant
CHAR
4
0
T001W
IREFWERKS
PREFPACOD
Preference code for foreign trade (decl.to author., import)
CHAR
3
0
T604C
PREFPACOD
RECHNWEAK
Invoice value
CURR
15
2
RECHNWEAK
RECHNWEEH
Currency Key
CUKY
5
0
TCURC
WAERS
GRENZWEAK
Statistical value
CURR
13
2
GRENZWEAK
GRENZWEEH
Currency Key
CUKY
5
0
TCURC
WAERS
EIGENMAAK
Tare mass
QUAN
13
3
EIGENMAAK
EIGENMAEH
Weight Unit
UNIT
3
0
T006
GEWEI
BESONMAAK
Special unit of measure
QUAN
13
3
BESONMAAK
BESONMAEH
Weight Unit
UNIT
3
0
T006
GEWEI
IFREMDWAK
Invoice value in foreign currency
CURR
15
2
IFREMDWAK
IFREMDWEH
Currency Key
CUKY
5
0
TCURC
WAERS
GENES
Data Origin Indicator
CHAR
1
0
GENES
Possible values
Dispatches in Sales and Receipts in Purchasing
1
Returns to Supplier in Purchasing
2
Receipts and Returns to Supplier in Intercompany Sales
3
Customer Returns in Sales
4
Receipts and Returns to Supplier in Distance Selling
P_LANDKEY
Country/Region key
CHAR
1
0
P_LANDKEY
FLAGEUROC
Declarations to the authorities: Ind. for decl. crcy = Euro
CHAR
1
0
FTEUR
MATNR
Material Number
CHAR
40
0
MARA
MATNR
LIFNR
Account Number of Supplier
CHAR
10
0
LFA1
LIFNR
KUNNR
Customer Number
CHAR
10
0
KNA1
KUNNR
ORDPA
Classification Key for Periodic Declarations in For. Trade
CHAR
10
0
ORDPA
SERVICEITEM
Periodic Message: Service Item Ind.
CHAR
1
0
SERVICEITEM
FI_NUMBER
Italy - Number of Financial Accounting Document
CHAR
15
0
INTRA_FI_NUMBER
FI_DATE
Field of type DATS
DATS
8
0
DATS
SERVICE_CODE
Italy - Code Number of Service
CHAR
6
0
INTRA_SERVICE_CODE
SUPPLY_CODE
Italy - Type of Delivery with Services
CHAR
1
0
INTRA_SUPPLY_CODE
Possible values
PAYMENT_CODE
Italy - Payment Method for Services
CHAR
1
0
INTRA_PAYMENT_CODE
Possible values
A
Credit
B
Bank Transfer
X
Miscellaneous
PAYER_COUNTRY
Country or Region of the payer
CHAR
3
0
*
PLARG
PROT_NO
Sequence Number of Intrastat Declaration in this Period
NUMC
6
0
EXDANUMD
PROG_NO
Foreign Trade: Periodic Declarations: Sequence Number
NUMC
6
0
FTLFDNR