Follow us on LinkedIn for your next SAP project
← Back to Search

SAP Table FICA_CASH_PAY_STR_ITEMS

Assigned Business Partner Items

FICA_CASH_PAY_STR_ITEMS (Assigned Business Partner Items) 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 FICA_CASH_PAY_STR_ITEMS to other SAP tables.

FICA_CASH_PAY_STR_ITEMS table fields

Field Data element Checktable Datatype Length Decimals Possible values
WA_ITEMS
 FKKOP
STRU
 0 0
MANDT
Client
 MANDT
CLNT
 3 0
OPBEL
Number of Contract Accts Rec. & Payable Doc.
 OPBEL_KK
CHAR
 12 0
OPUPW
Repetition Item in Contract Account Document
 OPUPW_KK
NUMC
 3 0
OPUPK
Item number in contract account document
 OPUPK_KK
NUMC
 4 0
OPUPZ
Subitem for a Partial Clearing in Document
 OPUPZ_KK
NUMC
 3 0
BUKRS
Company Code
 BUKRS
CHAR
 4 0
GSBER
Business Area
 GSBER
CHAR
 4 0
BUPLA
Business Place
 BUPLA
CHAR
 4 0
SEGMENT
Segment for Segmental Reporting
 SEGMT_KK
CHAR
 10 0
PRCTR
Profit Center
 PRCTR
CHAR
 10 0
AUGST
Clearing status
 AUGST_KK
CHAR
 1 0
GPART
Business Partner Number
 GPART_KK
CHAR
 10 0
VTREF
Reference Specifications from Contract
 VTREF_KK
CHAR
 20 0
VTPOS
Contract: Item Number
 VTPOS_KK
NUMC
 6 0
VTRE2
Additional Reference Information
 VTRE2_KK
CHAR
 20 0
VKONT
Contract Account Number
 VKONT_KK
CHAR
 12 0
ABWBL
Number of the substitute FI-CA document
 ABWBL_KK
CHAR
 12 0
ABWTP
Category of substitute document in FI-CA
 ABWTP_KK
CHAR
 1 0
ABWKT
Alternative contract account for collective bills
 ABWVK_KK
CHAR
 12 0
APPLK
Application area
 APPLK_KK
CHAR
 1 0
HVORG
Main Transaction for Line Item
 HVORG_KK
CHAR
 4 0
TVORG
Subtransaction for Document Item
 TVORG_KK
CHAR
 4 0
KOFIZ
Account Determination ID
 KOFIZ_KK
CHAR
 2 0
SPART
Division
 SPART_KK
CHAR
 2 0
HKONT
General ledger account
 HKONT_KK
CHAR
 10 0
MWSKZ
Tax on sales/purchases code
 MWSKZ
CHAR
 2 0
MWSZKZ
Supplementary Tax
 MWSZKZ_KK
CHAR
 2 0
XANZA
Item is a Down Payment/Down Payment Request
 XANZA_KK
CHAR
 1 0
STAKZ
Type of statistical item
 STAKZ_KK
CHAR
 1 0
BLDAT
Document Date in Document
 BLDAT
DATS
 8 0
BUDAT
Posting Date in the Document
 BUDAT_KK
DATS
 8 0
OPTXT
Item text
 OPTXT_KK
CHAR
 50 0
WAERS
Transaction Currency
 BLWAE_KK
CUKY
 5 0
FAEDN
Due date for net payment
 FAEDN_KK
DATS
 8 0
FAEDS
Due Date for Cash Discount
 FAEDS_KK
DATS
 8 0
VERKZ
Item Can Only Be Cleared
 VERKZ_KK
CHAR
 1 0
STUDT
Deferral to
 STUDT_KK
DATS
 8 0
SKTPZ
Cash discount rate
 SKTPZ_KK
DEC
 5 3
XMANL
Exclude Item from Dunning Run
 XMANL_KK
CHAR
 1 0
KURSF
Exchange rate
 KURSF_KK
DEC
 9 5
BETRH
Amount In Local Currency With +/- Signs
 BETRH_KK
CURR
 13 2
BETRW
Amount in Transaction Currency with +/- Sign
 BETRW_KK
CURR
 13 2
BETR2
Amount in second parallel currency with +/- sign
 BETR2_KK
CURR
 13 2
BETR3
Amount in third parallel currency with +/- sign
 BETR3_KK
CURR
 13 2
SKFBT
Amount eligible for cash discount in document currency
 SKFBT_KK
CURR
 13 2
SBETH
Tax Amount in Local Currency With +/- Sign
 SBETH_KK
CURR
 13 2
SBETW
Tax Amount in Transaction Currency with +/- Sign
 SBETW_KK
CURR
 13 2
SBET2
Tax amount in second parallel currency
 SBET2_KK
