SAP Table J11SPA1 stores Send Structure for TR-EDT Receiver Structure JBIUPA1data

  

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!


SAP J11SPA1 dictionary attributes

Object Name: J11SPA1
Dictionary Type: Structure
Description: Send Structure for TR-EDT Receiver Structure JBIUPA1


J11SPA1 field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
PARTNRBP_PARTNR_OLDCHAR10(0) BP000Business Partner NumberBP_PARTNRBPN
STYPESTYPEGPCHAR1(0) Record Type for TR External Data Transfer: Business PartnerSTYPEGP
SFEMODETRUBMODECHAR1(0) Transfer modeTRUBMODE
KLASSEBP_TYPE_OLDCHAR1(0) Partner categoryBP_TYPE
MIGDATESYDATUMDATS8(0) System DateSYDATSSYST
KUNNRKUNNRCHAR10(0) KNA1Customer NumbersKUNNRKUNVC_KUNNRKUNNR
AKONTAKONTCHAR10(0) SKA1Reconciliation Account in General LedgerSAKNRFB
STRASSTRAS_GPCHAR35(0) House number and streetTEXT35FB
STRA1STRAS_GPCHAR35(0) House number and streetTEXT35FB
ORT01ORT01_GPCHAR35(0) CityTEXT35FB
ORT02ORT02_GPCHAR35(0) DistrictTEXT35SAP
PSTLZPSTLZCHAR10(0) Postal CodePSTLZFB
PSTBZPSTBZCHAR15(0) Post delivery districtPSTBZSAP
LAND1LAND1_GPCHAR3(0) T005Country KeyLAND1FBC_LAND1LAND1
REGIOREGIOCHAR3(0) T005SSTATE (State, Province, County)REGIOFB
BANKNBANKNCHAR18(0) Bank account numberBANKNFB
BKONTBKONTCHAR2(0) Bank Control KeyBKONTFB
BVTYPBVTYPCHAR4(0) Partner Bank TypeBVTYPFB
XEZERXEZERCHAR1(0) Indicator: Is there collection authorization ?XFELDFB
BKREFBKREFCHAR20(0) Reference specifications for bank detailsCHAR20
KOINHKOINH_FICHAR60(0) Account Holder NameKOINH
ADR_REF_KBP_ADR_REF_OLDCHAR10(0) TP14Address IDBP_ADR_REFADK
ADR_DATBP_ADR_DATDATS8(0) Business partner address relationship valid fromDATUM
BUKRSBUKRSCHAR4(0) T001Company CodeBUKRSBUKFBC_T001BUKRS
ROLEBP_ROLECHAR4(0) TPZ6Business Partner Role TypeBP_ROLE
ROLETYPBP_ROLETYP_OLDCHAR4(0) TPZ3Business Partner Role CategoryBP_ROLETYPBPR
AUTHORITYBRGRUCHAR4(0) TBRGAuthorization GroupBRGRUFB
DEL_INDROBP_DEL_INDCHAR1(0) Deletion FlagXFELD
ERDATERDAT_RFDATS8(0) Date on which the Record Was CreatedDATUMFB
ERNAMERNAM_RFCHAR12(0) Name of Person who Created the ObjectUSNAMFB
BANKABANKACHAR60(0) Name of bankTEXT60FB
PROVZREGIOCHAR3(0) T005SSTATE (State, Province, County)REGIOFB
SWIFTSWIFTCHAR11(0) SWIFT/BIC for International PaymentsSWIFTFB
BGRUPBGRUPCHAR2(0) Bank group (bank network)BGRUPFB
XPGROXPGROCHAR1(0) Post Office Bank Current AccountXFELDFB
LOEVMLOEVMCHAR1(0) Deletion IndicatorXFELDFVV
BNKLZBANKLCHAR15(0) Bank numberBANKLBLZFB
PSKTOPSKTO_CHCHAR16(0) Post office bank current account numberPSKTOFB
BRNCHBRNCHCHAR40(0) Bank BranchTEXT40
KNRZBKNRZBCHAR10(0) KNA1Account number of an alternative payerKUNNRFB
WEBTRUB_WEBTRNUMC13(0) Bill of Exchange Limit (in Local Currency)NUM13FB
N_WEBTRUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
REMITREMITCHAR10(0) KNA1Next payeeKUNNRFB
HBKIDHBKIDCHAR5(0) T012Short Key for a House BankHBKIDFB
XPOREXPORECHAR1(0) Indicator: Pay all items separately ?XFELDFB
LOCKBLOCKBCHAR7(0) T049LKey of the Lockbox to Which the Customer Is To PayLCKID
UZAWEUZAWECHAR2(0) T042FPayment Method SupplementUZAWE
EXTPARTNRBP_EXT_PNRCHAR15(0) External Business Partner IDCHAR15
TYPEBP_TYPE_OLDCHAR1(0) Partner categoryBP_TYPE
GROUP_IDBP_GRP_ID_OLDCHAR4(0) TPZ2Business Partner GroupingBP_GRP_ID
NAME1BP_NAME1CHAR40(0) Name 1 (surname for persons, otherwise company name)TEXT40
NAME2BP_NAME2CHAR40(0) Name 2 (Continuation of NAME 1)TEXT40
LANGUUB_LANGUCHAR1(0) Language KeyCHAR1PP
TITLEBP_TITLE_OLDNUMC2(0) TP01Form of Address (Key)BP_TITLE
TITLE_LETBP_TITL_LTNUMC2(0) TP02SalutationBP_TITL_LT
ADR_REFBP_ADR_REF_OLDCHAR10(0) TP14Address IDBP_ADR_REFADK
SORT1BP_SORT1CHAR20(0) Sort Field 1CHAR20
SORT2BP_SORT2CHAR20(0) Sort Field 2CHAR20
SORT_PHONBP_SORT_PHCHAR20(0) Sort Field for Phonetic Search; ObsoleteCHAR20
MC_NAME1BP_MC_NAM1CHAR25(0) Field NAME1 in Upper CaseCHAR25
MC_NAME2BP_MC_NAM2CHAR25(0) Field NAME2 in Upper CaseCHAR25
SOURCEBP_SOURCECHAR4(0) Source Key of Business Partner DataBP_SOURCE
CRUSERBP_CRUSERCHAR12(0) Entered bySYCHAR12
CRDATBP_CRDATDATS8(0) Creation DateDATUM
VIPBP_VIPCHAR1(0) TVIPBusiness Partner: VIP PartnerPAVIP
GROUP_DBP_GROUP_DCHAR4(0) TP13Target GroupBP_GROUP_D
DEL_INDBP_DEL_INDCHAR1(0) Deletion FlagXFELD
FDGRVFDGRVCHAR10(0) T035Planning groupFDGRPFF
BLNKZBLNKZCHAR2(0) T057Subsidy indicator for determining the reduction ratesBLNKZFB
KNRZEKNRZECHAR10(0) KNA1Head office account number (in branch accounts)KUNNRFB
XTITLEBP_XTITLECHAR50(0) Text of Form of AddressTEXT50
XTIT_LEBP_XTIT_LECHAR50(0) SalutationTEXT50
PAR_RELBP_PAR_RELCHAR1(0) Business Partner ReleasedBP_PAR_REL
NAME_LASTBP_NAMLASTCHAR40(0) Last NameTEXT40
NAME_FIRSTBP_NAMFRSTCHAR40(0) First NameTEXT40
TITLE_ACBP_TITL_ACCHAR20(0) Academic TitleTEXT20
N_PREFIXBP_PREFIXCHAR20(0) Name PrefixTEXT20
N_ADDITIONBP_ADDITNCHAR20(0) Name AffixTEXT20
NICKNAMEBP_NICKNAMCHAR20(0) Known AsTEXT20
SEXBP_SEX_OLDCHAR1(0) Gender of Business PartnerBP_SEX
PROFESSIONBP_PROFESSCHAR40(0) Description of Occupation for Business PartnerTEXT40
NATIONBP_CNTR_NCHAR3(0) T005NationalityLAND1
STATEBP_CNTR_STCHAR3(0) T005CitizenshipLAND1
BIRTH_DATEBP_BIRTHDDATS8(0) Date of Birth of Business PartnerDATUM
BIRTH_PLACBP_BIRTHPLCHAR40(0) BirthplaceTEXT40
BIRTH_NAMEBP_BIRTHNACHAR40(0) Name at BirthTEXT40
BIRTH_N_ADBP_BIRTH_ACHAR40(0) Name at Birth AffixTEXT40
DEATH_DATEBP_DEATH_DDATS8(0) Date of DeathDATUM
MARITAL_STBP_MARITALCHAR1(0) TB027Marital StatusBU_MARST
PROPRTY_STBP_PROPRTYNUMC2(0) TP04Marital Property RegimeBP_PROPRTY
CHILDRENUB_CHILDRNNUMC2(0) Number of Children (External Data Transfer)NUMC2
MEM_HOUSEUB_MEM_HOUNUMC2(0) Number of Household Members (External Data Transfer)NUMC2
INCOME_CURUB_BP_INC_CURCHAR5(0) Currency of Net IncomeCHAR5
NET_INCOMEUB_NET_INCNUMC15(0) Annual Net Income (External Data Transfer)NUM15
N_NET_INCOMEUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
MO_NET_INCUB_MO_INCNUMC15(0) Monthly Net Income of Business PartnerNUM15
N_MO_NET_INCUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
NET_INC_YBP_N_INC_YNUMC4(0) Year of Net Annual IncomeGJAHR
MO_INC_MBP_M_INC_MNUMC2(0) Calendar Month of Monthly Net IncomeBP_M_INC_M
MO_INC_YBP_M_INC_YNUMC4(0) Year of Monthly Net IncomeGJAHR
PERS_NRBP_PERS_NRCHAR15(0) Personnel NumberCHAR15
STAFF_GRPBP_STAFF_GCHAR4(0) TP05Employee GroupBP_STAFF_G
HR_ORG_REFHR_ORG_REFCHAR1(0) HR Org. LinkXFELD
XUBNAMEXUBNAMECHAR12(0) USR02User Name in User Master RecordXUBNAMEXUSSUSR
STAFF_REFBP_STAFF_RCHAR1(0) EmployeeXFELD
ORG_NAMEBP_NAME1CHAR40(0) Name 1 (surname for persons, otherwise company name)TEXT40
ORG_NAME2BP_NAME2CHAR40(0) Name 2 (Continuation of NAME 1)TEXT40
CALENDARIDBP_CAL_IDCHAR2(0) TFACDFactory calendarWFCID
LEGAL_ENTYBP_LEG_ETY_OLDNUMC2(0) TP08Legal Form of OrganizationBP_LEG_ETY
LEGAL_ORGBP_LEG_ORG_OLDNUMC2(0) TP09Legal Entity of OrganizationBP_LEG_ORG
BALANCE_FLBP_BAL_FLGCHAR1(0) Balance Sheet DisplayBP_BAL_FLG
FOUND_YEARBP_FOUND_YNUMC4(0) Foundation Year of OrganizationGJAHR
COMM_REGISBP_COM_REGCHAR50(0) Entry in Commercial RegisterTEXT50
COMM_REG_DBP_COM_R_DDATS8(0) Date of Entry in Commercial RegisterDATUM
CNTRY_COMPBP_CNTR_HDCHAR3(0) T005Country of Organization's Registered OfficeLAND1
COMP_HEADBP_COMP_HDCHAR35(0) Registered OfficeTEXT35
LIQUID_DATBP_LIQUI_DDATS8(0) Date of LiquidationDATUM
COMP_NRBBBNRNUMC7(0) International location number (part 1)NUM07FB
COMP_NR_ADBBSNRNUMC5(0) International location number (Part 2)NUM05FB
BUBKZBUBKZNUMC1(0) Check digit for the international location numberNUM01FB
IND_SECTORBP_SECTORCHAR10(0) TB023Business Partner: Industry (Organization)BU_INDSECT
MIN_RESERVBP_MIN_RSVCHAR1(0) Bank Subject to Minimum Reserve RequirementXFELD
BAL_SH_CURUB_BP_BAL_CURCHAR5(0) Balance Sheet CurrencyCHAR5
CAP_INCR_AUB_CA_IN_ANUMC15(0) Amount of Last Capital IncreaseNUM15
N_CAP_INCR_AUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
CAP_INCR_YBP_CA_IN_YNUMC4(0) Year of Last Capital IncreaseGJAHR
BANKLBANKKCHAR15(0) Bank KeysBANKKBNKFB
BANKSBANKSCHAR3(0) T005Bank country keyLAND1BKLFB
ADRNRBP_ADRNRCHAR10(0) SANS1Address NumberSADRNR
ADR_D_EBP_ADR_D_EDATS8(0) Business Partner Address Relationship Valid UntilDATUM
ADR_LOCBP_ADR_LOCCHAR20(0) BuildingCHAR20
FLOORBP_FLOORCHAR10(0) FloorCHAR10
ROOM_NRBP_ROOM_NRCHAR10(0) Room NumberCHAR10
NAME3BP_NAME3CHAR40(0) Name 3TEXT40
NAME4BP_NAME4CHAR40(0) Name 4TEXT40
NAME_COBP_NAME_COCHAR40(0) c/o NameTEXT40
PFACHPFACHCHAR10(0) PO BoxPFACHMG
PSTL2PSTL2CHAR10(0) P.O. Box Postal CodePSTLZFB
TELF1TELF1CHAR16(0) First telephone numberTEXT16SAP
TELF2TELF2CHAR16(0) Second telephone numberTEXT16SAP
TELFX1TELFXCHAR31(0) Fax NumberTEXT31FB
TELFX2TELFXCHAR31(0) Fax NumberTEXT31FB
TELBXTELBXCHAR15(0) Telebox numberTEXT15FB
TELX1TELX1CHAR30(0) Telex numberTEXT30FB
DATLTDATLTCHAR14(0) Data communication line no.TEXT14FB
TELTXTELTXCHAR30(0) Teletex numberTEXT30FB
EMPL_SINCEEMPL_DATEDATS8(0) Employed fromDATUM
EMPL_UNTILBP_EMP_UNTDATS8(0) Employed UntilDATUM
EMPLOYMENTBP_EMPLOYMNUMC2(0) TP11Employment StatusBP_EMPLOYM
EMP_SECTOREMP_SECTORCHAR10(0) TB023Industry; Only Relevant for Real Estate Business PartnerBU_INDSECT
EMPLOYEREMPLOYERCHAR35(0) EmployerTEXT35
BUSINESS_YBP_BUSIN_YNUMC4(0) Fiscal yearGJAHR
GEN_MEET_DBP_GE_ME_DDATS8(0) Date of Annual Stockholders MeetingDATUM
BU_Y_BEGINBP_B_Y_BEGDATS8(0) Fiscal Year Start DateDATUM
BU_Y_ENDBP_B_Y_ENDDATS8(0) Fiscal Year End DateDATUM
ANNUAL_ACCBP_ANN_ACCCHAR1(0) Year-End ClosingXFELD
ANNU_ACC_DBP_A_ACC_DDATS8(0) Year-End Closing Date for Fiscal YearDATUM
CONS_FST_DBP_C_FST_DDATS8(0) Date of Consolidated Financial Statements of Group CompanyDATUM
CAPI_STOCKUB_CAP_STKNUMC15(0) Authorized Capital Stock (External Data Transfer)NUM15
N_CAPI_STOCKUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
SHAR_STOCKUB_SHA_STKNUMC15(0) Stock Capital Issued (External Data Transfer)NUM15
N_SHAR_STOCKUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
PRSH_STOCKUB_PRS_STKNUMC15(0) Participation Certificates Outstanding (Ext. Data Transfer)NUM15
N_PRSH_STOCKUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
EQUITYUB_EQUITYNUMC15(0) Equity CapitalNUM15
N_EQUITYUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
GROSS_AMNTUB_GROSS_ANUMC15(0) Gross ContributionNUM15
N_GROSS_AMNTUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
NET_AMOUNTUB_NET_ANUMC15(0) Net ContributionNUM15
N_NET_AMOUNTUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
TURNOVERUB_TURNOVRNUMC15(0) Annual SalesNUM15
N_TURNOVERUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
DIV_DIS_AMUB_DIV_DISNUMC15(0) Dividend/Profit Distribution AmountNUM15
N_DIV_DIS_AMUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
DEBTS_FACTUB_DEBTS_FNUMC6(0) Debt RatioNUM06
N_DEBTS_FACTUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
DIS_PROFITUB_PROFITNUMC15(0) Profit Reported by OrganizationNUM15
N_DIS_PROFITUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
BAL_AMOUNTUB_BAL_AMTNUMC15(0) Balance Sheet TotalNUM15
N_BAL_AMOUNTUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
REL_TYPBP_REL_TYP_OLDCHAR4(0) TPZ7Business Partner Relationship CategoryBP_REL_TYP
PARTNR2BP_PARTNR_OLDCHAR10(0) BP000Business Partner NumberBP_PARTNRBPN
DIF_TYP1BP_DIF_TYPCHAR4(0) TPZ8Business Partner - Differentiation CategoryBP_DIF_TYP
DIF_TYP2BP_DIF_TYPCHAR4(0) TPZ8Business Partner - Differentiation CategoryBP_DIF_TYP
REL_DATBP_REL_DATDATS8(0) Start of Validity of BP-BP RelationshipDATUM
RELATBP_RELAT_OLDCHAR4(0) TPZ11Relationship TypeBP_RELAT
REL_ENDBP_REL_ENDDATS8(0) End of Validity of BP-BP RelationshipDATUM
REL_PERUB_REL_PERNUMC10(0) Percentage Rate of RelationshipNUM10
N_REL_PERUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
REL_AMOUB_REL_AMONUMC13(0) Relationship AmountNUM13
N_REL_AMOUB_KOMMANUMC1(0) Number of decimal places from legacy systemNUM1
REL_CURUB_WHRCHAR5(0) Currency ISO codeCHAR5WHRFVV
FUNCTNBP_FUNCTNCHAR4(0) TB912Partner FunctionBU_PAFKT
DEPARTBP_DEPARTCHAR4(0) TB910Business Partner's DepartmentBU_ABTNR
KONZSKONZSCHAR10(0) Group keyKONZSFB
LIFNRLIFNRCHAR10(0) *Account Number of Vendor or CreditorLIFNRLIFFBKRED_CLIFNR
VBUNDRASSCCHAR6(0) *Company ID of trading partnerRCOMPPGSFG
BEGRUBRGRUCHAR4(0) TBRGAuthorization GroupBRGRUFB
XZEMPXZEMPCHAR1(0) Indicator: Alternative payee in document allowed ?XFELDFB
KNRZAKNRZACHAR10(0) *Account number of an alternative payerKUNNRFB
DTAMSDTAMSCHAR1(0) Indicator for Data Medium ExchangeDTAMSFB
DTAWSDTAWSCHAR2(0) *Instruction key for data medium exchangeDTAWSFB
ESRNRESRNRCHAR11(0) ISR Subscriber NumberESRNRFB
PART_COBP_PART_COCHAR4(0) *Partner-Company Code AllocationBUKRS
MABERMABERCHAR2(0) T047MDunning AreaMABERFB
MAHNAMAHNACHAR4(0) T047ADunning ProcedureMAHNAFB
MANSPMANSPCHAR1(0) T040SDunning blockMANSPFB
MADATMADATDATS8(0) Last dunned onDATUMFB
MAHNSMAHNS_DNUMC1(0) Dunning levelMAHNSFB
KNRMAKNRMACHAR10(0) KNA1Account number of the dunning recipientKUNNRKUNFBM
GMVDTGMVDTDATS8(0) Date of the legal dunning proceedingsDATUMFBM
BUSABBUSAB_MACHAR2(0) T001SDunning clerkBUSABFBM
MGRUPMGRUPCHAR2(0) T047RKey for dunning notice groupingMGRUPFBZ
DE_OATHBP_DE_OATHCHAR1(0) AffidavitXFELD
DE_OA_DBP_DE_OA_DDATS8(0) Date of affidavitDATUM
BANKRUPBP_BANKRUPCHAR1(0) Launch Bankruptcy ProceedingsXFELD
BNKRY_DBP_BNKRY_DDATS8(0) Commencement Date of Bankruptcy ProceedingsDATUM
FORECLOBP_FORECLOCHAR1(0) ForeclosureXFELD
FORCL_DBP_FORCL_DDATS8(0) Date of foreclosureDATUM
SOLVNCYBP_SOLVNCYCHAR1(0) Credit StandingBP_SOLVNCY
SOL_INSBP_SOL_INSCHAR4(0) *Institute Providing Credit Standing InformationBP_SOL_INS
SOL_INFBP_SOL_INFCHAR1(0) Status of Credit Standing InformationBP_SOL_INF
SOL_TXTBP_SOL_TXTCHAR50(0) Additional Credit Standing InformationTEXT50
SOL_I_DBP_SOL_I_DDATS8(0) Date of Credit Standing InformationDATUM
RATINGBP_RATINGCHAR3(0) *RatingBP_RATING
NRESIDTBP_NRESIDTCHAR1(0) Non-Resident According to Paragraph 4 AWGXFELD
NRESI_DBP_NRESI_DDATS8(0) Start of Non-Residency According to Paragraph 4 AWGDATUM
KWG_RLVBP_KWG_RLVCHAR1(0) Recipient of Multimillion Loan According to Paragraph 14 GBAXFELD
KWG_NRBP_KWG_NRCHAR8(0) Borrower Number for Reporting a Loan According to GBACHAR8
KWG_ENRBP_KWG_ENRCHAR8(0) Borrower Entity Number Used to Report Loan acc. to GBACHAR8
KWG_CREBP_KWG_CRENUMC2(0) TP12Credit Standing Review According to Paragraph 18 GBABP_KWG_CRE
KWG_CRE_DBP_KWG_CRE_DDATS8(0) Date of Credit Standing Review According to Paragraph 18 GBADATUM
KWG_ORGBP_KWG_ORGNUMC2(0) *Loan to Manager According to Paragraph 15 German Banking ActBP_KWG_ORG
COMP_REBP_COMP_RECHAR1(0) Organization RelationshipBP_COMP_RE
XID_ATVVXID_AT_FSCHAR11(0) (OeNB) Ident NumberVVXID_AT_FS
SZG_ATVVSZG_AT_FSCHAR2(0) TD05_AT_FSTarget Group According to OeNBVVSZG_AT_FS
SID_ATVVSID_AT_FSCHAR1(0) Assign (OeNB) Ident NumberBP_JANEI
SINLZ_ATVVSINLZ_ATCHAR7(0) Institute Number According to OeNBVVSINLZ_AT
SINME_ATVVSINME_ATCHAR1(0) Institute Subject to Austrian Reg. Reporting RequirementsXFELD
GID_ATVVGID_ATCHAR15(0) Group ID
GIDTYPE_ATVVGIDTYPE_ATCHAR1(0) Group Assignment CategoryVVGIDTYPE_AT
GNAME_ATVVGNAME_ATCHAR50(0) Group NameTEXT50
BAL_SHBP_BAL_SHCHAR1(0) Balance Sheet DisplayBP_BAL_SH
VZSKZVZSKZCHAR2(0) *Interest calculation indicatorVZSKZFB
DATLZDATLZDATS8(0) Date of the last interest calculation runDATUMFB
WAKONWAKONCHAR4(0) Terms of payment key for bill of exchange chargesZTERMFB
XZVERXZVERCHAR1(0) Indicator: Record Payment History ?XFELDFB
TOGRUTOGRUCHAR4(0) *Tolerance group for the business partner/G/L accountTOGRUFB
KULTGUB_KULTGNUMC3(0) Probable Time Until Check Is EncashedNUMC3FB
URLIDURLIDCHAR4(0) *Short Key for Known/Negotiated LeaveURLID
STCD1STCD1CHAR16(0) Tax Number 1STCD1FB
STCD2STCD2CHAR11(0) Tax Number 2STCD2FB
TAX_RESBP_TAX_RESCHAR1(0) Tax Non-Resident IndicatorXFELD
COUNCCOUNCCHAR3(0) *County CodeCOUNCSAP
CITYCCITYCCHAR4(0) *City CodeCITYCFB
STKZASTKZACHAR1(0) Indicator: Business Partner Subject to Equalization Tax?STKZAFB
STKZUSTKZUCHAR1(0) Liable for VATXFELDFB
STCEGSTCEGCHAR20(0) VAT Registration NumberSTCEGFB
TXJCDTXJCDCHAR15(0) *Tax JurisdictionTXJCDTXJFB
COUNTRYLAND1CHAR3(0) *Country KeyLAND1LNDFB
REGIONREGIOCHAR3(0) *STATE (State, Province, County)REGIOFB
FISKNFISKN_DCHAR10(0) *Account number of the master record with the fiscal addressKUNNRFB


View list of all tables