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