SAP TABLES | Financial Services | Loans Management(FS-CML) SAP FS

J11SPA1 SAP Send Structure for TR-EDT Receiver Structure JBIUPA1 Structure and data







J11SPA1 is an SAP Structure so does not store data like a database table does but can be used 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 .

Below is the documentation avaialable and full details of the fields which make up this Structure.

You can view further information about this via relevant transactions such as SE11 or SE80. Also check out the Comments section below to view or add related contributions and example screen shots.



Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type)
See here for more information about this and other SAP enhancement categories


SAP J11SPA1 Structure fields within data Dictionary





Field
Component Type
Data Typelength (Decimals)Check tableDescriptionConversion Routine
.INCLUDEJBIUPA1 TR Business partner transfer - external fields (3.0 BP)
MANDTMANDTCLNT3 T000Client
PARTNRBP_PARTNR_OLDCHAR10 BP000Business Partner NumberALPHA
STYPESTYPEGPCHAR1 Record Type for TR External Data Transfer: Business Partner
SFEMODETRUBMODECHAR1 Transfer mode
KLASSEBP_TYPE_OLDCHAR1 Partner category
MIGDATESYDATUMDATS8 System Date
AKONTAKONTCHAR10 SKA1Reconciliation Account in General LedgerALPHA
STRASSTRAS_GPCHAR35 House number and street
STRA1STRAS_GPCHAR35 House number and street
ORT01ORT01_GPCHAR35 City
ORT02ORT02_GPCHAR35 District
PSTLZPSTLZCHAR10 Postal Code
PSTBZPSTBZCHAR15 Post delivery district
LAND1LAND1_GPCHAR3 T005Country Key
BANKNBANKNCHAR18 Bank account number
BKONTBKONTCHAR2 Bank Control Key
BVTYPBVTYPCHAR4 Partner Bank Type
XEZERXEZERCHAR1 Indicator: Is there collection authorization ?
BKREFBKREFCHAR20 Reference specifications for bank details
KOINHKOINH_FICHAR60 Account Holder Name
ADR_REF_KBP_ADR_REF_OLDCHAR10 TP14Address ID
ADR_DATBP_ADR_DATDATS8 Business partner address relationship valid from
BUKRSBUKRSCHAR4 T001Company Code
ROLEBP_ROLECHAR4 TPZ6Business Partner Role Type
ROLETYPBP_ROLETYP_OLDCHAR4 TPZ3Business Partner Role Category
AUTHORITYBRGRUCHAR4 TBRGAuthorization Group
DEL_INDROBP_DEL_INDCHAR1 Deletion Flag
ERDATERDAT_RFDATS8 Date on which the Record Was Created



