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
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

103 columns | Print definition?ERP 6.0  | AUTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVA_PCREA_WIP_OLT PC Reorg Analysis: WIP Reconciliation results (Level 2)12AUTYPOrder categorynvarchar20
2FIKZD_CONTR_MAPCSubsoil use contracts mapping15AUTYPOrder categorynvarchar20
3FIKZD_CONTR_MAPPSubsoil use contracts mapping22AUTYPOrder categorynvarchar20
4J_1UF_TP_BSEGCORItems of Corrective documents38AUTYPSD document categorynvarchar10
5J_1UF_TP_BSEGORIItems of Original documents38AUTYPSD document categorynvarchar10
6J_3RF_TP_BSEGCORItems of Corrective documents36AUTYPSD document categorynvarchar10
7J_3RF_TP_BSEGORIItems of Original documents36AUTYPSD document categorynvarchar10
8T490Transactions PP - orders - order category2AUTYPOrder categorynvarchar20
9T496BCIM order: Assigning document types to reference doc. types2AUTYPOrder categorynvarchar20
10T496FCIM order: Form description of the list2AUTYPOrder categorynvarchar20
11T496NCIM order: List descriptions2AUTYPOrder categorynvarchar20
12T496RPrint PP shop papers: Report control2AUTYPOrder categorynvarchar20
13T496TPrint PP shop papers: Transaction control2AUTYPOrder categorynvarchar20
14TC62Sequence of detail screens when processing header externally1AUTYPOrder categorynvarchar20
15TCO01Sequence/operations control in logicstics orders1AUTYPOrder categorynvarchar20
16TCO03CIM order: Texts for TCO01, Description of order categories2AUTYPOrder categorynvarchar20
17TCO04Table for controlling the screen sequence group2AUTYPOrder categorynvarchar20
18TCO60Sequence keys for input facility and verification2AUTYPOrder categorynvarchar20
19TCO61Sequence key for PP orders3AUTYPOrder categorynvarchar20
20TCORVTable with Routines for structureing variable loop lines2AUTYPOrder categorynvarchar20
21TCORWConfirmation: Window Control1AUTYPOrder categorynvarchar20
22ZAUFTRAGOrder selection criteria2AUTYPOrder categorynvarchar20
23ZCATSDBRecords changed with processing status '10'53AUTYPnvarchar20
24ZCATSDB2Records changed with processing status '10'54AUTYPnvarchar20
25ZPS1IDES Text Pools10AUTYPOrder categorynvarchar20
26ZPS1_OLDIDES: Assign text pool to standard structure10AUTYPOrder categorynvarchar20
27ZPS2IDES: Assign text pool to standard structure5AUTYPOrder categorynvarchar20
TOPAccounting - General
28KPEP_WL_PSHIERHierarchy for WL Type Projects in Schedule Manager Worklist9AUTYPOrder categorynvarchar20
TOPAccounting Interface
29GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)229AUTYPOrder categorynvarchar20
30GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)229AUTYPOrder categorynvarchar20
TOPActual CostingMaterial Ledger
31CKMLMV013Assignment table: Process for production order3AUTYPOrder categorynvarchar20
TOPBatches
32CHVW_PREPreliminary Batch Where-used List According to Order/PO20AUTYPOrder categorynvarchar20
TOPBilling
33VBRPBilling Document: Item Data127AUTYPSD document categorynvarchar10
TOPConditions
34A037Overhead Type/Order Catg.6AUTYPOrder categorynvarchar20
TOPConfirmations
35AFFWGoods Movements with Errors from Confirmations46AUTYPOrder categorynvarchar20
36AFRCIncorrect cost calculations from confirmations8AUTYPOrder categorynvarchar20
37AFRDDefault values for collective confirmation2AUTYPOrder categorynvarchar20
38AFRVConfirmation pool147AUTYPOrder categorynvarchar20
39AFRV_DELBackup Copy for Confirmation Pool147AUTYPOrder categorynvarchar20
40CORUUSRUser Settings for Confirmation3AUTYPOrder categorynvarchar20
41TCORDTable for field-dependent check routines1AUTYPOrder categorynvarchar20
42TCORUPBTXTCustomizing Single Screen Entry Confirmat.: Status Interface2AUTYPOrder categorynvarchar20
43TCORUSSDEFCustomizing for Single Screen Entry of a Confirmation2AUTYPOrder categorynvarchar20
44TPRRUControl table for process chain for confirmation2AUTYPOrder category for controlling confirmation processnvarchar20
45TPRRUTText table for process control of confirmation3AUTYPOrder category for controlling confirmation processnvarchar20
46TRUSControl table for collective confirmation2AUTYPOrder categorynvarchar20
47TSUBSCRAREACustomizing for Single Screen Entry of a Confirmation3AUTYPOrder categorynvarchar20
TOPConsumer Products for Food Beverage
48CFB_RB_CUSTCustomizing: Clearing Remaining Batch Quantities6AUTYPOrder Category for Clearing Remaining Batch Quantitiesnvarchar20
TOPCross-Application Components
49AAUUFKOrder master data4AUTYPOrder categorynvarchar20
TOPData Retention Tool
50TXW_S_VBRPRetrieve VBRP from archive17AUTYPSD document categorynvarchar10
TOPESS Based on WD ABAP
51HRESS_D_CATS_FAVCATS Favorites: database table60AUTYPOrder categorynvarchar20
TOPFinancial Accounting
52ACCTITCompressed Data from FI/CO Document92AUTYPOrder categorynvarchar20
TOPInformation System
53MCAFKOVVersions: Order Header Data - PP Orders7AUTYPOrder categorynvarchar20
54MCSFISR/2 SFIS Data: Old15AUTYPOrder categorynvarchar20
TOPIntegration
55FKK_VBRP_SHORTItem Data for SD Billing Document - Extracts13AUTYPSD document categorynvarchar10
TOPInventory Management
56CHVWTable CHVW for Batch Where-Used List34AUTYPOrder categorynvarchar20
TOPItaly
57PA0659HR master record for INAIL administration32AUTYPSubtype for INAIL Self-Settlementnvarchar40
TOPMaintenance History
58HIKOOrder master data history4AUTYPOrder categorynvarchar20
TOPMaterials Management
59/ISDFPS/CHVW_EExternal Batch Where-Used List34AUTYPOrder categorynvarchar20
TOPNetwork and Activity
60MLSTMilestone17AUTYPOrder categorynvarchar20
61SMGTMilestone group description3AUTYPOrder categorynvarchar20
62SMLGStandard milestone group2AUTYPOrder categorynvarchar20
63SMLSStandard milestone2AUTYPOrder categorynvarchar20
64TCN06Activity status that can trigger a workflow process1AUTYPOrder categorynvarchar20
65TCN61Parameter: Create network from sales order12AUTYPOrder categorynvarchar20
66TCOFPFORM subscreen for functions in milestone/trigger point2AUTYPOrder categorynvarchar20
TOPNon-Ferrous Metal enhancements
67/NFM/TPROVHISProvision: History10AUTYPNF document categorynvarchar10
TOPOrder Planning
68TCORUSHVALCheck Table for Header Screen Customizing SingleScreen Entry1AUTYPOrder categorynvarchar20
69TCORUSSVALCheck Table for Detail Screen Customizing SingleScreen Entry1AUTYPOrder categorynvarchar20
TOPOverhead Cost Orders
70AUFKOrder master data4AUTYPOrder categorynvarchar20
71T003OOrder Types3AUTYPOrder categorynvarchar20
TOPPlant Data Collection
72RUECKTemp. storage for subsystem confirmations142AUTYPOrder categorynvarchar20
TOPProduction Orders
73AFBPCIM order: Batch print requests8AUTYPOrder categorynvarchar20
74COWB140PARWorkbench Print Parameters for Request7AUTYPOrder categorynvarchar20
75COWB210PARParameters for Request for Technical Completion6AUTYPOrder Categorynvarchar20
76ORDCOMCommunication control Operation download5AUTYPOrder categorynvarchar20
77T399XParameters dependent on order type13AUTYPOrder categorynvarchar20
78T496DCIM: Destination/lists/spool parameters per user/plant2AUTYPOrder categorynvarchar20
79T496PPrint PP documents: Determination of output device2AUTYPOrder categorynvarchar20
80T496VPP Print: Default Value for Printing Online or Background2AUTYPOrder categorynvarchar20
81T496ZCIM order: Table-controlled table access2AUTYPOrder categorynvarchar20
82TCO36PP orders: Control table for calling up pop-up windows4AUTYPOrder categorynvarchar20
83TCO43PP-SFC Order Profile10AUTYPOrder categorynvarchar20
84TCO47Change profile for Order Change Management3AUTYPOrder categorynvarchar20
85TCO62Defining screen sequences for input facility and verificatn.2AUTYPOrder categorynvarchar20
86TCODBDatabase fields development class CO per order category1AUTYPOrder categorynvarchar20
87TCOFKTexts for functions in milestones/trigger points2AUTYPOrder categorynvarchar20
88TCOKTAccount assignment categories for order2AUTYPOrder categorynvarchar20
TOPRepetitive Manufacturing
89COMPMOVEGoods Movement of Components192AUTYPOrder categorynvarchar20
TOPSAP Business Partner
90TB030BP authorization types3AUTYPAuthorization typenvarchar80
91TB030TBP Authorization Types: Texts4AUTYPAuthorization typenvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
92NEO_NFALIS-H: External Orders - Order Data5AUTYPExternal Order - Order Categorynvarchar20
93NWCHNBEWIS-H CH: Bewegungen zum Fall - Zusatzfelder Schweiz21AUTYPIS-H: OE categoria ordine dell'ordine esternonvarchar20
94TNEO_ORDER_CATIS-H: Order Categories of External Order3AUTYPExternal Order - Order Categorynvarchar20
95TNEO_ORDER_CATTIS-H: Order Categories - Texts of External Order4AUTYPExternal Order - Order Categorynvarchar20
96TNEO_WORK_ORGIS-H: Form Control for External Orders4AUTYPExternal Order - Order Categorynvarchar20
97TNWCHCOIS-H: Aufträge bestimmen für Überleitung ins CO4AUTYPIS-H: OE categoria ordine dell'ordine esternonvarchar20
98TNWCHEA15IS-H CH: Auftragstypen des Externen Auftrages3AUTYPIS-H: OE categoria ordine dell'ordine esternonvarchar20
99TNWCHEA15TIS-H CH: Auftragsarten - Texte des Externen Auftrages4AUTYPIS-H: OE categoria ordine dell'ordine esternonvarchar20
TOPSimulation
100VSAUFK_CNVersion: Order master data5AUTYPOrder categorynvarchar20
101VSMLST_CNVersion: Milestone18AUTYPOrder categorynvarchar20
TOPTime Sheet
102CATSDBCATS: Database Table for Time Sheet53AUTYPOrder categorynvarchar20
103CATS_TEMPCATS: Database Table for Templates55AUTYPOrder categorynvarchar20