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
7BSEG345Accounting Document Segment
8/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
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
4OVTG52Tax Definition
5ORDR386Sales Order
6INV1265A/R Invoice - Rows
7OJDT100Journal Entry
8OPCH386A/P Invoice
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

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

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

SELECT MANDT, BUKRS, LIFNR, UMSKS, UMSKZ, AUGDT, AUGBL, ZUONR, GJAHR, BELNR, BUZEI, BUDAT, BLDAT, CPUDT, WAERS, XBLNR, BLART, MONAT, BSCHL, ZUMSK, SHKZG, GSBER, MWSKZ, DMBTR, WRBTR, MWSTS, WMWST, BDIFF, BDIF2, SGTXT, PROJN, AUFNR, ANLN1, ANLN2, EBELN, EBELP, SAKNR, HKONT, FKONT, FILKD, ZFBDT, ZTERM, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, SKFBT, SKNTO, WSKTO, ZLSCH, ZLSPR, ZBFIX, HBKID, BVTYP, REBZG, REBZJ, REBZZ, SAMNR, ZOLLT, ZOLLD, LZBKZ, LANDL, DIEKZ, MANSP, MSCHL, MADAT, MANST, MABER, XNETB, XANET, XCPDD, XESRD, XZAHL, MWSK1, DMBT1, WRBT1, MWSK2, DMBT2, WRBT2, MWSK3, DMBT3, WRBT3, QSSKZ, QSSHB, QBSHB, BSTAT, ANFBN, ANFBJ, ANFBU, VBUND, REBZT, STCEG, EGBLD, EGLLD, QSZNR, QSFBT, XINVE, PROJK, FIPOS, NPLNR, AUFPL, APLZL, XEGDR, DMBE2, DMBE3, DMB21, DMB22, DMB23, DMB31, DMB32, DMB33, MWST2, MWST3, SKNT2, SKNT3, BDIF3, XRAGL, RSTGR, UZAWE, KOSTL, LNRAN, XSTOV, KZBTR, XREF1, XREF2, XARCH, PSWSL, PSWBT, IMKEY, ZEKKN, FISTL, GEBER, DABRZ, XNEGP, EMPFB, PRCTR, XREF3, DTWS1, DTWS2, DTWS3, DTWS4, XPYPR, KIDNO, PYCUR, PYAMT, BUPLA, SECCO, PPDIFF, PPDIF2, PPDIF3, PENLC1, PENLC2, PENLC3, PENFC, PENDAYS, PENRC, VERTT, VERTN, VBEWA, KBLNR, KBLPOS, GRANT_NBR, GMVKZ, SRTYPE, LOTKZ, ZINKZ, FKBER, INTRENO, PPRCT, BUZID, AUGGJ, HKTID, BUDGET_PD, KONTT, KONTL, UEBGDAT, VNAME, EGRUP, BTYPE, PROPMANO FROM BSAK_BAK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoLFB1BUKRS Allow NULL? 
3LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')NoLFA1LIFNR Allow NULL? 
4UMSKSSpecial G/L Transaction Typechar10CHAR(N' ')NoUMSKS Allow NULL? 
5UMSKZSpecial G/L Indicatorchar10CHAR(N' ')No*UMSKZ Allow NULL? 
6AUGDTClearing Datenvarchar80DATS(N'00000000')NoAUGDT Allow NULL? 
7AUGBLDocument Number of the Clearing Documentnvarchar100CHAR(N' ')NoAUGBL Allow NULL? 
8ZUONRAssignment Numbernvarchar180CHAR(N' ')NoDZUONR Allow NULL? 
9GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
10BELNRAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
11BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
12BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
13BLDATDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
14CPUDTDay On Which Accounting Document Was Enterednvarchar80DATS(N'00000000')YesCPUDT Allow NULL? 
15WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
16XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
17BLARTDocument Typenvarchar20CHAR(N' ')Yes*BLART Allow NULL? 
18MONATFiscal Periodnvarchar20NUMC(N'00')YesMONAT Allow NULL? 
19BSCHLPosting Keynvarchar20CHAR(N' ')Yes*BSCHL Allow NULL? 
20ZUMSKTarget Special G/L Indicatorchar10CHAR(N' ')Yes*DZUMSK Allow NULL? 
21SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
22GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
23MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
24DMBTRAmount in Local Currencydecimal132CURR((0))YesDMBTR
25WRBTRAmount in document currencydecimal132CURR((0))YesWRBTR
26MWSTSTax Amount in Local Currencydecimal132CURR((0))YesMWSTS
27WMWSTTax amount in document currencydecimal132CURR((0))YesWMWST
28BDIFFValuation Differencedecimal132CURR((0))YesBDIFF
29BDIF2Valuation Difference for the Second Local Currencydecimal132CURR((0))YesBDIF2
30SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
31PROJNOld: Project number : No longer used --> PS_POSNRnvarchar160CHAR(N' ')YesPROJN Allow NULL? 
32AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
33ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
34ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
35EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
36EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
37SAKNRG/L Account Numbernvarchar100CHAR(N' ')Yes*SAKNR Allow NULL? 
38HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')Yes*HKONT Allow NULL? 
39FKONTFinancial Budget Itemnvarchar30NUMC(N'000')YesFIPLS Allow NULL? 
40FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
41ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
42ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
43ZBD1TCash discount days 1decimal30DEC((0))YesDZBD1T
44ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
45ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
46ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
47ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
48SKFBTAmount Eligible for Cash Discount in Document Currencydecimal132CURR((0))YesSKFBT
49SKNTOCash discount amount in local currencydecimal132CURR((0))YesSKNTO
50WSKTOCash discount amount in document currencydecimal132CURR((0))YesWSKTO
51ZLSCHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
52ZLSPRPayment Block Keychar10CHAR(N' ')Yes*DZLSPR Allow NULL? 
53ZBFIXFixed Payment Termschar10CHAR(N' ')YesDZBFIX Allow NULL? 
54HBKIDShort Key for a House Banknvarchar50CHAR(N' ')Yes*HBKID Allow NULL? 
55BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
56REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
57REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40NUMC(N'0000')YesREBZJ Allow NULL? 
58REBZZLine Item in the Relevant Invoicenvarchar30NUMC(N'000')YesREBZZ Allow NULL? 
59SAMNRInvoice List Numbernvarchar80NUMC(N'00000000')YesSAMNR Allow NULL? 
60ZOLLTCustoms Tariff Numbernvarchar80CHAR(N' ')YesDZOLLT Allow NULL? 
61ZOLLDCustoms Datenvarchar80DATS(N'00000000')YesDZOLLD Allow NULL? 
62LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')Yes*LZBKZ Allow NULL? 
63LANDLSupplying Countrynvarchar30CHAR(N' ')Yes*LANDL Allow NULL? 
64DIEKZService Indicator (Foreign Payment)char10CHAR(N' ')YesDIEKZ Allow NULL? 
65MANSPDunning blockchar10CHAR(N' ')Yes*MANSP Allow NULL? 
66MSCHLDunning keychar10CHAR(N' ')Yes*MSCHL Allow NULL? 
67MADATLast dunned onnvarchar80DATS(N'00000000')YesMADAT Allow NULL? 
68MANSTDunning levelchar10NUMC(N'0')YesMAHNS_D Allow NULL? 
69MABERDunning Areanvarchar20CHAR(N' ')Yes*MABER Allow NULL? 
70XNETBIndicator: Document posted net ?char10CHAR(N' ')YesXNETB Allow NULL? 
71XANETIndicator: Down payment in net procedure ?char10CHAR(N' ')YesXANET Allow NULL? 
72XCPDDIndicator: Address and bank data set individuallychar10CHAR(N' ')YesXCPDD Allow NULL? 
73XESRDIndicator: Is any ISR data set in the document ?char10CHAR(N' ')YesXESRD Allow NULL? 
74XZAHLIndicator: Is the posting key used in a payment transaction?char10CHAR(N' ')YesXZAHL Allow NULL? 
75MWSK1Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
76DMBT1Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
77WRBT1Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
78MWSK2Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
79DMBT2Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
80WRBT2Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
81MWSK3Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
82DMBT3Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
83WRBT3Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
84QSSKZWithholding Tax Codenvarchar20CHAR(N' ')Yes*QSSKZ Allow NULL? 
85QSSHBWithholding Tax Base Amountdecimal132CURR((0))YesQSSHB
86QBSHBWithholding Tax Amount (in Document Currency)decimal132CURR((0))YesQBSHB
87BSTATDocument Statuschar10CHAR(N' ')YesBSTAT_D Allow NULL? 
88ANFBNDocument Number of the Bill of Exchange Payment Requestnvarchar100CHAR(N' ')YesANFBN Allow NULL? 
89ANFBJFiscal Year of the Bill of Exchange Payment Request Documentnvarchar40NUMC(N'0000')YesANFBJ Allow NULL? 
90ANFBUCompany Code in Which Bill of Exch.Payment Request Is Postednvarchar40CHAR(N' ')Yes*ANFBU Allow NULL? 
91VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')Yes*RASSC Allow NULL? 
92REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
93STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
94EGBLDCountry of Destination for Delivery of Goodsnvarchar30CHAR(N' ')Yes*EGBLD Allow NULL? 
95EGLLDSupplying Country for Delivery of Goodsnvarchar30CHAR(N' ')Yes*EGLLD Allow NULL? 
96QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100CHAR(N' ')YesQSZNR Allow NULL? 
97QSFBTWithholding Tax-Exempt Amount (in Document Currency)decimal132CURR((0))YesQSFBT
98XINVEIndicator: Capital Goods Affected?char10CHAR(N' ')YesXINVE Allow NULL? 
99PROJKWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
100FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
101NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
102AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
103APLZLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
104XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
105DMBE2Amount in Second Local Currencydecimal132CURR((0))YesDMBE2
106DMBE3Amount in Third Local Currencydecimal132CURR((0))YesDMBE3
107DMB21Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
108DMB22Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
109DMB23Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
110DMB31Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
111DMB32Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
112DMB33Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
113MWST2Tax Amount in Second Local Currencydecimal132CURR((0))YesMWST2
114MWST3Tax Amount in Third Local Currencydecimal132CURR((0))YesMWST3
115SKNT2Cash Discount Amount in Second Local Currencydecimal132CURR((0))YesSKNT2
116SKNT3Cash Discount Amount in Third Local Currencydecimal132CURR((0))YesSKNT3
117BDIF3Valuation Difference for the Third Local Currencydecimal132CURR((0))YesBDIF3
118XRAGLIndicator: Clearing was Reversedchar10CHAR(N' ')YesXRAGL Allow NULL? 
119RSTGRReason Code for Paymentsnvarchar30CHAR(N' ')Yes*RSTGR Allow NULL? 
120UZAWEPayment Method Supplementnvarchar20CHAR(N' ')YesT042FUZAWE Allow NULL? 
121KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
122LNRANSequence number of asset line items in fiscal yearnvarchar50NUMC(N'00000')YesANEKLNRAN Allow NULL? 
123XSTOVIndicator: Document is flagged for reversalchar10CHAR(N' ')YesXSTOV Allow NULL? 
124KZBTROriginal Reduction Amount in Local Currencydecimal132CURR((0))YesKZBTR_FI
125XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
126XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
127XARCHIndicator: Document already archived ?char10CHAR(N' ')YesXARCH Allow NULL? 
128PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50CUKY(N' ')YesTCURCPSWSL Allow NULL? 
129PSWBTAmount for Updating in General Ledgerdecimal132CURR((0))YesPSWBT
130IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
131ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
132FISTLFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
133GEBERFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
134DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
135XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
136EMPFBPayee/Payernvarchar100CHAR(N' ')YesEMPFB Allow NULL? 
137PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
138XREF3Reference key for line itemnvarchar200CHAR(N' ')YesXREF3 Allow NULL? 
139DTWS1Instruction key 1nvarchar20NUMC(N'00')Yes*DTAT16 Allow NULL? 
140DTWS2Instruction key 2nvarchar20NUMC(N'00')Yes*DTAT17 Allow NULL? 
141DTWS3Instruction key 3nvarchar20NUMC(N'00')Yes*DTAT18 Allow NULL? 
142DTWS4Instruction key 4nvarchar20NUMC(N'00')Yes*DTAT19 Allow NULL? 
143XPYPRIndicator: Items from Payment Program Blockedchar10CHAR(N' ')YesXPYPR Allow NULL? 
144KIDNOPayment Referencenvarchar300CHAR(N' ')YesKIDNO Allow NULL? 
145PYCURCurrency for Automatic Paymentnvarchar50CUKY(N' ')Yes*PYCUR Allow NULL? 
146PYAMTAmount in Payment Currencydecimal132CURR((0))YesPYAMT
147BUPLABusiness Placenvarchar40CHAR(N' ')Yes*BUPLA Allow NULL? 
148SECCOSection Codenvarchar40CHAR(N' ')Yes*SECCO Allow NULL? 
149PPDIFFRealized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)decimal132CURR((0))YesPPDIFF
150PPDIF2Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)decimal132CURR((0))YesPPDIF2
151PPDIF3Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)decimal132CURR((0))YesPPDIF3
152PENLC1Penalty charge amount in first local currencydecimal132CURR((0))YesPENALTY1
153PENLC2Penalty charge amount in second local currencydecimal132CURR((0))YesPENALTY2
154PENLC3Penalty Charge Amount in Third Local Currencydecimal132CURR((0))YesPENALTY3
155PENFCPenalty charge amount in document currencydecimal132CURR((0))YesPENALTY
156PENDAYSNumber of days for penalty charge calculationint100INT4((0))YesPDAYS Allow NULL? 
157PENRCReason for late paymentnvarchar20CHAR(N' ')YesPENRC Allow NULL? 
158VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
159VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
160VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
161KBLNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')Yes*KBLNR_FI Allow NULL? 
162KBLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')Yes*KBLPOS Allow NULL? 
163GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
164GMVKZItem is in Executionchar10CHAR(N' ')YesFM_GMVKZ Allow NULL? 
165SRTYPEType of Additional Receivablenvarchar20CHAR(N' ')YesFM_SRTYPE Allow NULL? 
166LOTKZLot Number for Requestsnvarchar100CHAR(N' ')YesPSO_LOTKZ Allow NULL? 
167ZINKZExempted from interest calculationnvarchar20CHAR(N' ')YesDZINKZ Allow NULL? 
168FKBERFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
169INTRENOInternal Real Estate Master Data Codenvarchar130CHAR(N' ')YesVVINTRENO Allow NULL? 
170PPRCTPartner Profit Centernvarchar100CHAR(N' ')Yes*PPRCTR Allow NULL? 
171BUZIDIdentification of the Line Itemchar10CHAR(N' ')YesBUZID Allow NULL? 
172AUGGJFiscal Year of Clearing Documentnvarchar40NUMC(N'0000')YesAUGGJ Allow NULL? 
173HKTIDID for account detailsnvarchar50CHAR(N' ')Yes*HKTID Allow NULL? 
174BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
175KONTTAccount Assignment Category for Industry Solutionnvarchar20CHAR(N' ')YesKONTT_FI Allow NULL? 
176KONTLAcct assignment string for industry-specific acct assignmntsnvarchar500CHAR(N' ')YesKONTL_FI Allow NULL? 
177UEBGDATTransfer date of an item to legal dunning proceedingnvarchar80DATS(N'00000000')YesUEBGDAT Allow NULL? 
178VNAMEJoint Venturenvarchar60CHAR(N' ')Yes*JV_NAME Allow NULL? 
179EGRUPEquity groupnvarchar30CHAR(N' ')Yes*JV_EGROUP Allow NULL? 
180BTYPEPayroll Typenvarchar20CHAR(N' ')Yes*JV_BILIND Allow NULL? 
181PROPMANOMandate, Mandate-Opening Contractnvarchar130CHAR(N' ')YesREHORECNNRM Allow NULL? 
NamePrimaryUniqueTypeColumns
BSAK_BAK~0YesYesCLUSTEREDBUZEI, BELNR, GJAHR, ZUONR, AUGBL, AUGDT, UMSKZ, UMSKS, LIFNR, BUKRS, MANDT