SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OPOR386Purchase Order
9JDT1124Journal Entry - Rows
10OACT114G/L Accounts

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
1ERP EHP76.0REGUP1911Processed items from payment program
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, LAUFD, LAUFI, XVORL, ZBUKR, LIFNR, KUNNR, EMPFG, VBLNR, BUKRS, BELNR, GJAHR, BUZEI, FILKD, ZLSCH, WAERS, HBKID, BVTYP, POKEN, XBLNR, BLART, BUDAT, BLDAT, KOART, BSCHL, HKONT, SAKNR, UMSKZ, UMSKS, ZUMSK, SHKZG, DMBTR, WRBTR, BDIFF, GSBER, MWSKZ, MWSTS, WMWST, MWSK1, DMBT1, WRBT1, MWSK2, DMBT2, WRBT2, MWSK3, DMBT3, WRBT3, SGTXT, ZFBDT, ZTERM, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, SKFBT, SKNTO, WSKTO, ZBFIX, ZLSPR, SPLEV, XREBZ, ZOLLT, ZOLLD, LZBKZ, LANDL, DIEKZ, QSSKZ, QSSHB, QBSHB, QBSHH, ESRNR, ESRRE, ESRPZ, ZBDXT, ZBDXP, MSHBT, MSFBT, PROJN, AUFNR, ANLN1, ANLN2, EBELN, EBELP, XANET, XNETB, XNACH, ZWELS, VBUND, STCEG, EGBLD, EGLLD, QSZNR, BDIF2, DSKVH, POKLA, FIPOS, PROJK, NPLNR, AUFPL, APLZL, XEGDR, BDIF3, DMBE2, DMBE3, MWST2, SKNT2, SKNT3, QBSH2, QBSH3, DMB21, DMB22, DMB23, DMB31, DMB32, DMB33, UZAWE, MWST3, ZUONR, OSKTO, VERTN, IMKEY, REBZT, REBZG, REBZJ, REBZZ, KOSTL, XINVE, VBEL2, VPOS2, ZEKKN, POSN2, ETEN2, FISTL, GEBER, DABRZ, KKBER, EMPFB, PRCTR, XREF1, XREF2, XREF3, ZINKZ, DTWS1, DTWS2, DTWS3, DTWS4, MANSP, KIDNO, XCPDD, VERTT, VBEWA, AGZEI, PSWSL, PSWBT, PSSKT, XPYAM, GDIFF, GDIF2, GDIF3, BUPLA, SECCO, XSAEN, KBLNR, KBLPOS, CESSION_KZ, KEYNO, PAMTF, ORIGIN, PENLC1, PENLC2, PENLC3, PENFC, PENDAYS, PPRCT, GRANT_NBR, FKBER, SNAME1, SORT01, SLAND1, SAMNR, MABER, BUDGET_PD, SNAME2, SNAME3, SNAME4, SSTRAS, SSTRS2, SPSTLZ, SID, EXTACCOUNT FROM REGUP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2LAUFDDate on Which the Program Is to Be Runnvarchar80DATS(N'00000000')NoLAUFD Allow NULL? 
3LAUFIAdditional Identificationnvarchar60CHAR(N' ')NoLAUFI Allow NULL? 
4XVORLIndicator: Only Proposal Run?char10CHAR(N' ')NoXVORL Allow NULL? 
5ZBUKRPaying company codenvarchar40CHAR(N' ')NoT001DZBUKR Allow NULL? 
6LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')NoLFA1LIFNR Allow NULL? 
7KUNNRCustomer Numbernvarchar100CHAR(N' ')NoKNA1KUNNR Allow NULL? 
8EMPFGPayee codenvarchar160CHAR(N' ')NoEMPFG Allow NULL? 
9VBLNRDocument Number of the Payment Documentnvarchar100CHAR(N' ')NoVBLNR Allow NULL? 
10BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
11BELNRAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
12GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
13BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
14FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
15ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZDZLSCH Allow NULL? 
16WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
17HBKIDShort Key for a House Banknvarchar50CHAR(N' ')YesT012HBKID Allow NULL? 
18BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
19POKENItem Indicatornvarchar30CHAR(N' ')YesPOKEN Allow NULL? 
20XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
21BLARTDocument Typenvarchar20CHAR(N' ')YesT003BLART Allow NULL? 
22BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
23BLDATDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
24KOARTAccount Typechar10CHAR(N' ')YesKOART Allow NULL? 
25BSCHLPosting Keynvarchar20CHAR(N' ')YesTBSLBSCHL Allow NULL? 
26HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')YesSKB1HKONT Allow NULL? 
27SAKNRG/L Account Numbernvarchar100CHAR(N' ')YesSKB1SAKNR Allow NULL? 
28UMSKZSpecial G/L Indicatorchar10CHAR(N' ')YesT074UUMSKZ Allow NULL? 
29UMSKSSpecial G/L Transaction Typechar10CHAR(N' ')YesUMSKS Allow NULL? 
30ZUMSKTarget Special G/L Indicatorchar10CHAR(N' ')YesT074UDZUMSK Allow NULL? 
31SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
32DMBTRAmount in Local Currencydecimal132CURR((0))YesDMBTR
33WRBTRAmount in document currencydecimal132CURR((0))YesWRBTR
34BDIFFValuation Differencedecimal132CURR((0))YesBDIFF
35GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
36MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
37MWSTSTax Amount in Local Currencydecimal132CURR((0))YesMWSTS
38WMWSTTax amount in document currencydecimal132CURR((0))YesWMWST
39MWSK1Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
40DMBT1Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
41WRBT1Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
42MWSK2Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
43DMBT2Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
44WRBT2Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
45MWSK3Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
46DMBT3Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
47WRBT3Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
48SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
49ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
50ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
51ZBD1TCash discount days 1decimal30DEC((0))YesDZBD1T
52ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
53ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
54ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
55ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
56SKFBTAmount Eligible for Cash Discount in Document Currencydecimal132CURR((0))YesSKFBT
57SKNTOCash discount amount in local currencydecimal132CURR((0))YesSKNTO
58WSKTOCash discount amount in document currencydecimal132CURR((0))YesWSKTO
59ZBFIXFixed Payment Termschar10CHAR(N' ')YesDZBFIX Allow NULL? 
60ZLSPRPayment Block Keychar10CHAR(N' ')YesT008DZLSPR Allow NULL? 
61SPLEVLevel on Which a Payment Block has Taken Placechar10CHAR(N' ')YesSPLEV Allow NULL? 
62XREBZIndicator: Item is an Invoice-Related Credit Memochar10CHAR(N' ')YesXREBZ Allow NULL? 
63ZOLLTCustoms Tariff Numbernvarchar80CHAR(N' ')YesDZOLLT Allow NULL? 
64ZOLLDCustoms Datenvarchar80DATS(N'00000000')YesDZOLLD Allow NULL? 
65LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')YesT015LLZBKZ Allow NULL? 
66LANDLSupplying Countrynvarchar30CHAR(N' ')YesT005LANDL Allow NULL? 
67DIEKZService Indicator (Foreign Payment)char10CHAR(N' ')YesDIEKZ Allow NULL? 
68QSSKZWithholding Tax Codenvarchar20CHAR(N' ')Yes*QSSKZ Allow NULL? 
69QSSHBWithholding Tax Base Amountdecimal132CURR((0))YesQSSHB
70QBSHBWithholding Tax Amount (in Document Currency)decimal132CURR((0))YesQBSHB
71QBSHHWithholding Tax Amount (in Local Currency)decimal132CURR((0))YesQBSHH
72ESRNRISR Subscriber Numbernvarchar110CHAR(N' ')YesESRNR Allow NULL? 
73ESRREISR Reference Numbernvarchar270CHAR(N' ')YesESRRE Allow NULL? 
74ESRPZISR Check Digitnvarchar20CHAR(N' ')YesESRPZ Allow NULL? 
75ZBDXTSelected cash discount daysdecimal30DEC((0))YesDZBDXT
76ZBDXPSelected cash discount percentage ratedecimal53DEC((0))YesDZBDXP
77MSHBTMaximum Cash Discount Amount in Local Currencydecimal132CURR((0))YesMSHBT
78MSFBTMaximum Cash Discount Amount in Foreign Currencydecimal132CURR((0))YesMSFBT
79PROJNOld: Project number : No longer used --> PS_POSNRnvarchar160CHAR(N' ')YesPROJN Allow NULL? 
80AUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
81ANLN1Main Asset Numbernvarchar120CHAR(N' ')YesANLHANLN1 Allow NULL? 
82ANLN2Asset Subnumbernvarchar40CHAR(N' ')YesANLAANLN2 Allow NULL? 
83EBELNPurchasing Document Numbernvarchar100CHAR(N' ')YesEKKOEBELN Allow NULL? 
84EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')YesEKPOEBELP Allow NULL? 
85XANETIndicator: Down payment in net procedure ?char10CHAR(N' ')YesXANET Allow NULL? 
86XNETBIndicator: Document posted net ?char10CHAR(N' ')YesXNETB Allow NULL? 
87XNACHIndicator: Document Data Must be Rereadchar10CHAR(N' ')YesXNACH Allow NULL? 
88ZWELSList of the Payment Methods to be Considerednvarchar100CHAR(N' ')YesDZWELS Allow NULL? 
89VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')YesT880RASSC Allow NULL? 
90STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
91EGBLDCountry of Destination for Delivery of Goodsnvarchar30CHAR(N' ')Yes*EGBLD Allow NULL? 
92EGLLDSupplying Country for Delivery of Goodsnvarchar30CHAR(N' ')Yes*EGLLD Allow NULL? 
93QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100CHAR(N' ')YesQSZNR Allow NULL? 
94BDIF2Valuation Difference for the Second Local Currencydecimal132CURR((0))YesBDIF2
95DSKVHImpending Lost Cash Discount in Local Currencydecimal132CURR((0))YesDSKVH
96POKLAItem Classification for Online Check Printingchar10CHAR(N' ')YesPOKLA Allow NULL? 
97FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
98PROJKWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
99NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
100AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
101APLZLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
102XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
103BDIF3Valuation Difference for the Third Local Currencydecimal132CURR((0))YesBDIF3
104DMBE2Amount in Second Local Currencydecimal132CURR((0))YesDMBE2
105DMBE3Amount in Third Local Currencydecimal132CURR((0))YesDMBE3
106MWST2Tax Amount in Second Local Currencydecimal132CURR((0))YesMWST2
107SKNT2Cash Discount Amount in Second Local Currencydecimal132CURR((0))YesSKNT2
108SKNT3Cash Discount Amount in Third Local Currencydecimal132CURR((0))YesSKNT3
109QBSH2Withholding Tax Amount in Second Local Currencydecimal132CURR((0))YesQBSH2
110QBSH3Withholding Tax Amount in Third Local Currencydecimal132CURR((0))YesQBSH3
111DMB21Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
112DMB22Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
113DMB23Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
114DMB31Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
115DMB32Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
116DMB33Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
117UZAWEPayment Method Supplementnvarchar20CHAR(N' ')YesT042FUZAWE Allow NULL? 
118MWST3Tax Amount in Third Local Currencydecimal132CURR((0))YesMWST3
119ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
120OSKTOCash discount amount in local currencydecimal132CURR((0))YesSKNTO
121VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
122IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
123REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
124REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
125REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40NUMC(N'0000')YesREBZJ Allow NULL? 
126REBZZLine Item in the Relevant Invoicenvarchar30NUMC(N'000')YesREBZZ Allow NULL? 
127KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
128XINVEIndicator: Capital Goods Affected?char10CHAR(N' ')YesXINVE Allow NULL? 
129VBEL2Sales Documentnvarchar100CHAR(N' ')Yes*VBELN_VA Allow NULL? 
130VPOS2Numeric field: Length 6nvarchar60NUMC(N'000000')YesNUM06 Allow NULL? 
131ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
132POSN2Sales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
133ETEN2Delivery Schedule Line Numbernvarchar40NUMC(N'0000')Yes*ETENR Allow NULL? 
134FISTLFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
135GEBERFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
136DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
137KKBERCredit control areanvarchar40CHAR(N' ')YesT014KKBER Allow NULL? 
138EMPFBPayee/Payernvarchar100CHAR(N' ')YesEMPFB Allow NULL? 
139PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
140XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
141XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
142XREF3Reference key for line itemnvarchar200CHAR(N' ')YesXREF3 Allow NULL? 
143ZINKZExempted from interest calculationnvarchar20CHAR(N' ')YesDZINKZ Allow NULL? 
144DTWS1Instruction key 1nvarchar20NUMC(N'00')Yes*DTAT16 Allow NULL? 
145DTWS2Instruction key 2nvarchar20NUMC(N'00')Yes*DTAT17 Allow NULL? 
146DTWS3Instruction key 3nvarchar20NUMC(N'00')Yes*DTAT18 Allow NULL? 
147DTWS4Instruction key 4nvarchar20NUMC(N'00')Yes*DTAT19 Allow NULL? 
148MANSPDunning blockchar10CHAR(N' ')Yes*MANSP Allow NULL? 
149KIDNOPayment Referencenvarchar300CHAR(N' ')YesKIDNO Allow NULL? 
150XCPDDIndicator: Address and bank data set individuallychar10CHAR(N' ')YesXCPDD Allow NULL? 
151VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
152VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
153AGZEIClearing Itemdecimal50DEC((0))YesAGZEI
154PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50CUKY(N' ')Yes*PSWSL Allow NULL? 
155PSWBTAmount for Updating in General Ledgerdecimal132CURR((0))YesPSWBT
156PSSKTCash Discount Deduction for the Itemdecimal132CURR((0))YesPSSKT
157XPYAMIndicator: Payment Amount Predefinedchar10CHAR(N' ')YesXPYAM Allow NULL? 
158GDIFFTotal Exchange Rate Differencedecimal132CURR((0))YesGDIFF
159GDIF2Total Exchange Rate Differencedecimal132CURR((0))YesGDIFF
160GDIF3Total Exchange Rate Differencedecimal132CURR((0))YesGDIFF
161BUPLABusiness Placenvarchar40CHAR(N' ')Yes*BUPLA Allow NULL? 
162SECCOSection Codenvarchar40CHAR(N' ')Yes*SECCO Allow NULL? 
163XSAENIndicator: Unconfirmed master data changechar10CHAR(N' ')YesXSAEN Allow NULL? 
164KBLNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')Yes*KBLNR_FI Allow NULL? 
165KBLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')Yes*KBLPOS Allow NULL? 
166CESSION_KZAccounts Receivable Pledging Indicatornvarchar20CHAR(N' ')YesTCESSIONCESSION_KZ Allow NULL? 
167KEYNOKey Number for Payment Requestnvarchar100CHAR(N' ')Yes*PRQ_KEYNO Allow NULL? 
168PAMTFPayment Request Amount in Payment Currencydecimal132CURR((0))YesPRQ_AMTFC
169ORIGINOrigin Indicatornvarchar80CHAR(N' ')YesTFIBLORIGINFIBL_ORIGIN Allow NULL? 
170PENLC1Penalty charge amount in first local currencydecimal132CURR((0))YesPENALTY1
171PENLC2Penalty charge amount in second local currencydecimal132CURR((0))YesPENALTY2
172PENLC3Penalty Charge Amount in Third Local Currencydecimal132CURR((0))YesPENALTY3
173PENFCPenalty charge amount in document currencydecimal132CURR((0))YesPENALTY
174PENDAYSNumber of days for penalty charge calculationint100INT4((0))YesPDAYS Allow NULL? 
175PPRCTPartner Profit Centernvarchar100CHAR(N' ')Yes*PPRCTR Allow NULL? 
176GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
177FKBERFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
178SNAME1Name 1nvarchar350CHAR(N' ')YesNAME1_GP Allow NULL? 
179SORT01Citynvarchar350CHAR(N' ')YesORT01_GP Allow NULL? 
180SLAND1Country Keynvarchar30CHAR(N' ')Yes*LAND1_GP Allow NULL? 
181SAMNRInvoice List Numbernvarchar80NUMC(N'00000000')YesSAMNR Allow NULL? 
182MABERDunning Areanvarchar20CHAR(N' ')Yes*MABER Allow NULL? 
183BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
184SNAME2Name 2nvarchar350CHAR(N' ')YesNAME2_GP Allow NULL? 
185SNAME3Name 3nvarchar350CHAR(N' ')YesNAME3_GP Allow NULL? 
186SNAME4Name 4nvarchar350CHAR(N' ')YesNAME4_GP Allow NULL? 
187SSTRASHouse number and streetnvarchar350CHAR(N' ')YesSTRAS_GP Allow NULL? 
188SSTRS2House number and streetnvarchar350CHAR(N' ')YesSTRAS_GP Allow NULL? 
189SPSTLZPostal codenvarchar100CHAR(N' ')YesPSTLZ_BAS Allow NULL? 
190SIDOriginal Payer of a Payment (ID)nvarchar350CHAR(N' ')YesSENDER_ID Allow NULL? 
191EXTACCOUNTExternal Accountnvarchar100CHAR(N' ')YesTPM_EXT_ACCOUNT Allow NULL? 
NamePrimaryUniqueTypeColumns
REGUP~0YesYesCLUSTEREDBUZEI, GJAHR, BELNR, BUKRS, VBLNR, EMPFG, KUNNR, LIFNR, ZBUKR, XVORL, LAUFI, LAUFD, MANDT