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

174 tablesERP 6.0 

Production Planning and Control :: Basic Data :: Computer Aided Process Planning
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PLPH294CAPP: Sub-operationsComputer Aided Process Planning
2ERP EHP76.0TCAPI21CAPP statusComputer Aided Process Planning
3ERP EHP76.0TCAPM21Date of the last mini reorgComputer Aided Process Planning
4ERP EHP76.0TCAPT51Tables used in CAPP formulas and methodsComputer Aided Process Planning
5ERP EHP76.0TCARA21Rounding categoriesComputer Aided Process Planning
6ERP EHP76.0TCART41Rounding categories (Text)Computer Aided Process Planning
7ERP EHP76.0TCEH31Characteristic origins for formulas and methodsComputer Aided Process Planning
8ERP EHP76.0TCEHT41Characteristic origins for formulas and methods (text)Computer Aided Process Planning
9ERP EHP76.0TCEIT41CAPP status (text)Computer Aided Process Planning
10ERP EHP76.0TCERS21Rounding & additional values keysComputer Aided Process Planning
11ERP EHP76.0TCERT41Keys for rounding categories & additional values (text)Computer Aided Process Planning
12ERP EHP76.0TMATT41Machine types (text)Computer Aided Process Planning
13ERP EHP76.0TMATY21Machine typesComputer Aided Process Planning
14ERP EHP76.0TSRTB21Sort stringsComputer Aided Process Planning
15ERP EHP76.0TSRTT41Sort strings (text)Computer Aided Process Planning
16ERP EHP76.0TTTAB61Tables for technical dataComputer Aided Process Planning
17ERP EHP76.0TZART31Value types for CAPPComputer Aided Process Planning
18ERP EHP76.0TZATT41Value types for CAPP (texts)Computer Aided Process Planning
19ERP EHP76.0VERFK122Process header dataComputer Aided Process Planning
20ERP EHP76.0VERFT61Process textsComputer Aided Process Planning
21ERP EHP76.0VERME51Assignment of CAPP methods to CAPP processesComputer Aided Process Planning
22ERP EHP76.0VERTE61Assignment of CAPP processes to work centersComputer Aided Process Planning
23ERP EHP76.0VFORK102Formula header dataComputer Aided Process Planning
24ERP EHP76.0VFORP82Characteristics for formulasComputer Aided Process Planning
25ERP EHP76.0VFORS41Formula stringsComputer Aided Process Planning
26ERP EHP76.0VFORT41Formula textsComputer Aided Process Planning
27ERP EHP76.0VMETK162Method header dataComputer Aided Process Planning
28ERP EHP76.0VMETP122Characteristics for methodsComputer Aided Process Planning
29ERP EHP76.0VMETT51Method textsComputer Aided Process Planning
30ERP EHP76.0VMETV141Rules for characteristicsComputer Aided Process Planning
31ERP EHP76.0VMETVOR161Data base for CAPP rulesComputer Aided Process Planning
32ERP EHP76.0VMETW51Default values for characteristicsComputer Aided Process Planning
Production Planning and Control :: Basic Data :: Production ResourcesTools
ProductVersionTableColumnsIndexesDescriptionModule
33ERP EHP76.0AFFH672PRT assignment data for the work orderProduction ResourcesTools
34ERP EHP76.0CRFH602CIM production resource/tool master dataProduction ResourcesTools
35ERP EHP76.0CRVD_A71Link of PRT to DocumentProduction ResourcesTools
36ERP EHP76.0CRVD_B71Link of Document to PRTProduction ResourcesTools
37ERP EHP76.0CRVE_A41Assignment PRT data - equipmentProduction ResourcesTools
38ERP EHP76.0CRVE_B41Assignment equipment - PRT dataProduction ResourcesTools
39ERP EHP76.0CRVM_A51Link of PRT data to a materialProduction ResourcesTools
40ERP EHP76.0CRVM_B51Link of material to a production resource/toolProduction ResourcesTools
41ERP EHP76.0CRVP_A41Linkage of PRT Data - Measuring PointProduction ResourcesTools
42ERP EHP76.0CRVP_B41Linkage of Measuring Point - PRT DataProduction ResourcesTools
43ERP EHP76.0CRVS_A41Relationship of PRT internal number to PRT external numberProduction ResourcesTools
44ERP EHP76.0CRVS_B41Relationship of PRT external number to PRT internal numberProduction ResourcesTools
45ERP EHP76.0TCF0211PRT categoriesProduction ResourcesTools
46ERP EHP76.0TCF0341Texts for the production resources/tools categoryProduction ResourcesTools
47ERP EHP76.0TCF0441Status of the PRT masterProduction ResourcesTools
48ERP EHP76.0TCF0541Language-dependent text table for PRT statusProduction ResourcesTools
49ERP EHP76.0TCF1071PRT control keyProduction ResourcesTools
50ERP EHP76.0TCF1141Language-dependent text table for PRT control keysProduction ResourcesTools
51ERP EHP76.0TCF1221Key for grouping production resources/toolsProduction ResourcesTools
52ERP EHP76.0TCF1341Language-dependent text table for PRT group keysProduction ResourcesTools
Production Planning and Control :: Basic Data :: Routing
ProductVersionTableColumnsIndexesDescriptionModule
53ERP EHP76.0CWB_OPTIONS_DEF401User-specific options for the Engineering WorkbenchRouting
54ERP EHP76.0CWB_SEL_VARIANTS141EWB: User-Specific Initial VariantsRouting
55ERP EHP76.0CWB_SEL_VAR_DEF41EWB: User-defined settings for selection variantsRouting
56ERP EHP76.0CWB_SEL_VAR_ROOT51EWB: All selection variantsRouting
57ERP EHP76.0CWB_SEL_VAR_TXT61EWB: Descriptions (meanings) of selection variants in EWBRouting
58ERP EHP76.0CWB_WORKAREA_DEF41EWB: User-Dependent Initial VariantsRouting
59ERP EHP76.0MAPL253Assignment of Task Lists to MaterialsRouting
60ERP EHP76.0PLAS162Task list - selection of operations/activitiesRouting
61ERP EHP76.0PLFH403Task list - production resources/toolsRouting
62ERP EHP76.0PLFL272Task list - sequencesRouting
63ERP EHP76.0PLKO788Task list - headerRouting
64ERP EHP76.0PLKZ131Task list: main headerRouting
65ERP EHP76.0PLMZ544Allocation of bill of material items to operationsRouting
66ERP EHP76.0PLPO2257Task list - operation/activityRouting
67ERP EHP76.0PLPR51Log collector for task listsRouting
68ERP EHP76.0PLSR161Scheduling resultsRouting
69ERP EHP76.0PLZU131Routing data for groupRouting
70ERP EHP76.0STPF102Structure tree of the exploded BOMRouting
71ERP EHP76.0T024A41Planner groupRouting
72ERP EHP76.0T410361Engineering Workbench: Working areaRouting
73ERP EHP76.0T410T51Engineering Workbench: Working environment (text)Routing
74ERP EHP76.0T41131Task list usageRouting
75ERP EHP76.0T411T41Language-dependent texts for T411: Task list usagesRouting
76ERP EHP76.0T41251Task list statusRouting
77ERP EHP76.0T412T41Language-dependent texts for T412: Task list statusRouting
78ERP EHP76.0T42541Setup group keysRouting
79ERP EHP76.0T425T61Language-dependent texts for T425: Setup group keysRouting
80ERP EHP76.0T42631Setup group categoriesRouting
81ERP EHP76.0T426T51Language-dependent texts for T426: Setup group categoriesRouting
82ERP EHP76.0T42931Standard Times Calculation TypeRouting
83ERP EHP76.0T429T51Lang.-depend. texts for Tab. T429: Types of std. val. determRouting
84ERP EHP76.0T48831Assignment of Table Fields to GroupsRouting
85ERP EHP76.0T488A51Language-dependent texts for Table T488Routing
86ERP EHP76.0T488B11Value table for T488: "Option types for routing history"Routing
87ERP EHP76.0T488C31Texts for Table T488BRouting
88ERP EHP76.0TC01111CUA status tableRouting
89ERP EHP76.0TC01A51Set type of functionRouting
90ERP EHP76.0TC0261Check whether an FCode is permittedRouting
91ERP EHP76.0TC3371Allocation of function code to the operation to be checkedRouting
92ERP EHP76.0TCA0711Sequence categoriesRouting
93ERP EHP76.0TCA0841Language-dependent texts for sequence categoriesRouting
94ERP EHP76.0TCA16101Layout of lines in object overview versionsRouting
95ERP EHP76.0TCA2041Grouping categories for object overview versionsRouting
96ERP EHP76.0TCA2341Permissible tables and structures for grouping categoriesRouting
97ERP EHP76.0TCA36121Task lists: Ctrl.tab. for callng. popups from functn.modulesRouting
98ERP EHP76.0TCA5011Relationship key for ref. operations of parallel sequencesRouting
99ERP EHP76.0TCA5141Lang-dependent texts for TCA50: Relationship keys for schd.Routing
100ERP EHP76.0TCA5211Alignment key used for scheduling parallel sequencesRouting
101ERP EHP76.0TCA5341Language-dependent texts for TCA52: Alignment keysRouting
102ERP EHP76.0TCA5411Key for reference dates used in offset schedulingRouting
103ERP EHP76.0TCA5531Language-dependent texts for reference dates in offset schd.Routing
104ERP EHP76.0TCA6271Defining screen sequences for entry toolRouting
105ERP EHP76.0TCA6671Screen sequence definitionRouting
106ERP EHP76.0TCA7131Task lists: Verification of function modulesRouting
107ERP EHP76.0TCA7251Task lists: Verification level of the function modulesRouting
108ERP EHP76.0TTXCP21Objects and IDs for client copyRouting
Production Planning and Control :: Basic Data :: Work Center
ProductVersionTableColumnsIndexesDescriptionModule
109ERP EHP76.0CRCA273Work Center Capacity AllocationWork Center
110ERP EHP76.0CRCIFOBJ51Object IDs of changed capacitiesWork Center
111ERP EHP76.0CRCO202Assignment of Work Center to Cost CenterWork Center
112ERP EHP76.0CRHD1286Work Center HeaderWork Center
113ERP EHP76.0CRHH112Hierarchy Header DataWork Center
114ERP EHP76.0CRHS122Hierarchy StructureWork Center
115ERP EHP76.0CRID31CIM Resource - EntitiesWork Center
116ERP EHP76.0CRTX81Text for the Work Center or Production Resource/ToolWork Center
117ERP EHP76.0KAKO765Capacity Header SegmentWork Center
118ERP EHP76.0KAKT42Capacity DescriptionWork Center
119ERP EHP76.0KAPA181Shift Parameters for Available CapacityWork Center
120ERP EHP76.0KAPE81Capacity unit of measure allocationWork Center
121ERP EHP76.0KAZY131Interval of Available CapacityWork Center
122ERP EHP76.0T024C31Planner Group for CAPPWork Center
123ERP EHP76.0T42131Wage groupsWork Center
124ERP EHP76.0T421T51Language-dependent texts for T421: Wage groupsWork Center
125ERP EHP76.0T42331Wage group qualificationWork Center
126ERP EHP76.0T423T51Language-dependent texts for T423: Qualifications/Wage grp.Work Center
127ERP EHP76.0T42831Setup Type KeyWork Center
128ERP EHP76.0T428T51Language-dependent texts for T428: Setup type keyWork Center
129ERP EHP76.0T430221Operation/Activity control keyWork Center
130ERP EHP76.0T430T51Language-dependent text table for the control key T430Work Center
131ERP EHP76.0T43521Standard texts for routing/ref. op set itemsWork Center
132ERP EHP76.0T435T41Language-dependent texts for T435: Standard text keyWork Center
133ERP EHP76.0T499S51LocationWork Center
134ERP EHP76.0TC10111Initial values for CIM screen sequenceWork Center
135ERP EHP76.0TC20131"Formula Parameters"Work Center
136ERP EHP76.0TC20T51Text for parameter IDWork Center
137ERP EHP76.0TC21421Standard value keyWork Center
138ERP EHP76.0TC21T41Language-dependent texts for TC21: Standard value keyWork Center
139ERP EHP76.0TC2231Field Name of Value from Transport StructureWork Center
140ERP EHP76.0TC22T51Field Name of Value from Transport StructureWork Center
141ERP EHP76.0TC2321Key for use of the work center in the task listsWork Center
142ERP EHP76.0TC23A41Valid types for the work centerWork Center
143ERP EHP76.0TC23T41Language-dependent texts for TC23: Usage keyWork Center
144ERP EHP76.0TC2441Person responsible for the work centerWork Center
145ERP EHP76.0TC25101Work center formulasWork Center
146ERP EHP76.0TC25T41Short text for the formulaWork Center
147ERP EHP76.0TC2651Capacity categoryWork Center
148ERP EHP76.0TC26D41Default values for capacityWork Center
149ERP EHP76.0TC26T41Description of the capacity categoryWork Center
150ERP EHP76.0TC2721Capacity planner groupsWork Center
151ERP EHP76.0TC27T41Text for the capacity planner groupWork Center
152ERP EHP76.0TC2831Location groupsWork Center
153ERP EHP76.0TC28T51Description of the location groupWork Center
154ERP EHP76.0TC3081Work center categoryWork Center
155ERP EHP76.0TC30A31Work center categoriesWork Center
156ERP EHP76.0TC30D41Defaults for the work centerWork Center
157ERP EHP76.0TC30T41Text for the work center categoryWork Center
158ERP EHP76.0TC3121Performance Efficiency Rate KeyWork Center
159ERP EHP76.0TC31A51Key for performance efficiency rateWork Center
160ERP EHP76.0TC31T41Text for the performance efficiency rate keyWork Center
161ERP EHP76.0TC3521Period pattern keyWork Center
162ERP EHP76.0TC35T41Text for period pattern keyWork Center
163ERP EHP76.0TC3641Available capacity versionWork Center
164ERP EHP76.0TC36T41Text for this version of available capacityWork Center
165ERP EHP76.0TC37A141Shift definitionWork Center
166ERP EHP76.0TC37P81Break scheduleWork Center
167ERP EHP76.0TC37S51Texts for break plansWork Center
168ERP EHP76.0TC37T51Texts for shift definitionsWork Center
169ERP EHP76.0TC38A111Shift sequenceWork Center
170ERP EHP76.0TC38T51Texts for shift groupingsWork Center
171ERP EHP76.0TC39A21Grouping shift definitions and shift sequencesWork Center
172ERP EHP76.0TC39T41Texts for grouping shift definition and shift sequenceWork Center
173ERP EHP76.0TCR0091Installation constants for work centerWork Center
174ERP EHP76.0TCRCOT41Alternative Texts for Describing an ActivityWork Center