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

49 columns | Print definition?ERP 6.0  | FELDN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPD_MDG_FLDMAPMDG: Assignment Entity/Database Field Name7FELDNField namenvarchar300
2DICS_T150FStock Types and Allocated Fields in Physical Inventory7FELDNStock field in material master record viewnvarchar160
3J_1BAKHAssignment of Field to Field Group (Header)2FELDNField namenvarchar300
4J_1BAKITAssignment of Field to Field Group (Item)2FELDNField namenvarchar300
5J_1BAMDATASELField Selection at Master Data2FELDNField Namenvarchar300
6J_1BCUST_SCFSELField Selection for Customer Master Data3FELDNField Namenvarchar300
7J_1BVEND_SCFSELField Selection for Vendor Master Data3FELDNField Namenvarchar300
8T021RField selection for spec.functions (list displays)4FELDNField namenvarchar300
9T047FSorting of dunning letters4FELDNName of field used for sortingnvarchar160
10T150FStock Types and Allocated Fields in Physical Inventory7FELDNStock field in material master record viewnvarchar160
11T159EIM Print Func.:Determ.No.of Copies f. Label Print.5FELDNName of fieldnvarchar160
12T169APosting String for Invoice Verification4FELDNName of fieldnvarchar160
13TKSBRField Selection for Special Functions (List Display)4FELDNName of fieldnvarchar160
TOPAccount Determination
14T180PReporting: Display Variants: Selection Fields per Variant(s)8FELDNName of fieldnvarchar160
TOPAlternative Valuation Run
15CKMLAVRDOCITLines for Cumulation Posting Document9FELDNName of fieldnvarchar160
TOPApplications
16MDG_ECC_CUST_FGAttribution Entity/DB/Modification group (Customer)6FELDNName of fieldnvarchar160
TOPBank
17T055Field group fields (master data)4FELDNComplete field name (table, separator, field name)nvarchar610
TOPBasic Data
18TN12PIS-H: Parameters for Transferring Persons From RP3FELDNIS-H: Field Name of a Table (for RP Data Transfer)nvarchar200
19TNDCVIS-H: Screen Fields Dependent on Country Version1FELDNIS-H: Field Namenvarchar1320
TOPBasic Functions
20TABWD_FTCFields Used for Table Controls on Asset Postings2FELDNField Namenvarchar300
TOPCollectionsDisbursements
21TIMA_VKTYP_DEFIO: Ctr. Acct Category Default Vals for Contr. Acct Creation3FELDNField Namenvarchar300
22TKKVKONTOAccount Control4FELDNField Namenvarchar300
TOPContract Accounts Receivable and Payable
23TFK021RField selection for list processing functions4FELDNField Namenvarchar300
24TFK055Fields of Field Groups for Document Change3FELDNComplete field name (table, separator, field name)nvarchar610
TOPDunning
25T047FSLLast-Used Additional Selection for Dunning2FELDNComplete field name (table, separator, field name)nvarchar610
TOPFinancial Accounting
26T055FField Group Fields (Master Data)3FELDNComplete field name (table, separator, field name)nvarchar610
27TMODUCross Reference Field Name - MODIF14FELDNField Namenvarchar300
28TNAMNPuffer for Keywords (NAMETAB)3FELDNField Namenvarchar300
TOPFunds Management
29FMRESACCMVRULESRules for Account Assignment Transfer3FELDNPossible field for account assignment transfernvarchar300
30FMRESFIELDSControllable Fields Earmarked Funds1FELDNPermitted field names for earmarked funds field selctn cont.nvarchar300
31TRE01Copy Template when Creating Funds Reservations3FELDNPermitted template fields for earmarked fundsnvarchar300
32TRE02Template for Copying from Funds Reservation Reference Docs3FELDNField Namenvarchar300
33TREFFields for Field Selection String in Funds Reservations4FELDNPermitted field names for earmarked funds field selctn cont.nvarchar300
34TREWFFIELDFiels in Group Keys for Workflow (Obsolete Since 4.70)4FELDNField Namenvarchar300
TOPFunds Management-Specific Postings
35PSOFSTField Selection String and Fields for Requests3FELDNPermitted field names for the field selection contrl. reqstsnvarchar300
36PSOFST_FLFields for Field Selection String for Requests1FELDNPermitted field names for the field selection contrl. reqstsnvarchar300
TOPInformation system
37FMFIPVVAnzeigefelder für den Veränderungsnachweis2FELDNDozwolone nazwy pól dla sterowania wyborem pól rez. srodkównvarchar300
TOPInventory Management
38T156WPosting string values4FELDNName of fieldnvarchar160
TOPLocalization
39J_1BAKField assignment3FELDNField namenvarchar300
40J_1BIM01MM-IM: Tax posting strings for inventory management7FELDNName of fieldnvarchar160
TOPMDG Business Partner Central Part
41MDG_BS_BP_FLDGRPAttribution Entity/DB/Fieldgroups9FELDNField namenvarchar300
42MDG_ECC_BPFLDMAPMapping of CVI-structures to modif-groups4FELDNName of fieldnvarchar160
43MDG_FND_BPFLDMAPMapping of BP-bapistructures and fields to BDT fieldgroups5FELDNField namenvarchar300
TOPMDG Supplier Central Parts
44MDG_BS_SUPPL_FGAttribution Entity/DB/Modification group (Supplier)6FELDNName of fieldnvarchar160
TOPPayment Transactions
45T042FSLLast additional selections used2FELDNComplete field name (table, separator, field name)nvarchar610
46TFAGSDefinition of FI clearing rules3FELDNField Namenvarchar300
TOPPegging, Grouping, and Distribution
47TBLP_MODUCross Reference Field Name - MODIF14FELDNField Namenvarchar300
TOPTransaction Manager
48TMODVField Selection: Assign Fields to Field Groups4FELDNField Namenvarchar300
TOPWarehouse Management
49T308Requirements Categories4FELDNName of fieldnvarchar160