CURR
 13 2
SBET3
Tax amount in third parallel currency
 SBET3_KK
CURR
 13 2
MWSKO
Account for posting taxes for down payments
 MWSKO_KK
CHAR
 10 0
MWVKO
Account for offsetting tax posting in down payments
 MWVKO_KK
CHAR
 10 0
TXRUL
Update Rule for Tax and Tax Clearing
 TXRUL_KK
CHAR
 1 0
SPZAH
Lock Reason for Automatic Payment
 SPZAH_KK
CHAR
 1 0
PYMET
Payment Method
 PYMET_KK
CHAR
 1 0
PYBUK
Company Code for Automatic Payment Transactions
 PYBUK_KK
CHAR
 4 0
PERNR
Personnel Number
 PERNR_D
NUMC
 8 0
GRKEY
Grouping Key for Displaying Open Items
 GRKEY_KK
CHAR
 3 0
PERSL
Key for Period Assignment
 PERSL_KK
CHAR
 4 0
XAESP
Printing - No Changes Possible
 XAESP_KK
CHAR
 1 0
AUGDT
Clearing date
 AUGDT_KK
DATS
 8 0
AUGBL
Clearing Document or Printed Document
 AUGBL_KK
CHAR
 12 0
AUGBD
Clearing document posting date
 AUGBD_KK
DATS
 8 0
AUGRD
Clearing Reason
 AUGRD_KK
CHAR
 2 0
AUGWA
Clearing currency
 AUGWA_KK
CUKY
 5 0
AUGBT
Clearing amount in clearing currency
 AUGBT_KK
CURR
 13 2
AUGBS
Tax amount in clearing currency
 AUGBS_KK
CURR
 13 2
AUGSK
Cash Discount Granted/Surcharge Levied in Clearing Currency
 AUGSK_KK
CURR
 13 2
AUGVD
Value date for clearing
 AUGVD_KK
DATS
 8 0
AUGOB
Item Canceled
 AUGOB_KK
CHAR
 1 0
WHANG
Number of repetition items
 WHANG_KK
NUMC
 3 0
WHGRP
Repetition group
 WHGRP_KK
NUMC
 3 0
XEIPH
Create Line Item in General Ledger
 XEIPH_KK
CHAR
 1 0
MAHNV
Dunning Procedure
 MAHNV_KK
CHAR
 2 0
MANSP
Dunning Lock Reason
 MANSP_KK
CHAR
 1 0
XAUGP
Check Sample Record Clearing
 XAUGP_KK
CHAR
 1 0
ABRZU
Lower Limit of Settlement Period
 ABRZU_KK
DATS
 8 0
ABRZO
Upper Limit of the Billing Period
 ABRZO_KK
DATS
 8 0
FDGRP
Planning Group
 FDGRP_KK
CHAR
 10 0
FDLEV
Planning level
 FDLEV_KK
CHAR
 2 0
FDZTG
Additional Days for Cash Management
 FDZTG_KK
NUMC
 2 0
FDWBT
Planning amount in document currency
 FDWBT
CURR
 13 2
XTAUS
Item Split
 XTAUS_KK
CHAR
 1 0
AUGRS
Clearing restriction
 AUGRS_KK
CHAR
 1 0
PYGRP
Grouping field for automatic payments
 PYGRP_KK
CHAR
 10 0
PDTYP
Category of Payment Specification
 PDTYP_KK
CHAR
 1 0
SPERZ
Interest Lock Reason
 SPERZ_KK
CHAR
 1 0
INFOZ
Doubtful Item Entry/Individual Value Adjustment
 INFOZ_KK
NUMC
 3 0
TXJCD
Tax Jurisdiction
 TXJCD
CHAR
 15 0
TXDAT
Decisive Date for Calculating Taxes
 TXDAT_KK
DATS
 8 0
VBUND
Company ID of trading partner
 RASSC
CHAR
 6 0
KONTT
Account Assignment Category
 KONTT_KK
CHAR
 2 0
KONTL
Acct assnmnt string for industry-specific account assngments
 KONTL_KK
CHAR
 50 0
OPSTA
Dunning indicator
 OPSTA_KK
CHAR
 3 0
BLART
Document Type
 BLART_KK
CHAR
 2 0
EMGPA
Alternative Business Partner for Payments
 EMGPA_KK
CHAR
 10 0
EMBVT
Bank Details ID of Payee
 EMBVT_KK
CHAR
 4 0
EMADR
Address number
 AD_ADDRNUM
CHAR
 10 0
IKEY
Interest Key
 IKEY_KK
CHAR
 2 0
EUROU
Status of Euro Conversion
 EUROU_KK
CHAR
 1 0
XRAGL
Clearing posting reversed
 XRAGL_KK
