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

98 columns | Print definition?ERP 6.0  | OBART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_10020_AOBJNRAnalysis results for object numbers7OBARTObject typenvarchar20
2CNV_10020_EOBARTObject types for which determination is not possible2OBARTObject typenvarchar20
3CNV_10020_LOBARTObject types to be loaded irrespective of org. analysis4OBARTObject typenvarchar20
4CNV_10994_OBARTGeneral object number types for J_OBJNR in CNV_10994_TSTRU6OBARTObject typenvarchar20
5CNV_20330_TSTRUCStructure of CO object numbers3OBARTObject Typenvarchar20
6CNV_20330_VALUETable analysis - found object types per table field5OBARTObject Typenvarchar20
7CNV_20551CONTROLControl table for deletion packages (select single)4OBARTGeneral object number type (for CO object numbers)nvarchar20
8CNV_20551_DERIVObject types for Find_Objects - evaluation tables4OBARTGeneral object number type (for CO object numbers)nvarchar20
9CNV_20551_DERIV1Object types for Find_Objects - fields and check fields4OBARTGeneral object number type (for CO object numbers)nvarchar20
10CNV_20551_DERIV2Object types for Find_Objects - parameter fields4OBARTGeneral object number type (for CO object numbers)nvarchar20
11CNV_20551_DERIV3Object types for Find_Objects - evaluation rule4OBARTGeneral object number type (for CO object numbers)nvarchar20
12CNV_20551_OBJObject types for check routines & Find_Objects4OBARTGeneral object number type (for CO object numbers)nvarchar20
13CNV_20551_OBJNRCO object numbers selected for deletion (internal numbering)3OBARTGeneral object number type (for CO object numbers)nvarchar20
14CNV_20551_RESULTFound relevant objects for deletion (statistics)4OBARTGeneral object number type (for CO object numbers)nvarchar20
15T371DIB: Installation Component - Object Type2OBARTIB: Object Typenvarchar20
16T457SBlock table for MRP and forecast run2OBARTSingle-Character Indicatornvarchar10
17T460DOrder/Purchase order types for planned order2OBARTObject typenvarchar10
18TKB2CDefault Rules for Posting Rules3OBARTObject type of settlement sendernvarchar20
19TKB3Settings for Default Rules2OBARTObject type of settlement sendernvarchar20
TOPActual CostingMaterial Ledger
20FCML_MATML Characteristics for Material (Selection Criteria)4OBARTObject Typenvarchar20
TOPBasic Data and Tools
21EHSBC_ST01EHS-BAS: Assignment: Status Profile to Object Type3OBARTObject Typenvarchar20
TOPBasic Functions
22ANEKDocument Header Asset Posting32OBARTObject type of forwarding object at settlementnvarchar20
TOPBasic Settings
23T8A40EC-PCA: Transfer Statistical Key Figures3OBARTEC-PCA: Allowed object types for statistical key figuresnvarchar20
TOPControlling
24COAS_IDENT_ATTRIdentification Attributes on Object Type in AttributeService1OBARTIdentifier for Object Typenvarchar30
25COAS_KONT_ATTRAcct Assignment Attributes for Obj.Type in Attribute Service1OBARTIdentifier for Object Typenvarchar30
26COAS_OBJ_TEXTText for Object Types in Attribute Service1OBARTIdentifier for Object Typenvarchar30
27COAS_OBJ_TYPESObject Types in Attribute Service1OBARTIdentifier for Object Typenvarchar30
28TKACPCCO Line Item Summarization: Fields to be Summarized3OBARTObject Typenvarchar20
TOPCost Element Accounting
29COFIO1Object Table for Reconciliation Ledger COFIT9OBARTReconciliation ledger object type (technical)nvarchar20
TOPCosting
30PRECP0ECP: Default Versions2OBARTObject Type Easy Cost Planningnvarchar20
31PRECP3ECP: Activation per Controlling Area2OBARTObject Type Easy Cost Planningnvarchar20
TOPCosts
32TORS0Customizing Time-Dependent Status: Activate Function3OBARTObject Typenvarchar20
33TORS1Statuses Relevant for Key-Date Based Management1OBARTObject Typenvarchar20
TOPDistributed Maintenance
34/ISDFPS/FWOBJDSPDFPS: Objects to Be Distributed from Maintenance Calls2OBARTObject type (such as material, BOM, ...)nvarchar40
TOPExpense-Related Billing
35PRSD_DMRP_ACC_CHEngagement Mgmt: Accrual Characteristics for DMR Lines35OBARTObject Typenvarchar20
TOPFinancial Accounting
36FERC_C11Regulatory indicator assignment field3OBARTObject Typenvarchar20
37T003BObject Types for Early Entry in Financial Acctng4OBARTDocument typenvarchar100
TOPFunds Management
38FMZUCOFM-CO Assignment Control Table3OBARTObject typenvarchar20
TOPGeneral Application Functions
39BSVWOT2OAStatus Management Events: Status Objects <-> Object Kind2OBARTObject Typenvarchar20
TOPGeneral Ledger Accounting
40FAGLSKFGeneral Ledger: Statistical Key Figures (Current Values)13OBARTObject Typenvarchar20
41FAGLSKF_PNGeneral Ledger; Statistical Key Figures (Source Document)15OBARTObject Typenvarchar20
TOPGeneral status management
42TBO00Object type control parameters1OBARTObject Typenvarchar20
43TBO01Language-specific values for object type2OBARTObject Typenvarchar20
44TONRNumber status: general object number2OBARTObject Typenvarchar20
TOPInput Tax Treatment
45TIVBEOBJBerichtigungsobjekte: Zulässige Objektarten1OBARTObjektartnvarchar20
TOPInstalled Base
46T371STVIBase: Status Assignment Database Table4OBARTIB: Object Typenvarchar20
TOPInvestment Programs
47IMPSAssignable Operative Objs for Capital Investment Positions3OBARTAllowed object types for cap. inv. programsnvarchar20
48TAI07Operative objects for inv. programs that can be allocated3OBARTAllowed object types for cap. inv. programsnvarchar20
49TAIGDScale of investment objects2OBARTObject Typenvarchar20
50TAIGKKey figure key for scale2OBARTObject Typenvarchar20
51TAIGMPossible key figures keys for scale1OBARTObject Typenvarchar20
52TAIGWDefinition of the scale of investment measures2OBARTObject Typenvarchar20
TOPInvoice Verification
53T003SDocument Types for Storing Documents (Log. IV)4OBARTDocument typenvarchar100
TOPLine Maintenance
54/ISDFPS/LMIDTBRelation Between Uppermost Tech. Obj. and Dependent Objects3OBARTObject Typenvarchar20
TOPLocalization
55J_3RNDSINVTarget use of ingoing invoice positions for AuC22OBARTObject Typenvarchar20
TOPMaintenance Orders
56/MRSS/C_RSG_STATMRS Customizing for Status Object Type (Release 46C)2OBARTObject Typenvarchar20
TOPMaster Data
57BLPKDocument log header28OBARTObject type for reference in document log - repetitive mfgnvarchar10
58PLAFPlanned Order74OBARTObject typenvarchar10
59T460COrder/Purchase order types for planned order2OBARTObject typenvarchar10
TOPOverhead Cost Controlling
60ARCU_COIT1Residence Times for CO Line Items2OBARTObject Typenvarchar20
TOPPersonnel Administration
61T585OHR Optical Archiving: Configuration Table for PREL and PAPL2OBARTObject typenvarchar100
TOPProduction Orders
62COWB120PARParameters for Costing Request3OBARTObject Typenvarchar20
63COWB135PARGenerate Parameters for Preselection of Control Recipe3OBARTObject Typenvarchar20
64COWB140PARWorkbench Print Parameters for Request3OBARTObject Typenvarchar20
65COWB160PARWorkbench Print Parameters for Request3OBARTObject Typenvarchar20
66COWB170PARParameters for Request for Creation of Capacity Requirements3OBARTObject Typenvarchar20
67COWB180PARParameters for Request for Triggering WM Goods Movements3OBARTObject Typenvarchar20
68COWB190PARParameters for User Status Request3OBARTObject Typenvarchar20
69COWB200PARParameters for Request for Confirmations3OBARTObject Typenvarchar20
70COWB205PARParameter for Flag for Planned-Order Firming3OBARTObject Typenvarchar20
71COWB210PARParameters for Request for Technical Completion3OBARTObject Typenvarchar20
72COWB215PARParameter for Flag for Deletion of Planned Order3OBARTObject Typenvarchar20
73COWB220PARParameters for Request for Technical Completion3OBARTObject Typenvarchar20
74COWB230PARParameters for Request for Close3OBARTObject Typenvarchar20
75COWB260PARParameter for Request for Deletion Flag3OBARTObject Typenvarchar20
76COWB270PARParameter for Flag for Deletion Indicator3OBARTObject Typenvarchar20
77COWBSUBOBJFile for Saving Sub-objects COWRK (INDX)4OBARTObject Typenvarchar20
78COWORK110PARWorkbench scheduling parameters for preposting3OBARTObject Typenvarchar20
79COWORK130PARWorkbench release parameters for preposting3OBARTObject Typenvarchar20
80FUNOCMFunction marked for Order Change Management3OBARTObject Typenvarchar20
81FUNREQFunction marked for PP/PS3OBARTObject Typenvarchar20
TOPProfit Center Accounting
82KE1_WU_IMPCA Where-Used List: Real Estate Objects7OBARTObject Type (20 Characters)nvarchar200
TOPPublic Sector Contract Accounts Receivable and Payable
83DFACTSOBJNR to Facts2OBARTObject Typenvarchar20
TOPReal Estate Management
84TIV100Real Estate direct input: Non-transferable fields1OBARTObject Typenvarchar20
85TIVCN07Assignment Contract Type <-> Object Category3OBARTObject typenvarchar20
TOPRepetitive Manufacturing
86RMIOInput Structure of Repetitive Manufacturing Confirmation83OBARTObject type for reference in document log - repetitive mfgnvarchar10
87T460PProcurement and Special Procurement Check2OBARTObject typenvarchar10
TOPReport Selection for Product Costing
88TKKRAHierarchy Summarization (Hierarchy Types)3OBARTObject type of CO objects to be summarized (costing)nvarchar20
TOPRevenues and Earnings
89AD01SRCARCResidence Time for DIP Sources3OBARTObject Typenvarchar20
TOPSchedule Manager
90KPEP_WL_ROLESAssignment of Role to Object Type3OBARTGeneral Object Type SCMAnvarchar30
TOPSimulation
91VSPLAF_CNVersion: Planned order74OBARTObject typenvarchar10
TOPStatistical Key Figures
92ANLKAsset Origin by Cost Element6OBARTObject type of forwarding object at settlementnvarchar20
TOPTechnical Application Support
93CNV_COO_STATStatus of creation of CNV_COO (currencies of the CO objects)3OBARTObject Typenvarchar20
TOPTechnical Objects
94EAML_D_LFE_CDOCLinear Data2OBARTObject Type for Linear Datanvarchar20
95EAML_D_LFE_DATALinear Asset Management - Database2OBARTObject Type for Linear Datanvarchar20
TOPTime Sheet
96TCATX_ACCOBJNext Screen Processing: Account Assignment Object3OBARTObject Typenvarchar20
97TCATX_COCONVCATX: Conversion of CO Fields into CATS Fields3OBARTObject Typenvarchar20
TOPWarranty Claim Processing
98WTY_COND_ACCOUNTAuxiliary Account Assignment of Conditions6OBARTObject Type for CO Account Assignmentnvarchar20