SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | VZZKOPO
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Treasury
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VZZKOPO1153Table condition itemsTreasury
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, SANLF, RKEY1, RKEY2, RKEY3, DGUEL_KK, NLFD_ANG, SKOART, DGUEL_KP, NSTUFE, SSTATI, PKOND, BKOND, SWHRKOND, SBASIS, SZSREF, SZSREFVZ, PFLUCT, AMMRHY, ATTRHY, SZAWS, RDIVNR, JNULLKON, MWSKZ, JBMONAT, DVALUT, DFAELL, KUNNR, ZLSCH, BVTYP, MABER, SPARTNR, RKONT, SVULT, SFULT, SVKALRI, SFKALRI, AVGSTAGE, AFGSTAGE, SVKALZUS, SFKALZUS, SKALID, SZBMETH, JSOFVERR, DALLGEM, SZEGEN, SBUST, SKOPO, SALTKOND, SZINSANP, SINCL, SFORMREF, SVARNAME, SVWERK, SVMETH, SFWERK, SFMETH, DPKOND, AZGSTAGE, SZKALRI, DZSREF, SKALID2, JGESUCHT, KURS1, BBASIS, SZWERK, SFINCL, SRUNDVORF, SZWKEY, SFVMETH, SDWERK, SBERECH, JPROZR, SZEITANT, SFANT, SFRANZ, KBKOND, SBASFIX, MANSP, ZAHLS, BKONDQM, JAREA, SFLART, TXJCD, AVGSTAGEVZ, AFGSTAGEVZ, LIFNR, JEXPOZINS, KOSTL, GFZLSCH, ZLSPR, SROUND, SKALIDWT, BMWST, XCROSS, PPAYMENT, AMMRHYZV, PKOND2, MNDID, RBO, STECH_COND, SEXCLGUEL, SULTGUEL, A_AMTMIN, A_AMTMAX, SSCHMETH, BAUDAMNT, A_PAYDAY, RCO, BROUNDUNIT, BBASISUNIT, GPDAYS, IND_IOAGP, DISBRATE FROM VZZKOPO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3SANLFProduct Categorynvarchar30NUMC(N'000')No*SANLF Allow NULL? 
4RKEY1Key part 1nvarchar130CHAR(N' ')NoRKEY1 Allow NULL? 
5RKEY2Key part 2nvarchar80CHAR(N' ')NoRKEY2 Allow NULL? 
6RKEY3Key part 3nvarchar80CHAR(N' ')NoRKEY3 Allow NULL? 
7DGUEL_KKDate Condition Effective fromnvarchar80DATS(N'00000000')NoDGUEL Allow NULL? 
8NLFD_ANGOffer consecutive numbernvarchar30NUMC(N'000')NoNLFD_ANG Allow NULL? 
9SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40NUMC(N'0000')NoTZK01SKOART Allow NULL? 
10DGUEL_KPCondition Item Valid Fromnvarchar80DATS(N'00000000')NoDGUEL_KP Allow NULL? 
11NSTUFELevel number of condition item for recurring paymentsnvarchar20NUMC(N'00')NoNSTUFE Allow NULL? 
12SSTATIStatus of data recordnvarchar20NUMC(N'00')Yes*SSTATI Allow NULL? 
13PKONDPercentage rate for condition itemsdecimal107DEC((0))YesPKOND
14BKONDCondition item currency amountdecimal132CURR((0))YesBKOND
15SWHRKONDCurrency of Condition Itemnvarchar50CUKY(N' ')YesTCURCSWHRKOND Allow NULL? 
16SBASISCalculation base referencenvarchar40CHAR(N' ')YesTZFBVVSBASIS Allow NULL? 
17SZSREFReference Interest Ratenvarchar100CHAR(N' ')YesT056RSZSREF Allow NULL? 
18SZSREFVZ+/- sign / reference interest rate operatorchar10CHAR(N' ')YesSZSREFVZ Allow NULL? 
19PFLUCTFluctuation margindecimal107DEC((0))YesTFM_PFLUCT
20AMMRHYFrequency in monthsnvarchar30NUMC(N'000')YesAMMRHY Allow NULL? 
21ATTRHYFrequency in Daysnvarchar30NUMC(N'000')YesATTRHY Allow NULL? 
22SZAWSPayment form (at start of period, mid-period, at period end)char10NUMC(N'0')YesSZAWS Allow NULL? 
23RDIVNRDividend coupon numbernvarchar30NUMC(N'000')YesRDIVNR Allow NULL? 
24JNULLKONCondition Formchar10CHAR(N' ')YesJNULLKON Allow NULL? 
25MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')YesT007AMWSKZ Allow NULL? 
26JBMONATIndicator for calculating amount per monthchar10CHAR(N' ')YesJBMONAT Allow NULL? 
27DVALUTCalculation Datenvarchar80DATS(N'00000000')YesDVALUT Allow NULL? 
28DFAELLDue datenvarchar80DATS(N'00000000')YesDFAELL Allow NULL? 
29KUNNRCustomer Numbernvarchar100CHAR(N' ')YesKNA1KUNNR Allow NULL? 
30ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZDZLSCH Allow NULL? 
31BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
32MABERDunning Areanvarchar20CHAR(N' ')YesT047MMABER Allow NULL? 
33SPARTNRBusiness Partner Numbernvarchar100CHAR(N' ')YesBUT000BP_PARTNR_NEW Allow NULL? 
34RKONTQuota numbernvarchar60NUMC(N'000000')YesRKONT Allow NULL? 
35SVULTMonth-end indicator for calculation datechar10CHAR(N' ')YesVVSBULT Allow NULL? 
36SFULTMonth-End Indicator for Due Datechar10CHAR(N' ')YesSFULT Allow NULL? 
37SVKALRIField is no longer usedchar10CHAR(N' ')YesVVSNVER1 Allow NULL? 
38SFKALRICalculation of periods with flexible valid-to date?char10CHAR(N' ')YesVVSFKALRI Allow NULL? 
39AVGSTAGENumber of working days for value datenvarchar20NUMC(N'00')YesAVGSTAGE Allow NULL? 
40AFGSTAGENumber of working days to due datenvarchar20NUMC(N'00')YesAFGSTAGE Allow NULL? 
41SVKALZUSField is no longer usedchar10CHAR(N' ')YesVVSNVER1 Allow NULL? 
42SFKALZUSField is no longer usedchar10CHAR(N' ')YesVVSNVER1 Allow NULL? 
43SKALIDFactory calendarnvarchar20CHAR(N' ')YesTFACDSKALID Allow NULL? 
44SZBMETHInterest Calculation Methodchar10CHAR(N' ')YesSZBMETH Allow NULL? 
45JSOFVERRImmediate settlementchar10CHAR(N' ')YesJSOFVERR Allow NULL? 
46DALLGEMGeneral datenvarchar80DATS(N'00000000')YesDALLGEM Allow NULL? 
47SZEGENGenerate incoming payment immediatelynvarchar20NUMC(N'00')YesTD21SZEGEN Allow NULL? 
48SBUSTPosting control keynvarchar20NUMC(N'00')YesTZB09VVSBUST Allow NULL? 
49SKOPODetailed identification for condition itemsnvarchar20NUMC(N'00')YesTZK07VVSKOPO Allow NULL? 
50SALTKONDBracket condition for alternative conditionsnvarchar40NUMC(N'0000')YesVVSALTKOND Allow NULL? 
51SZINSANPCross-referenced condition grp for interest rate adjustmentnvarchar40NUMC(N'0000')YesVVSZINSANP Allow NULL? 
52SINCLInclusive indicator for beginning and end of a periodchar10NUMC(N'0')YesVVSINCL Allow NULL? 
53SFORMREFFormula reference for the cash flow calculatornvarchar40CHAR(N' ')YesAT30VVSFORMREF Allow NULL? 
54SVARNAMEDescription of variables in cash flow calculatornvarchar40CHAR(N' ')YesVVSVARNAME Allow NULL? 
55SVWERKShift calculation date to working daychar10NUMC(N'0')YesVVSVWERK Allow NULL? 
56SVMETHMethod for determining the next value datechar10NUMC(N'0')YesVVSVMETH Allow NULL? 
57SFWERKShift due date to working daychar10NUMC(N'0')YesVVSFWERK Allow NULL? 
58SFMETHMethod for determining the next due datechar10NUMC(N'0')YesVVSFMETH Allow NULL? 
59DPKONDDetermination date for percentage rate of condition itemsnvarchar80DATS(N'00000000')YesVVDPKOND Allow NULL? 
60AZGSTAGENumber of working days for interest fixingnvarchar20NUMC(N'00')YesAZGSTAGE Allow NULL? 
61SZKALRICalendar direction for interest rate fixingchar10CHAR(N' ')YesSZKALRI Allow NULL? 
62DZSREFDate fixing for benchmark interest rate in cash flownvarchar80DATS(N'00000000')YesVVDZSREF Allow NULL? 
63SKALID2Calendar ID 2 (valid in connection with calendar ID 1)nvarchar20CHAR(N' ')YesTFACDVVSKALID2 Allow NULL? 
64JGESUCHTInt. indicator for alternative calculationschar10CHAR(N' ')YesVVJGESUCHT Allow NULL? 
65KURS1Exchange ratedecimal95DEC((0))YesKURSF
66BBASISCalculation base amountdecimal132CURR((0))YesBBASIS
67SZWERKShift to working day for interest fixing datechar10NUMC(N'0')YesVVSZWERK Allow NULL? 
68SFINCLInclusive Indicator for Due Datechar10NUMC(N'0')YesVVSFINCL Allow NULL? 
69SRUNDVORFRounding of interim results for prepaymentschar10NUMC(N'0')YesVVSRUNDVF Allow NULL? 
70SZWKEYPayment form with adjustment daysnvarchar20CHAR(N' ')YesTDZWVVSZWKEY Allow NULL? 
71SFVMETHUpdate method for calculation date/due datenvarchar20NUMC(N'00')YesTB_SFVMETH Allow NULL? 
72SDWERKWorking Day Shift for Payment Datechar10NUMC(N'0')YesTB_SDWERK Allow NULL? 
73SBERECHGrace Period Interest Methodchar10CHAR(N' ')YesSBERECH Allow NULL? 
74JPROZRPercentage Calculationchar10CHAR(N' ')YesTB_JPROZR Allow NULL? 
75SZEITANTIndicator for Pro Rata Temporis Calculationschar10NUMC(N'0')YesVVSZEITANT Allow NULL? 
76SFANTIndicator for due date-related FiMa calculationschar10NUMC(N'0')YesVVSFANT Allow NULL? 
77SFRANZShift Due Datechar10NUMC(N'0')YesTFMSFRANZ Allow NULL? 
78KBKONDCondition amount independent of currencydecimal156DEC((0))YesVVKBKOND
79SBASFIXIndicator for fixing calculation basechar10NUMC(N'0')YesTFMSBASFIX Allow NULL? 
80MANSPDunning blockchar10CHAR(N' ')YesT040SMANSP Allow NULL? 
81ZAHLSPayment Block Keychar10CHAR(N' ')YesT008DZLSPR Allow NULL? 
82BKONDQMCurrency amount per area unitdecimal132CURR((0))YesBKONDQM
83JAREARental on basis of area?char10CHAR(N' ')YesVVJAREA Allow NULL? 
84SFLARTArea typenvarchar40NUMC(N'0000')YesTIV08SFLART Allow NULL? 
85TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
86AVGSTAGEVZ+/- sign for number of working days for value datechar10CHAR(N' ')YesAVGSTAGEVZ Allow NULL? 
87AFGSTAGEVZ+/- sign for number of working days for due datechar10CHAR(N' ')YesAFGSTAGEVZ Allow NULL? 
88LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')YesLFA1LIFNR Allow NULL? 
89JEXPOZINSExponential Interest Calculationchar10CHAR(N' ')YesTB_JZINSRE Allow NULL? 
90KOSTLCost center of internal contractnvarchar100CHAR(N' ')Yes*RECNKOSTL Allow NULL? 
91GFZLSCHPayment method for credit memoschar10CHAR(N' ')Yes*RECNGFZLSCH Allow NULL? 
92ZLSPRPayment Block Keychar10CHAR(N' ')YesT008DZLSPR Allow NULL? 
93SROUNDRounding Categorychar10CHAR(N' ')YesTFM_SROUND Allow NULL? 
94SKALIDWTInterest Calendarnvarchar20CHAR(N' ')Yes*TFMSKALIDWT Allow NULL? 
95BMWSTValue-added tax amount includeddecimal132CURR((0))YesBMWST
96XCROSSGross amount indicatorchar10CHAR(N' ')YesRECNXCROSS Allow NULL? 
97PPAYMENTPayment Ratedecimal117DEC((0))YesTFM_PPAYMENT
98AMMRHYZVInterest Settlement Frequency for Exponential Interest Calc.nvarchar20NUMC(N'00')YesTFM_AMMRHYZV Allow NULL? 
99PKOND2Percentage Rate for Condition Itemsdecimal1510DEC((0))YesPKOND2
100MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350CHAR(N' ')YesSEPA_MNDID Allow NULL? 
101RBOBusiness Operation Number (Loans)nvarchar150CHAR(N' ')YesRBO Allow NULL? 
102STECH_CONDIndicator for Technical Program Conditionchar10CHAR(N' ')YesTB_STECH_COND Allow NULL? 
103SEXCLGUELExclusive indicator for start date of condition positionchar10NUMC(N'0')YesTFMSEXCLKP Allow NULL? 
104SULTGUELMonth-end indicator for start date of condition positionchar10CHAR(N' ')YesTFMSULT_KP Allow NULL? 
105A_AMTMINMinimum Amount to Be Capitalizeddecimal132CURR((0))YesTB_FICO_AAMTMIN
106A_AMTMAXMaximum Amount to Be Capitalizeddecimal132CURR((0))YesTB_FICO_AAMTMAX
107SSCHMETHCalculation Method for Auto Debit Amountchar10CHAR(N' ')YesTB_SSCHMETH Allow NULL? 
108BAUDAMNTAmountdecimal132CURR((0))YesTB_BAUDAMNT
109A_PAYDAYModel Calculation: Day of Installment Payment (1-31)nvarchar20NUMC(N'00')YesTB_MODEL_PAYDAY Allow NULL? 
110RCOBus. Operation No. (Installment Plan Change: Consumer Loan)nvarchar150CHAR(N' ')YesTB_MODEL_RCO Allow NULL? 
111BROUNDUNITRounding Unit for Amountsdecimal137DEC((0))YesTB_BROUNDUNIT_A
112BBASISUNITBase Unit for Roundingdecimal172CURR((0))YesTFM_BBASISUNIT
113GPDAYSTolerance Days for Grace Periodnvarchar20NUMC(N'00')YesTB_GPDAYS_CMLCHN Allow NULL? 
114IND_IOAGPIndicator for IOA/GP condition itemchar10CHAR(N' ')YesTB_IOAGP_CMLCHN Allow NULL? 
115DISBRATEDisbursement Ratechar10NUMC(N'0')YesTB_DISBRATE_CMLCHN Allow NULL? 
NamePrimaryUniqueTypeColumns
VZZKOPO~0YesYesCLUSTEREDMANDT, BUKRS, SANLF, RKEY1, RKEY2, RKEY3, DGUEL_KK, NLFD_ANG, SKOART, DGUEL_KP, NSTUFE
VZZKOPO~1NoNoNONCLUSTEREDMANDT, BUKRS, SANLF, KUNNR
VZZKOPO~2NoNoNONCLUSTEREDRKEY1

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy