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  | TVAP
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
Sales and Distribution :: Sales :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TVAP711Sales Document: Item CategoriesBasic Functions
SQL:  selectupdate insert create

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

SELECT MANDT, PSTYV, FKREL, PRSFD, POSGR, PARGR, PSGRP, STULI, ASWPA, STRUM, EVRWR, KOWRR, FELDP, FAKSP, SHELL, ERLRE, TXN08, DIAFM, KDERL, TXTGR, POSAR, LFREL, ERNAM, ETERL, GWREL, KOMPP, FEHGR, SHKZG, EQMAT, STGAP, KALSM, SOBKZ, CMPNT, STRAT, STSMA, MENG1, ALEKZ, FPART, CHAUT, EXCOP, SVGNG, TYPFD, LTYPA, LTYPV, WKMAT, RKTIO, SEGAL, STDTE, RDERL, EFFEC, FFPRF, SCHEME_RMA, SCHEME_VF, FAKTF, RRREL, ACDATV, UVEIB, OIBOM, OIBCST, OIUSEREXIT, REVSP, REVEVTYP, MILL_BATCH_REF, MILL_BATCH_SEL_D, RBACONTROL, FSH_SEADET, FSH_VASS_DETC, FSH_AUTODELOC, LVART, ISM_SE_PLANNING, MILL_SE_KKNMT FROM TVAP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PSTYVSales document item categorynvarchar40CHAR(N' ')NoTVPTPSTYV Allow NULL? 
3FKRELRelevant for Billingchar10CHAR(N' ')YesFKREL Allow NULL? 
4PRSFDCarry out pricingchar10CHAR(N' ')YesPRSFD Allow NULL? 
5POSGRScreen sequence group for document header & itemnvarchar40CHAR(N' ')YesTVHBBIFGR Allow NULL? 
6PARGRPartner Determination Procedurenvarchar40CHAR(N' ')YesTVPGPARGR Allow NULL? 
7PSGRPApplicationnvarchar40CHAR(N' ')YesTC04CAPID Allow NULL? 
8STULIMaterial structurechar10CHAR(N' ')YesSTULI Allow NULL? 
9ASWPAManual selection for BOM alternativeschar10CHAR(N' ')YesASWPA Allow NULL? 
10STRUMStructural scope of a material with bill of materialchar10CHAR(N' ')YesSTRUM Allow NULL? 
11EVRWRDetermine costchar10CHAR(N' ')YesEVRWR Allow NULL? 
12KOWRRStatistical valueschar10CHAR(N' ')YesKOWRR Allow NULL? 
13FELDPField selection for itemnvarchar40CHAR(N' ')YesTVHFFELDP Allow NULL? 
14FAKSPBlocknvarchar20CHAR(N' ')YesTVFSFAKSP Allow NULL? 
15SHELLBill of material in foregroundchar10CHAR(N' ')YesSHELL Allow NULL? 
16ERLRECompletion rule for quotation / contractchar10CHAR(N' ')YesERLRE Allow NULL? 
17TXN08Number of the standard textnvarchar80CHAR(N' ')YesTXN08 Allow NULL? 
18DIAFMDialog for short quantitychar10CHAR(N' ')YesDIAFM Allow NULL? 
19KDERLBusiness data allowed at item level?char10CHAR(N' ')YesKDERL Allow NULL? 
20TXTGRText determination procedurenvarchar20CHAR(N' ')YesTTXGTXTGR Allow NULL? 
21POSARItem typechar10CHAR(N' ')YesPOSAR Allow NULL? 
22LFRELItem is relevant for deliverychar10CHAR(N' ')YesLFREL_AP Allow NULL? 
23ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
24ETERLSchedule lines allowedchar10CHAR(N' ')YesETERL Allow NULL? 
25GWRELRelevant for weight/volumechar10CHAR(N' ')YesGWREL Allow NULL? 
26KOMPPForm delivery group and correlate BOM componentschar10CHAR(N' ')YesKOMPP Allow NULL? 
27FEHGRIncompletion procedure for sales documentnvarchar20CHAR(N' ')YesTVUVFEHGR Allow NULL? 
28SHKZGReturns Itemchar10CHAR(N' ')YesSHKZG_VA Allow NULL? 
29EQMATMaterial block indicatorchar10CHAR(N' ')YesEQMAT Allow NULL? 
30STGAPStatistics group for the item categorynvarchar20CHAR(N' ')YesTVSFSTGAP Allow NULL? 
31KALSMProcedure for item outputnvarchar60CHAR(N' ')YesT683KALSMBP Allow NULL? 
32SOBKZSpecial Stock Indicatorchar10CHAR(N' ')YesT148SOBKZ Allow NULL? 
33CMPNTID: Item with active credit function / relevant for creditchar10CHAR(N' ')YesCMPNT Allow NULL? 
34STRATForm of configuration processingnvarchar20CHAR(N' ')YesT476STRATCON Allow NULL? 
35STSMAStatus Profilenvarchar80CHAR(N' ')YesTJ20J_STSMA Allow NULL? 
36MENG1Order quantiy for each item is limited to 1char10CHAR(N' ')YesMENG1 Allow NULL? 
37ALEKZCreate purchase order automaticallychar10CHAR(N' ')YesALEKZ Allow NULL? 
38FPARTBilling/Invoicing Plan Typenvarchar20CHAR(N' ')YesTFPLAFPART Allow NULL? 
39CHAUTAutomatic batch determinationchar10CHAR(N' ')YesCHAUT Allow NULL? 
40EXCOPCarry out legal control for item categorychar10CHAR(N' ')YesEXCOP Allow NULL? 
41SVGNGActivity category for controlling of technical objectsnvarchar40CHAR(N' ')YesSVGNG Allow NULL? 
42TYPFDCarry out variant matchingchar10CHAR(N' ')YesTYPFD Allow NULL? 
43LTYPAAction when material variant determined during configurationchar10CHAR(N' ')YesLTYPA Allow NULL? 
44LTYPVRun ATP check on material variantschar10CHAR(N' ')YesLTYPV Allow NULL? 
45WKMATValue contract materialnvarchar180CHAR(N' ')YesMARAWKMAT Allow NULL? 
46RKTIOResponse on reaching release order value in value contractchar10CHAR(N' ')YesRKTIO Allow NULL? 
47SEGALExclusion/Inclusion indicator for declara. to authoritiesnvarchar20CHAR(N' ')YesT609ASEGAL Allow NULL? 
48STDTEDetermine date for bill of materials configurationchar10CHAR(N' ')YesSTDTE Allow NULL? 
49RDERLRounding permitted?char10CHAR(N' ')YesRDERL Allow NULL? 
50EFFECIndicator: Assign values for parameter effectivitieschar10CHAR(N' ')YesEFFEC Allow NULL? 
51FFPRFDynamic Item Processor Profilenvarchar80CHAR(N' ')YesAD01C_PROFAD01PROFNR Allow NULL? 
52SCHEME_RMARepair procedure: Procedurenvarchar40CHAR(N' ')YesTVRMASRMA_SCHEMA Allow NULL? 
53SCHEME_VFVariant matching procedure: procedurenvarchar40CHAR(N' ')YesTVVFSVF_SCHEMA Allow NULL? 
54FAKTFBilling formnvarchar20CHAR(N' ')YesFAKTF Allow NULL? 
55RRRELRevenue recognition categorychar10CHAR(N' ')YesRR_RELTYP Allow NULL? 
56ACDATVProposed start date for accrual periodchar10CHAR(N' ')YesRR_ACDATV Allow NULL? 
57UVEIBDoc. pricing procedure for incomplete export/import datanvarchar30CHAR(N' ')YesT609BUVEIB Allow NULL? 
58OIBOMUse of item category as part of an Oil bill of material(BOM)char10CHAR(N' ')YesOIB_BOM Allow NULL? 
59OIBCSTOil BoM cost.(X=..from BoM header;' '=..from BoM components)char10CHAR(N' ')YesOIB_CST Allow NULL? 
60OIUSEREXITNumber of the routine used for copyingnvarchar30NUMC(N'000')Yes*GRPNO Allow NULL? 
61REVSPRevenue Distribution Typechar10CHAR(N' ')YesRR_REVSP Allow NULL? 
62REVEVTYPRevenue Event Type (Customizing)char10CHAR(N' ')YesRR_REVEVTYP_CUST Allow NULL? 
63MILL_BATCH_REFMP Returns with Batch Referencechar10CHAR(N' ')YesMILL_BATCH_REF Allow NULL? 
64MILL_BATCH_SEL_DDefault Value for Indicator: Batch Selction Controlchar10CHAR(N' ')YesMILL_BATCH_SEL_DEF Allow NULL? 
65RBACONTROLControl of Rules-Based ATP Checkchar10CHAR(N' ')YesRBACONTROL Allow NULL? 
66FSH_SEADETSeason Determinationchar10CHAR(N' ')YesFSH_SEADET Allow NULL? 
67FSH_VASS_DETCVAS Determination Mode for SDchar10CHAR(N' ')YesFSH_VASS_DETC Allow NULL? 
68FSH_AUTODELOCAutomatic Deallocation for Sales Document Changeschar10CHAR(N' ')YesFSH_AUTODELOC Allow NULL? 
69LVARTBill of services typenvarchar20CHAR(N' ')YesLVART Allow NULL? 
70ISM_SE_PLANNINGIS-M: Planning Datanvarchar20CHAR(N' ')YesISMPLANNING Allow NULL? 
71MILL_SE_KKNMTIndicator for characteristic transfer frm cust-mat-info-rcdchar10CHAR(N' ')YesMILL_SE_KKNMT Allow NULL? 
NamePrimaryUniqueTypeColumns
TVAP~0YesYesCLUSTEREDMANDT, PSTYV

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