In this post, I will try and describe everything you need to know about the SAP j11spa1 table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for J11SPA1 what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from J11SPA1....Right lets get started!
Object Name: J11SPA1
Dictionary Type: Structure
Description: Send Structure for TR-EDT Receiver Structure JBIUPA1
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| MANDT | MANDT | CLNT | 3(0) | T000 | Client | MANDT | TEST | |||||
| PARTNR | BP_PARTNR_OLD | CHAR | 10(0) | BP000 | Business Partner Number | BP_PARTNR | BPN | |||||
| STYPE | STYPEGP | CHAR | 1(0) | Record Type for TR External Data Transfer: Business Partner | STYPEGP | |||||||
| SFEMODE | TRUBMODE | CHAR | 1(0) | Transfer mode | TRUBMODE | |||||||
| KLASSE | BP_TYPE_OLD | CHAR | 1(0) | Partner category | BP_TYPE | |||||||
| MIGDATE | SYDATUM | DATS | 8(0) | System Date | SYDATS | SYST | ||||||
| KUNNR | KUNNR | CHAR | 10(0) | KNA1 | Customer Numbers | KUNNR | KUN | V | C_KUNNR | KUNNR | ||
| AKONT | AKONT | CHAR | 10(0) | SKA1 | Reconciliation Account in General Ledger | SAKNR | FB | |||||
| STRAS | STRAS_GP | CHAR | 35(0) | House number and street | TEXT35 | FB | ||||||
| STRA1 | STRAS_GP | CHAR | 35(0) | House number and street | TEXT35 | FB | ||||||
| ORT01 | ORT01_GP | CHAR | 35(0) | City | TEXT35 | FB | ||||||
| ORT02 | ORT02_GP | CHAR | 35(0) | District | TEXT35 | SAP | ||||||
| PSTLZ | PSTLZ | CHAR | 10(0) | Postal Code | PSTLZ | FB | ||||||
| PSTBZ | PSTBZ | CHAR | 15(0) | Post delivery district | PSTBZ | SAP | ||||||
| LAND1 | LAND1_GP | CHAR | 3(0) | T005 | Country Key | LAND1 | FB | C_LAND1 | LAND1 | |||
| REGIO | REGIO | CHAR | 3(0) | T005S | STATE (State, Province, County) | REGIO | FB | |||||
| BANKN | BANKN | CHAR | 18(0) | Bank account number | BANKN | FB | ||||||
| BKONT | BKONT | CHAR | 2(0) | Bank Control Key | BKONT | FB | ||||||
| BVTYP | BVTYP | CHAR | 4(0) | Partner Bank Type | BVTYP | FB | ||||||
| XEZER | XEZER | CHAR | 1(0) | Indicator: Is there collection authorization ? | XFELD | FB | ||||||
| BKREF | BKREF | CHAR | 20(0) | Reference specifications for bank details | CHAR20 | |||||||
| KOINH | KOINH_FI | CHAR | 60(0) | Account Holder Name | KOINH | |||||||
| ADR_REF_K | BP_ADR_REF_OLD | CHAR | 10(0) | TP14 | Address ID | BP_ADR_REF | ADK | |||||
| ADR_DAT | BP_ADR_DAT | DATS | 8(0) | Business partner address relationship valid from | DATUM | |||||||
| BUKRS | BUKRS | CHAR | 4(0) | T001 | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | ||
| ROLE | BP_ROLE | CHAR | 4(0) | TPZ6 | Business Partner Role Type | BP_ROLE | ||||||
| ROLETYP | BP_ROLETYP_OLD | CHAR | 4(0) | TPZ3 | Business Partner Role Category | BP_ROLETYP | BPR | |||||
| AUTHORITY | BRGRU | CHAR | 4(0) | TBRG | Authorization Group | BRGRU | FB | |||||
| DEL_INDRO | BP_DEL_IND | CHAR | 1(0) | Deletion Flag | XFELD | |||||||
| ERDAT | ERDAT_RF | DATS | 8(0) | Date on which the Record Was Created | DATUM | FB | ||||||
| ERNAM | ERNAM_RF | CHAR | 12(0) | Name of Person who Created the Object | USNAM | FB | ||||||
| BANKA | BANKA | CHAR | 60(0) | Name of bank | TEXT60 | FB | ||||||
| PROVZ | REGIO | CHAR | 3(0) | T005S | STATE (State, Province, County) | REGIO | FB | |||||
| SWIFT | SWIFT | CHAR | 11(0) | SWIFT/BIC for International Payments | SWIFT | FB | ||||||
| BGRUP | BGRUP | CHAR | 2(0) | Bank group (bank network) | BGRUP | FB | ||||||
| XPGRO | XPGRO | CHAR | 1(0) | Post Office Bank Current Account | XFELD | FB | ||||||
| LOEVM | LOEVM | CHAR | 1(0) | Deletion Indicator | XFELD | FVV | ||||||
| BNKLZ | BANKL | CHAR | 15(0) | Bank number | BANKL | BLZ | FB | |||||
| PSKTO | PSKTO_CH | CHAR | 16(0) | Post office bank current account number | PSKTO | FB | ||||||
| BRNCH | BRNCH | CHAR | 40(0) | Bank Branch | TEXT40 | |||||||
| KNRZB | KNRZB | CHAR | 10(0) | KNA1 | Account number of an alternative payer | KUNNR | FB | |||||
| WEBTR | UB_WEBTR | NUMC | 13(0) | Bill of Exchange Limit (in Local Currency) | NUM13 | FB | ||||||
| N_WEBTR | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| REMIT | REMIT | CHAR | 10(0) | KNA1 | Next payee | KUNNR | FB | |||||
| HBKID | HBKID | CHAR | 5(0) | T012 | Short Key for a House Bank | HBKID | FB | |||||
| XPORE | XPORE | CHAR | 1(0) | Indicator: Pay all items separately ? | XFELD | FB | ||||||
| LOCKB | LOCKB | CHAR | 7(0) | T049L | Key of the Lockbox to Which the Customer Is To Pay | LCKID | ||||||
| UZAWE | UZAWE | CHAR | 2(0) | T042F | Payment Method Supplement | UZAWE | ||||||
| EXTPARTNR | BP_EXT_PNR | CHAR | 15(0) | External Business Partner ID | CHAR15 | |||||||
| TYPE | BP_TYPE_OLD | CHAR | 1(0) | Partner category | BP_TYPE | |||||||
| GROUP_ID | BP_GRP_ID_OLD | CHAR | 4(0) | TPZ2 | Business Partner Grouping | BP_GRP_ID | ||||||
| NAME1 | BP_NAME1 | CHAR | 40(0) | Name 1 (surname for persons, otherwise company name) | TEXT40 | |||||||
| NAME2 | BP_NAME2 | CHAR | 40(0) | Name 2 (Continuation of NAME 1) | TEXT40 | |||||||
| LANGU | UB_LANGU | CHAR | 1(0) | Language Key | CHAR1 | PP | ||||||
| TITLE | BP_TITLE_OLD | NUMC | 2(0) | TP01 | Form of Address (Key) | BP_TITLE | ||||||
| TITLE_LET | BP_TITL_LT | NUMC | 2(0) | TP02 | Salutation | BP_TITL_LT | ||||||
| ADR_REF | BP_ADR_REF_OLD | CHAR | 10(0) | TP14 | Address ID | BP_ADR_REF | ADK | |||||
| SORT1 | BP_SORT1 | CHAR | 20(0) | Sort Field 1 | CHAR20 | |||||||
| SORT2 | BP_SORT2 | CHAR | 20(0) | Sort Field 2 | CHAR20 | |||||||
| SORT_PHON | BP_SORT_PH | CHAR | 20(0) | Sort Field for Phonetic Search; Obsolete | CHAR20 | |||||||
| MC_NAME1 | BP_MC_NAM1 | CHAR | 25(0) | Field NAME1 in Upper Case | CHAR25 | |||||||
| MC_NAME2 | BP_MC_NAM2 | CHAR | 25(0) | Field NAME2 in Upper Case | CHAR25 | |||||||
| SOURCE | BP_SOURCE | CHAR | 4(0) | Source Key of Business Partner Data | BP_SOURCE | |||||||
| CRUSER | BP_CRUSER | CHAR | 12(0) | Entered by | SYCHAR12 | |||||||
| CRDAT | BP_CRDAT | DATS | 8(0) | Creation Date | DATUM | |||||||
| VIP | BP_VIP | CHAR | 1(0) | TVIP | Business Partner: VIP Partner | PAVIP | ||||||
| GROUP_D | BP_GROUP_D | CHAR | 4(0) | TP13 | Target Group | BP_GROUP_D | ||||||
| DEL_IND | BP_DEL_IND | CHAR | 1(0) | Deletion Flag | XFELD | |||||||
| FDGRV | FDGRV | CHAR | 10(0) | T035 | Planning group | FDGRP | FF | |||||
| BLNKZ | BLNKZ | CHAR | 2(0) | T057 | Subsidy indicator for determining the reduction rates | BLNKZ | FB | |||||
| KNRZE | KNRZE | CHAR | 10(0) | KNA1 | Head office account number (in branch accounts) | KUNNR | FB | |||||
| XTITLE | BP_XTITLE | CHAR | 50(0) | Text of Form of Address | TEXT50 | |||||||
| XTIT_LE | BP_XTIT_LE | CHAR | 50(0) | Salutation | TEXT50 | |||||||
| PAR_REL | BP_PAR_REL | CHAR | 1(0) | Business Partner Released | BP_PAR_REL | |||||||
| NAME_LAST | BP_NAMLAST | CHAR | 40(0) | Last Name | TEXT40 | |||||||
| NAME_FIRST | BP_NAMFRST | CHAR | 40(0) | First Name | TEXT40 | |||||||
| TITLE_AC | BP_TITL_AC | CHAR | 20(0) | Academic Title | TEXT20 | |||||||
| N_PREFIX | BP_PREFIX | CHAR | 20(0) | Name Prefix | TEXT20 | |||||||
| N_ADDITION | BP_ADDITN | CHAR | 20(0) | Name Affix | TEXT20 | |||||||
| NICKNAME | BP_NICKNAM | CHAR | 20(0) | Known As | TEXT20 | |||||||
| SEX | BP_SEX_OLD | CHAR | 1(0) | Gender of Business Partner | BP_SEX | |||||||
| PROFESSION | BP_PROFESS | CHAR | 40(0) | Description of Occupation for Business Partner | TEXT40 | |||||||
| NATION | BP_CNTR_N | CHAR | 3(0) | T005 | Nationality | LAND1 | ||||||
| STATE | BP_CNTR_ST | CHAR | 3(0) | T005 | Citizenship | LAND1 | ||||||
| BIRTH_DATE | BP_BIRTHD | DATS | 8(0) | Date of Birth of Business Partner | DATUM | |||||||
| BIRTH_PLAC | BP_BIRTHPL | CHAR | 40(0) | Birthplace | TEXT40 | |||||||
| BIRTH_NAME | BP_BIRTHNA | CHAR | 40(0) | Name at Birth | TEXT40 | |||||||
| BIRTH_N_AD | BP_BIRTH_A | CHAR | 40(0) | Name at Birth Affix | TEXT40 | |||||||
| DEATH_DATE | BP_DEATH_D | DATS | 8(0) | Date of Death | DATUM | |||||||
| MARITAL_ST | BP_MARITAL | CHAR | 1(0) | TB027 | Marital Status | BU_MARST | ||||||
| PROPRTY_ST | BP_PROPRTY | NUMC | 2(0) | TP04 | Marital Property Regime | BP_PROPRTY | ||||||
| CHILDREN | UB_CHILDRN | NUMC | 2(0) | Number of Children (External Data Transfer) | NUMC2 | |||||||
| MEM_HOUSE | UB_MEM_HOU | NUMC | 2(0) | Number of Household Members (External Data Transfer) | NUMC2 | |||||||
| INCOME_CUR | UB_BP_INC_CUR | CHAR | 5(0) | Currency of Net Income | CHAR5 | |||||||
| NET_INCOME | UB_NET_INC | NUMC | 15(0) | Annual Net Income (External Data Transfer) | NUM15 | |||||||
| N_NET_INCOME | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| MO_NET_INC | UB_MO_INC | NUMC | 15(0) | Monthly Net Income of Business Partner | NUM15 | |||||||
| N_MO_NET_INC | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| NET_INC_Y | BP_N_INC_Y | NUMC | 4(0) | Year of Net Annual Income | GJAHR | |||||||
| MO_INC_M | BP_M_INC_M | NUMC | 2(0) | Calendar Month of Monthly Net Income | BP_M_INC_M | |||||||
| MO_INC_Y | BP_M_INC_Y | NUMC | 4(0) | Year of Monthly Net Income | GJAHR | |||||||
| PERS_NR | BP_PERS_NR | CHAR | 15(0) | Personnel Number | CHAR15 | |||||||
| STAFF_GRP | BP_STAFF_G | CHAR | 4(0) | TP05 | Employee Group | BP_STAFF_G | ||||||
| HR_ORG_REF | HR_ORG_REF | CHAR | 1(0) | HR Org. Link | XFELD | |||||||
| XUBNAME | XUBNAME | CHAR | 12(0) | USR02 | User Name in User Master Record | XUBNAME | XUS | SUSR | ||||
| STAFF_REF | BP_STAFF_R | CHAR | 1(0) | Employee | XFELD | |||||||
| ORG_NAME | BP_NAME1 | CHAR | 40(0) | Name 1 (surname for persons, otherwise company name) | TEXT40 | |||||||
| ORG_NAME2 | BP_NAME2 | CHAR | 40(0) | Name 2 (Continuation of NAME 1) | TEXT40 | |||||||
| CALENDARID | BP_CAL_ID | CHAR | 2(0) | TFACD | Factory calendar | WFCID | ||||||
| LEGAL_ENTY | BP_LEG_ETY_OLD | NUMC | 2(0) | TP08 | Legal Form of Organization | BP_LEG_ETY | ||||||
| LEGAL_ORG | BP_LEG_ORG_OLD | NUMC | 2(0) | TP09 | Legal Entity of Organization | BP_LEG_ORG | ||||||
| BALANCE_FL | BP_BAL_FLG | CHAR | 1(0) | Balance Sheet Display | BP_BAL_FLG | |||||||
| FOUND_YEAR | BP_FOUND_Y | NUMC | 4(0) | Foundation Year of Organization | GJAHR | |||||||
| COMM_REGIS | BP_COM_REG | CHAR | 50(0) | Entry in Commercial Register | TEXT50 | |||||||
| COMM_REG_D | BP_COM_R_D | DATS | 8(0) | Date of Entry in Commercial Register | DATUM | |||||||
| CNTRY_COMP | BP_CNTR_HD | CHAR | 3(0) | T005 | Country of Organization's Registered Office | LAND1 | ||||||
| COMP_HEAD | BP_COMP_HD | CHAR | 35(0) | Registered Office | TEXT35 | |||||||
| LIQUID_DAT | BP_LIQUI_D | DATS | 8(0) | Date of Liquidation | DATUM | |||||||
| COMP_NR | BBBNR | NUMC | 7(0) | International location number (part 1) | NUM07 | FB | ||||||
| COMP_NR_AD | BBSNR | NUMC | 5(0) | International location number (Part 2) | NUM05 | FB | ||||||
| BUBKZ | BUBKZ | NUMC | 1(0) | Check digit for the international location number | NUM01 | FB | ||||||
| IND_SECTOR | BP_SECTOR | CHAR | 10(0) | TB023 | Business Partner: Industry (Organization) | BU_INDSECT | ||||||
| MIN_RESERV | BP_MIN_RSV | CHAR | 1(0) | Bank Subject to Minimum Reserve Requirement | XFELD | |||||||
| BAL_SH_CUR | UB_BP_BAL_CUR | CHAR | 5(0) | Balance Sheet Currency | CHAR5 | |||||||
| CAP_INCR_A | UB_CA_IN_A | NUMC | 15(0) | Amount of Last Capital Increase | NUM15 | |||||||
| N_CAP_INCR_A | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| CAP_INCR_Y | BP_CA_IN_Y | NUMC | 4(0) | Year of Last Capital Increase | GJAHR | |||||||
| BANKL | BANKK | CHAR | 15(0) | Bank Keys | BANKK | BNK | FB | |||||
| BANKS | BANKS | CHAR | 3(0) | T005 | Bank country key | LAND1 | BKL | FB | ||||
| ADRNR | BP_ADRNR | CHAR | 10(0) | SANS1 | Address Number | SADRNR | ||||||
| ADR_D_E | BP_ADR_D_E | DATS | 8(0) | Business Partner Address Relationship Valid Until | DATUM | |||||||
| ADR_LOC | BP_ADR_LOC | CHAR | 20(0) | Building | CHAR20 | |||||||
| FLOOR | BP_FLOOR | CHAR | 10(0) | Floor | CHAR10 | |||||||
| ROOM_NR | BP_ROOM_NR | CHAR | 10(0) | Room Number | CHAR10 | |||||||
| NAME3 | BP_NAME3 | CHAR | 40(0) | Name 3 | TEXT40 | |||||||
| NAME4 | BP_NAME4 | CHAR | 40(0) | Name 4 | TEXT40 | |||||||
| NAME_CO | BP_NAME_CO | CHAR | 40(0) | c/o Name | TEXT40 | |||||||
| PFACH | PFACH | CHAR | 10(0) | PO Box | PFACH | MG | ||||||
| PSTL2 | PSTL2 | CHAR | 10(0) | P.O. Box Postal Code | PSTLZ | FB | ||||||
| TELF1 | TELF1 | CHAR | 16(0) | First telephone number | TEXT16 | SAP | ||||||
| TELF2 | TELF2 | CHAR | 16(0) | Second telephone number | TEXT16 | SAP | ||||||
| TELFX1 | TELFX | CHAR | 31(0) | Fax Number | TEXT31 | FB | ||||||
| TELFX2 | TELFX | CHAR | 31(0) | Fax Number | TEXT31 | FB | ||||||
| TELBX | TELBX | CHAR | 15(0) | Telebox number | TEXT15 | FB | ||||||
| TELX1 | TELX1 | CHAR | 30(0) | Telex number | TEXT30 | FB | ||||||
| DATLT | DATLT | CHAR | 14(0) | Data communication line no. | TEXT14 | FB | ||||||
| TELTX | TELTX | CHAR | 30(0) | Teletex number | TEXT30 | FB | ||||||
| EMPL_SINCE | EMPL_DATE | DATS | 8(0) | Employed from | DATUM | |||||||
| EMPL_UNTIL | BP_EMP_UNT | DATS | 8(0) | Employed Until | DATUM | |||||||
| EMPLOYMENT | BP_EMPLOYM | NUMC | 2(0) | TP11 | Employment Status | BP_EMPLOYM | ||||||
| EMP_SECTOR | EMP_SECTOR | CHAR | 10(0) | TB023 | Industry; Only Relevant for Real Estate Business Partner | BU_INDSECT | ||||||
| EMPLOYER | EMPLOYER | CHAR | 35(0) | Employer | TEXT35 | |||||||
| BUSINESS_Y | BP_BUSIN_Y | NUMC | 4(0) | Fiscal year | GJAHR | |||||||
| GEN_MEET_D | BP_GE_ME_D | DATS | 8(0) | Date of Annual Stockholders Meeting | DATUM | |||||||
| BU_Y_BEGIN | BP_B_Y_BEG | DATS | 8(0) | Fiscal Year Start Date | DATUM | |||||||
| BU_Y_END | BP_B_Y_END | DATS | 8(0) | Fiscal Year End Date | DATUM | |||||||
| ANNUAL_ACC | BP_ANN_ACC | CHAR | 1(0) | Year-End Closing | XFELD | |||||||
| ANNU_ACC_D | BP_A_ACC_D | DATS | 8(0) | Year-End Closing Date for Fiscal Year | DATUM | |||||||
| CONS_FST_D | BP_C_FST_D | DATS | 8(0) | Date of Consolidated Financial Statements of Group Company | DATUM | |||||||
| CAPI_STOCK | UB_CAP_STK | NUMC | 15(0) | Authorized Capital Stock (External Data Transfer) | NUM15 | |||||||
| N_CAPI_STOCK | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| SHAR_STOCK | UB_SHA_STK | NUMC | 15(0) | Stock Capital Issued (External Data Transfer) | NUM15 | |||||||
| N_SHAR_STOCK | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| PRSH_STOCK | UB_PRS_STK | NUMC | 15(0) | Participation Certificates Outstanding (Ext. Data Transfer) | NUM15 | |||||||
| N_PRSH_STOCK | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| EQUITY | UB_EQUITY | NUMC | 15(0) | Equity Capital | NUM15 | |||||||
| N_EQUITY | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| GROSS_AMNT | UB_GROSS_A | NUMC | 15(0) | Gross Contribution | NUM15 | |||||||
| N_GROSS_AMNT | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| NET_AMOUNT | UB_NET_A | NUMC | 15(0) | Net Contribution | NUM15 | |||||||
| N_NET_AMOUNT | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| TURNOVER | UB_TURNOVR | NUMC | 15(0) | Annual Sales | NUM15 | |||||||
| N_TURNOVER | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| DIV_DIS_AM | UB_DIV_DIS | NUMC | 15(0) | Dividend/Profit Distribution Amount | NUM15 | |||||||
| N_DIV_DIS_AM | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| DEBTS_FACT | UB_DEBTS_F | NUMC | 6(0) | Debt Ratio | NUM06 | |||||||
| N_DEBTS_FACT | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| DIS_PROFIT | UB_PROFIT | NUMC | 15(0) | Profit Reported by Organization | NUM15 | |||||||
| N_DIS_PROFIT | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| BAL_AMOUNT | UB_BAL_AMT | NUMC | 15(0) | Balance Sheet Total | NUM15 | |||||||
| N_BAL_AMOUNT | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| REL_TYP | BP_REL_TYP_OLD | CHAR | 4(0) | TPZ7 | Business Partner Relationship Category | BP_REL_TYP | ||||||
| PARTNR2 | BP_PARTNR_OLD | CHAR | 10(0) | BP000 | Business Partner Number | BP_PARTNR | BPN | |||||
| DIF_TYP1 | BP_DIF_TYP | CHAR | 4(0) | TPZ8 | Business Partner - Differentiation Category | BP_DIF_TYP | ||||||
| DIF_TYP2 | BP_DIF_TYP | CHAR | 4(0) | TPZ8 | Business Partner - Differentiation Category | BP_DIF_TYP | ||||||
| REL_DAT | BP_REL_DAT | DATS | 8(0) | Start of Validity of BP-BP Relationship | DATUM | |||||||
| RELAT | BP_RELAT_OLD | CHAR | 4(0) | TPZ11 | Relationship Type | BP_RELAT | ||||||
| REL_END | BP_REL_END | DATS | 8(0) | End of Validity of BP-BP Relationship | DATUM | |||||||
| REL_PER | UB_REL_PER | NUMC | 10(0) | Percentage Rate of Relationship | NUM10 | |||||||
| N_REL_PER | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| REL_AMO | UB_REL_AMO | NUMC | 13(0) | Relationship Amount | NUM13 | |||||||
| N_REL_AMO | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| REL_CUR | UB_WHR | CHAR | 5(0) | Currency ISO code | CHAR5 | WHR | FVV | |||||
| FUNCTN | BP_FUNCTN | CHAR | 4(0) | TB912 | Partner Function | BU_PAFKT | ||||||
| DEPART | BP_DEPART | CHAR | 4(0) | TB910 | Business Partner's Department | BU_ABTNR | ||||||
| KONZS | KONZS | CHAR | 10(0) | Group key | KONZS | FB | ||||||
| LIFNR | LIFNR | CHAR | 10(0) | * | Account Number of Vendor or Creditor | LIFNR | LIF | FB | KRED_C | LIFNR | ||
| VBUND | RASSC | CHAR | 6(0) | * | Company ID of trading partner | RCOMP | PGS | FG | ||||
| BEGRU | BRGRU | CHAR | 4(0) | TBRG | Authorization Group | BRGRU | FB | |||||
| XZEMP | XZEMP | CHAR | 1(0) | Indicator: Alternative payee in document allowed ? | XFELD | FB | ||||||
| KNRZA | KNRZA | CHAR | 10(0) | * | Account number of an alternative payer | KUNNR | FB | |||||
| DTAMS | DTAMS | CHAR | 1(0) | Indicator for Data Medium Exchange | DTAMS | FB | ||||||
| DTAWS | DTAWS | CHAR | 2(0) | * | Instruction key for data medium exchange | DTAWS | FB | |||||
| ESRNR | ESRNR | CHAR | 11(0) | ISR Subscriber Number | ESRNR | FB | ||||||
| PART_CO | BP_PART_CO | CHAR | 4(0) | * | Partner-Company Code Allocation | BUKRS | ||||||
| MABER | MABER | CHAR | 2(0) | T047M | Dunning Area | MABER | FB | |||||
| MAHNA | MAHNA | CHAR | 4(0) | T047A | Dunning Procedure | MAHNA | FB | |||||
| MANSP | MANSP | CHAR | 1(0) | T040S | Dunning block | MANSP | FB | |||||
| MADAT | MADAT | DATS | 8(0) | Last dunned on | DATUM | FB | ||||||
| MAHNS | MAHNS_D | NUMC | 1(0) | Dunning level | MAHNS | FB | ||||||
| KNRMA | KNRMA | CHAR | 10(0) | KNA1 | Account number of the dunning recipient | KUNNR | KUN | FBM | ||||
| GMVDT | GMVDT | DATS | 8(0) | Date of the legal dunning proceedings | DATUM | FBM | ||||||
| BUSAB | BUSAB_MA | CHAR | 2(0) | T001S | Dunning clerk | BUSAB | FBM | |||||
| MGRUP | MGRUP | CHAR | 2(0) | T047R | Key for dunning notice grouping | MGRUP | FBZ | |||||
| DE_OATH | BP_DE_OATH | CHAR | 1(0) | Affidavit | XFELD | |||||||
| DE_OA_D | BP_DE_OA_D | DATS | 8(0) | Date of affidavit | DATUM | |||||||
| BANKRUP | BP_BANKRUP | CHAR | 1(0) | Launch Bankruptcy Proceedings | XFELD | |||||||
| BNKRY_D | BP_BNKRY_D | DATS | 8(0) | Commencement Date of Bankruptcy Proceedings | DATUM | |||||||
| FORECLO | BP_FORECLO | CHAR | 1(0) | Foreclosure | XFELD | |||||||
| FORCL_D | BP_FORCL_D | DATS | 8(0) | Date of foreclosure | DATUM | |||||||
| SOLVNCY | BP_SOLVNCY | CHAR | 1(0) | Credit Standing | BP_SOLVNCY | |||||||
| SOL_INS | BP_SOL_INS | CHAR | 4(0) | * | Institute Providing Credit Standing Information | BP_SOL_INS | ||||||
| SOL_INF | BP_SOL_INF | CHAR | 1(0) | Status of Credit Standing Information | BP_SOL_INF | |||||||
| SOL_TXT | BP_SOL_TXT | CHAR | 50(0) | Additional Credit Standing Information | TEXT50 | |||||||
| SOL_I_D | BP_SOL_I_D | DATS | 8(0) | Date of Credit Standing Information | DATUM | |||||||
| RATING | BP_RATING | CHAR | 3(0) | * | Rating | BP_RATING | ||||||
| NRESIDT | BP_NRESIDT | CHAR | 1(0) | Non-Resident According to Paragraph 4 AWG | XFELD | |||||||
| NRESI_D | BP_NRESI_D | DATS | 8(0) | Start of Non-Residency According to Paragraph 4 AWG | DATUM | |||||||
| KWG_RLV | BP_KWG_RLV | CHAR | 1(0) | Recipient of Multimillion Loan According to Paragraph 14 GBA | XFELD | |||||||
| KWG_NR | BP_KWG_NR | CHAR | 8(0) | Borrower Number for Reporting a Loan According to GBA | CHAR8 | |||||||
| KWG_ENR | BP_KWG_ENR | CHAR | 8(0) | Borrower Entity Number Used to Report Loan acc. to GBA | CHAR8 | |||||||
| KWG_CRE | BP_KWG_CRE | NUMC | 2(0) | TP12 | Credit Standing Review According to Paragraph 18 GBA | BP_KWG_CRE | ||||||
| KWG_CRE_D | BP_KWG_CRE_D | DATS | 8(0) | Date of Credit Standing Review According to Paragraph 18 GBA | DATUM | |||||||
| KWG_ORG | BP_KWG_ORG | NUMC | 2(0) | * | Loan to Manager According to Paragraph 15 German Banking Act | BP_KWG_ORG | ||||||
| COMP_RE | BP_COMP_RE | CHAR | 1(0) | Organization Relationship | BP_COMP_RE | |||||||
| XID_AT | VVXID_AT_FS | CHAR | 11(0) | (OeNB) Ident Number | VVXID_AT_FS | |||||||
| SZG_AT | VVSZG_AT_FS | CHAR | 2(0) | TD05_AT_FS | Target Group According to OeNB | VVSZG_AT_FS | ||||||
| SID_AT | VVSID_AT_FS | CHAR | 1(0) | Assign (OeNB) Ident Number | BP_JANEI | |||||||
| SINLZ_AT | VVSINLZ_AT | CHAR | 7(0) | Institute Number According to OeNB | VVSINLZ_AT | |||||||
| SINME_AT | VVSINME_AT | CHAR | 1(0) | Institute Subject to Austrian Reg. Reporting Requirements | XFELD | |||||||
| GID_AT | VVGID_AT | CHAR | 15(0) | Group ID | ||||||||
| GIDTYPE_AT | VVGIDTYPE_AT | CHAR | 1(0) | Group Assignment Category | VVGIDTYPE_AT | |||||||
| GNAME_AT | VVGNAME_AT | CHAR | 50(0) | Group Name | TEXT50 | |||||||
| BAL_SH | BP_BAL_SH | CHAR | 1(0) | Balance Sheet Display | BP_BAL_SH | |||||||
| VZSKZ | VZSKZ | CHAR | 2(0) | * | Interest calculation indicator | VZSKZ | FB | |||||
| DATLZ | DATLZ | DATS | 8(0) | Date of the last interest calculation run | DATUM | FB | ||||||
| WAKON | WAKON | CHAR | 4(0) | Terms of payment key for bill of exchange charges | ZTERM | FB | ||||||
| XZVER | XZVER | CHAR | 1(0) | Indicator: Record Payment History ? | XFELD | FB | ||||||
| TOGRU | TOGRU | CHAR | 4(0) | * | Tolerance group for the business partner/G/L account | TOGRU | FB | |||||
| KULTG | UB_KULTG | NUMC | 3(0) | Probable Time Until Check Is Encashed | NUMC3 | FB | ||||||
| URLID | URLID | CHAR | 4(0) | * | Short Key for Known/Negotiated Leave | URLID | ||||||
| STCD1 | STCD1 | CHAR | 16(0) | Tax Number 1 | STCD1 | FB | ||||||
| STCD2 | STCD2 | CHAR | 11(0) | Tax Number 2 | STCD2 | FB | ||||||
| TAX_RES | BP_TAX_RES | CHAR | 1(0) | Tax Non-Resident Indicator | XFELD | |||||||
| COUNC | COUNC | CHAR | 3(0) | * | County Code | COUNC | SAP | |||||
| CITYC | CITYC | CHAR | 4(0) | * | City Code | CITYC | FB | |||||
| STKZA | STKZA | CHAR | 1(0) | Indicator: Business Partner Subject to Equalization Tax? | STKZA | FB | ||||||
| STKZU | STKZU | CHAR | 1(0) | Liable for VAT | XFELD | FB | ||||||
| STCEG | STCEG | CHAR | 20(0) | VAT Registration Number | STCEG | FB | ||||||
| TXJCD | TXJCD | CHAR | 15(0) | * | Tax Jurisdiction | TXJCD | TXJ | FB | ||||
| COUNTRY | LAND1 | CHAR | 3(0) | * | Country Key | LAND1 | LND | FB | ||||
| REGION | REGIO | CHAR | 3(0) | * | STATE (State, Province, County) | REGIO | FB | |||||
| FISKN | FISKN_D | CHAR | 10(0) | * | Account number of the master record with the fiscal address | KUNNR | FB |