ERNAMERNAM_RFCHAR12 Name of Person who Created the Object
BANKABANKACHAR60 Name of bank
SWIFTSWIFTCHAR11 SWIFT/BIC for International Payments
BGRUPBGRUPCHAR2 Bank group (bank network)
XPGROXPGROCHAR1 Post Office Bank Current Account
LOEVMLOEVMCHAR1 Deletion Indicator
BNKLZBANKLCHAR15 Bank number
PSKTOPSKTO_CHCHAR16 Post office bank current account number
BRNCHBRNCHCHAR40 Bank Branch
KNRZBKNRZBCHAR10 KNA1Account number of an alternative payerALPHA
ZWELSDZWELSCHAR10 List of the Payment Methods to be Considered
ZAHLSDZAHLSCHAR1 T008Block Key for Payment
WEBTRUB_WEBTRNUMC13 Bill of Exchange Limit (in Local Currency)
N_WEBTRUB_KOMMANUMC1 Number of decimal places from legacy system
REMITREMITCHAR10 KNA1Next payeeALPHA
HBKIDHBKIDCHAR5 T012Short Key for a House Bank
XPOREXPORECHAR1 Indicator: Pay all items separately ?
ZGRUPDZGRUPCHAR2 TZGRKey for Payment Grouping
LOCKBLOCKBCHAR7 T049LKey of the Lockbox to Which the Customer Is To Pay
UZAWEUZAWECHAR2 T042FPayment Method Supplement
EXTPARTNRBP_EXT_PNRCHAR15 External Business Partner ID
TYPEBP_TYPE_OLDCHAR1 Partner category
GROUP_IDBP_GRP_ID_OLDCHAR4 TPZ2Business Partner Grouping
NAME1BP_NAME1CHAR40 Name 1 (surname for persons, otherwise company name)
NAME2BP_NAME2CHAR40 Name 2 (Continuation of NAME 1)
LANGUUB_LANGUCHAR1 Language Key
TITLEBP_TITLE_OLDNUMC2 TP01Form of Address (Key)
TITLE_LETBP_TITL_LTNUMC2 TP02Salutation
ADR_REFBP_ADR_REF_OLDCHAR10 TP14Address ID
SORT1BP_SORT1CHAR20 Sort Field 1
SORT2BP_SORT2CHAR20 Sort Field 2
SORT_PHONBP_SORT_PHCHAR20 Sort Field for Phonetic Search; Obsolete
MC_NAME1BP_MC_NAM1CHAR25 Field NAME1 in Upper Case
MC_NAME2BP_MC_NAM2CHAR25 Field NAME2 in Upper Case
SOURCEBP_SOURCECHAR4 Source Key of Business Partner Data
CRUSERBP_CRUSERCHAR12 Entered by
CRDATBP_CRDATDATS8 Creation Date
VIPBP_VIPCHAR1 TVIPBusiness Partner: VIP Partner
GROUP_DBP_GROUP_DCHAR4 TP13Target Group
DEL_INDBP_DEL_INDCHAR1 Deletion Flag
ZUAWADZUAWACHAR3 TZUNKey for sorting according to assignment numbers
FDGRVFDGRVCHAR10 T035Planning groupALPHA
BLNKZBLNKZCHAR2 T057Subsidy indicator for determining the reduction rates
KNRZEKNRZECHAR10 KNA1Head office account number (in branch accounts)ALPHA
XTITLEBP_XTITLECHAR50 Text of Form of Address
XTIT_LEBP_XTIT_LECHAR50 Salutation
PAR_RELBP_PAR_RELCHAR1 Business Partner Released
NAME_LASTBP_NAMLASTCHAR40 Last Name
NAME_FIRSTBP_NAMFRSTCHAR40 First Name





TITLE_ACBP_TITL_ACCHAR20 Academic Title
N_PREFIXBP_PREFIXCHAR20 Name Prefix
N_ADDITIONBP_ADDITNCHAR20 Name Affix
NICKNAMEBP_NICKNAMCHAR20 Known As
SEXBP_SEX_OLDCHAR1 Gender of Business Partner
PROFESSIONBP_PROFESSCHAR40 Description of Occupation for Business Partner
NATIONBP_CNTR_NCHAR3 T005Nationality
STATEBP_CNTR_STCHAR3 T005Citizenship
BIRTH_DATEBP_BIRTHDDATS8 Date of Birth of Business Partner
BIRTH_PLACBP_BIRTHPLCHAR40 Birthplace
BIRTH_NAMEBP_BIRTHNACHAR40 Name at Birth
BIRTH_N_ADBP_BIRTH_ACHAR40 Name at Birth Affix
DEATH_DATEBP_DEATH_DDATS8 Date of Death
MARITAL_STBP_MARITALCHAR1 TB027Marital Status
PROPRTY_STBP_PROPRTYNUMC2 TP04Marital Property Regime
CHILDRENUB_CHILDRNNUMC2 Number of Children (External Data Transfer)
MEM_HOUSEUB_MEM_HOUNUMC2 Number of Household Members (External Data Transfer)
INCOME_CURUB_BP_INC_CURCHAR5 Currency of Net Income
NET_INCOMEUB_NET_INCNUMC15 Annual Net Income (External Data Transfer)
N_NET_INCOMEUB_KOMMANUMC1 Number of decimal places from legacy system
MO_NET_INCUB_MO_INCNUMC15 Monthly Net Income of Business Partner
N_MO_NET_INCUB_KOMMANUMC1 Number of decimal places from legacy system
NET_INC_YBP_N_INC_YNUMC4 Year of Net Annual IncomeGJAHR
MO_INC_MBP_M_INC_MNUMC2 Calendar Month of Monthly Net Income
MO_INC_YBP_M_INC_YNUMC4 Year of Monthly Net IncomeGJAHR
PERS_NRBP_PERS_NRCHAR15 Personnel Number
STAFF_GRPBP_STAFF_GCHAR4 TP05Employee Group
HR_ORG_REFHR_ORG_REFCHAR1 HR Org. Link
XUBNAMEXUBNAMECHAR12 USR02User Name in User Master Record
STAFF_REFBP_STAFF_RCHAR1 Employee
ORG_NAMEBP_NAME1CHAR40 Name 1 (surname for persons, otherwise company name)
ORG_NAME2BP_NAME2CHAR40 Name 2 (Continuation of NAME 1)
CALENDARIDBP_CAL_IDCHAR2 TFACDFactory calendar
LEGAL_ENTYBP_LEG_ETY_OLDNUMC2 TP08Legal Form of Organization
LEGAL_ORGBP_LEG_ORG_OLDNUMC2 TP09Legal Entity of Organization
BALANCE_FLBP_BAL_FLGCHAR1 Balance Sheet Display
FOUND_YEARBP_FOUND_YNUMC4 Foundation Year of OrganizationGJAHR
COMM_REGISBP_COM_REGCHAR50 Entry in Commercial Register
COMM_REG_DBP_COM_R_DDATS8 Date of Entry in Commercial Register


