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

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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

80 columns | Print definition?ERP 6.0  | STATUS_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/C_RM_PRF_STRisk Profile Status3STATUS_IDRisk Status IDnvarchar40
2/CPD/C_RM_STATRisk Status2STATUS_IDRisk Status IDnvarchar40
3/CPD/C_RM_STAT_TRisk Status: Text Table2STATUS_IDRisk Status IDnvarchar40
4/CPD/D_MP_ST_ARVTable for Status Area version6STATUS_IDStatus Keynvarchar40
5/CPD/D_MP_ST_HRAStatus Header Area6STATUS_IDStatus Keynvarchar40
6/CPD/D_PFP_PHPlan Header18STATUS_IDStatus IDnvarchar40
7/CPD/D_PFP_PVPlan Version11STATUS_IDStatus IDnvarchar40
8/CPD/FC_PRF_STProfile's Status Info Table3STATUS_IDStatus IDnvarchar40
9/CPD/FC_STATUSStatus Info Table2STATUS_IDStatus IDnvarchar40
10/CPD/FC_STATUS_TText Table For Status3STATUS_IDStatus IDnvarchar40
11/CPD/FC_ST_NEXTFor Next Staus Info for a Status3STATUS_IDStatus IDnvarchar40
12/CPD/FC_TRNMT_STTransfer Method and Status3STATUS_IDStatus IDnvarchar40
13/MRSS/C_TEAM_INTTeam Integration Customizing Details2STATUS_IDType of Abstract MRS Statusnvarchar100
14/MRSS/M_AUT_ASGNMirror for Control table for automatic assignment creation6STATUS_IDUser status (header)nvarchar40
15/MRSS/M_RSG_CTRLMRS: Mirror for resource planning relevance of operations8STATUS_IDUser status (header)nvarchar40
16/PLMB/PR_TMP_STAProcess Route Template Determination Based on Status4STATUS_IDStatus Identificationnvarchar200
17/SAPSRM/ST_INDEXStatus Index Table : Used for POWL1STATUS_IDObject statusnvarchar50
18DMC_MDS_STATUSStatus table for all maintenance events2STATUS_IDIUUC: status table idnvarchar10
19GRRMOBWAGDLoss Event WF: Agent Determination for Statuses3STATUS_IDStatus of Loss Event - IDnvarchar30
20GRRMOBWSTLoss Event WF: Statuses2STATUS_IDStatus of Loss Event - IDnvarchar30
21GRRMOBWSTSCSTLoss Event WF: Available Statuses for Status Schemes3STATUS_IDStatus of Loss Event - IDnvarchar30
22GRRMOBWSTSCSTNLoss Event WF: Next Available Statuses3STATUS_IDStatus of Loss Event - IDnvarchar30
23GRRMOBWSTSCSTTLoss Event WF: Available Statuses for Status Schemes - Texts4STATUS_IDStatus of Loss Event - IDnvarchar30
24GRRMOBWSTTLoss Event WF: Statuses - Text Table3STATUS_IDStatus of Loss Event - IDnvarchar30
25RSBPCW_LCK_DIMBPC Work Status - Lock Dimension Table4STATUS_IDwork status idnvarchar200
26RSBPCW_STATCODEBPC Work Status - Status Code Table4STATUS_IDwork status idnvarchar200
27RSBPCW_STATCODETBPC Work Status - Status Code Text Table5STATUS_IDwork status idnvarchar200
28RSBPCW_STATCOMPBPC Work Status - Component Enablement Status for Work State4STATUS_IDwork status idnvarchar200
29RSBPCW_WK_STATUSBPC Work Status: Meta Info for Work Status4STATUS_IDwork status idnvarchar200
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
30SATC_AC_STATUSHMovement data: 'History Series' header1STATUS_IDUnique ID - hex 16 - raw formatvarbinary160
TOPBusiness Process Change Analyzer
31E2ET_AT_REC_HEADTBOM Recording by eCATT: Header Data3STATUS_IDGUID for Structurenvarchar320
32E2ET_AT_REC_TRIDTBOM Recording by eCATT: Trace IDs3STATUS_IDGUID for Structurenvarchar320
TOPCapacity and Resource Planning
33/MRSS/C_RM_AB_CARM Abstract Statuses at the Candidate Level3STATUS_IDUser Statusnvarchar50
34/MRSS/C_RM_AB_RORM Abstract Statuses at the Role Level3STATUS_IDUser Statusnvarchar50
35/MRSS/C_RM_AB_RQRM Abstract Statuses at the Request Level3STATUS_IDUser Statusnvarchar50
36/MRSS/C_RM_A_CA1RM Abstract Statuses at the Candidate Level3STATUS_IDUser Statusnvarchar50
37/MRSS/D_RM_BCDATBroadcast Worklist Data7STATUS_IDIndividual status of an object (short form)nvarchar40
38/MRSS/D_RM_BCHISBroadcast History Table9STATUS_IDIndividual status of an object (short form)nvarchar40
TOPClinical System
39TN2COM_STATTYPESStatus for Document Dispatch2STATUS_IDDispatch Status IDnvarchar150
40TN2COM_STATTYPETText Table for N2COMM_STATTYPES2STATUS_IDDispatch Status IDnvarchar150
TOPCollaboration Folders
41CFS_STATUSCFS: Additional (Mapping) Data for Status2STATUS_IDStatus IDnvarchar320
42CFS_STATUS_FGRPField Groups for Status2STATUS_IDStatus IDnvarchar320
43CFS_STAT_ACTIONCFS: Actions for Status2STATUS_IDStatus IDnvarchar320
44CFX_COLCollaboration Folders: Collaboration14STATUS_IDObject IDvarbinary160
45CFX_REMIND_QUEUECFX: Queue for Reminder Actions for Status Management7STATUS_IDStatus IDnvarchar320
TOPCross-Application Components
46/IXOS/DC_TCSTACM: Status table5STATUS_IDCM Status: Status IDnvarchar40
47/IXOS/DC_TCSTATCM: Status text table6STATUS_IDCM Status: Status IDnvarchar40
48/IXOS/DC_TTCSTACM: temporary status table, used at f4-help flow5STATUS_IDCM Status: Status IDnvarchar40
49/IXOS/DC_TTCSTATCM: temporary status text table, used for f4 help - flow6STATUS_IDCM Status: Status IDnvarchar40
TOPEngineering Change Record
50/PLMI/ECR_PREREQECR - Status Prerequisite customizing table2STATUS_IDECR Status Identificationnvarchar200
TOPImplementation Guide
51TSTAFPRTest Workbench status: Connection to test package3STATUS_IDUnique identifier for status informationnvarchar320
52TSTAFTWTest Workbench Status Mgt: Connection to Test Package3STATUS_IDUnique identifier for status informationnvarchar320
53TSTATIMGAssignment of activity data for project, activity, view2STATUS_IDUnique identifier for status informationnvarchar320
TOPMaintenance Orders
54/MRSS/C_AUT_ASGNControl table for automatic assignment creation4STATUS_IDUser status (operation)nvarchar40
55/MRSS/C_RSG_CTRLMRS: resource planning relevance of operations6STATUS_IDUser status (header)nvarchar40
56/MRSS/C_WL_CSTATCustomer Status in Demand3STATUS_IDCustomer-status numbernvarchar10
57/MRSS/D_DEM_STATStatus of demand items8STATUS_IDStatus: IDnvarchar50
TOPNetWeaver Enterprise Search
58ESH_ADM_SC_MONStatus Monitor for Search Object Connectors3STATUS_IDStatus of a Search Object Connector in the Web Servicenvarchar100
TOPOrganizational Flexibility
59/ISDFPS/PM_TP_OFlight Programs for Order7STATUS_IDTraining Status IDnvarchar150
60/ISDFPS/TRNGQUALTraining - Qualification Mapping4STATUS_IDTraining Status IDnvarchar150
TOPPersonnel Categories
61PA0806Personnel Master Record for Infotype 080627STATUS_IDTraining Status IDnvarchar150
62TRAIN_PLAN_VALPlanned Data for a Training Course4STATUS_IDTraining Status IDnvarchar150
63TRAIN_QUALIMapping: Qualification to Training5STATUS_IDTraining Status IDnvarchar150
64TRAIN_STATTraining Status4STATUS_IDTraining Status IDnvarchar150
65TRAIN_STAT_TTraining Status Description5STATUS_IDTraining Status IDnvarchar150
TOPStatus and Action Management
66/PLMB/SAM_FCPLM Status Management - OType, Status, Struc, Field, Propert3STATUS_IDStatus Identificationnvarchar200
67/PLMB/SAM_ND_APLM Status management - status action assignments2STATUS_IDStatus Identificationnvarchar200
68/PLMB/SAM_ND_FPLM Status management - status fieldvalue assignments2STATUS_IDStatus Identificationnvarchar200
69/PLMB/SAM_NODEPLM Status management - status definition3STATUS_IDStatus Identificationnvarchar200
70/PLMB/SAM_NODE_TPLM Status management - status definition text table4STATUS_IDStatus Identificationnvarchar200
71/PLMB/SAM_OBJSTPLM Status management - Otype Schema,Status, Date And User6STATUS_IDStatus Identificationnvarchar200
TOPTest Organizer
72ISSUE_ATTRIBIssue Managment: Message Attributes1STATUS_IDUnique identifier for status informationnvarchar320
73ISSUE_RELIssue Management: Relationship Table (Project, Issue)2STATUS_IDUnique identifier for status informationnvarchar320
74ISSUE_RELATIONIssue Management: Relationship Table (Project, Issue)2STATUS_IDUnique identifier for status informationnvarchar320
TOPTour Status
75/DSD/ST_CACT_IUActivites in UPDATE TASK3STATUS_IDTour status IDnvarchar80
76/DSD/ST_CPROFILEStatus profile5STATUS_IDTour status IDnvarchar80
77/DSD/ST_CSTATUSTour status ID1STATUS_IDTour status IDnvarchar80
78/DSD/ST_CSTAT_TTour status ID (Text table to /DSD/ST_CSTATUS)1STATUS_IDTour status IDnvarchar80
79/DSD/ST_STATUSCurrent tour status5STATUS_IDTour status IDnvarchar80
80/DSD/ST_STATUS_HTour status history - Recording tour status4STATUS_IDTour status IDnvarchar80