Key MANDT
Client
CLNT
3
0
T000
MANDT
Key KUNNR
Customer Number
CHAR
10
0
KUNNR
LAND1
Country/Region Key
CHAR
3
0
T005
LAND1_GP
NAME1
Name 1
CHAR
35
0
NAME1_GP
NAME2
Name 2
CHAR
35
0
NAME2_GP
ORT01
City
CHAR
35
0
ORT01_GP
PSTLZ
Postal Code
CHAR
10
0
PSTLZ
REGIO
Region (State, Province, County)
CHAR
3
0
T005S
REGIO
SORTL
Sort field
CHAR
10
0
SORTL
STRAS
Street and House Number
CHAR
35
0
STRAS_GP
TELF1
First telephone number
CHAR
16
0
TELF1
TELFX
Fax Number
CHAR
31
0
TELFX
XCPDK
Indicator: Is the account a one-time account?
CHAR
1
0
XCPDK
ADRNR
Address
CHAR
10
0
ADRNR
MCOD1
Search term for matchcode search
CHAR
25
0
MCDD1
MCOD2
Search Term for Matchcode Search
CHAR
25
0
MCDD2
MCOD3
Search term for matchcode search
CHAR
25
0
MCDD3
ANRED
Title
CHAR
15
0
ANRED
AUFSD
Central order block for customer
CHAR
2
0
TVAST
AUFSD_X
BAHNE
Express train station
CHAR
25
0
BAHNE
BAHNS
Train station
CHAR
25
0
BAHNS
BBBNR
International location number (part 1)
NUMC
7
0
BBBNR
BBSNR
International location number (Part 2)
NUMC
5
0
BBSNR
BEGRU
Authorization Group
CHAR
4
0
*
BRGRU
BRSCH
Industry key
CHAR
4
0
T016
BRSCH
BUBKZ
Check digit for the international location number
NUMC
1
0
BUBKZ
DATLT
Data communication line no.
CHAR
14
0
DATLT
ERDAT
Date on which the Record Was Created
DATS
8
0
ERDAT_RF
ERNAM
Name of Person who Created the Object
CHAR
12
0
ERNAM_RF
EXABL
Indicator: Unloading points exist
CHAR
1
0
EXABL
FAKSD
Central billing block for customer
CHAR
2
0
TVFS
FAKSD_X
FISKN
Account number of the master record with the fiscal address
CHAR
10
0
KNA1
FISKN_D
KNAZK
Working Time Calendar
CHAR
2
0
TFACD
KNAZK
KNRZA
Account Number of an Alternative Payer
CHAR
10
0
KNA1
KNRZA
KONZS
Group key
CHAR
10
0
KONZS
KTOKD
Customer Account Group
CHAR
4
0
T077D
KTOKD
KUKLA
Customer Classification
CHAR
2
0
TKUKL
KUKLA
LIFNR
Account Number of Supplier
CHAR
10
0
LFA1
LIFNR
LIFSD
Central delivery block for the customer
CHAR
2
0
TVLS
LIFSD_X
LOCCO
City Coordinates
CHAR
10
0
LOCCO
LOEVM
Central Deletion Flag for Master Record
CHAR
1
0
LOEVM_X
NAME3
Name 3
CHAR
35
0
NAME3_GP
NAME4
Name 4
CHAR
35
0
NAME4_GP
NIELS
Nielsen ID
CHAR
2
0
TNLS
NIELS
ORT02
District
CHAR
35
0
ORT02_GP
PFACH
PO Box
CHAR
10
0
PFACH
PSTL2
P.O. Box Postal Code
CHAR
10
0
PSTL2
COUNC
County Code
CHAR
3
0
T005E
COUNC
CITYC
City Code
CHAR
4
0
T005G
CITYC
RPMKR
Regional market
CHAR
5
0
RPMKR
SPERR
Central posting block
CHAR
1
0
SPERB_X
SPRAS
Language Key
LANG
1
0
T002
SPRAS
STCD1
Tax Number 1
CHAR
16
0
STCD1
STCD2
Tax Number 2
CHAR
11
0
STCD2
STKZA
Indicator: Business Partner Subject to Equalization Tax?
CHAR
1
0
STKZA
Possible values
Not subject to equalization tax
X Subject to equalization tax
STKZU
Liable for VAT
CHAR
1
0
STKZU
TELBX
Telebox number
CHAR
15
0
TELBX
TELF2
Second telephone number
CHAR
16
0
TELF2
TELTX
Teletex number
CHAR
30
0
TELTX
TELX1
Telex number
CHAR
30
0
TELX1
LZONE
Transportation zone to or from which the goods are delivered
CHAR
10
0
TZONE
LZONE
XZEMP
Indicator: Is an alternative payer allowed in document?
CHAR
1
0
XREGU
VBUND
Company ID of Trading Partner
CHAR
6
0
T880
RASSC
STCEG
VAT Registration Number
CHAR
20
0
STCEG
DEAR1
Indicator: Competitor
CHAR
1
0
DEAR1
DEAR2
Indicator: Sales partner
CHAR
1
0
DEAR2
DEAR3
Indicator: Sales prospect
CHAR
1
0
DEAR3
Possible values
DEAR4
Indicator for customer type 4
CHAR
1
0
DEAR4
DEAR5
ID for default sold-to party
CHAR
1
0
DEAR5
GFORM
Legal status
CHAR
2
0
TVGF
GFORM
BRAN1
Industry code 1
CHAR
10
0
TBRC
BRAN1_D
BRAN2
Industry code 2
CHAR
10
0
TBRC
BRAN2
BRAN3
Industry code 3
CHAR
10
0
TBRC
BRAN3
BRAN4
Industry code 4
CHAR
10
0
TBRC
BRAN4
BRAN5
Industry code 5
CHAR
10
0
TBRC
BRAN5
EKONT
Initial contact
CHAR
10
0
EKONT
UMSAT
Annual sales
CURR
8
2
UMSAT
UMJAH
Year For Which Sales are Given
NUMC
4
0
UMJAH
UWAER
Currency of sales figure
CUKY
5
0
TCURC
UWAER
JMZAH
Yearly number of employees
NUMC
6
0
JMZAH
JMJAH
Year for which the number of employees is given
NUMC
4
0
JMJAH
KATR1
Attribute 1
CHAR
2
0
TVK1
KATR1
KATR2
Attribute 2
CHAR
2
0
TVK2
KATR2
KATR3
Attribute 3
CHAR
2
0
TVK3
KATR3
KATR4
Attribute 4
CHAR
2
0
TVK4
KATR4
KATR5
Attribute 5
CHAR
2
0
TVK5
KATR5
KATR6
Attribute 6
CHAR
3
0
TVK6
KATR6
KATR7
Attribute 7
CHAR
3
0
TVK7
KATR7
KATR8
Attribute 8
CHAR
3
0
TVK8
KATR8
KATR9
Attribute 9
CHAR
3
0
TVK9
KATR9
KATR10
Attribute 10
CHAR
3
0
TVK0
KATR10
STKZN
Natural Person
CHAR
1
0
STKZN
Possible values
Legal person
X Natural person
UMSA1
Annual sales
CURR
15
2
UMSA1
TXJCD
Tax Jurisdiction
CHAR
15
0
TTXJ
TXJCD
PERIV
Fiscal Year Variant
CHAR
2
0
T009
PERIV
ABRVW
Usage Indicator
CHAR
3
0
TVLV
ABRVW
INSPBYDEBI
Inspection Carried Out By Customer (No Inspection Lot)
CHAR
1
0
QINSPBYDEB
INSPATDEBI
Inspection for a Delivery Note After Outbound Delivery
CHAR
1
0
QINSPATDEB
KTOCD
Reference Account Group for One-Time Account (Customer)
CHAR
4
0
T077D
KTOCD
PFORT
PO Box city
CHAR
35
0
PFORT_GP
WERKS
Plant
CHAR
4
0
T001W
WERKS_D
DTAMS
Report key for data medium exchange
CHAR
1
0
DTAMS
Possible values
Use house bank default value
0 Single data record can be forwarded to the Bundesbank
1 Single data record not to be forwarded to the Bundesbank
DTAWS
Instruction Key for Data Medium Exchange
CHAR
2
0
*
DTAWS
DUEFL
Status of Data Transfer into Subsequent Release
CHAR
1
0
DUEFL_BKPF
Possible values
Not transferred yet
A Transfer taken place, document changed later
X Transfer taken place, document unchanged
HZUOR
Assignment to Hierarchy
NUMC
2
0
HZUOR
SPERZ
Payment Block
CHAR
1
0
SPERZ
ETIKG
IS-R Labeling: customer/plant group
CHAR
10
0
TWEK
ETIKG
CIVVE
ID for mainly non-military use
CHAR
1
0
CIVVE
MILVE
ID for mainly military use
CHAR
1
0
MILVE
KDKG1
Customer condition group 1
CHAR
2
0
TVKGG
KDKG1
KDKG2
Customer condition group 2
CHAR
2
0
TVKGG
KDKG2
KDKG3
Customer condition group 3
CHAR
2
0
TVKGG
KDKG3
KDKG4
Customer condition group 4
CHAR
2
0
TVKGG
KDKG4
KDKG5
Customer condition group 5
CHAR
2
0
TVKGG
KDKG5
XKNZA
Indicator: Alternative payer using account number
CHAR
1
0
XKNZA
FITYP
Tax type
CHAR
2
0
J_1AFITP
J_1AFITP_D
STCDT
Tax Number Type
CHAR
2
0
J_1ATODC
J_1ATOID
STCD3
Tax Number 3
CHAR
18
0
STCD3
STCD4
Tax Number 4
CHAR
18
0
STCD4
STCD5
Tax Number 5
CHAR
60
0
STCD5
STCD6
Tax Number 6
CHAR
20
0
STCD6
XICMS
Customer is ICMS-exempt
CHAR
1
0
J_1BTCICMS
XXIPI
Customer is IPI-exempt
CHAR
1
0
J_1BTCIPI
XSUBT
Customer group for Substituiçao Tributária calculation
CHAR
3
0
J_1BTXSTG
J_1BTCST
CFOPC
Customer's CFOP category
CHAR
2
0
J_1BINDUS1
Possible values
00 industry (cooperative)
01 electric co.
02 communication co.
03 transport co.
04 service co.
05 consumer industry (cooperative)
06 non-contributing customer
07 agricultural customer
08 trading company
09 producer establishment
TXLW1
Tax law: ICMS
CHAR
3
0
J_1BATL1
J_1BTAXLW1
TXLW2
Tax law: IPI
CHAR
3
0
J_1BATL2
J_1BTAXLW2
CCC01
Indicator for biochemical warfare for legal control
CHAR
1
0
CCC01
CCC02
Indicator for nuclear nonproliferation for legal control
CHAR
1
0
CCC02
CCC03
Indicator for national security for legal control
CHAR
1
0
CCC03
CCC04
Indicator for missile technology for legal control
CHAR
1
0
CCC04
BONDED_AREA_CONFIRM
TW: Bonded Area Confirm in Business Partner Extension
CHAR
1
0
TWVAT_BONDED_AREA_CONF
Possible values
1 Buyer as business entity in the Bonded Area
2 Buyer as business entity of overseas fishery
3 Buyer as business entity in the Free Trade Zone
DONATE_MARK
TW: Donate Mark in Business Partner Extension
CHAR
1
0
TWVAT_DONATE_MARK
Possible values
0 Non-Donation Invoice
1 Donation Invoice
CONSOLIDATE_INVOICE
Consolidated Invoicing for Taiwan
CHAR
1
0
TWGUI_CONSOLIDATE_INVOICE
Possible values
Not support
X Support collective billing
ALLOWANCE_TYPE
TW: Allowance Type in Business Partner Extension
CHAR
1
0
TWVAT_ALLOWANCE_TYPE
Possible values
1 Allowance issued by buyer
2 Allowance issued by seller
EINVOICE_MODE
Taiwan, China: Mode in Business Partner Extension
CHAR
1
0
TWVAT_EINVOICE_MODE
Possible values
1 Certificate Mode
2 B2B Exchange Mode
CASSD
Central sales block for customer
CHAR
2
0
CASSD_X
KNURL
Uniform resource locator
CHAR
132
0
URL
J_1KFREPRE
Name of Representative
CHAR
10
0
REPRES
J_1KFTBUS
Type of Business
CHAR
30
0
BUSTYPE
GESTYP
J_1KFTIND
Type of Industry
CHAR
30
0
INDUSTYPE
INDTYP
CONFS
Status of Change Authorization (Central)
CHAR
1
0
CONFS_X
UPDAT
Date on Which the Changes Were Confirmed
DATS
8
0
UPDAT_RF
UPTIM
Time of Last Change Confirmation
TIMS
6
0
UPTIM_RF
NODEL
Central deletion block for master record
CHAR
1
0
NODEL_X
DEAR6
Indicator: Consumer
CHAR
1
0
DEAR6
DELIVERY_DATE_RULE
Delivery Date Rule
CHAR
1
0
SD_DELIVERY_DATE_TYPE_RULE
Possible values
On Requested Date or Later
A On Confirmed Date
B By Confirmed Date
CVP_XBLCK
Business Purpose Completed Flag
CHAR
1
0
CVP_XBLCK
Possible values
SUFRAMA
Suframa Code
CHAR
9
0
J_1BSUFRAMA
RG
RG Number
CHAR
11
0
J_1BRG
EXP
Issued by
CHAR
3
0
J_1BEXP
UF
State
CHAR
2
0
J_1BUF
RGDATE
RG Issuing Date
DATS
8
0
J_1BRGDATE
RIC
RIC Number
NUMC
11
0
J_1BRIC
RNE
Foreign National Registration
CHAR
10
0
J_1BRNE
RNEDATE
RNE Issuing Date
DATS
8
0
J_1BRNEDATE
CNAE
CNAE
CHAR
7
0
J_1BTCNAE
J_1BCNAE
LEGALNAT
Legal Nature
NUMC
4
0
J_1BTLEGALNAT
J_1BLEGALNAT
CRTN
CRT Number
CHAR
1
0
J_1BCRTN
Possible values
1 Simples Nacional
2 Simples Nacional # excesso de sublimite da receita bruta
3 Regime Normal (não simples)
4 Simples Nacional - Microempreendedor Individual - MEI
ICMSTAXPAY
ICMS Taxpayer
CHAR
2
0
J_1BTICMSTAXPAY
J_1BICMSTAXPAY
INDTYP
Industry Main Type
CHAR
2
0
J_1BTINDTYP
J_1BINDTYP
TDT
Tax Declaration Type
CHAR
2
0
J_1BTTDT
J_1BTDT
COMSIZE
Company Size
CHAR
2
0
J_1BTCOMSIZE
J_1BCOMSIZE
DECREGPC
Declaration Regimen for PIS/COFINS
CHAR
2
0
J_1BTDECREGPC
J_1BDECREGPC
PH_BIZ_STYLE
PH Business Style Text
CHAR
140
0
PH_BIZ_STYLE
PAYTRSN
Payment Reason
CHAR
4
0
*
FARP_PAYT_RSN
KNA1_EEW_CUST
data element for customer
CHAR
1
0
KNA1_EEW_CUST
RULE_EXCLUSION
Account Excluded from Rule-Based Assignment
CHAR
1
0
CRMT_BUS_RULE_EXCLUSION
KNA1_ADDR_EEW_CUST
Customer General addr. dep. extensibility
CHAR
1
0
KNA1_ADDR_EEW_CUST
/VSO/R_PALHGT
Maximum Stacking Height of the Packaging Material (VSO)
QUAN
13
3
/VSO/R_PAL_BIN_HGT
/VSO/R_PAL_UL
Unit of Length for Packaging Material (VSO)
UNIT
3
0
T006
/VSO/R_PAL_UNIT_L
/VSO/R_PK_MAT
Customer-Related Packing for Each Packaging Material (VSO)
CHAR
1
0
/VSO/M_PACK_BY_MAT
/VSO/R_MATPAL
Packaging Material of the Customer in VSO
CHAR
40
0
MARA
/VSO/M_MATNR_PAL
/VSO/R_I_NO_LYR
Number Layers Under an Inter-Pallet (VSO)
NUMC
2
0
/VSO/M_IPAL_NO_LYR
/VSO/R_ONE_MAT
Packing Material-Specific for Each Packaging Material
CHAR
1
0
/VSO/M_ONE_MAT
/VSO/R_ONE_SORT
Pack Only One Package Type for Each PKM (VSO)
CHAR
1
0
/VSO/M_ONE_SORT
/VSO/R_ULD_SIDE
Side Preference of Loading/Unloading (VSO)
NUMC
1
0
/VSO/M_UNLOAD_SIDE_PREF
/VSO/R_LOAD_PREF
Front/Back Preference of Loading/Unloading (VSO)
NUMC
1
0
/VSO/M_LOAD_PREF
Possible values
/VSO/R_DPOINT
Collective Unloading Point for VSO
CHAR
10
0
/VSO/R_DPOINT
/VSO/R_DELIVERYPOINT
ALC
Agency Location Code
CHAR
8
0
FMFGT_ALC
FMFG_ALC
PMT_OFFICE
Payment Office
CHAR
5
0
FMFGT_PO
FMFG_PMT_OFF
FEE_SCHEDULE
Fee schedule
CHAR
4
0
FM_FEE_SCHED
DUNS
DUNS Number
CHAR
9
0
FMCCRDUNS
DUNS4
DUNS+4
CHAR
4
0
FMCCRDUNS4
SAM_UE_ID
System for Award Management Unique Entity Identifier
CHAR
12
0
FMFG_UNIQUE_ENTITY_ID
SAM_EFT_IND
System for Award Management Electronic Funds Transfer Ind
CHAR
4
0
FMFG_EFT_IND
PSOFG
Processor group
CHAR
10
0
PSO19
PSOFG
PSOIS
Subledger acct preprocessing procedure
CHAR
20
0
PSOIS
PSON1
Name 1
CHAR
35
0
NAME1_GP
PSON2
Name 2
CHAR
35
0
NAME2_GP
PSON3
Name 3
CHAR
35
0
NAME3_GP
PSOVN
First Name
CHAR
35
0
PSOVN
PSOTL
Title
CHAR
20
0
PSOTL
PSOHS
House number: is no longer used from Release 4.6B
CHAR
6
0
PSOHS
PSOST
Street: No longer used from Release 4.6B
CHAR
28
0
PSOST
PSOO1
Description
CHAR
50
0
PSOO1
PSOO2
Description
CHAR
50
0
PSOO1
PSOO3
Description
CHAR
50
0
PSOO1
PSOO4
Description
CHAR
50
0
PSOO1
PSOO5
Description
CHAR
50
0
PSOO1
J_1IEXCD
ECC Number
CHAR
40
0
J_1IEXCD
J_1IEXRN
Excise Registration Number
CHAR
40
0
J_1IEXRN
J_1IEXRG
Excise Range
CHAR
60
0
J_1IEXRG
J_1IEXDI
Excise Division
CHAR
60
0
J_1IEXDI
J_1IEXCO
Excise Commissionerate
CHAR
60
0
J_1IEXCO
J_1ICSTNO
Central Sales Tax Number
CHAR
40
0
J_1ICSTNO
J_1ILSTNO
Local Sales Tax Number
CHAR
40
0
J_1ILSTNO
J_1IPANNO
Permanent Account Number
CHAR
40
0
J_1IPANNO
J_1IEXCICU
Excise tax indicator for customer
CHAR
1
0
J_1ITAXIND
J_1IEXCICU
AEDAT
(Obsolete) Last Changed On – do not use
DATS
8
0
J_1IAEDAT_OBSOLETE
USNAM
(Obsolete) Changed by the user – do not use
CHAR
12
0
J_1IUSNAM_OBSOLETE
J_1ISERN
Service Tax Registration Number
CHAR
40
0
J_1ISERN
J_1IPANREF
PAN Reference Number
CHAR
40
0
J_1IPANREF
GST_TDS
GST TDS Registration
CHAR
18
0
J_1IGSTTDS
J_3GETYP
Recipient Type
CHAR
2
0
J_3GZUETYP
J_3GETYP
J_3GREFTYP
Reference Type for Recipient
CHAR
2
0
J_3GREFTYP
Possible values
1 WBS element
2 Project definition
3 CO order
4 Cost center
5 PM order
6 Warehouse/storage
7 Third party
8 Network
99 Dummy
PSPNR
WBS Element
NUMC
8
0
PRPS
PS_POSNR
COAUFNR
Order Number
CHAR
12
0
AUFK
AUFNR
J_3GAGEXT
External Sold-to Party
CHAR
10
0
KNA1
J_3GAGEXT
J_3GAGINT
Customer Internal Settlement
CHAR
10
0
KNA1
J_3GAGINT
J_3GAGDUMI
Dummy Recipient
CHAR
10
0
KNA1
J_3GDEMPST
J_3GAGSTDI
Standard Recipient
CHAR
10
0
KNA1
J_3GAGSTDI
LGORT
Storage location
CHAR
4
0
T001L
LGORT_D
KOKRS
Controlling Area
CHAR
4
0
TKA01
KOKRS
KOSTL
Cost Center
CHAR
10
0
CSKS
KOSTL
J_3GABGLG
Retirement Date Counts for Performance-Based Equipment
CHAR
1
0
J_3GABGLG
J_3GABGVG
Retirement Date Counts for Time-Based Equipment
CHAR
1
0
J_3GABGVG
J_3GABRART
Settlement Type
CHAR
1
0
J_3GABRART
Possible values
1 Complete months + remaining calendar days
2 Complete months + remaining workdays
3 Calendar days
4 Workdays
5 Customer Logic - BAdi J_3G_DAY_CALCULATE
J_3GSTDMON
Hours per Month
DEC
5
2
J_3GSTDMON
J_3GSTDTAG
Hours per Day
DEC
5
2
J_3GSTDTAG
J_3GTAGMON
Number of Days/Month
DEC
5
2
J_3GTAGMON
J_3GZUGTAG
Function for Settlement on Acquisition Date/PBE
CHAR
1
0
J_3GZUGTAG
J_3GMASCHB
"Fill PBE Documents" Indicator
CHAR
1
0
J_3GMASCHB
Possible values
Neither create (1) nor complete (2)
1 Missing PBE documents are created
2 Existing PBE documents are completed
3 Create (1) and complete (2)
J_3GMEINSA
Indicator: Take Multiple Usage Periods into Account
CHAR
1
0
J_3GMEINSA
J_3GKEINSA
Indicator - Relevant to Short Operation Periods
CHAR
1
0
J_3GKEINSA
J_3GBLSPER
Blocking Indicator for Document Entry
CHAR
1
0
J_3GBLSPER
J_3GKLEIVO
Indicator: Calculate PBE as TBE
CHAR
1
0
J_3GKLEIVO
J_3GCALID
Calendar ID
CHAR
2
0
TFACD
J_3GCALID
J_3GVMONAT
Indicator for Complete Month
NUMC
1
0
J_3GVMONAT
Possible values
1 Beyond the bounds of the month using differences
2 Whole month is encompassed
J_3GABRKEN
Settlement Indicator
CHAR
1
0
J_3GABRKEN
Possible values
Dummy or standard recipient
X According to recipient
J_3GLABRECH
Date of Last Settlement
DATS
8
0
J_3GLABRECH
J_3GAABRECH
Date of Current Settlement
DATS
8
0
J_3GAABRECH
J_3GZUTVHLG
Ind.: Acquisition Date Counts (as Daily Settlement for PBE)
CHAR
1
0
J_3GZUTVHLG
J_3GNEGMEN
Negative Quantities Allowed Even for Chronolog. Inv. Mgmt
CHAR
1
0
J_3GNEGMEN
J_3GFRISTLO
Indicator: Deadline Logic
CHAR
1
0
J_3GFRISTLO
J_3GEMINBE
Minimum Usage Period for Restricted Usage (Days)
NUMC
5
0
J_3GEMINBE
J_3GFMGUE
Release Notification Allowance for Unrestricted Usage (Days)
NUMC
5
0
J_3GFMGUE
J_3GZUSCHUE
Surcharge for Unrestricted Usage (Days)
NUMC
5
0
J_3GZUSCHUE
J_3GSCHPRS
Indicator: Shift Price
CHAR
1
0
J_3GSCHPRS
J_3GINVSTA
Status of Construction Site Inventory
CHAR
1
0
J_3GINVSTA
Possible values
No inventory
1 Construction site announces end of construction work
2 All shipping documents have been written
/SAPCEM/DBER
Planning Area
CHAR
8
0
/SAPCEM/DISPOBER
/SAPCEM/DBER
/SAPCEM/KVMEQ
Indicator: Settlement Qty Relevant to Equipment
CHAR
1
0
/SAPCEM/KVMEQ
Possible values
1 Ship. doc. UM has priority over settl. UM for equipment
2 Settl. UM for equipment has priority over ship. doc. UM
3 Acording to base unit of measure in equipment