CHAR
 1 0
XWHPO
Expanded Repetition Item
 XWHPO_KK
CHAR
 1 0
ASTKZ
Statistical Key of the Initiating Item
 ASTKZ_KK
CHAR
 1 0
ASBLG
Number of Triggering Document
 ASBLG_KK
CHAR
 12 0
XBLNR
Reference document number
 XBLNR_KK
CHAR
 16 0
INKPS
Collection Item
 INKPS_KK
NUMC
 3 0
RNDPS
Type of Rounding Item
 RNDPS_KK
CHAR
 1 0
QSSKZ
Withholding Tax Code
 QSSKZ
CHAR
 2 0
QSSEW
Withholding Tax Supplement
 QSSEW_KK
CHAR
 2 0
QSPTP
Line Item Category From Withholding Tax View
 QSPTP_KK
CHAR
 1 0
QSSHB
Tax Base Amount
 QSSHB_KK
CURR
 13 2
QBSHB
Withholding Tax Amount (in Document Currency)
 QBSHB_KK
CURR
 13 2
QSZNR
Certificate Number of the Withholding Tax Exemption
 QSZNR
CHAR
 10 0
XWHEX
Variable Withholding Tax in DFKKOPWH
 XWHEX_KK
CHAR
 1 0
RFUPK
Reference Item In FI-CA Document
 RFUPK_KK
NUMC
 4 0
STRKZ
Tax Code for Other Taxes
 STRKZ_KK
CHAR
 2 0
FITPR
Tax type
 J_1AFITP_D
CHAR
 2 0
XPYOR
Item Included in a Payment Order
 XPYOR_KK
CHAR
 1 0
LANDL
Country Supplied (for Tax Notifications)
 LANDL_KK
CHAR
 3 0
INTBU
Reason for Automatic Creation of Posting
 INTBU_KK
CHAR
 1 0
EMCRD
Alternative Payment Card ID in Document
 EMCRD_KK
CHAR
 6 0
C4EYE
Check Reason for Workflows Acc. to Dual Control Principle
 C4EYE_KK
CHAR
 2 0
CFOPN
CFOP Code and Extension
 J_1BCFOP
CHAR
 10 0
C4EYP
Editing Process To Be Confirmed
 C4EYP_KK
CHAR
 1 0
SCTAX
Tax Portion in FI-CA Local Currency
 SCTAX_KK
CURR
 13 2
STTAX
Tax Amount as Statistical Information in Document Currency
 STTAX_KK
CURR
 13 2
STZAL
Status of Payment Processing
 STZAL_KK
CHAR
 1 0
ORUPZ
Subitem Number before Item Split
 ORUPZ_KK
CHAR
 3 0
NEGBU
Control Field for Negative Posting
 NEGBU_KK
NUMC
 1 0
SUBAP
Subapplication in Contract Accounts Receivable and Payable
 SUBAP_KK
CHAR
 1 0
PSWSL
Update Currency for General Ledger Transaction Figures
 PSWSL_KK
CUKY
 5 0
PSWBT
Amount for Updating in General Ledger
 PSWBT_KK
CURR
 13 2
PSWTX
Tax Amount for Update in General Ledger
 PSWTX_KK
CURR
 13 2
PSGRP
Grouping Key for Document Items
 PSGRP_KK
CHAR
 4 0
XCOLC
Item Is Included in Collection Case
 XCOLC_KK
CHAR
 1 0
AASTA
Control Field for Account Assignment Distributions
 AASTA_KK
CHAR
 1 0
XCSHA
Document Contains Assignments from Cash Flows
 XCSHA_KK
CHAR
 1 0
REACC
Originating Account in Cash Flow Anlaysis
 REACC_KK
CHAR
 10 0
REBUK
Partner Company Code for Cash Flow Analysis
 REBUK_KK
CHAR
 4 0
XUSTPD
Tax on Sales/Purchases Was Calculated by Document
 XUSTPD_KK
CHAR
 1 0
PTITM
Status of Partner Settlement Using Billable Items
 PTITM_KK
CHAR
 1 0
EMMND
SEPA Mandate Identifier
 EMMND_KK
NUMC
 6 0
PNNUM
SEPA: Number of Direct Debit Pre-Notification
 PNNUM_KK
CHAR
 16 0
PNHKF
SEPA: Origin of Direct Debit Pre-Notification
 PNHKF_KK
CHAR
 2 0
PNEXD
SEPA: Date of Execution of Direct Debit Pre-Notifcation
 PNEXD_KK
DATS
 8 0
PNCTR
SEPA: Requirement for a Pre-Notification
 PNCTR_KK
CHAR
 1 0
FINRE
Contract Account of Final Recipient
 FINRE_KK
CHAR
 12 0
RDSTA
Current Distribution Status
 RDSTA_KK
