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

73 columns | Print definition?ERP 6.0  | UNITS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/D_DAG_ASGDemand Agr. Graph for Demand that is planned9UNITSDemand Units (Natural Number)int100
2/MRSS/D_DAG_DEMDemand Agr. Graph for Total and Attribute specific Demand9UNITSDemand Units (Natural Number)int100
3/MRSS/D_DAG_MOBOBSOLETE DB Table - NOT IN USE9UNITSDemand Units (Natural Number)int100
4/MRSS/D_DAG_PASDemand Agr. Graph for Preparation/Warp-up of Assignments9UNITSDemand Units (Natural Number)int100
5/MRSS/D_DAG_PDEDemand Agr. Graph for expected Prep/Warp-up of unpl. Dem.9UNITSDemand Units (Natural Number)int100
6/MRSS/D_DAG_RSBDemand Agr. Graph for virtual Reserve Base(non existing Dem)9UNITSDemand Units (Natural Number)int100
7/MRSS/D_DAG_RSVDemand Agr. Graph for virtual Reservation (non existing Dem)9UNITSDemand Units (Natural Number)int100
8/MRSS/D_DAG_TASDemand Agr. Graph for Travel Times of Assignments9UNITSDemand Units (Natural Number)int100
9/MRSS/D_DAG_TDEDemand Agr. Graph for expected Travel Times of unpl. Dem.9UNITSDemand Units (Natural Number)int100
10/MRSS/D_DAG_TRVOBSOLETE DB Table - NOT IN USE9UNITSDemand Units (Natural Number)int100
11/MRSS/D_DAG_UNADemand Agr. Graph for Demand that is not planned yet9UNITSDemand Units (Natural Number)int100
12BCKTRDT_MULTASSGMultiple Account Assignment of Flows8UNITSUnitsdecimal226
13T5A4AGeneral Absence Data9UNITSQuotas and Deduction Methodsnvarchar10
TOPBack Office
14TRET_PROTOCOLTransactions Generated for Endowments10UNITSNo. of Units for Financial Instrumentsdecimal155
15TRFT_FLOWTreasury: Table with TRF Flows9UNITSUnitsdecimal226
16TRFT_MATCH_FLOWTreasury: Table with Matching Process Flows9UNITSUnitsdecimal226
17TRFT_SUBTOTALTreasury: Table with TRF Transaction Figure4UNITSUnitsdecimal226
18TRFT_SUBTRANSTreasury: TRF Business Subtransaction6UNITSUnitsdecimal226
19TRST_CLASFLOCFM: Class Flows in Securities Account21UNITSUnitsdecimal226
20TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account21UNITSUnitsdecimal226
21TRST_POSCHG_FLOWCFM: Flow for Securities Account Position Change4UNITSUnitsdecimal226
22TRST_SECACCTRANSTreasury: Securities Account Transfer12UNITSUnitsdecimal226
23TRST_SUBTOTALTreasury: Table with Trans.Figs - Class Pos. in Sec. Acct4UNITSUnitsdecimal226
TOPCompensation Management
24PA0380HR Master Data Record Infotype 0380 (Comp. Adjustment)40UNITSUnits of time/measuremenet for intervalsnvarchar30
TOPIndia
25T7INC5Perk value of car9UNITSUnit field (cc or hp)nvarchar20
TOPPayroll
26T5H2YKülönadó bérelemei11UNITSBérelem idoegységenvarchar10
TOPRegulatory reporting for insurance companies
27ISSRPREFLOWISSR: Basistabelle/Bewegungstabelle24UNITSISSR: Stückedecimal226
TOPTaiwan
28T7TW3CRetirement Pay Calculation Rule8UNITSUnit: Month/Pointnvarchar10
29T7TW3ESeverance Pay Calculation Rule8UNITSUnit: Month/Pointnvarchar10
30T7TW3GResignation Pay Calculation Rule8UNITSUnit: Month/Pointnvarchar10
TOPTask Resource Management
31LEGORECOs' subscriptions at runtime5UNITSQuantity of Objectsint100
32LEGRSResource-ECO subscription6UNITSQuantity of Objectsint100
33LRTCPCapacity assignment for resource types6UNITSNumber of Unitstinyint30
34LSECCCapacity of Static Execution Control (SEC)6UNITSQuantity of Objectsint100
TOPTransaction Management
35THXT_HR_FLOWSTreasury: Hedging Relationship Flows7UNITSUnitsdecimal226
36THXT_MD_PVmarket data present value11UNITSUnitsdecimal226
TOPTransaction Manager
37BCKTCAT_FLOWBACKUP: Flow Table of Capital Actions12UNITSUnitsdecimal226
38BCKTERT_FLOWBACKUP: Flow Table for Executable Rights14UNITSUnitsdecimal226
39IDCFM_DATA_SECValuation-Area-Independent Data for Securities15UNITSUnitsdecimal226
40IDCFM_FRIM_DATAImpairment Main Data34UNITSNumber of unitsdecimal226
41SLDT_FLOWSubledger Distributor Transactions28UNITSUnitsdecimal226
42TCAT_FLOWFlow Table of the Corporate Actions15UNITSUnitsdecimal226
43TCORT_CODMDDeal: Main Data60UNITSUnitsdecimal226
44TCORT_COSAFLSecurity Account Transfer: Flows7UNITSUnitsdecimal226
45TCORT_COSAPOSecurity Account Transfer: Positions7UNITSUnitsdecimal226
46TERT_FLOWFlow Table for Rights that can be Exercised36UNITSUnitsdecimal226
47TERT_TRANSACTIONBusiness Transaction: Exercise of Rights17UNITSUnitsdecimal226
48TRDTT_DATA_SECValuation-Area-Independent Data for Securities14UNITSUnitsdecimal226
49TRDT_FLOWPersistent distributor flows26UNITSUnitsdecimal226
50TRDT_MULTASSGNMultiple Account Assignment of Flows7UNITSUnitsdecimal226
51TRLT_VCL_FLOWFlows Valuation Class Transfer12UNITSUnitsdecimal226
52TRQT_ASSIGN_HISTCFM: Lot Assignment History7UNITSUnitsdecimal226
53TRQT_FLOWTreasury: Flow Data Quantity Ledger7UNITSUnitsdecimal226
54TRQT_INIT_LOT(obsolete)8UNITSUnitsdecimal226
55TRQT_LOTFLOWTreasury: Table with Lot Flows5UNITSUnitsdecimal226
56TRQT_SUBTOTALTreasury: Table with Quantity Ledger Position Trans. Figures7UNITSUnitsdecimal226
57VTBFASGTAccount Assignment of a Financial Transaction Flow8UNITSUnitsdecimal226
TOPTransfer to Financial Accounting
58TLVT_VAL_STEPTreasury: Valuation Step21UNITSUnitsdecimal226
59TRLT_BACKUPVORABBackup Flow Table from Preliminary Solution - Pos. Mgmt Sol.17UNITSUnitsdecimal226
60TRLT_DERIVFLOWSTreasury: Flows for Derived Business Transactions9UNITSUnitsdecimal226
61TRLT_FBP_CMP_VALFlow Backpack Values for Each Component and Subposition5UNITSUnitsdecimal226
62TRLT_FLOWTreasury Ledger Flows11UNITSUnitsdecimal226
63TRLT_FS_COMPTR Ledger: Transaction Figures per Component4UNITSUnitsdecimal226
64TRLT_FS_SUB_COMPTransaction Figures for Each Component and Subposition5UNITSUnitsdecimal226
65TRLT_INIT_VAL_FUInitialization Values for TRL Futures Positions13UNITSUnitsdecimal226
66TRLT_INIT_VAL_SEInitialization Values for TRL Positions: Securities17UNITSUnitsdecimal226
TOPTreasury and Risk Management
67TREAT_FLOWTreasury: TREA Flows21UNITSUnitsdecimal226
TOPUSA
68PA0103HR Master Record: Infotype 0103 (Bond Purchases NA)34UNITSUnit of measurementnvarchar30
TOPWorkforce Management Application
69WFAC_CONTR_RULEContract Rule5UNITSNumber of Periods in Contractint100
70WFA_ACT_SUMMActual summary hours, total paid hours and total pay9UNITSBase Unit of Measurenvarchar30
71WFA_SCHED_SUMMSchedule summary hours, total paid hours and total pay9UNITSBase Unit of Measurenvarchar30
72WFA_SCH_CONPAYContract employee pay to min hours per week6UNITSBase Unit of Measurenvarchar30
TOPWorkforce Management Core
73WFMCAS_ACT_SUMMActual summary hours, total paid hours and total pay9UNITSBase Unit of Measurenvarchar30