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  | VZZKOKO
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
Financials :: Financial Supply Chain Management :: Treasury and Risk Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VZZKOKO812Table condition headerTreasury and Risk Management
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, SANLF, RKEY1, DGUEL_KK, NLFD_ANG, SSTATI, SKOKOART, STILGRHY, STILGART, SDISEIN, KZAHLUNG, BZAHLUNG, SWHRZHLG, BZUSAGE, SWHRZUSA, PEFFZINS, SEFFMETH, SZBMETH, SDISKO, DKUEND, SKUEND, DKUENDDG, DBLFZ, DBLFZ_ORIGIN, DELFZ, DRESAM, DRESBIS, DANGAM, DANGBIS, SANGVOR, JANNAHME, SANNAHME, DANNAHME, JVERTRAG, DVERTRAM, DVERTBIS, PMANEFFZ, SEFFM2, SKUEGL, RPNR, DEFSZ, DGES, SGESAUS, SZKZ, NANGEBOT, SINCL, ZVRHYEFF, PVGLEFFZ, SULTEFSZ, DABEFFZ, DKUENDDN, SKUEDN, SKUEART, DMARKTZINS, SKALIDWT, EDEFFZINS, EDEFFMETH, JAHREFFZINS, JAHREFFMETH, PEFFZINS_ORIGIN, ORIGINAL_TERM, OVERALL_RUNTIME, ORIG_CREDIT_SUM, DATE_REPAYMENT, DATE_FIRST_RATE, DAY_OF_PAYMENT, CLEARING_RATE, EFF_INT_L_PYMNP, DEFF_INT_L_PYMNP, REPAY_DELAY, CALCULATED_PARAM, CURR_CREDIT_SUM, BROUNDUNIT, SROUND, BOVERLIMIT, POVERLIMIT, CONTAB, CONTAB_VERSION, TERM_PAYMENT, PAPR_ORIGIN FROM VZZKOKO
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? 
5DGUEL_KKDate Condition Effective fromnvarchar80DATS(N'00000000')NoDGUEL Allow NULL? 
6NLFD_ANGOffer consecutive numbernvarchar30NUMC(N'000')NoNLFD_ANG Allow NULL? 
7SSTATIStatus of data recordnvarchar20NUMC(N'00')Yes*SSTATI Allow NULL? 
8SKOKOARTType of Condition Headernvarchar20NUMC(N'00')YesSKOKOART Allow NULL? 
9STILGRHYPayment cyclenvarchar20NUMC(N'00')YesSTILGRHY Allow NULL? 
10STILGARTRepayment Type Indicatorchar10NUMC(N'0')YesSTILGART Allow NULL? 
11SDISEINType of Discount Withholdingchar10CHAR(N' ')YesSDISEIN Allow NULL? 
12KZAHLUNGPay-in/disbursement ratedecimal107DEC((0))YesKZAHLUNG
13BZAHLUNGPay-in/disbursement amountdecimal132CURR((0))YesBZAHLUNG
14SWHRZHLGCurrency of payment amountnvarchar50CUKY(N' ')YesTCURCSWHRZHLG Allow NULL? 
15BZUSAGECommitment capitaldecimal132CURR((0))YesBZUSAGE
16SWHRZUSACurrency of commitment amountnvarchar50CUKY(N' ')YesTCURCSWHRZUSA Allow NULL? 
17PEFFZINSEffective Interest Ratedecimal107DEC((0))YesTB_EFF_RATE
18SEFFMETHEffective Interest Method (Financial Mathematics)char10NUMC(N'0')YesSEFFMETH Allow NULL? 
19SZBMETHInterest Calculation Methodchar10CHAR(N' ')YesSZBMETH Allow NULL? 
20SDISKODiscountedchar10CHAR(N' ')YesSDISKO Allow NULL? 
21DKUENDDate of noticenvarchar80DATS(N'00000000')YesDKUEND Allow NULL? 
22SKUENDReason for Noticenvarchar30NUMC(N'000')YesTD04SKUEND Allow NULL? 
23DKUENDDGEarliest Possible Date for Notice Given by the Lendernvarchar80DATS(N'00000000')YesDKUENDDG Allow NULL? 
24DBLFZStart of Termnvarchar80DATS(N'00000000')YesDBLFZ Allow NULL? 
25DBLFZ_ORIGINOriginal Term Startnvarchar80DATS(N'00000000')YesDBLFZ_ORIGIN Allow NULL? 
26DELFZEnd of Termnvarchar80DATS(N'00000000')YesDELFZ Allow NULL? 
27DRESAMReservation of Conditions Onnvarchar80DATS(N'00000000')YesDRESAM Allow NULL? 
28DRESBISReservation of Conditions Untilnvarchar80DATS(N'00000000')YesDRESBIS Allow NULL? 
29DANGAMOffer creation datenvarchar80DATS(N'00000000')YesDANGAM Allow NULL? 
30DANGBISOffer Effective Tonvarchar80DATS(N'00000000')YesDANGBIS Allow NULL? 
31SANGVOROffer/Acceptance Reservation Indicatornvarchar20NUMC(N'00')YesATRESERVATIONSANGVOR Allow NULL? 
32JANNAHMEOffer Acceptance Indicatorchar10CHAR(N' ')YesJANNAHME Allow NULL? 
33SANNAHMEType of offer acceptance indicatornvarchar20NUMC(N'00')YesTD13SANNAHME Allow NULL? 
34DANNAHMEDate of acceptance of offernvarchar80DATS(N'00000000')YesDANNAHME Allow NULL? 
35JVERTRAGIndicator: Contract Created?char10CHAR(N' ')YesJVERTRAG Allow NULL? 
36DVERTRAMContract creation datenvarchar80DATS(N'00000000')YesDVERTRAM Allow NULL? 
37DVERTBISReturn contract bynvarchar80DATS(N'00000000')YesDVERTBIS Allow NULL? 
38PMANEFFZInternal Effective Interest Ratedecimal107DEC((0))YesTB_EFF_RATE_INT
39SEFFM2Effective Interest Method (Financial Mathematics)char10NUMC(N'0')YesSEFFMETH Allow NULL? 
40SKUEGLNotice Arrangement Lendernvarchar30NUMC(N'000')YesTD28VVSKUEGL Allow NULL? 
41RPNRActivity number/rollover numbernvarchar80NUMC(N'00000000')YesVVRPNR Allow NULL? 
42DEFSZDate of fixed period endnvarchar80DATS(N'00000000')YesVVDEFSZ Allow NULL? 
43DGESEarliest Notice Date in acc. with the Legal Right of Noticenvarchar80DATS(N'00000000')YesVVDGES Allow NULL? 
44SGESAUSLegal Right of Notice Excludedchar10CHAR(N' ')YesVVSGESAUS Allow NULL? 
45SZKZSpecial int. ID for int. on arrears for remaining balancechar10CHAR(N' ')YesTDSOZVVSZKZ Allow NULL? 
46NANGEBOTOffer consecutive numbernvarchar30NUMC(N'000')YesNLFD_ANG Allow NULL? 
47SINCLInclusive indicator for beginning and end of a periodchar10NUMC(N'0')YesVVSINCL Allow NULL? 
48ZVRHYEFFInt.sttlmnt frequency for effective int.rate calc.in monthsnvarchar30NUMC(N'000')YesVVZVRHYEFF Allow NULL? 
49PVGLEFFZComparative Effective Interestdecimal107DEC((0))YesTB_EFF_RATE_COM
50SULTEFSZMonth-end indicator for end of fixed periodchar10CHAR(N' ')YesVVSULTEFSZ Allow NULL? 
51DABEFFZDate when calculation of effective rate startsnvarchar80DATS(N'00000000')YesVVDABEFFZ Allow NULL? 
52DKUENDDNEarliest Possible Date for Notice Given by the Borrowernvarchar80DATS(N'00000000')YesVVDKUENDDN Allow NULL? 
53SKUEDNNotice Arrangement Borrowernvarchar30NUMC(N'000')YesTD29VVSKUEDN Allow NULL? 
54SKUEARTNotice Type for the Loannvarchar30NUMC(N'000')YesTD27VVSKUEART Allow NULL? 
55DMARKTZINSISB: Market Rate Date: Market Interest Rate for NPV Calc.nvarchar80DATS(N'00000000')YesDMARKTZINS Allow NULL? 
56SKALIDWTInterest Calendarnvarchar20CHAR(N' ')Yes*TFMSKALIDWT Allow NULL? 
57EDEFFZINSRelevant for Closely Defined Effective Interestdecimal107DEC((0))YesTB_EFF_RATE_ED
58EDEFFMETHEffective Interest Method - Acc. to EU Gdline Int.Statisticschar10CHAR(N' ')YesEFFMETH Allow NULL? 
59JAHREFFZINSRelevant for Yearly Eff. Interest Acc Guideline 87/102/EUdecimal107DEC((0))YesTB_EFF_RATE_YEAR
60JAHREFFMETHEffective Interest Method - Acc. to EU Gdline Int.Statisticschar10CHAR(N' ')YesEFFMETH Allow NULL? 
61PEFFZINS_ORIGINOriginal Effective Interest Ratedecimal107DEC((0))YesTB_EFF_RATE_ORIG
62ORIGINAL_TERMOriginal Term in Monthsnvarchar30NUMC(N'000')YesTB_VIEW_ORIGINAL_TERM Allow NULL? 
63OVERALL_RUNTIMEOverall Termnvarchar30NUMC(N'000')YesTB_VIEW_OVERALL_RUNTIME Allow NULL? 
64ORIG_CREDIT_SUMOriginal Total Loan Amountdecimal132CURR((0))YesTB_VIEW_ORIGINAL_CREDIT_SUM
65DATE_REPAYMENTStart Date for Repaymentnvarchar80DATS(N'00000000')YesTB_VIEW_DATE_REPAYMENT Allow NULL? 
66DATE_FIRST_RATEDue Date for First Installment to Include a Repayment Amountnvarchar80DATS(N'00000000')YesTB_VIEW_DATE_FIRST_RATE Allow NULL? 
67DAY_OF_PAYMENTDay of Installment Paymentnvarchar20NUMC(N'00')YesTB_VIEW_DAY_OF_PAYMENT Allow NULL? 
68CLEARING_RATEAmount for Final Loan Installment Paymentdecimal132CURR((0))YesTB_VIEW_CLEARING_RATE
69EFF_INT_L_PYMNPEffective Interest Rate for Last Change to Installment Plandecimal107DEC((0))YesTB_MODEL_EFFECTIV_INTERSTS_PPC
70DEFF_INT_L_PYMNPKey Date for Last Change to Installment Plannvarchar80DATS(N'00000000')YesTB_MODEL_DATE_LAST_PAYMENTPLAN Allow NULL? 
71REPAY_DELAYModel Calculation: DE for Periods of Repayment Suspensionnvarchar20NUMC(N'00')YesTB_MODEL_REPAY_DELAY Allow NULL? 
72CALCULATED_PARAMCalculate Installment Amount or Number of Installments?nvarchar40CHAR(N' ')YesTB_MODEL_P_RATE_OR_TERM Allow NULL? 
73CURR_CREDIT_SUMCurrent Total Loan Amountdecimal132CURR((0))YesTB_VIEW_CURRENT_CREDIT_SUM
74BROUNDUNITRounding Unit for Amountsdecimal137DEC((0))YesTB_BROUNDUNIT_A
75SROUNDRounding Category (Round up, Round Down or Number Rounding)char10CHAR(N' ')YesTB_SROUND_A Allow NULL? 
76BOVERLIMITDrawing Tolerance as Amountdecimal132CURR((0))YesTB_COMP_OVERLIMIT_AMOUNT
77POVERLIMITDrawing Tolerance as a Percentagedecimal107DEC((0))YesTB_COMP_OVERLIMT_PERCENT
78CONTABCondition Tablenvarchar80CHAR(N' ')YesTB_FICO_CONTAB Allow NULL? 
79CONTAB_VERSIONVersion Number for a Condition Tablenvarchar40NUMC(N'0000')YesTB_FICO_CONTAB_VERSION Allow NULL? 
80TERM_PAYMENTCategory of Last Installmentchar10CHAR(N' ')YesTB_TERM_PAYMENT Allow NULL? 
81PAPR_ORIGINOriginal U.S. Effective Interest Ratedecimal107DEC((0))YesTB_PAPR_ORIGIN
NamePrimaryUniqueTypeColumns
VZZKOKO~0YesYesCLUSTEREDMANDT, BUKRS, SANLF, RKEY1, DGUEL_KK, NLFD_ANG
VZZKOKO~112NoNoNONCLUSTEREDMANDT, RKEY1

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