CHAR
 1 0
RDSTB
Last Distribution Status Reported
 RDSTB_KK
CHAR
 1 0
FMTYP
Update Method for FM - FI-CA Integration
 FMTYP_KK
CHAR
 2 0
ORIGFIKRS
Original FM Area for FM Account Assignment
 ORIGFIKRS_KK
CHAR
 4 0
FIPEX
Commitment Item
 FM_FIPEX
CHAR
 24 0
FISTL
Funds Center
 FISTL
CHAR
 16 0
FONDS
Fund
 BP_GEBER
CHAR
 10 0
FKBER
Functional Area
 FKBER
CHAR
 16 0
MEASURE
Funded Program
 FM_MEASURE
CHAR
 24 0
GRANT_NBR
Grant
 GM_GRANT_NBR
CHAR
 20 0
BUDGETYEAR
Original Year for FM Account Assignment
 FM_START_OF_CHAIN
NUMC
 4 0
BUDGET_PD
FM: Budget Period
 FM_BUDGET_PERIOD
CHAR
 10 0
WA_IVORGTEXTS
 FKK_HVORG_TVORG_TEXTS
STRU
 0 0
HVORG_TXT
Text
 TXT30
CHAR
 30 0
TVORG_TXT
Text
 TXT30
CHAR
 30 0
WA_RES_CCODE
 T001
STRU
 0 0
MANDT
Client
 MANDT
CLNT
 3 0
BUKRS
Company Code
 BUKRS
CHAR
 4 0
BUTXT
Name of Company Code or Company
 BUTXT
CHAR
 25 0
ORT01
City
 ORT01
CHAR
 25 0
LAND1
Country Key
 LAND1
CHAR
 3 0
WAERS
Currency Key
 WAERS
CUKY
 5 0
SPRAS
Language Key
 SPRAS
LANG
 1 0
KTOPL
Chart of Accounts
 KTOPL
CHAR
 4 0
WAABW
Maximum exchange rate deviation in percent
 WAABW_001
NUMC
 2 0
PERIV
Fiscal Year Variant
 PERIV
CHAR
 2 0
KOKFI
Allocation Indicator
 KOKFI
CHAR
 1 0
RCOMP
Company
 RCOMP_D
CHAR
 6 0
ADRNR
Address
 ADRNR
CHAR
 10 0
STCEG
VAT Registration Number
 STCEG
CHAR
 20 0
FIKRS
Financial Management Area
 FIKRS
CHAR
 4 0
XFMCO
Indicator: Project Cash Management active?
 XFMCO
CHAR
 1 0
XFMCB
Indicator: Cash budget management active
 XFMCB
CHAR
 1 0
XFMCA
Activate Update in Funds Management
 XFMCA
CHAR
 1 0
TXJCD
Jurisdiction for tax calculation - tax jurisdiction code
 TXJCD_NSTX
CHAR
 15 0
FMHRDATE
Funds center can be assigned to an account in HR from
 FM_HRDATE
DATS
 8 0
BUVAR
Company Code Variant (Screen)
 BUVAR
CHAR
 1 0
FDBUK
Cash Management and Forecast Company Code
 FDBUK
CHAR
 4 0
XFDIS
Indicator: Cash Management activated?
 XFDIS
CHAR
 1 0
XVALV
Indicator: Propose current date as value date ?
 XVALV
CHAR
 1 0
XSKFN
Indicator: Discount base amount is the net value
 XSKFN
CHAR
 1 0
KKBER
Credit control area
 KKBER
CHAR
 4 0
XMWSN
Indicator: Base amount for tax is net of discount ?
 XMWSN
CHAR
 1 0
MREGL
Rules for Copying from the Sample Account for G/L Accounts
 MREGL
CHAR
 4 0
XGSBE
Indicator: Business area financial statements required?
 XGSBE
CHAR
 1 0
XGJRV
Indicator: Propose fiscal year ?
 XGJRV
CHAR
 1 0
XKDFT
Indicator: Post translations for exchange rate differences ?
 XKDFT
CHAR
 1 0
XPROD
Indicator: Productive company code?
 XPROD_001
CHAR
 1 0
XEINK
Indicator: Purchase Account Processing is Active
 XEINK
CHAR
 1 0
XJVAA
Indicator: JVA Active
 JV_ACTIVE
CHAR
 1 0
XVVWA
Indicator: Financial Assets Management active
 XVVWA
CHAR
 1 0
XSLTA
Indicator: No ex.rate difference when clearing in local crcy
 XSLTA
CHAR
 1 0
XFDMM
Indicator: Updating MM in Cash Mgmt/Forecast activated?
 XFDMM
CHAR
 1 0
XFDSD
Indicator: Updating SD in Cash Mgmt/Forecast activated?
 XFDSD
