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  | TCBP
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
Project System :: Structures :: Operative Structures :: Project Planning Board
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TCBP631Gantt chart settingsProject Planning Board
SQL:  selectupdate insert create

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

SELECT MANDT, PROFILE, PROF_FD, WIDTH_P_C, TRMNL, CMART, CMPOS, VRGEA, RELEA, UPDTS, TRMKS, WAERS, DAUNE, ARBEH, DFARB, DFDAU, PRF_GRUPPE, PRF_NAME, TIM_PROF, PRT_SCALE, TIM_SCALE, AENAM, PROTECT, CUSTOM, ANZ_KAL, ANZ_TRM, ANZ_HGR, ANZ_VGR, APPLI, TMPRI, MSANZ, MSTEA, VERSN1, VERSN2, FRSPT, PFFREI, ACTYP, ELTYP, T_LEFT, T_MIDDLE, T_RIGHT, T_UPPER, T_DOWN, GRID_MODE, HORL_MODE, ROW_HEIGHT, CLMN_INDEN, VELEA, VGKRT, NZANZ, RIBB_PROF, PROF_FCAP, PROF_FMAT, PROF_FCOS, EVA_VERSN, CONSTR, SHDOW, PROF_ORDER, CP_UNAME, OBJCP, DSHIFT, PROF_PRNT, SUBEA FROM TCBP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PROFILEProfile for project planning boardnvarchar120CHAR(N' ')NoBPPROFILE Allow NULL? 
3PROF_FDGantt chart profile in planning board: Displayed fieldsnvarchar120CHAR(N' ')NoTCNFPS_PPT_GT Allow NULL? 
4WIDTH_P_CWidth per character in project planning boardnvarchar30NUMC(N'000')NoPS_NUMC3 Allow NULL? 
5TRMNLEarliest and/or latest dateschar10NUMC(N'0')NoPS_TRMLAGE Allow NULL? 
6CMARTDescription on the time barchar10NUMC(N'0')NoPS_COMMART Allow NULL? 
7CMPOSText position on time barchar10NUMC(N'0')NoPS_COMMPOS Allow NULL? 
8VRGEAShow/Hide activitieschar10CHAR(N' ')NoPS_VRGNGEA Allow NULL? 
9RELEAShow/Hide relationshipschar10CHAR(N' ')NoPS_RELATEA Allow NULL? 
10UPDTSSchedule every changechar10CHAR(N' ')NoPS_UPDDATS Allow NULL? 
11TRMKSWhich set of dates should be displayed?char10NUMC(N'0')NoPS_TRMNKRS Allow NULL? 
12WAERSCurrency Keynvarchar50CUKY(N' ')NoTCURCWAERS Allow NULL? 
13DAUNENormal duration/unitnvarchar30UNIT(N' ')NoT006DAUNORE Allow NULL? 
14ARBEHUnit for worknvarchar30UNIT(N' ')NoT006ARBEITE Allow NULL? 
15DFARBDefault values for workdecimal71QUAN((0))NoDEFARBEIT
16DFDAUDefault values for durationdecimal51QUAN((0))NoDFDAUER
17PRF_GRUPPEProfile group (sort graphics profiles)nvarchar40CHAR(N' ')NoTBCGBCPRFGROUP Allow NULL? 
18PRF_NAMEName of graphics profilenvarchar120CHAR(N' ')NoBCPRFNAME Allow NULL? 
19TIM_PROFTime profile for capacity leveling/extended evaluationnvarchar100CHAR(N' ')NoTCY33CY_TIPRO Allow NULL? 
20PRT_SCALETime scale in the planning tablenvarchar100CHAR(N' ')NoTCY54DSEC_PROF Allow NULL? 
21TIM_SCALETime scale profilenvarchar100CHAR(N' ')NoTCY58RIB_PROF Allow NULL? 
22AENAMLast changed bynvarchar120CHAR(N' ')NoPS_AENAM Allow NULL? 
23PROTECTIndicator: Entry can only be changed by the last processorchar10CHAR(N' ')NoPS_PPTPCT Allow NULL? 
24CUSTOMIndicator: Maintenance only allowed in Customizingchar10CHAR(N' ')NoPS_PPTCST Allow NULL? 
25ANZ_KALDisplay non-working timechar10CHAR(N' ')NoPS_ANZKAL Allow NULL? 
26ANZ_TRMDisplay scheduled WBS dateschar10CHAR(N' ')NoPS_ANZTRM Allow NULL? 
27ANZ_HGRDisplay horizontal lineschar10CHAR(N' ')NoPS_ANZHGR Allow NULL? 
28ANZ_VGRDisplay vertical lineschar10CHAR(N' ')NoPS_ANZVGR Allow NULL? 
29APPLIApplication calling up the project planning boardnvarchar20CHAR(N' ')NoPS_APPLI Allow NULL? 
30TMPRIDate display for several sets of dateschar10NUMC(N'0')NoPS_TMPRI Allow NULL? 
31MSANZIndicator: Display milestone for WBS element/activitychar10CHAR(N' ')NoPS_MSANZ Allow NULL? 
32MSTEAShow/hide milestonechar10CHAR(N' ')NoPS_MSTEA Allow NULL? 
33VERSN1Plan versionnvarchar30CHAR(N' ')NoTKVSVERSN_CO Allow NULL? 
34VERSN2Plan versionnvarchar30CHAR(N' ')NoTKVSVERSN_CO Allow NULL? 
35FRSPTIndicator: Show total floatchar10CHAR(N' ')NoFRHSPTLG Allow NULL? 
36PFFREIIndicator: Show free bufferchar10CHAR(N' ')YesPS_PFFREI Allow NULL? 
37ACTYPKey for activity typechar10CHAR(N' ')YesPS_ACTYP Allow NULL? 
38ELTYPKey for activity element typechar10CHAR(N' ')YesPS_ELTYP Allow NULL? 
39T_LEFTDescription to the left ofthe time barnvarchar200CHAR(N' ')YesCNT_LEFT Allow NULL? 
40T_MIDDLEDescription in the time barnvarchar200CHAR(N' ')YesCNT_MIDDLE Allow NULL? 
41T_RIGHTDescription to the right of the time barnvarchar200CHAR(N' ')YesCNT_RIGHT Allow NULL? 
42T_UPPERDescription above the time barnvarchar200CHAR(N' ')YesCNT_UPPER Allow NULL? 
43T_DOWNDescription below the time barnvarchar200CHAR(N' ')YesCNT_DOWN Allow NULL? 
44GRID_MODETime fence modechar10CHAR(N' ')YesGRID_MODE Allow NULL? 
45HORL_MODEHorizontal lines in graph areanvarchar20NUMC(N'00')YesBCHORLINE_ Allow NULL? 
46ROW_HEIGHTHeight of lines in bar chartint100INT4((0))YesBCROWHEIGH Allow NULL? 
47CLMN_INDENNumber of columns that the field should be indentednvarchar20NUMC(N'00')YesCNT_CLMN_IND Allow NULL? 
48VELEAShow/hide activity elementschar10CHAR(N' ')YesPS_VRELMEA Allow NULL? 
49VGKRTValue for crtical activitiesdecimal30DEC((0))YesPS_VGKRT
50NZANZDisplay network mumberchar10CHAR(N' ')YesNZ_NZANZPPB Allow NULL? 
51RIBB_PROFName of the time scale profilenvarchar120CHAR(N' ')Yes*BCRIBPROF Allow NULL? 
52PROF_FCAPLoad chart profile in planning board: Displayed fieldsnvarchar120CHAR(N' ')YesTCNFPS_PROF_FCAP Allow NULL? 
53PROF_FMATMaterial components profile in planning board: Displ. fieldsnvarchar120CHAR(N' ')YesTCNFPS_PROF_FMAT Allow NULL? 
54PROF_FCOSCost chart profile in planning board: Displayed fieldsnvarchar120CHAR(N' ')YesTCNFPS_PROF_FCOS Allow NULL? 
55EVA_VERSNProgress Versionnvarchar30CHAR(N' ')Yes*VERSN_EV Allow NULL? 
56CONSTRSet constraintchar10CHAR(N' ')YesPS_CONSTRAINT Allow NULL? 
57SHDOWDisplay original schedulechar10CHAR(N' ')YesPS_SHADOW Allow NULL? 
58PROF_ORDERProfile for PM ordersnvarchar120CHAR(N' ')YesTCNFPS_PROF_ORDER Allow NULL? 
59CP_UNAMEReference user for templatesnvarchar120CHAR(N' ')YesPS_UNAMECP Allow NULL? 
60OBJCPIndicator: Copy objectschar10CHAR(N' ')YesPS_OBJCP Allow NULL? 
61DSHIFTIndicator: Move datechar10CHAR(N' ')YesPS_DSHIFT Allow NULL? 
62PROF_PRNTField selection for additional printing featurenvarchar120CHAR(N' ')YesTCNFPS_PROF_PRNT Allow NULL? 
63SUBEADisplay subnetworkschar10CHAR(N' ')YesPS_VRGEA Allow NULL? 
NamePrimaryUniqueTypeColumns
TCBP~0YesYesCLUSTEREDPROFILE, 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