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

110 columns | Print definition?ERP 6.0  | FUND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/AT_APPR_HISApproval History for Level Based Approvals30FUNDFundnvarchar100
2/OPT/AT_LBA_LOGApproval History for Level Based Approvals31FUNDFundnvarchar100
3/SAPPSSRM/SPFSETSelective Release - Blocking Options by Account4FUNDFundnvarchar100
4/SAPPSSRM/TGMACCIBU PS: link table between Contract data and earmarked funds11FUNDFundnvarchar100
5BBP_FUND_FAVUser-Specific Favorites for Permitted Funds4FUNDFundnvarchar100
6BBP_PCACCProcurement Card: Accounting Data28FUNDFundnvarchar100
7BBP_PCMODProcurement Card: Modified Statement Data30FUNDFundnvarchar100
8BBP_PDACCAccount Assignment32FUNDFundnvarchar100
9BCKTRDT_MULTASSGMultiple Account Assignment of Flows6FUNDFundnvarchar100
10FMBASOBJNR_TRACETrace for table FMBASOBJNR4FUNDFundnvarchar100
11FMBCS_FMBL_CDEmpty table for change documents on FMBL incl. local. fields11FUNDFundnvarchar100
12REQACCTAccount Assignment for the Req. Coverage Request Lines36FUNDFundnvarchar100
13ZCATSDBRecords changed with processing status '10'22FUNDnvarchar100
14ZCATSDB2Records changed with processing status '10'23FUNDnvarchar100
TOPAvailability Control
15FMAVCOObject table 18FUNDFundnvarchar100
TOPBack Office
16TRET_END2POOLPools Permitted for Each Endowment3FUNDFundnvarchar100
17TRET_ENDOWMENTAdditional Fund/Grant Data for Endowments3FUNDFundnvarchar100
18TRET_POOLAdditional Pool Data for Fund3FUNDFundnvarchar100
19TRET_SEC_POOLAdditional Pool Data for Security4FUNDFundnvarchar100
20TRST_CLASFLOCFM: Class Flows in Securities Account9FUNDFundnvarchar100
21TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account9FUNDFundnvarchar100
22TRST_CLASPOSTreasury: Class position in Securities Account8FUNDFundnvarchar100
TOPBasis Components
23/XFT/INV_Q_11Account assignment data27FUNDFundnvarchar100
24/XFT/INV_Q_11_SAccount assignment data27FUNDFundnvarchar100
TOPBudget Control System
25FMBASOBJNRObject numbers for FM addresses6FUNDFundnvarchar100
TOPBudgeting
26BUCC_RULEConsistency Checks - Rules13FUNDKey Figures - Fund aggregationnvarchar10
27FMBDOObject table 1 - Budget address8FUNDFundnvarchar100
28FMBLFunds management budget document lines (entry documents)11FUNDFundnvarchar100
29FMBUMANAGERManagement of budgeting enironment in FM6FUNDFundnvarchar100
30FMCONSUM_FUNDConsumable budget type for Fund3FUNDFundnvarchar100
31FMHBLFunds management budget document lines (held documents)11FUNDFundnvarchar100
32FMMIGOVOverview of Migration Status3FUNDFundnvarchar100
33FMMIGPARPartially Migrated Documents8FUNDFundnvarchar100
34FMOPENPER_FUNDControl Budgeting Periods per Fund6FUNDFundnvarchar100
35FMPEP_VARIANTLSession variants (line part) for transaction FMPEP11FUNDFundnvarchar100
36FMRBOObject table 18FUNDFundnvarchar100
37FMREL_FUNDRelease settings for Fund3FUNDFundnvarchar100
38FMROLLUP_FUNDPreclosing Rollup: Transfer Rules for Fund3FUNDFundnvarchar100
TOPBudgeting and Availability Control
39GMBASOBJNRObject numbers of GM addresses7FUNDFundnvarchar100
40GMBDGTFYDLINEGM Budgeting Fiscal Year Distribution Lines11FUNDFundnvarchar100
41GMBDGTLINEBudget Document Line10FUNDFundnvarchar100
42GMFMRECSGM RIB: FM Receivers (obsolete)3FUNDFundnvarchar100
43GMHBDGTFYDLINEGM Budgeting Fiscal Year Distribution Lines12FUNDFundnvarchar100
44GMHBDGTLINEBudget Line: Held Documents11FUNDFundnvarchar100
TOPCost Element Accounting
45COFIO1Object Table for Reconciliation Ledger COFIT14FUNDFundnvarchar100
TOPESS Based on WD ABAP
46HRESS_D_CATS_FAVCATS Favorites: database table29FUNDReceiver fundnvarchar100
TOPFunctions for U.S. Federal Government
47FMFGYECLAAUS Federal Gov't : Y/E Pre-Closing of Anticipated Accounts3FUNDFundnvarchar100
TOPFund Accounting
48FMCCAVCOObject table 19FUNDFundnvarchar100
49FMCCAVCRESERVECCAVC aux table for reserved items8FUNDFundnvarchar100
50FMCCBASOBJNRObject numbers for CC addresses7FUNDFundnvarchar100
TOPFunds Management
51FMBPCLOSE_FUNDPreclosing Rollup: Transfer Rules for Fund3FUNDFundnvarchar100
52FMBUDACLRules for Closing Residual Ledger Accounts6FUNDSender fundnvarchar100
53FMFG_YBA_AVCFMFG: Year of Budget Authority - AVC7FUNDFundnvarchar100
54FMSPLITOObject table 114FUNDFundnvarchar100
55FMUSFGFACTS1OObject table 19FUNDFundnvarchar100
56FMUSFGFACTS2OObject table 19FUNDFundnvarchar100
57FMUSFGOObject table 1 for US Federal Government14FUNDFundnvarchar100
58FUMA_EVENTFund Management Events6FUNDFundnvarchar100
59IAOM_GTR_EXATGrantor: Account Assignment Manager External Characteristics6FUNDFundnvarchar100
60TBPAS_FUNDBudget Subtypes for Availability Control Per Fund4FUNDFundnvarchar100
TOPFunds Management-Specific Postings
61FMCJIS-PS: Documents in Cash Desk Subsidiary Ledger20FUNDFundnvarchar100
TOPGrantee Management
62GMAVCOObject table 19FUNDFundnvarchar100
63GMIOObject table GMIO12FUNDFundnvarchar100
TOPIncentive and Commission Management ICM
64CACSHR_DOCHR_PDSettlement to PY: Reference Line Item19FUNDFundnvarchar100
65YCRM01_ACCASAccount Assignment Type/Cost Information for Remuneration25FUNDFundnvarchar100
66YTEL01_ACCASAccount Assignment Type/Cost Information for Remuneration32FUNDFundnvarchar100
TOPInformation System
67FTI_BI_REP_ODSReparation Records for Inconsistent Data in ODS 0CFM_O01 /BW31FUNDFundnvarchar100
TOPMaster Data
68GMFUNDRECOVER_OFund recovery for outgoing grants5FUNDFundnvarchar100
69GMGFUNDGrant specific fund details4FUNDFundnvarchar100
70GMGRCOSTSHARECost sharing master data4FUNDFundnvarchar100
71GMGRFUNDRECOVERFund recovery3FUNDFundnvarchar100
72GMGRSPONSOREDOBJGrant sponsored objects6FUNDFundnvarchar100
TOPRental Accounting
73VIEXCFCNDNSCash Flow Summarization26FUNDFundnvarchar240
74VIRADOCITEMRE Document Item31FUNDFundnvarchar240
75VITMOATerm: Organizational Assignment11FUNDFundnvarchar240
TOPRevenues and Earnings
76AD01DLIDynamic items (DI)53FUNDFundnvarchar100
TOPTime Sheet
77CATSCOCross-Application Time Sheet (CATS): Transfer to CO37FUNDReceiver fundnvarchar100
78CATSDBCATS: Database Table for Time Sheet22FUNDReceiver fundnvarchar100
79CATS_TEMPCATS: Database Table for Templates24FUNDReceiver fundnvarchar100
TOPTransaction Manager
80DIFT_POS_IDENTPersistent Flow Selectors22FUNDFundnvarchar100
81FDC1Cash Management Shadow table18FUNDFundnvarchar100
82IDCFM_DATA_SECValuation-Area-Independent Data for Securities9FUNDFundnvarchar100
83IDCFM_FRIM_DATAImpairment Main Data14FUNDFundnvarchar100
84IDCFM_FRIM_DEXPImpairment: BAdI Example Values: Expected & Expert Values14FUNDFundnvarchar100
85POGT_POS_GUARDLock Objects36FUNDFundnvarchar100
86SLDT_FLOWSubledger Distributor Transactions21FUNDFundnvarchar100
87TRCT_FLOWTable of business transactions flows11FUNDFundnvarchar100
88TRDTT_DATA_ADMINLegacy Data Transfer Admin. Entries Business Transactions12FUNDFundnvarchar100
89TRDTT_DATA_SECValuation-Area-Independent Data for Securities8FUNDFundnvarchar100
90TRDTT_IGTDATA_SEIntragroup Transaction (IGT) Data for Securities9FUNDFundnvarchar100
91TRDTT_POS_ADMINLegacy Data Transfer Admin. Entries Subledger Positions10FUNDFundnvarchar100
92TRDTT_POS_SECPosition Information for Securities8FUNDFundnvarchar100
93TRDTT_VADATA_FUTValuation-Area-Dependent Data for Futures9FUNDFundnvarchar100
94TRDTT_VADATA_OTCValuation-Area-Dependent Data for MM, FX, OTC Derivatives.7FUNDFundnvarchar100
95TRDTT_VADATA_SECValuation-Area-Dependent Data for Securities9FUNDFundnvarchar100
96TRDT_FLOWPersistent distributor flows22FUNDFundnvarchar100
97TRDT_MULTASSGNMultiple Account Assignment of Flows5FUNDFundnvarchar100
98TRGT_MIGPS_OTCAssignment of PS Account Assignments to Transactions4FUNDFundnvarchar100
99TRGT_MIGPS_SECAssignment of PS Account Assignments to Securities Positions7FUNDFundnvarchar100
100TRLT_VCL_FLOWFlows Valuation Class Transfer24FUNDFundnvarchar100
101VTBFASGTAccount Assignment of a Financial Transaction Flow4FUNDFundnvarchar100
102VTBFATITAcct Assmt Templates for PS Mult. Acct Assmts: Line Info.5FUNDFundnvarchar100
103VTBFHATransaction56FUNDFundnvarchar100
TOPTransfer to Financial Accounting
104TLVT_MANUAL_VALBook Values for Manual Valuation of Positions13FUNDFundnvarchar100
105TRLT_INIT_IGT_SEInitialization Values for Intragroup Transactions12FUNDFundnvarchar100
106TRLT_INIT_VAL_FUInitialization Values for TRL Futures Positions9FUNDFundnvarchar100
107TRLT_INIT_VAL_SEInitialization Values for TRL Positions: Securities12FUNDFundnvarchar100
108VALT_SP_VAL_SECSecurity Prices and NPV for Special Valuation14FUNDFundnvarchar100
TOPTravel Expenses
109PTRV_COMM_ITMHeader Data: Transfer to FM When Trip Saved22FUNDFundnvarchar100
110PTRV_SCOSTrip Statistics - Cost Assignment20FUNDFundnvarchar100