CHAR
 1 0
XEXTB
Indicator: Company code is in another system
 XEXTB
CHAR
 1 0
EBUKR
Original Key of the Company Code
 EBUKR_001
CHAR
 4 0
KTOP2
Chart of Accounts According to Country Legislation
 KTOP2
CHAR
 4 0
UMKRS
Sales/Purchases Tax Group
 UMKRS
CHAR
 4 0
BUKRS_GLOB
Name of global company code
 BUKRS_GLOB
CHAR
 6 0
FSTVA
Field Status Variant
 FSTVA
CHAR
 4 0
OPVAR
Posting Period Variant
 OPVAR
CHAR
 4 0
XCOVR
Indicator: hedge request active
 XCOVR
CHAR
 1 0
TXKRS
Foreign Currency Translation for Tax Items
 TXKRS
CHAR
 1 0
WFVAR
Workflow variant
 WFVAR
CHAR
 4 0
XBBBF
G/L account authorization check in inventory management
 XBBBF
CHAR
 1 0
XBBBE
G/L account authorization check in PO/scheduling agreement
 XBBBE
CHAR
 1 0
XBBBA
G/L account authorization check in purchase requisitions
 XBBBA
CHAR
 1 0
XBBKO
G/L account authorization check in contracts
 XBBKO
CHAR
 1 0
XSTDT
Indicator: Document date as the basis for tax determination
 XSTDT_001
CHAR
 1 0
MWSKV
Input Tax Code for Non-Taxable Transactions
 MWSKZ_NSTV
CHAR
 2 0
MWSKA
Output Tax Code for Non-Taxable Transactions
 MWSKZ_NSTA
CHAR
 2 0
IMPDA
Foreign Trade: Import Data Control in MM Purchase Orders
 IMPDATEN
CHAR
 1 0
XNEGP
Indicator: Negative Postings Permitted
 XNEGP_ACT
CHAR
 1 0
XKKBI
Indicator: Can credit control area be overwritten?
 XKKBI
CHAR
 1 0
WT_NEWWT
Indicator: Extended withholding tax active
 WT_NEWWT
CHAR
 1 0
PP_PDATE
Procedure for Setting the Posting Date
 PP_PDATE
CHAR
 1 0
INFMT
Inflation Method
 J_1AINFME_
CHAR
 4 0
FSTVARE
Funds reservation field status var.
 FSTVARE
CHAR
 4 0
KOPIM
Foreign trade: Import data copying control for GR
 KOPIM
CHAR
 1 0
DKWEG
Foreign Trade: Screen ctrl of imp.data f. MM-goods rececipt
 DKWEG
CHAR
 1 0
OFFSACCT
Method for offsetting account determination
 GOFFSACCT
NUMC
 1 0
BAPOVAR
Additional settings variant for bus.area financial statemnts
 BAPOVAR
CHAR
 2 0
XCOS
Cost of sales accounting status
 XCOS
CHAR
 1 0
XCESSION
Accounts Receivable Pledging Active
 X_CESSION
CHAR
 1 0
XSPLT
Enable Amount Split
 BSPLT
CHAR
 1 0
SURCCM
Surcharge Calculation Method
 J_1ISURC
CHAR
 1 0
DTPROV
Document Type for Provisions for Taxes on Services Received
 J_1IPROV
CHAR
 2 0
DTAMTC
Document Type for Journal Voucher (Amount Correction)
 J_1IAMTC
CHAR
 2 0
DTTAXC
Document Type for Journal Voucher (Tax Code Correction)
 J_1ITAXC
CHAR
 2 0
DTTDSP
Document Type for Remittance Challans
 J_1ITDSTYP
CHAR
 2 0
DTAXR
Deferred Tax Rule
 DTAXR
CHAR
 4 0
XVATDATE
Tax Reporting Date Active in Documents
 XVATDATE
CHAR
 1 0
PST_PER_VAR
Manage Variant of Posting Period for Company Code/Ledger
 FAGL_POST_PER_VAR
CHAR
 1 0
XBBSC
G/L account authorization check in shopping cart
 /SRMERP/XBBSC
CHAR
 1 0
FM_DERIVE_ACC
Activate Account Assignment Derivation in Funds Management
 FM_DERIVE_ACC
CHAR
 1 0
WA_BUS_PART
 BUS000_EXT
STRU
 0 0
PARTNER
Business Partner Number
 BU_PARTNER
CHAR
 10 0
ADDRNUMBER
Address number
 AD_ADDRNUM
CHAR
 10 0
TYPE
Business partner category
 BU_TYPE
CHAR
 1 0
BPKIND
Business Partner Type
 BU_BPKIND
CHAR
 4 0
BU_GROUP
Business Partner Grouping
 BU_GROUP
CHAR
 4 0
BPEXT
Business Partner Number in External System
 BU_BPEXT
CHAR
 20 0
BU_SORT1
Search term 1 for business partner
 BU_SORT1
CHAR
 20 0
BU_SORT2
Search term 2 for business partner
 BU_SORT2
CHAR
 20 0
SOURCE
Data Origin Types
 BU_SOURCE
CHAR
 4 0
TITLE
Form-of-Address Key
 AD_TITLE
CHAR
 4 0
XDELE
Central Archiving Flag
 BU_XDELE
CHAR
 1 0
XBLCK
Central Block for Business Partner
 BU_XBLCK
CHAR
 1 0
AUGRP
Authorization Group
 BU_AUGRP
CHAR
 4 0
TITLE_LET
Salutation
 BU_TITLE_LET
CHAR
 50 0
BU_LOGSYS
Logical system
 LOGSYS
CHAR
 10 0
CONTACT
Business Partner: Contact Permission
 BU_CONTACT
CHAR
 1 0
NOT_RELEASED
Indicator: Not Released
 BU_XNOT_RELEASED
CHAR
 1 0
NOT_LG_COMPETENT
Indicator: Not Legally Competent
 BU_NOT_LEG_COMPETENT
CHAR
 1 0
PRINT_MODE
Business Partner Print Format
 BU_PRINT_MODE
CHAR
 1 0
BP_EEW_DUMMY
Dummy function in length 1
 DUMMY
CHAR
 1 0
NAPR
Business Partner Is a Natural Person Under the Tax Laws
 BU_NATURAL_PERSON
CHAR
 1 0
BBP_IPISP
Tax Split
 BBP_J_1BINDEQU
CHAR
 1 0
RATE
Cost Rate/Revenue Rate for Project Costing
 DPR_TV_RATE
CHAR
 15 0
NAME_ORG1
Name 1 of organization
 BU_NAMEOR1
CHAR
 40 0
NAME_ORG2
Name 2 of organization
 BU_NAMEOR2
CHAR
 40 0
NAME_ORG3
Name 3 of organization
 BU_NAMEOR3
CHAR
 40 0
NAME_ORG4
Name 4 of organization
 BU_NAMEOR4
CHAR
 40 0
LEGAL_ENTY
BP: Legal form of organization
 BU_LEGENTY
CHAR
 2 0
IND_SECTOR
Industry sector
 BU_INDSECT
CHAR
 10 0
LEGAL_ORG
Legal Entity of Organization
 BU_LEGAL_ORG
CHAR
 2 0
FOUND_DAT
Date organization founded
 BU_FOUND_DAT
DATS
 8 0
LIQUID_DAT
Liquidation date of organization
 BU_LIQUID_DAT
DATS
 8 0
LOCATION_1
International location number (part 1)
 BBBNR
NUMC
 7 0
LOCATION_2
International location number (Part 2)
 BBSNR
NUMC
 5 0
LOCATION_3
Check digit for the international location number
 BUBKZ
NUMC
 1 0
NAME_LAST
Last name of business partner (person)
 BU_NAMEP_L
CHAR
 40 0
NAME_FIRST
First name of business partner (person)
 BU_NAMEP_F
CHAR
 40 0
NAME_LST2
Other Last Name of a Person
 BU_NAMEPL2
CHAR
 40 0
NAME_LAST2
Name at birth of business partner
 BU_BIRTHNM
CHAR
 40 0
NAMEMIDDLE
Middle name or second forename of a person
 BU_NAMEMID
CHAR
 40 0
TITLE_ACA1
Academic Title: Key
 AD_TITLE1
CHAR
 4 0
TITLE_ACA2
Second academic title (key)
 AD_TITLE2
CHAR
 4 0
TITLE_ROYL
Name supplement, e.g. noble title (key)
 AD_TITLES
CHAR
 4 0
PREFIX1
Name Prefix (Key)
 AD_PREFIX
CHAR
 4 0
PREFIX2
2nd name prefix (key)
 AD_PREFIX2
CHAR
 4 0
NAME1_TEXT
Full Name
 BU_NAME1TX
CHAR
 80 0
NICKNAME
Nickname of Business Partner (Person)
 BU_NICKNAM
CHAR
 40 0
INITIALS
"Middle Initial" or personal initials
 AD_INITS
CHAR
 10 0
NAMEFORMAT
Name format
 AD_FORMAT
CHAR
 2 0
NAMCOUNTRY
Country for name format rule
 AD_NAMCTRY
CHAR
 3 0
LANGU_CORR
Business Partner: Correspondence Language
 BU_LANGU_CORR
LANG
 1 0
XSEXM
Selection: Business partner is male
 BU_XSEXM
CHAR
 1 0
