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  | TIPZB
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Real Estate Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TIPZB891General real estate installation parameters, co.cd.-depend.Real Estate Management
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, DEF_FEINS, DEF_REINS, DEF_VORZ, RA_INSTALL, VVLEN, JAUTOMV, JAUTOGEB, XTRENNMV, SDEBAUT, VVJBAV, JPOSTNOW, JOPTIERT, JAEPRUEF, BNOVST, BVEVST, MVKOP, ANZSWENR, ANZGEBGR, ANZSMENR, XFILL, JAMHIER, JVSTBEST, JANL1Z1, JANLOBL, JKONDMV, PKONDMV, JBRBEW, WERKS, OPTABW, DPCFLG, ZLSCH, EQM_INSTAL, EIGT_BLART, ZBUKRS, JEIGTV, LZLSCH, KZLSCHG, KZLSCHL, ZEBLART, VVMWSKZ0, VVVSTKZ0, EBBLART, UNTZLSCH, UEBZLSCH, UNTZLSPR, UEBZLSPR, OPTSATZ, OPTERM, XZUONR, KPBLART, JCONDDAY, TAXUSBLART, RPNEW, ZEBKUEB, JEQM_1Z1, JEQM_WE, JEQM_GR, JEQM_GE, JEQM_ME, EQM_TPLKZ, EQM_FLTYP, JBKBEST, EQM_TCODE, JEQM_FL, JEQM_RA, EQM_TPLNR, JEQM_1Z1WE, JEQM_1Z1GR, JEQM_1Z1GE, JEQM_1Z1ME, EQM_OT_WE, EQM_OT_GR, EQM_OT_GE, EQM_OT_ME, JNOTAXCORR, EQM_OT_FL, EQM_OT_RA, JEQM_VFL, EQM_OT_VFL, EQM_TCODE2, JMANDBUKRS, ACCSYSTEM, CNDSPOS, CNDSTAX, DEF_TFEINS, FLTGNR, REHORMS FROM TIPZB
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3DEF_FEINSPreallocation for area unitsnvarchar30UNIT(N' ')YesT006DEF_FEINS Allow NULL? 
4DEF_REINSPreallocation for volume unitsnvarchar30UNIT(N' ')YesT006DEF_REINS Allow NULL? 
5DEF_VORZAdvance payment percentage rates indicatorchar10NUMC(N'0')YesDEF_VORZ Allow NULL? 
6RA_INSTALLFlag: AM installed for real estatechar10CHAR(N' ')YesRA_INSTALL Allow NULL? 
7VVLENPre-setting for units of lengthnvarchar30UNIT(N' ')YesT006VVLEN_DEF Allow NULL? 
8JAUTOMVCreate Lease-Out Number Automaticallychar10CHAR(N' ')YesVVJAUTOMV Allow NULL? 
9JAUTOGEBAutom. determination of LO no.: Consider building/property?char10CHAR(N' ')YesVVJAUTOGEB Allow NULL? 
10XTRENNMVSeparator for the individual parts of the RA numberchar10CHAR(N' ')YesVVXTRENNMV Allow NULL? 
11SDEBAUTAutomatic customer indicatorchar10CHAR(N' ')YesVVSDEBAUT Allow NULL? 
12VVJBAVSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
13JPOSTNOWCarry out one-time postings immediatelychar10CHAR(N' ')YesVVJPOSTNOW Allow NULL? 
14JOPTIERTCompany code opted for input tax - Indicator for opt. rate.char10CHAR(N' ')YesVVJOPIERT Allow NULL? 
15JAEPRUEFDo not carry out check function for settlement unitschar10CHAR(N' ')YesVVJAEPRUEF Allow NULL? 
16BNOVSTInput tax amount up to which an correction is not applicabledecimal132CURR((0))YesVVBNOVST
17BVEVSTMaximum amount for simplification of input tax correctiondecimal132CURR((0))YesVVBVEVST
18MVKOPTransfer Condition Items From Previous Lease-Outchar10CHAR(N' ')YesVVJMVKOP Allow NULL? 
19ANZSWENRNumber of characters for business entity numberchar10NUMC(N'0')YesVVANZSWENR Allow NULL? 
20ANZGEBGRNo. of characters for number of building/propertychar10NUMC(N'0')YesVVANZGEBGR Allow NULL? 
21ANZSMENRNumber of characters for rental unit numberchar10NUMC(N'0')YesVVANZSMENR Allow NULL? 
22XFILLPadding character for non-numerical numberschar10CHAR(N' ')YesVVXFILL Allow NULL? 
23JAMHIERTake asset hierarchy into consideration for correction itemschar10CHAR(N' ')YesVVJAMHIER Allow NULL? 
24JVSTBESTAllocation number management indicatorchar10CHAR(N' ')YesVVJVSTBEST Allow NULL? 
25JANL1Z1Indic: Real estate object must be assigned 1:1 to assetchar10CHAR(N' ')YesVVJANL1Z1 Allow NULL? 
26JANLOBLIndic.: Asset assignment is mandatorychar10CHAR(N' ')YesVVJANLOBL Allow NULL? 
27JKONDMVTransfer conditions to RU when lease-out expires?char10CHAR(N' ')YesVVJKONDMV Allow NULL? 
28PKONDMVPercentage rate for transfer of terms from LO to RUdecimal52DEC((0))YesVVPKONDMV
29JBRBEWValuation of storable fuel activechar10CHAR(N' ')YesVVJBRBEW Allow NULL? 
30WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
31OPTABWOption rate deviation in percentage pointsdecimal96DEC((0))YesVVOPTABW
32DPCFLGDummy Profit Center from Controlling Areachar10CHAR(N' ')YesVVDPCFLG Allow NULL? 
33ZLSCHPayment method for credit memoschar10CHAR(N' ')YesT042ZVVGZLSCH Allow NULL? 
34EQM_INSTALPlant Maintenance (PM) comp. is installed for Real Estatechar10CHAR(N' ')YesEQM_INSTAL Allow NULL? 
35EIGT_BLARTOwner settlement: Document type for vendor postingnvarchar20CHAR(N' ')YesT003VVEBLART Allow NULL? 
36ZBUKRSAssigned company codenvarchar40CHAR(N' ')YesT001VVZBUKRS Allow NULL? 
37JEIGTVIndicator: Owner management activechar10CHAR(N' ')YesVVJEIGTV Allow NULL? 
38LZLSCHPayment method for debit memoschar10CHAR(N' ')YesT042ZVVLZLSCH Allow NULL? 
39KZLSCHGPayment Method for Credit Memos After Lease-Out Endedchar10CHAR(N' ')YesT042ZVVKZLSCHG Allow NULL? 
40KZLSCHLPayment method for debit memos after lease-out endedchar10CHAR(N' ')YesT042ZVVKZLSCHL Allow NULL? 
41ZEBLARTDocument type for incoming paymentnvarchar20CHAR(N' ')YesT003VVIEZBLART Allow NULL? 
42VVMWSKZ0Tax on Sales/Purchases Code with Tax Rate 0nvarchar20CHAR(N' ')Yes*VVMWSKZ0 Allow NULL? 
43VVVSTKZ0Input tax indicator with tax rate 0%nvarchar20CHAR(N' ')Yes*VVVSTKZ0 Allow NULL? 
44EBBLARTDefault document type for one-time postingsnvarchar20CHAR(N' ')YesT003VVEBBLART Allow NULL? 
45UNTZLSCHDefault payment method for underpayment from rental agreemntchar10CHAR(N' ')YesVVUNTZLSCH Allow NULL? 
46UEBZLSCHDefault payment method for overpayment from lease-outchar10CHAR(N' ')YesVVUEBZLSCH Allow NULL? 
47UNTZLSPRDefault payment block for underpaymentchar10CHAR(N' ')YesT008VVUNTZLSPR Allow NULL? 
48UEBZLSPRDefault payment block for overpaymentchar10CHAR(N' ')YesT008VVUEBZLSPR Allow NULL? 
49OPTSATZOption rate - Default valuedecimal96DEC((0))YesOPTSATZ
50OPTERMOption rate determinatioin - Procedurechar10CHAR(N' ')YesOPTERM Allow NULL? 
51XZUONRFill Assignment in Documentchar10CHAR(N' ')YesVVIS_ZUONR Allow NULL? 
52KPBLARTDefault document type for account maintenancenvarchar20CHAR(N' ')YesT003VVKPBLART Allow NULL? 
53JCONDDAYContract conditions on a daily basis?char10CHAR(N' ')YesVVJCONDDAY Allow NULL? 
54TAXUSBLARTDocument type for tax transfer to SCS down paymentsnvarchar20CHAR(N' ')YesT003VVTAXUSBLART Allow NULL? 
55RPNEWCreate new residual items for incoming paymentchar10CHAR(N' ')YesVVRPNEW Allow NULL? 
56ZEBKUEBIncoming payment: cross company code rental agrmnt selectionchar10CHAR(N' ')YesVVZEBKUEB Allow NULL? 
57JEQM_1Z1Unique assignment of functional location to RE objectchar10CHAR(N' ')YesVVJEQM_1Z1 Allow NULL? 
58JEQM_WEAutomatic change/create FL for business entitychar10NUMC(N'0')YesVVJEQM_AUTO_WE Allow NULL? 
59JEQM_GRAutomatic create/change FL for propertychar10NUMC(N'0')YesVVJEQM_AUTO_GR Allow NULL? 
60JEQM_GEAutomatic create/change FL for buildingchar10NUMC(N'0')YesVVJEQM_AUTO_GE Allow NULL? 
61JEQM_MEAutomatic create/change FL for rental unitchar10NUMC(N'0')YesVVJEQM_AUTO_ME Allow NULL? 
62EQM_TPLKZFunctional location structure indicatornvarchar50CHAR(N' ')YesT370STPLKZ Allow NULL? 
63EQM_FLTYPFunctional location categorychar10CHAR(N' ')YesT370FFLTYP Allow NULL? 
64JBKBESTIndicator: Additional data owner activechar10CHAR(N' ')YesVVJBKBEST Allow NULL? 
65EQM_TCODETransaction code for creating maintainance messagenvarchar200CHAR(N' ')YesT365AVVEQM_TCODE Allow NULL? 
66JEQM_FLAutomatic create/change FL for architectural areachar10NUMC(N'0')YesVVJEQM_AUTO_FL Allow NULL? 
67JEQM_RAAutomatic create/change FL for architectural roomchar10NUMC(N'0')YesVVJEQM_AUTO_RA Allow NULL? 
68EQM_TPLNRTemporary name for generated functional locationnvarchar300CHAR(N' ')YesVVTPLNR_TEMP Allow NULL? 
69JEQM_1Z1WEUnique business entity assignment to functional locationchar10CHAR(N' ')YesVVJEQM_1Z1_WE Allow NULL? 
70JEQM_1Z1GRUnique assignment of property to functional locationchar10CHAR(N' ')YesVVJEQM_1Z1_GR Allow NULL? 
71JEQM_1Z1GEUnique assignment of building to functional locationchar10CHAR(N' ')YesVVJEQM_1Z1_GE Allow NULL? 
72JEQM_1Z1MEUnique assignment of rental unit to functional locationchar10CHAR(N' ')YesVVJEQM_1Z1_ME Allow NULL? 
73EQM_OT_WEObject type business entity for generated functional locat.nvarchar30CHAR(N' ')YesVVEQM_OT_WE Allow NULL? 
74EQM_OT_GRObject type property for generated functional locationsnvarchar30CHAR(N' ')YesVVEQM_OT_GR Allow NULL? 
75EQM_OT_GEObject type building for generated functional locationsnvarchar30CHAR(N' ')YesVVEQM_OT_GE Allow NULL? 
76EQM_OT_MEObject type rental unit for generated functional locationsnvarchar30CHAR(N' ')YesVVEQM_OT_ME Allow NULL? 
77JNOTAXCORRNo input tax adjustment in the service charge settlementchar10CHAR(N' ')YesREJNOTAXCORR Allow NULL? 
78EQM_OT_FLObject type arch. space for generated functional locationsnvarchar30CHAR(N' ')YesVVEQM_OT_FL Allow NULL? 
79EQM_OT_RAObject type arch. room for generated functional locationnvarchar30CHAR(N' ')YesVVEQM_OT_RA Allow NULL? 
80JEQM_VFLAutomatic creation/change of FL for rental spacechar10NUMC(N'0')YesVVJEQM_AUTO_VMFL Allow NULL? 
81EQM_OT_VFLObject type rental space for generated functional locationsnvarchar30CHAR(N' ')YesVVEQM_OT_VFL Allow NULL? 
82EQM_TCODE2Transaction code for creating PM order for equipmentnvarchar200CHAR(N' ')YesT365AVVEQM_TCODE22 Allow NULL? 
83JMANDBUKRSIndicator: Third Party Company Codechar10CHAR(N' ')YesREMANDATSBUKRS Allow NULL? 
84ACCSYSTEMDefinition of Accounting Systemnvarchar40CHAR(N' ')YesTIVRAACCSYSTEMRERAACCSYSTEM Allow NULL? 
85CNDSPOSIs Summarization of Line Items Active?char10CHAR(N' ')YesRERACNDSPOS Allow NULL? 
86CNDSTAXIs Summarization of Tax Items Active?char10CHAR(N' ')YesRERACNDSTAX Allow NULL? 
87DEF_TFEINSnvarchar30(N' ')Yes Allow NULL? 
88FLTGNRnvarchar40(N'0000')Yes Allow NULL? 
89REHORMSchar10(N' ')Yes Allow NULL? 
NamePrimaryUniqueTypeColumns
TIPZB~0YesYesCLUSTEREDMANDT, BUKRS

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