CNTRY_COMPBP_CNTR_HDCHAR3 T005Country of Organization's Registered Office
COMP_HEADBP_COMP_HDCHAR35 Registered Office
LIQUID_DATBP_LIQUI_DDATS8 Date of Liquidation
COMP_NRBBBNRNUMC7 International location number (part 1)
COMP_NR_ADBBSNRNUMC5 International location number (Part 2)
BUBKZBUBKZNUMC1 Check digit for the international location number
IND_SECTORBP_SECTORCHAR10 TB023Business Partner: Industry (Organization)
MIN_RESERVBP_MIN_RSVCHAR1 Bank Subject to Minimum Reserve Requirement
BAL_SH_CURUB_BP_BAL_CURCHAR5 Balance Sheet Currency
CAP_INCR_AUB_CA_IN_ANUMC15 Amount of Last Capital Increase
N_CAP_INCR_AUB_KOMMANUMC1 Number of decimal places from legacy system
CAP_INCR_YBP_CA_IN_YNUMC4 Year of Last Capital IncreaseGJAHR
BANKLBANKKCHAR15 Bank Keys
BANKSBANKSCHAR3 T005Bank country key
ADRNRBP_ADRNRCHAR10 SANS1Address Number
ADR_D_EBP_ADR_D_EDATS8 Business Partner Address Relationship Valid Until
ADR_LOCBP_ADR_LOCCHAR20 Building
FLOORBP_FLOORCHAR10 Floor
ROOM_NRBP_ROOM_NRCHAR10 Room Number
NAME3BP_NAME3CHAR40 Name 3
NAME4BP_NAME4CHAR40 Name 4
NAME_COBP_NAME_COCHAR40 c/o Name
PFACHPFACHCHAR10 PO Box
PSTL2PSTL2CHAR10 P.O. Box Postal Code
TELF1TELF1CHAR16 First telephone number
TELF2TELF2CHAR16 Second telephone number
TELFX1TELFXCHAR31 Fax Number
TELFX2TELFXCHAR31 Fax Number
TELBXTELBXCHAR15 Telebox number
TELX1TELX1CHAR30 Telex number
DATLTDATLTCHAR14 Data communication line no.
TELTXTELTXCHAR30 Teletex number
EMPL_SINCEEMPL_DATEDATS8 Employed from
EMPL_UNTILBP_EMP_UNTDATS8 Employed Until
EMPLOYMENTBP_EMPLOYMNUMC2 TP11Employment Status
EMP_SECTOREMP_SECTORCHAR10 TB023Industry; Only Relevant for Real Estate Business Partner
EMPLOYEREMPLOYERCHAR35 Employer
BUSINESS_YBP_BUSIN_YNUMC4 Fiscal yearGJAHR
GEN_MEET_DBP_GE_ME_DDATS8 Date of Annual Stockholders Meeting
BU_Y_BEGINBP_B_Y_BEGDATS8 Fiscal Year Start Date
BU_Y_ENDBP_B_Y_ENDDATS8 Fiscal Year End Date
ANNUAL_ACCBP_ANN_ACCCHAR1 Year-End Closing
ANNU_ACC_DBP_A_ACC_DDATS8 Year-End Closing Date for Fiscal Year
CONS_FST_DBP_C_FST_DDATS8 Date of Consolidated Financial Statements of Group Company
CAPI_STOCKUB_CAP_STKNUMC15 Authorized Capital Stock (External Data Transfer)
N_CAPI_STOCKUB_KOMMANUMC1 Number of decimal places from legacy system
SHAR_STOCKUB_SHA_STKNUMC15 Stock Capital Issued (External Data Transfer)
N_SHAR_STOCKUB_KOMMANUMC1 Number of decimal places from legacy system
PRSH_STOCKUB_PRS_STKNUMC15 Participation Certificates Outstanding (Ext. Data Transfer)
N_PRSH_STOCKUB_KOMMANUMC1 Number of decimal places from legacy system
EQUITYUB_EQUITYNUMC15 Equity Capital
N_EQUITYUB_KOMMANUMC1 Number of decimal places from legacy system
GROSS_AMNTUB_GROSS_ANUMC15 Gross Contribution
N_GROSS_AMNTUB_KOMMANUMC1 Number of decimal places from legacy system
NET_AMOUNTUB_NET_ANUMC15 Net Contribution
N_NET_AMOUNTUB_KOMMANUMC1 Number of decimal places from legacy system
TURNOVERUB_TURNOVRNUMC15 Annual Sales
N_TURNOVERUB_KOMMANUMC1 Number of decimal places from legacy system
DIV_DIS_AMUB_DIV_DISNUMC15 Dividend/Profit Distribution Amount
N_DIV_DIS_AMUB_KOMMANUMC1 Number of decimal places from legacy system
DEBTS_FACTUB_DEBTS_FNUMC6 Debt Ratio
N_DEBTS_FACTUB_KOMMANUMC1 Number of decimal places from legacy system
DIS_PROFITUB_PROFITNUMC15 Profit Reported by Organization
N_DIS_PROFITUB_KOMMANUMC1 Number of decimal places from legacy system
BAL_AMOUNTUB_BAL_AMTNUMC15 Balance Sheet Total
N_BAL_AMOUNTUB_KOMMANUMC1 Number of decimal places from legacy system
REL_TYPBP_REL_TYP_OLDCHAR4 TPZ7Business Partner Relationship Category
PARTNR2BP_PARTNR_OLDCHAR10 BP000Business Partner NumberALPHA
DIF_TYP1BP_DIF_TYPCHAR4 TPZ8Business Partner - Differentiation Category
DIF_TYP2BP_DIF_TYPCHAR4 TPZ8Business Partner - Differentiation Category
REL_DATBP_REL_DATDATS8 Start of Validity of BP-BP Relationship
RELATBP_RELAT_OLDCHAR4 TPZ11Relationship Type
REL_ENDBP_REL_ENDDATS8 End of Validity of BP-BP Relationship
REL_PERUB_REL_PERNUMC10 Percentage Rate of Relationship
N_REL_PERUB_KOMMANUMC1 Number of decimal places from legacy system
REL_AMOUB_REL_AMONUMC13 Relationship Amount
N_REL_AMOUB_KOMMANUMC1 Number of decimal places from legacy system
REL_CURUB_WHRCHAR5 Currency ISO code
FUNCTNBP_FUNCTNCHAR4 TB912Partner Function
DEPARTBP_DEPARTCHAR4 TB910Business Partner's Department
.INCLUDEBPICON1 BP: Attributes of Account Control (Subledger)
KONZSKONZSCHAR10 Group key
LIFNRLIFNRCHAR10
*
Account Number of Vendor or CreditorALPHA
VBUNDRASSCCHAR6
*
Company ID of trading partnerALPHA
BEGRUBRGRUCHAR4 TBRGAuthorization Group
.INCLUDEBPICON2 BP: Attributes of Payment Control
XZEMPXZEMPCHAR1 Indicator: Alternative payee in document allowed ?
KNRZAKNRZACHAR10
*
Account number of an alternative payerALPHA
DTAMSDTAMSCHAR1 Indicator for Data Medium Exchange
DTAWSDTAWSCHAR2
*
Instruction key for data medium exchange
ESRNRESRNRCHAR11 ISR Subscriber Number
.INCLUDEBPI1050 BP: Attributes of General Control Data
PART_COBP_PART_COCHAR4
*
Partner-Company Code Allocation
MABERMABERCHAR2 T047MDunning Area
MAHNAMAHNACHAR4 T047ADunning Procedure
MANSPMANSPCHAR1 T040SDunning block
MADATMADATDATS8 Last dunned on
MAHNSMAHNS_DNUMC1 Dunning level
KNRMAKNRMACHAR10 KNA1Account number of the dunning recipientALPHA
GMVDTGMVDTDATS8 Date of the legal dunning proceedings
BUSABBUSAB_MACHAR2 T001SDunning clerk
MGRUPMGRUPCHAR2 T047RKey for dunning notice grouping
.INCLUDEBPI1010 BP: Attributes of Credit Standing Data
DE_OATHBP_DE_OATHCHAR1 Affidavit
DE_OA_DBP_DE_OA_DDATS8 Date of affidavit
BANKRUPBP_BANKRUPCHAR1 Launch Bankruptcy Proceedings
BNKRY_DBP_BNKRY_DDATS8 Commencement Date of Bankruptcy Proceedings
FORECLOBP_FORECLOCHAR1 Foreclosure
FORCL_DBP_FORCL_DDATS8 Date of foreclosure
SOLVNCYBP_SOLVNCYCHAR1 Credit Standing
SOL_INSBP_SOL_INSCHAR4
*
Institute Providing Credit Standing Information
SOL_INFBP_SOL_INFCHAR1 Status of Credit Standing Information
SOL_TXTBP_SOL_TXTCHAR50 Additional Credit Standing Information
SOL_I_DBP_SOL_I_DDATS8 Date of Credit Standing Information
RATINGBP_RATINGCHAR3
*
Rating
.INCLUDEBPI1030 BP: Attributes of Reporting Data
NRESIDTBP_NRESIDTCHAR1 Non-Resident According to Paragraph 4 AWG
NRESI_DBP_NRESI_DDATS8 Start of Non-Residency According to Paragraph 4 AWG
KWG_RLVBP_KWG_RLVCHAR1 Recipient of Multimillion Loan According to Paragraph 14 GBA
KWG_NRBP_KWG_NRCHAR8 Borrower Number for Reporting a Loan According to GBA
KWG_ENRBP_KWG_ENRCHAR8 Borrower Entity Number Used to Report Loan acc. to GBA
KWG_CREBP_KWG_CRENUMC2 TP12Credit Standing Review According to Paragraph 18 GBA
KWG_CRE_DBP_KWG_CRE_DDATS8 Date of Credit Standing Review According to Paragraph 18 GBA
KWG_ORGBP_KWG_ORGNUMC2
*
Loan to Manager According to Paragraph 15 German Banking Act
COMP_REBP_COMP_RECHAR1 Organization Relationship
.INCLUDESI_BPMELD1 Business Partner: Reporting Data Austria
XID_ATVVXID_AT_FSCHAR11 (OeNB) Ident Number
SZG_ATVVSZG_AT_FSCHAR2 TD05_AT_FSTarget Group According to OeNB
SID_ATVVSID_AT_FSCHAR1 Assign (OeNB) Ident Number
SINLZ_ATVVSINLZ_ATCHAR7 Institute Number According to OeNB
SINME_ATVVSINME_ATCHAR1 Institute Subject to Austrian Reg. Reporting Requirements
GID_ATVVGID_ATCHAR15 Group ID
GIDTYPE_ATVVGIDTYPE_ATCHAR1 Group Assignment Category
GNAME_ATVVGNAME_ATCHAR50 Group Name
BAL_SHBP_BAL_SHCHAR1 Balance Sheet Display
.INCLUDEBPIVZIN BP: Atttributes of Int. Calculation (Company Code)
VZSKZVZSKZCHAR2
*
Interest calculation indicator
ZINDTDZINDTDATS8 Key date of the last interest calculation
ZINRTDZINRTNUMC2 Interest calculation frequency in months
DATLZDATLZDATS8 Date of the last interest calculation run
ZTERMDZTERMCHAR4 Terms of Payment Key
WAKONWAKONCHAR4 Terms of payment key for bill of exchange charges
XZVERXZVERCHAR1 Indicator: Record Payment History ?
TOGRUTOGRUCHAR4
*
Tolerance group for the business partner/G/L account
KULTGUB_KULTGNUMC3 Probable Time Until Check Is Encashed
URLIDURLIDCHAR4
*
Short Key for Known/Negotiated Leave
.INCLUDEBPI1020 BP: Attributes of Fiscal Data
STCD1STCD1CHAR16 Tax Number 1
STCD2STCD2CHAR11 Tax Number 2
TAX_RESBP_TAX_RESCHAR1 Tax Non-Resident Indicator
COUNCCOUNCCHAR3
*
County Code
CITYCCITYCCHAR4
*
City Code
STKZASTKZACHAR1 Indicator: Business Partner Subject to Equalization Tax?
STKZUSTKZUCHAR1 Liable for VAT
STCEGSTCEGCHAR20 VAT Registration Number
TXJCDTXJCDCHAR15
*
Tax Jurisdiction
COUNTRYLAND1CHAR3
*
Country Key
FISKNFISKN_DCHAR10
*
Account number of the master record with the fiscal addressALPHA



Key field
Non-key field