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  | TCN41
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 :: Operative Structures :: Network and Activity
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TCN41781Network DefaultsNetwork and Activity
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, KSTAR_SERV, STEUS_SERV, DAUNE, ARBEH, WAERS, SLWID, LVARI, INDET, BUKRS, AOB_KEY, VORNR_DEL, TERKZ, AUART, WERKS, DISPO, RSCHL_OFER, RSCHL_OFRD, RSCHL_UFER, RSCHL_UFRD, RSCHL_OCST, RSCHL_UCST, GR_PRF_GR, GR_PRF_NAM, FHORI, NETSTUFE, VAGRP, MSGTY, AOB_DARST, VRG_DARST, NO_DISP, COLKZ_ELEM, COLKZ_TEIL, COLKZ_MLST, COLKZ_DOKU, COLKZ_MAT, VSPRF, CLASF, PROFILE_ID, BALK_PROF, KBED, KKALKR, LSTVAR, MATKL, MATEXIT, EKGRP, MATKL_FRMD, EKGRP_FRMD, POSNR_MAT, SCHED_END, SCEND_ACT, NT_SEARCH1, NT_SEARCH2, NT_SEARCH3, MFLIC, MEINH_FRMD, MEINH_SERV, KSTAR_MATVORPL, KZERB, VALID, VALID_VG, SUBST, SUBST_VG, FPART, IPPS, TEMPLATE_KEY, PSACL, PSACLH FROM TCN41
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PLNAWApplication of the task listchar10CHAR(N' ')NoTCA09PLNAW Allow NULL? 
3PROFIDNETZNetwork profilenvarchar70CHAR(N' ')NoPROFIDNZPL 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? 
12KSTAR_SERVCost element for servicesnvarchar100CHAR(N' ')NoCSKAKSTAR_SERV Allow NULL? 
13STEUS_SERVControl key for servicesnvarchar40CHAR(N' ')NoT430STEUS_SERV Allow NULL? 
14DAUNENormal duration/unitnvarchar30UNIT(N' ')NoT006DAUNORE Allow NULL? 
15ARBEHUnit for worknvarchar30UNIT(N' ')NoT006ARBEITE Allow NULL? 
16WAERSCurrency Keynvarchar50CUKY(N' ')NoTCURCWAERS Allow NULL? 
17SLWIDKey word ID for user-defined fieldsnvarchar70CHAR(N' ')NoTCN00SLWID Allow NULL? 
18LVARIVariant of an object overviewnvarchar20CHAR(N' ')NoTCA14LVARI Allow NULL? 
19INDETKey for calculationchar10CHAR(N' ')NoINDET Allow NULL? 
20BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
21AOB_KEYKey: View of relationshipschar10CHAR(N' ')NoAOB_KEY Allow NULL? 
22VORNR_DELIncrement for automatic operation/activity numberingnvarchar40CHAR(N' ')NoDEL_VORNR Allow NULL? 
23TERKZScheduling typechar10CHAR(N' ')NoT482TERMKZ Allow NULL? 
24AUARTOrder Typenvarchar40CHAR(N' ')NoT003OAUFART Allow NULL? 
25WERKSPlantnvarchar40CHAR(N' ')NoT001WWERKS_D Allow NULL? 
26DISPOMRP controller for the ordernvarchar30CHAR(N' ')NoT024DCO_DISPO Allow NULL? 
27RSCHL_OFERSequence key for internal processing of activitynvarchar60CHAR(N' ')NoTCO60RSCHL_OFEA Allow NULL? 
28RSCHL_OFRDSequence key for activity in external processingnvarchar60CHAR(N' ')NoTCO60RSCHL_OFRA Allow NULL? 
29RSCHL_UFERSequence key for internally processed activity elementnvarchar60CHAR(N' ')NoTCO60RSCHL_UFEA Allow NULL? 
30RSCHL_UFRDSequence key for externally processed activity elementnvarchar60CHAR(N' ')NoTCO60RSCHL_UFRA Allow NULL? 
31RSCHL_OCSTActivity sequence key in general costs activitiesnvarchar60CHAR(N' ')NoTCO60RSCHL_OCSA Allow NULL? 
32RSCHL_UCSTActivity element sequence key for general costs activitiesnvarchar60CHAR(N' ')NoTCO60RSCHL_UCSA Allow NULL? 
33GR_PRF_GRProfile group (sort graphics profiles)nvarchar40CHAR(N' ')NoTCNGNETPRFGRUP Allow NULL? 
34GR_PRF_NAMName of graphic profile in Network/Hierarchy Graphicsnvarchar120CHAR(N' ')NoNETPRFNAME Allow NULL? 
35FHORIScheduling Margin Key for Floatsnvarchar30CHAR(N' ')NoT436AFHORI Allow NULL? 
36NETSTUFELevel of detail for (standard) networksnvarchar20NUMC(N'00')NoNETSTUFE Allow NULL? 
37VAGRPResponsible planner group/departmentnvarchar30CHAR(N' ')NoT024AVAGRP Allow NULL? 
38MSGTYType of checking during top-down time schedulingchar10CHAR(N' ')NoPS_MSGTY Allow NULL? 
39AOB_DARSTRelationship displaychar10CHAR(N' ')NoAOB_DARST Allow NULL? 
40VRG_DARSTActivity display in the graphicchar10CHAR(N' ')NoACT_DARST Allow NULL? 
41NO_DISPEffective for Materials Planningchar10CHAR(N' ')NoNO_DISP_PLUS Allow NULL? 
42COLKZ_ELEMColor for indicator: Activity element existsnvarchar110CHAR(N' ')NoTWCOLCOLKZ_ELEM Allow NULL? 
43COLKZ_TEILColor for indicator: Subnetwork existsnvarchar110CHAR(N' ')NoTWCOLCOLKZ_TEIL Allow NULL? 
44COLKZ_MLSTColor for indicator: Milestone existsnvarchar110CHAR(N' ')NoTWCOLCOLKZ_MLST Allow NULL? 
45COLKZ_DOKUColor for indicator: Document existsnvarchar110CHAR(N' ')NoTWCOLCOLKZ_DOKU Allow NULL? 
46COLKZ_MATColor for indicator: Material existsnvarchar110CHAR(N' ')NoTWCOLCOLKZ_MAT Allow NULL? 
47VSPRFVersion profilenvarchar70CHAR(N' ')NoTCN51VER_PROFIL Allow NULL? 
48CLASFInd.: Take Activity Into Account for Project Summarizationchar10CHAR(N' ')NoCLASF Allow NULL? 
49PROFILE_IDOverall profile for capacity levelingnvarchar100CHAR(N' ')NoTCY30CY_GESPROF Allow NULL? 
50BALK_PROFProfile for project planning boardnvarchar120CHAR(N' ')NoTCBPBPPROFILE Allow NULL? 
51KBEDInd: do not create capacity requirementschar10CHAR(N' ')NoKBED_D Allow NULL? 
52KKALKRIndicator: Components will not be costedchar10CHAR(N' ')NoCOMP_CALC Allow NULL? 
53LSTVARVariable overviews: Overview variantnvarchar120CHAR(N' ')NoTCNVLCNL_LSTVAR Allow NULL? 
54MATKLMaterial Groupnvarchar90CHAR(N' ')NoT023MATKL Allow NULL? 
55MATEXITInd.: User exit for components replaces standard overviewchar10CHAR(N' ')YesMATEXIT Allow NULL? 
56EKGRPPurchasing Groupnvarchar30CHAR(N' ')YesT024EKGRP Allow NULL? 
57MATKL_FRMDMaterial Groupnvarchar90CHAR(N' ')YesT023MATKL Allow NULL? 
58EKGRP_FRMDPurchasing Groupnvarchar30CHAR(N' ')YesT024EKGRP Allow NULL? 
59POSNR_MATItem number increment for material componentsnvarchar40NUMC(N'0000')YesPOSNR_MAT Allow NULL? 
60SCHED_ENDScheduling aligned with activity finish datechar10CHAR(N' ')YesSCHED_END Allow NULL? 
61SCEND_ACTInd.: Purchase requisition at activity finish datechar10CHAR(N' ')YesSCEND_ACT Allow NULL? 
62NT_SEARCH1Number of the first text used for the search.nvarchar20CHAR(N' ')YesCN_SEARCH1 Allow NULL? 
63NT_SEARCH2Number of the second text used for the search.nvarchar20CHAR(N' ')YesCN_SEARCH2 Allow NULL? 
64NT_SEARCH3Number of the third text used for the search.nvarchar20CHAR(N' ')YesCN_SEARCH3 Allow NULL? 
65MFLICProcurement indicatornvarchar30CHAR(N' ')YesTCNMFCN_MFLIC Allow NULL? 
66MEINH_FRMDPurchase order unit for external processingnvarchar30UNIT(N' ')YesT006MEINH_FRMD Allow NULL? 
67MEINH_SERVPurchase order unit for a servicenvarchar30UNIT(N' ')YesT006MEINH_SERV Allow NULL? 
68KSTAR_MATVORPLCost element for material planning (int.processed activity)nvarchar100CHAR(N' ')YesCSKAKSTAR_MATVORPL Allow NULL? 
69KZERBIndicator: Project summarization via master data charact.char10CHAR(N' ')YesPS_KZERB Allow NULL? 
70VALIDValidationnvarchar70CHAR(N' ')YesGB93VALID Allow NULL? 
71VALID_VGValidationnvarchar70CHAR(N' ')YesGB93VALID Allow NULL? 
72SUBSTSubstitution namenvarchar70CHAR(N' ')YesGB92SUBST_ID Allow NULL? 
73SUBST_VGSubstitution namenvarchar70CHAR(N' ')YesGB92SUBST_ID Allow NULL? 
74FPARTBilling/Invoicing Plan Typenvarchar20CHAR(N' ')Yes*FPART Allow NULL? 
75IPPSiPPE Relationship with a Projectchar10CHAR(N' ')YesPS_IPPS Allow NULL? 
76TEMPLATE_KEYStandard text keynvarchar70CHAR(N' ')Yes*KTSCH Allow NULL? 
77PSACLACL tab activated for project and network profilechar10CHAR(N' ')YesPS_ACL_DELE Allow NULL? 
78PSACLHACL tab activated for project and network profilechar10CHAR(N' ')YesPS_ACLH_DELE Allow NULL? 
NamePrimaryUniqueTypeColumns
TCN41~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