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

52 columns | Print definition?ERP 6.0  | TO_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_B2E_CBenefit Type to Wage Type for External Transfers6TO_DATE"Valid To" Datenvarchar80
2/GSINS/INH_B2W_CBenefit Type to Wage Type for Payments6TO_DATE"Valid To" Datenvarchar80
3/OTTM/BL_T_ERME-Receipt metadata14TO_DATETo Datenvarchar80
4CMCBD_CYCLECash Budgeting Cycle7TO_DATECycle End Datenvarchar80
5FIEUD_FISUMMARYSAFT: FI Transaction Summary Information6TO_DATEDatenvarchar80
6FIEUD_GOODSCNTSAFT:MM: XML Goods movement Transaction Count and Summary5TO_DATEDatenvarchar80
7FIEUD_INVSUMMARYSAFT: FI Transaction Summary Information6TO_DATEDatenvarchar80
8FIEUD_MMINVCNTSAFT:MM: XML Invoice Transaction Count and Summary5TO_DATEDatenvarchar80
TOPArchive Information System
9ASPART_ACTArchiveInfoSys: Actual Partitioning4TO_DATEArchive Information System, Partitioning: To Datenvarchar80
TOPBackground Processing
10FAVSELSUser-Specific Favorite Selection Criteria10TO_DATEPlanned Start Date for Background Jobnvarchar80
TOPBudgeting and Availability Control
11GMBDGTVALIDITYGrant budget validity7TO_DATEValid-to Datenvarchar80
TOPCollectionsDisbursements
12IBROBHREALLOCChange Responsibilities for Broker Hierarchies10TO_DATEDatenvarchar80
TOPContract Accounts Receivable and Payable
13DFKK_DOC_EXTRFI-CA Documents - Extracts4TO_DATETo Posting Datenvarchar80
TOPData Access in Agreement with German Tax Law
14TPCDATEPeriods for Authorization Check5TO_DATEField of type DATSnvarchar80
15TPCDATENPeriods for Authorization Check6TO_DATEField of type DATSnvarchar80
TOPData Mining
16RSDMTP_BAT_BWHDRHeader Batch Table for Generic BW Upload6TO_DATEDate for Extractorsnvarchar80
TOPE-Recruiting
17T77RCF_DOVR_PMPerformance Management Templates in Overview (Successor)4TO_DATEValid tonvarchar80
TOPEmployee Interaction Center
18THREIC_IBSEARCHEIC Inbox Initial Search Profile8TO_DATEEIC: Created Tonvarchar80
19THREIC_IBSUBSTEIC Inbox Substitution4TO_DATEField of type DATSnvarchar80
TOPFunds Management
20FMSPLIT_SPLITDistributions for Rule-Based Account Distributions7TO_DATEEnd Datenvarchar80
TOPIncident Reporting
21EHHSSD_ISR_SURPTIncident Report - Summary Report9TO_DATETo-Date for Report Searchnvarchar80
TOPIntercompany Data Exchange
22ETAXTINVKOExtract Table for Tax Storage for Incoming Bill, Extr. Info4TO_DATETo Posting Datenvarchar80
23TINV_EXTR_HDRExtract of Bill Receipt Document: Admin. Data (Eval. System)4TO_DATETo Posting Datenvarchar80
TOPInterface to Terminal Automation System
24OIK37IS OIL: Shadow table for SD document processing25TO_DATETPI Time Frame To Datenvarchar80
TOPLocalization
25J_1IEWT_CERTIFCertificate Issued Details-EWT India17TO_DATEValid to Datenvarchar80
26J_1IEWT_CERTIF_NCertificate Issued Details-EWT India:SECCO17TO_DATEValid to Datenvarchar80
TOPMarketing, Accounting and Pricing
27OICINT_CALInterest calculation5TO_DATETo date for interest calculationnvarchar80
TOPMaster Data
28GMASPCLASSSponsored Class - Sponsor Specific Data5TO_DATEValid Untilnvarchar80
29GMASPPROGSponsored Program - Sponsor Specific Data5TO_DATEValid Untilnvarchar80
30GMFUNDRECOVER_OFund recovery for outgoing grants7TO_DATEValid-to Datenvarchar80
31GMGRFUNDRECOVERFund recovery5TO_DATEValid-to Datenvarchar80
32GMGRIDCCAPGrant IDC Cap (Program + Class)6TO_DATEValid-to Datenvarchar80
33GMGRIDCCAP2Grant IDC Cap (Grant level)4TO_DATEValid-to Datenvarchar80
34GMGRIDCCAP2_OGrant IDC Cap (Grant level) for outgoing grant5TO_DATEValid-to Datenvarchar80
35GMGRIDCCAP_OGrant IDC Cap (Program + Class) for outgoing grant7TO_DATEValid-to Datenvarchar80
36GMGRRESPONSIBLEObjects responsible for the grant7TO_DATEDate that responsibilitynvarchar80
37GMINDIRECTCOSTIDC rates for directly sponsored grants [incoming grants]6TO_DATEValid-to Datenvarchar80
38GMINDIRECTCOST_OIndirect costs for outgoing grants7TO_DATEValid-to Datenvarchar80
39GMINDIRECTCOST_RIndirect costs for recipient6TO_DATEValid-to Datenvarchar80
40GMSPAGTAllowed Grant Types for Sponsor5TO_DATEValid Untilnvarchar80
41GMSPRESPONSIBLEObjects responsible for the sponsored program7TO_DATEDate that responsibilitynvarchar80
42GMSPRESPTYPResponsibility Defaults for Sponsor7TO_DATEValid Untilnvarchar80
TOPMedia Product Sales and Distribution
43JVTSDHDPLANIS-M: Planning Record for M/SD Home Delivery of SD Orders4TO_DATEIS-M: Shipping Datenvarchar80
TOPPublic Sector Contract Accounts Receivable and Payable
44DFMCA_BRF560BRF: Parameters for Facts Selection15TO_DATEBRF: Expressionnvarchar200
45DFMCA_BRF772BRF: Parameters for Facts Selection15TO_DATEBRF: Expressionnvarchar200
TOPRevenues and Earnings
46AD01DLIEFDI flow: Individual flow18TO_DATETo Datenvarchar80
TOPTransaction Manager
47TCORT_CODRPDeal: Rollover Plan8TO_DATE'Valid To' Datenvarchar80
48VTBROLLOVERRollover Periods for Forward Securities Transactions6TO_DATE'Valid To' Datenvarchar80
TOPTravel Expenses
49PTRV_SADDTrip Statistics - Add. Receipt Data11TO_DATETo Datenvarchar80
TOPWeb Service and SOAP - ABAP
50SRT_CFG_TRC_ADMAdmin for Trace data for SOAP Runtime Configuration4TO_DATESystem Datenvarchar80
TOPWithout Description
51CCMSBIAVAILDOWNTIndividual Non-Availability Settings11TO_DATESystem Datenvarchar80
52CCMSBIAVLREPCFIndividual Reporting Settings: SLA Limits11TO_DATESystem Datenvarchar80