XSEXF
Selection: Business partner is female
 BU_XSEXF
CHAR
 1 0
BIRTHPL
Birthplace of business partner
 BU_BIRTHPL
CHAR
 40 0
MARST
Marital Status of Business Partner
 BU_MARST
CHAR
 1 0
EMPLO
Name of Employer of a Natural Person
 BU_EMPLO
CHAR
 35 0
JOBGR
Occupation/group
 BU_JOBGR
CHAR
 4 0
NATIO
Nationality
 BU_NATIO
CHAR
 3 0
CNTAX
Obsolete Field
 BU_CNTAX
CHAR
 3 0
CNDSC
Ctry of Origin: Non-Res. Companies
 BU_CNDSC
CHAR
 3 0
PERSNUMBER
Person number
 AD_PERSNUM
CHAR
 10 0
XSEXU
Selection: Sex of business partner is not known
 BU_XSEXU
CHAR
 1 0
XUBNAME
Obsolete Field
 BU_XUBNAME
CHAR
 12 0
BU_LANGU
Business partner: Language
 BU_LANGU
LANG
 1 0
BIRTHDT
Date of Birth of Business Partner
 BU_BIRTHDT
DATS
 8 0
DEATHDT
Date of death of business partner
 BU_DEATHDT
DATS
 8 0
PERNO
Personnel Number
 BU_PERNO
NUMC
 8 0
CHILDREN
Obsolete Field
 BU_CHILDREN
NUMC
 2 0
MEM_HOUSE
Obsolete Field
 BU_MEM_HOUSE
DEC
 2 0
PARTGRPTYP
Group type
 BU_GRPTYP
CHAR
 4 0
NAME_GRP1
Name 1 (group)
 BU_NAMEGR1
CHAR
 40 0
NAME_GRP2
Name 2 (group)
 BU_NAMEGR2
CHAR
 40 0
LGTYP
Legitimation Type
 BU_LGTYP
CHAR
 4 0
LGNUM
Identification number of legitimation document
 BU_LGNUM
CHAR
 16 0
INFCT
Responsible local court
 BU_INFCT
CHAR
 30 0
COMRG
Entry in commercial register
 BU_COMRG
CHAR
 30 0
CLBRG
BP: Entry in register of associations
 BU_CLBRG
CHAR
 30 0
COPRG
Entry in Register of Cooperatives
 BU_COPRG
CHAR
 30 0
COMREG_DAT
Date of entry in trade register
 BU_COMREG_DAT
DATS
 8 0
M_BONIWERT
Creditworthiness value set manually
 BONIWRT_KK
NUMC
 4 0
M_BONIDAT
Date on Which Creditworthiness was Manually Set
 BONIDAT_KK
DATS
 8 0
NAME1
Name field 1 (name1/last name)
 BU_NAME1
CHAR
 40 0
NAME2
Name field 2 (name2/first name)
 BU_NAME2
CHAR
 40 0
NAME_CO
c/o name
 AD_NAME_CO
CHAR
 40 0
CITY1
City
 AD_CITY1
CHAR
 40 0
CITY2
District
 AD_CITY2
CHAR
 40 0
CITY_CODE
City code for city/street file
 AD_CITYNUM
CHAR
 12 0
CITYP_CODE
District code for City and Street file
 AD_CITYPNM
CHAR
 8 0
HOME_CITY
City (different from postal city)
 AD_CITY3
CHAR
 40 0
CITYH_CODE
Different city for city/street file
 AD_CITYHNM
CHAR
 12 0
CHCKSTATUS
City file test status
 AD_CHECKST
CHAR
 1 0
REGIOGROUP
Regional structure grouping
 REGIOGROUP
CHAR
 8 0
POST_CODE1
City postal code
 AD_PSTCD1
CHAR
 10 0
POST_CODE2
PO Box Postal Code
 AD_PSTCD2
CHAR
 10 0
POST_CODE3
Company Postal Code (for Large Customers)
 AD_PSTCD3
CHAR
 10 0
