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

74 columns | Print definition?ERP 6.0  | FUNCT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T437VDistribution key in MRP4FUNCTDistribution functionnvarchar30
2T7QAPBS02TFunctional Areas Text4FUNCTFunctional Area Textnvarchar600
3TC29Distribution key for capacity load4FUNCTDistribution functionnvarchar30
4TC29FDistribution function for capacity planning2FUNCTDistribution functionnvarchar30
5TC29TDescriptions of distribution functions2FUNCTDistribution functionnvarchar30
6TC29VDistribution function2FUNCTDistribution functionnvarchar30
7TIV20Rep.list of rents master data19FUNCTFM for calculating rep.list of rents average rentnvarchar300
TOPBank
8T005BUTable for Transferring Bank Data3FUNCTApplication Module (Developed by SAP)nvarchar300
TOPBasic Functions
9T880BValuation methods10FUNCTFunctional currencynvarchar50
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
10TBE31Publish&Subscribe BTE: SAP Enhancement4FUNCTApplication Module (Developed by SAP)nvarchar300
11TBE32Publish&Subscribe BTE: Customer Enhancements7FUNCTPartner Function Modulenvarchar300
12TBE34Publish&Subscribe BTE: Customer Enhancements6FUNCTCustomer Function Modulenvarchar300
13TPS31Process BTE: Alternative Function Modules from SAP4FUNCTApplication Module (Developed by SAP)nvarchar300
14TPS32Process BTE: Partner Enhancements4FUNCTPartner Function Modulenvarchar300
15TPS34Process BTE: Customer Enhancements5FUNCTCustomer Function Modulenvarchar300
TOPBusiness Navigator
16DF31SComponent dependencies3FUNCTFunction assignmentnvarchar700
17TFM18Assignment of functions to IMG chapters4FUNCTFunction assignmentnvarchar700
TOPCCMS Database Monitors for Oracle
18SDBADDetail Table for DBA Logs2FUNCTFunction ID for DBA actionnvarchar30
19SDBAHHeader Table for DBA Logs2FUNCTFunction ID for DBA actionnvarchar30
TOPClinical System
20N2DGAISTISH*MED : Steuerung Schnittstelle Datenexport18FUNCTIS-H*MED: Isleme rutininvarchar600
TOPContract Accounts Receivable and Payable
21TFK021UDefault Values for Line Layout in Account Display3FUNCTCalled Function for Account Balance Displaynvarchar50
22TFKBWDFICA to BW - Extraction Source Tables3FUNCTFunction Namenvarchar300
TOPDB2 for OS39
23DB2CCDL_PARMSDSNACCDL: History of execution parameters for DB13 jobs2FUNCTFunction ID for DBA actionnvarchar30
24DB2CCDS_INDSNACCDS: History of input table for DB13 jobs2FUNCTFunction ID for DBA actionnvarchar30
25DB2CCDS_PARMSDSNACCDS: History of execution parameters for DB13 jobs2FUNCTFunction ID for DBA actionnvarchar30
26DB2CCMO_ERRORDSNACCMO: History of error info with length > 255 CHAR2FUNCTFunction ID for DBA actionnvarchar30
27DB2CCMO_IN1History of input table 1 for DB13 jobs executed via DSNACCMO2FUNCTFunction ID for DBA actionnvarchar30
28DB2CCMO_IN2History of input table 2 for DB13 jobs executed via DSNACCMO2FUNCTFunction ID for DBA actionnvarchar30
29DB2CCMO_OBJERRDSNACCMO: History of failed utility executions2FUNCTFunction ID for DBA actionnvarchar30
30DB2CCMO_OUTTSHistory of output table for DB13 jobs executed via DSNACCMO2FUNCTFunction ID for DBA actionnvarchar30
31DB2CCMO_PARMSHistory of execution parameters for DB13 jobs via DSNACCMO2FUNCTFunction ID for DBA actionnvarchar30
32DB2UTILS_OUTHistory of output table for DB13 jobs executed via DSNUTILS2FUNCTFunction ID for DBA actionnvarchar30
33DB2UTILS_PARMSHistory of execution parameters for DB13 jobs via DSNUTILS2FUNCTFunction ID for DBA actionnvarchar30
34SDBADDB2Detail Table for DBA Logs2FUNCTFunction ID for DBA actionnvarchar30
TOPImplementation Guide
35CUS_ATRVCOCustomizing Attributes: Variants for ACH Assignment4FUNCTFunction assignmentnvarchar700
TOPInventory Management
36RESBReservation/dependent requirements157FUNCTDistribution functionnvarchar30
TOPJoint Venture und Production Sharing Accounting
37T8JKAccounts for posting exchange differences3FUNCTJV Function for account tablenvarchar40
TOPLogistical Requirements
38/ISDFPS/PNEPAMMaterials Within an Equipment Package8FUNCTFunction Identifiernvarchar10
TOPMaxDB
39SDBADSDBDBA calendar: planning- vs. R/3 exec.vs. DB exec. times9FUNCTFunction ID for DBA actionnvarchar30
40SDBAHSDBSAP DB: DBA History2FUNCTFunction ID for DBA actionnvarchar30
TOPOverhead Cost Orders
41TKP01Persons in charge of availability control2FUNCTName of function modulenvarchar300
TOPPersonnel Administration
42T549DFeatures Directory4FUNCTFunction partnvarchar210
43T752CSAP Resumix: Imported Fields6FUNCTConversion Routine (SAP - Resumix)nvarchar300
44T752DSAP Resumix: Exported Fields6FUNCTConversion Routine (SAP - Resumix)nvarchar300
TOPPersonnel Time Management
45T555CPermitted PDC PIN Codes8FUNCTValue to be assigned to PIN code (absence type, etc.)nvarchar40
TOPProduction Orders
46COMPHOCM: Comparison result (header entry)13FUNCTFunction to be carried out by systemnvarchar30
47COWB120PARParameters for Costing Request2FUNCTFunction to be carried out by systemnvarchar30
48COWB135PARGenerate Parameters for Preselection of Control Recipe2FUNCTFunction to be carried out by systemnvarchar30
49COWB140PARWorkbench Print Parameters for Request2FUNCTFunction to be carried out by systemnvarchar30
50COWB160PARWorkbench Print Parameters for Request2FUNCTFunction to be carried out by systemnvarchar30
51COWB170PARParameters for Request for Creation of Capacity Requirements2FUNCTFunction to be carried out by systemnvarchar30
52COWB180PARParameters for Request for Triggering WM Goods Movements2FUNCTFunction to be carried out by systemnvarchar30
53COWB190PARParameters for User Status Request2FUNCTFunction to be carried out by systemnvarchar30
54COWB200PARParameters for Request for Confirmations2FUNCTFunction to be carried out by systemnvarchar30
55COWB205PARParameter for Flag for Planned-Order Firming2FUNCTFunction to be carried out by systemnvarchar30
56COWB210PARParameters for Request for Technical Completion2FUNCTFunction to be carried out by systemnvarchar30
57COWB215PARParameter for Flag for Deletion of Planned Order2FUNCTFunction to be carried out by systemnvarchar30
58COWB220PARParameters for Request for Technical Completion2FUNCTFunction to be carried out by systemnvarchar30
59COWB230PARParameters for Request for Close2FUNCTFunction to be carried out by systemnvarchar30
60COWB260PARParameter for Request for Deletion Flag2FUNCTFunction to be carried out by systemnvarchar30
61COWB270PARParameter for Flag for Deletion Indicator2FUNCTFunction to be carried out by systemnvarchar30
62COWBSUBOBJFile for Saving Sub-objects COWRK (INDX)3FUNCTFunction to be carried out by systemnvarchar30
63COWORK110PARWorkbench scheduling parameters for preposting2FUNCTFunction to be carried out by systemnvarchar30
64COWORK130PARWorkbench release parameters for preposting2FUNCTFunction to be carried out by systemnvarchar30
65FUNOCMFunction marked for Order Change Management2FUNCTFunction to be carried out by systemnvarchar30
66FUNREQFunction marked for PP/PS2FUNCTFunction to be carried out by systemnvarchar30
67TCOFKTexts for functions in milestones/trigger points4FUNCTDescription of the functionnvarchar350
TOPPublic Sector
68T5RPBS9ATText Table for Status Group5FUNCTText for Status Groupnvarchar600
TOPService Data Download
69/SDF/SDBADDetail Table for DBA Logs2FUNCTnvarchar30
70/SDF/SDBAHHeader Table for dba Log2FUNCTnvarchar30
TOPSimulation
71VSRESB_CNVersion: Reservation/Dependent requirements158FUNCTDistribution functionnvarchar30
TOPTime Tickets
72T703PIncentive Wages: Simple Functions6FUNCTFunction value for premium functionnvarchar90
TOPTransaction Variant and Table Control Settings
73SHDDCGlobal values 3.1: Assignment of domains to components2FUNCTFunction assignmentnvarchar700
TOPTransceiver
74TEUPLConfiguration of upload files4FUNCTName of function modulenvarchar300