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  | TCA41
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
Project System :: Structures :: Templates :: Standard Network
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TCA41661Default values for standard networks and profilesStandard Network
SQL:  selectupdate insert create

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

SELECT MANDT, PLNAW, PROFIDNETZ, FLG_ERF_H, ESOKZ, EKORG, KSTAR_FRMD, STEUS_WORK, STEUS_FRMD, STEUS_PRIM, KSTAR_COST, DAUNE, ARBEH, WAERS, SLWID, LVARI, INDET, BUKRS, AOB_KEY, VORNR_DEL, WERKS, NETSTUFE, PLNME, VERWE, STATU, UMREN, UMREZ, ZERMA, ESKOZ, BMSCH, STEUS, QMKDELTA, QMWDELTA, QMKEF, QMWEF, QPROBEMGEH, QPRUEFEINH, CF_PSNINC, RSCHL_OFER, RSCHL_OFRD, RSCHL_UFER, RSCHL_UFRD, GRPRF_GRUP, GRPRF_NAME, RSCHL_UCST, RSCHL_OCST, LVARI_TERM, FTNR_INC, FVNR_INC, AOB_DARST, VRG_DARST, PHS_DARST, KSTAR_SERV, STEUS_SERV, MATKL, LSTVAR, LSTVAR_T, EKGRP, LIFNR, NT_SEARCH1, NT_SEARCH2, NT_SEARCH3, CHRULE, CCOAA, VGWTS, PRES FROM TCA41
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PLNAWApplication of the task listchar10CHAR(N' ')NoTCA09PLNAW Allow NULL? 
3PROFIDNETZProfilenvarchar70CHAR(N' ')NoPROFID_STD Allow NULL? 
4FLG_ERF_HActivate/deactivate entry toolchar10CHAR(N' ')NoFLG_ERF_H Allow NULL? 
5ESOKZPurchasing info record categorychar10CHAR(N' ')NoESOKZ Allow NULL? 
6EKORGPurchasing Organizationnvarchar40CHAR(N' ')NoT024EEKORG Allow NULL? 
7KSTAR_FRMDCost element for external processingnvarchar100CHAR(N' ')NoCSKAKSTAR_FRMD Allow NULL? 
8STEUS_WORKControl key for internal activitiesnvarchar40CHAR(N' ')NoT430STEUS_WORK Allow NULL? 
9STEUS_FRMDControl key for external servicesnvarchar40CHAR(N' ')NoT430STEUS_FRMD Allow NULL? 
10STEUS_PRIMControl key for costsnvarchar40CHAR(N' ')NoT430STEUS_PRIM Allow NULL? 
11KSTAR_COSTCost element for general costs activitiesnvarchar100CHAR(N' ')NoCSKAKSTAR_COST Allow NULL? 
12DAUNENormal duration/unitnvarchar30UNIT(N' ')NoT006DAUNORE Allow NULL? 
13ARBEHUnit for worknvarchar30UNIT(N' ')NoT006ARBEITE Allow NULL? 
14WAERSCurrency Keynvarchar50CUKY(N' ')NoTCURCWAERS Allow NULL? 
15SLWIDKey word ID for user-defined fieldsnvarchar70CHAR(N' ')NoTCN00SLWID Allow NULL? 
16LVARIVariant of an object overviewnvarchar20CHAR(N' ')NoTCA14LVARI Allow NULL? 
17INDETKey for calculationchar10CHAR(N' ')NoINDET Allow NULL? 
18BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
19AOB_KEYKey: View of relationshipschar10CHAR(N' ')NoAOB_KEY Allow NULL? 
20VORNR_DELIncrement for automatic operation/activity numberingnvarchar40CHAR(N' ')NoDEL_VORNR Allow NULL? 
21WERKSPredefined plantnvarchar40CHAR(N' ')NoT001WVOR_WERK Allow NULL? 
22NETSTUFELevel of detail for (standard) networksnvarchar20NUMC(N'00')NoNETSTUFE Allow NULL? 
23PLNMETask list unit of measurenvarchar30UNIT(N' ')NoT006PLNME Allow NULL? 
24VERWETask list usagenvarchar30CHAR(N' ')NoT411PLN_VERWE Allow NULL? 
25STATUStatusnvarchar30CHAR(N' ')NoT412PLNST Allow NULL? 
26UMRENDenominator for conversion to base units of measuredecimal50DEC((0))NoUMREN
27UMREZNumerator for Conversion to Base Units of Measuredecimal50DEC((0))NoUMREZ
28ZERMAType of standard value calculationnvarchar50CHAR(N' ')NoT429DZERMA Allow NULL? 
29ESKOZPurchasing info record categorychar10CHAR(N' ')NoESOKZ Allow NULL? 
30BMSCHBase Quantitydecimal133QUAN((0))NoBMSCH
31STEUSControl keynvarchar40CHAR(N' ')NoT430STEUS Allow NULL? 
32QMKDELTAIncrement for Insp. Characteristic Number in Inspection Plannvarchar40NUMC(N'0000')NoQINKR_MK Allow NULL? 
33QMWDELTAIncrement for Assignment Number in Inspection Plannvarchar40NUMC(N'0000')NoQINKR_MW Allow NULL? 
34QMKEFInsert Increment for Characteristic Number in Insp. Plannvarchar40NUMC(N'0000')NoQINKR_MKEF Allow NULL? 
35QMWEFInsert Increment for Allocation Number in Inspection Plannvarchar40NUMC(N'0000')NoQINKR_MWEF Allow NULL? 
36QPROBEMGEHSample Unit of Measurenvarchar30UNIT(N' ')NoT006QPROBME Allow NULL? 
37QPRUEFEINHSample Quantity Factor for Sample(Mult. Sample Unit of Msr.)decimal52DEC((0))NoQPROBEFAK
38CF_PSNINCItem number increment for production resources/toolsnvarchar40NUMC(N'0000')NoCF_PSNINC Allow NULL? 
39RSCHL_OFERSequence key for internal operations or activitiesnvarchar60CHAR(N' ')NoTCA60RSCHL_OFER Allow NULL? 
40RSCHL_OFRDSequence key for external operations or activitiesnvarchar60CHAR(N' ')NoTCA60RSCHL_OFRD Allow NULL? 
41RSCHL_UFERSequence key for internal sub-operations or elementsnvarchar60CHAR(N' ')NoTCA60RSCHL_UFER Allow NULL? 
42RSCHL_UFRDSequence key for external sub-operations or elementsnvarchar60CHAR(N' ')NoTCA60RSCHL_UFRD Allow NULL? 
43GRPRF_GRUPProfile group (sort graphics profiles)nvarchar40CHAR(N' ')NoTCNGNETPRFGRUP Allow NULL? 
44GRPRF_NAMEName of graphic profile in Network/Hierarchy Graphicsnvarchar120CHAR(N' ')NoNETPRFNAME Allow NULL? 
45RSCHL_UCSTActivity element sequence key for general costs activitiesnvarchar60CHAR(N' ')NoTCA60RSCHL_UCST Allow NULL? 
46RSCHL_OCSTActivity sequence key for general costs activitiesnvarchar60CHAR(N' ')NoTCA60RSCHL_OCST Allow NULL? 
47LVARI_TERMObject overview variants for schedulingnvarchar20CHAR(N' ')NoTCA14CP_LVARI_T Allow NULL? 
48FTNR_INCIncrement for automatic process instruction numberingnvarchar40CHAR(N' ')NoFTNR_INC Allow NULL? 
49FVNR_INCIncrement for automatic PI characteristic numberingnvarchar40CHAR(N' ')NoFVNR_INC Allow NULL? 
50AOB_DARSTRelationship displaychar10CHAR(N' ')NoAOB_DARST Allow NULL? 
51VRG_DARSTOperation display in graphicchar10CHAR(N' ')NoVRG_DARST Allow NULL? 
52PHS_DARSTDisplay of phase in graphicschar10CHAR(N' ')NoPHS_DARST Allow NULL? 
53KSTAR_SERVCost element for servicesnvarchar100CHAR(N' ')NoCSKAKSTAR_SERV Allow NULL? 
54STEUS_SERVControl key for servicesnvarchar40CHAR(N' ')NoT430STEUS_SERV Allow NULL? 
55MATKLMaterial Groupnvarchar90CHAR(N' ')NoT023MATKL Allow NULL? 
56LSTVARVariable overviews: Overview variantnvarchar120CHAR(N' ')NoTCNVLCNL_LSTVAR Allow NULL? 
57LSTVAR_TObject overview variant for schedulingnvarchar120CHAR(N' ')NoTCNVLCP_LSTVAR Allow NULL? 
58EKGRPPurchasing group for external processingnvarchar30CHAR(N' ')NoT024VG_EKGRP Allow NULL? 
59LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')NoLFA1LIFNR Allow NULL? 
60NT_SEARCH1Number of the first text used for the search.nvarchar20CHAR(N' ')YesCN_SEARCH1 Allow NULL? 
61NT_SEARCH2Number of the second text used for the search.nvarchar20CHAR(N' ')YesCN_SEARCH2 Allow NULL? 
62NT_SEARCH3Number of the third text used for the search.nvarchar20CHAR(N' ')YesCN_SEARCH3 Allow NULL? 
63CHRULEChange rulechar10CHAR(N' ')YesR_CHRULE Allow NULL? 
64CCOAAChange Type for Objectnvarchar30NUMC(N'000')YesTCC13CCOAA Allow NULL? 
65VGWTSStandard value keynvarchar40CHAR(N' ')YesTC21VORGSCHL Allow NULL? 
66PRESType of Process Instruction Maintenancechar10CHAR(N' ')NoCPS_PRESPRES Allow NULL? 
NamePrimaryUniqueTypeColumns
TCA41~0YesYesCLUSTEREDPROFIDNETZ, PLNAW, MANDT

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