PCODE1_EXT
(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
 AD_PST1XT
CHAR
 10 0
PCODE2_EXT
(Not Supported) PO Box Postal Code Extension
 AD_PST2XT
CHAR
 10 0
PCODE3_EXT
(Not Supported) Major Customer Postal Code Extension
 AD_PST3XT
CHAR
 10 0
PO_BOX
PO Box
 AD_POBX
CHAR
 10 0
DONT_USE_P
PO Box Address Undeliverable Flag
 AD_NO_USEP
CHAR
 4 0
PO_BOX_NUM
Flag: PO Box Without Number
 AD_POBXNUM
CHAR
 1 0
PO_BOX_LOC
PO Box city
 AD_POBXLOC
CHAR
 40 0
CITY_CODE2
City PO box code (City file)
 AD_CIT2NUM
CHAR
 12 0
PO_BOX_REG
Region for PO Box (Country, State, Province, ...)
 AD_POBXREG
CHAR
 3 0
PO_BOX_CTY
PO box country
 AD_POBXCTY
CHAR
 3 0
POSTALAREA
(Not Supported) Post Delivery District
 AD_PSTLAR
CHAR
 15 0
TRANSPZONE
Transportation zone to or from which the goods are delivered
 LZONE
CHAR
 10 0
STREET
Street
 AD_STREET
CHAR
 60 0
DONT_USE_S
Street Address Undeliverable Flag
 AD_NO_USES
CHAR
 4 0
STREETCODE
Street Number for City/Street File
 AD_STRNUM
CHAR
 12 0
STREETABBR
(Not Supported) Abbreviation of Street Name
 AD_STRABBR
CHAR
 2 0
HOUSE_NUM1
House Number
 AD_HSNM1
CHAR
 10 0
HOUSE_NUM2
House number supplement
 AD_HSNM2
CHAR
 10 0
HOUSE_NUM3
(Not supported) House Number Range
 AD_HSNM3
CHAR
 10 0
STR_SUPPL1
Street 2
 AD_STRSPP1
CHAR
 40 0
STR_SUPPL2
Street 3
 AD_STRSPP2
CHAR
 40 0
STR_SUPPL3
Street 4
 AD_STRSPP3
CHAR
 40 0
LOCATION
Street 5
 AD_LCTN
CHAR
 40 0
BUILDING
Building (Number or Code)
 AD_BLDNG
CHAR
 20 0
FLOOR
Floor in building
 AD_FLOOR
CHAR
 10 0
ROOMNUMBER
Room or Appartment Number
 AD_ROOMNUM
CHAR
 10 0
COUNTRY
Country Key
 LAND1
CHAR
 3 0
LANGU
Language Key
 SPRAS
LANG
 1 0
REGION
Region (State, Province, County)
 REGIO
CHAR
 3 0
SORT1
Search Term 1
 AD_SORT1UL
CHAR
 20 0
SORT2
Search Term 2
 AD_SORT2UL
CHAR
 20 0
SORT_PHN
(Not Supported) Phonetic Search Sort Field
 AD_SRTPHN
CHAR
 20 0
ADDRORIGIN
(Not Supported) Address Data Source (Key)
 AD_ORIGINA
CHAR
 4 0
EXTENSION1
Extension (only for data conversion) (e.g. data line)
 AD_EXTENS1
CHAR
 40 0
EXTENSION2
Extension (only for data conversion) (e.g. telebox)
 AD_EXTENS2
CHAR
 40 0
TIME_ZONE
Address time zone
 AD_TZONE
CHAR
 6 0
TAXJURCODE
Tax Jurisdiction
 AD_TXJCD
CHAR
 15 0
ADDRESS_ID
(Not supported) Physical address ID
 AD_ADDR_ID
CHAR
 10 0
REMARK
Address notes
 AD_REMARK1
CHAR
 50 0
LANGU_CREA
Address record creation original language
 AD_LANGUCR
LANG
 1 0
PO_BOX_LOBBY
PO Box Lobby
 AD_PO_BOX_LBY
CHAR
 40 0
DELI_SERV_TYPE
Type of Delivery Service
 AD_DELIVERY_SERVICE_TYPE
CHAR
 4 0
DELI_SERV_NUMBER
Number of Delivery Service
 AD_DELIVERY_SERVICE_NUMBER
CHAR
 10 0
COUNTY_CODE
County code for county
 AD_CNTYNUM
CHAR
 8 0
COUNTY
County
 AD_COUNTY
CHAR
 40 0
TOWNSHIP_CODE
Township code for Township
 AD_TWSHPNUM
CHAR
 8 0
TOWNSHIP
Township
 AD_TOWNSHIP
CHAR
 40 0
DEFLT_COMM
Standard communication type
 AD_DFLTCMM
CHAR
 3 0
TEL_NUMBER
Telephone no.: dialling code+number
 AD_TLNMBR
CHAR
 30 0
TEL_EXTENS
Telephone no.: Extension
 AD_TLXTNS
CHAR
 10 0
FAX_NUMBER
Fax number: dialling code+number
 AD_FXNMBR
CHAR
 30 0
FAX_EXTENS
Fax no.: Extension
 AD_FXXTNS
CHAR
 10 0
VALID_FROM
Valid From
 BU_VALID_FROM_DATS
DATS
 8 0
VALID_TO
Valid To
 BU_VALID_TO_DATS
DATS
 8 0
NATPERS
Business Partner Is a Natural Person Under the Tax Laws
 BU_NATURAL_PERSON
CHAR
 1 0