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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

81 columns | Print definition?ERP 6.0  | VARNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T021Fields for Line Item and Document Line Layout3VARNRLine Layoutnvarchar30
2T021DLine Layout Fast Entry: Administration3VARNRFast Entry: Variantnvarchar50
3T021FLine Layout Fast Entry: Variants3VARNRFast Entry: Variantnvarchar50
4T021GLine Layout Fast Entry: Description of Variants4VARNRFast Entry: Variantnvarchar50
5T021JFast Entry: Inactive Standard Variants3VARNRFast Entry: Variantnvarchar50
6T021QFast Entry Line Layout: Control14VARNRFast Entry: Variantnvarchar50
7T021TLine Layout Variant Texts4VARNRLine Layoutnvarchar30
8T021VDefault Values for Layouts4VARNRLine Layoutnvarchar30
9T021ZLine Layout Variants3VARNRLine Layoutnvarchar30
10T180TReporting: Display Variants - Texts6VARNRLayoutnvarchar30
11T180UReporting: Display Variants - Headings6VARNRLayoutnvarchar30
12TKSBSFields for Line Structure3VARNRLine Layoutnvarchar30
13TKSBTDisplay Variant Texts4VARNRLine Layoutnvarchar30
14TKSBVDefault Values for Layouts4VARNRLine Layoutnvarchar30
15TKSBZLine Structure Variants3VARNRLine Layoutnvarchar30
TOPAccount Determination
16T180GReporting: Totals Variants for each Display Variant5VARNRLayoutnvarchar30
17T180PReporting: Display Variants: Selection Fields per Variant(s)5VARNRLayoutnvarchar30
18T180SReporting: Display Variants: Fields5VARNRLayoutnvarchar30
TOPAssortment
19WRF_APC_PAVARPlanned Article Variants3VARNRVariant numbernvarchar180
20WRF_APC_PLPLPurchasing List Planned Data19VARNRVariant numbernvarchar180
21WRF_APC_PPCMPPlanned Article Prepack Components3VARNRVariant numbernvarchar180
TOPBasic Data
22TIVBDAROBJTYPEArchitectural Object Type9VARNRBDT: Screen Sequence per Arch. Object Typenvarchar60
23TIVBDUSGROTYPEAllowed Usage Type per Rental Object Type4VARNRBDT: Screen Sequence for Rental Objectsnvarchar60
TOPBasic Functions
24EMMAC_CCAT_MOBAssignment of Business Objects (or Field Values) to Case Cat4VARNRMessage Variable or Parameters for Messagenvarchar100
25EMMAC_MSG_OBJMessage Objects3VARNRMessage Variable or Parameters for Messagenvarchar100
TOPClaims Management
26ICLSSEQScreen in Entry Mode5VARNRBDT: Screen sequencenvarchar60
TOPContract Accounts Receivable and Payable
27TFK021Line layout variants: Fields3VARNRLine Layout/Variantnvarchar30
28TFK021DScreen variants: Administration3VARNRScreen variants: Name of variantnvarchar50
29TFK021FScreen variants: Number of lines3VARNRScreen variants: Name of variantnvarchar50
30TFK021GScreen variants: Description of variants4VARNRScreen variants: Name of variantnvarchar50
31TFK021IFast entry line layout: Variant fields3VARNRScreen variants: Name of variantnvarchar50
32TFK021SScreen variants (standard): Management3VARNRScreen variants: Name of variantnvarchar50
33TFK021TLine layout variants: Texts4VARNRLine Layout/Variantnvarchar30
34TFK021UDefault Values for Line Layout in Account Display4VARNRLine Layout/Variantnvarchar30
35TFK021XScreen variants (standard): Meaning of variants4VARNRScreen variants: Name of variantnvarchar50
36TFK021ZLine layout variants: Header data3VARNRLine Layout/Variantnvarchar30
37TRM021Account Balance: Line-Layout Variant for Display Level 12VARNRLine Layout/Variantnvarchar30
38TRM021TText Table for TRM021 (Acc Ovw Line Variants Level 1)3VARNRLine Layout/Variantnvarchar30
39TRM021VLine Layout Variants for Acc. Ovw: Texts3VARNRLine Layout/Variantnvarchar30
40TRM022Account Balance: Line Layout Variant for Display Level 22VARNRLine Layout/Variantnvarchar30
41TRM022TText Table for TRM022 (Acc. Ovw Line Variants Level 2)3VARNRLine Layout/Variantnvarchar30
TOPControlling
42COPPP_HDRCO Postprocessing List - Headers28VARNRCO actual postings fast input: Variantnvarchar50
TOPCustomer Interaction Center
43EEFO01Settings for Account Balance in CIC4VARNRLine Layout/Variantnvarchar30
TOPFinancial Accounting
44KMKPFFI: Account Assignment Model Header Information17VARNRFast Entry: Variantnvarchar50
45T021HLine Layout Fast Entry: Screen Variants3VARNRFast Entry: Variantnvarchar50
46T021ILine Layout Fast Entry: Variant Fields3VARNRFast Entry: Variantnvarchar50
47T021STDFFast Entry: Standard Variant Fields3VARNRFast Entry: Variantnvarchar50
48T021STDTFast Entry: Standard Variants (Texts)4VARNRFast Entry: Variantnvarchar50
49T021STDVFast Entry: Standard Variants3VARNRFast Entry: Variantnvarchar50
TOPFinancial Conditions
50FICOC_COND_BDTDefine Condition Type - BDT4VARNRBDT: Screen sequencenvarchar60
TOPFlexible Real Estate Management
51TIVBDROTYPEOBSOLETE: Rental Objects and BDT Screen Sequences3VARNRBDT: Screen Sequence for Rental Objectsnvarchar60
52TIVBDROUSGRELOBSOLETE: Rental Object Type: Permitted Usage Types4VARNRBDT: Screen Sequence for Rental Objectsnvarchar60
TOPFunds Management
53KBLKDocument Header: Manual Document Entry13VARNRListscreen variantnvarchar50
TOPInformation System
54TITVARLine Items: Line Layout Variants, Assignment Old-New1VARNRLine Layoutnvarchar30
TOPMaterial Maintenance
55T180ZReporting: Display Variants5VARNRLayoutnvarchar30
TOPMaterial Master
56WSTN_PP_STRUCPrepack definition - Components table3VARNRVariant numbernvarchar180
TOPMaterials Management
57J_1GVL_WHB014CO repostings settings (NOT USED ANY MORE)4VARNRCO actual postings fast input: Variantnvarchar50
TOPMerchandise and Assortment Planning
58TWISPC_DPLVARetail Planning: Manual Planning Variants5VARNRVariant Number in Manual Planning Layoutnvarchar30
59TWISPC_DPLVATRetail Planning: Texts for Manual Planning Variants6VARNRVariant Number in Manual Planning Layoutnvarchar30
60TWISPC_DPLVVRetail Planning: Default Parameters for Manual Plng Variants5VARNRVariant Number in Manual Planning Layoutnvarchar30
61TWISPS_NOPROMO1Parameters for Promotions Created in MAP15VARNRVariant Number in Manual Planning Layoutnvarchar30
TOPOffer and Rental Request
62TIVORRRTYPEType of RE Search Request3VARNRBDT: Screen Sequencenvarchar60
TOPOverhead Cost Controlling
63COBKCO Object: Document Header27VARNRCO actual postings fast input: Variantnvarchar50
TOPPublic Sector Contract Accounts Receivable and Payable
64TFMCA_COV_002Business Partner Overview: Configuration13VARNRLine Layout/Variantnvarchar30
65TPSOB002Screen Sequence for Each Object Type and Hierarchy Level4VARNRBDT: Screen sequencenvarchar60
TOPReal Estate Management
66TIV26Real Estate Contract Type (Entities)18VARNRBDT: Screen sequencenvarchar60
TOPRoom Reservations and Seating Arrangements
67TIVORRSOBJTYPEReservation Object Type13VARNRBDT: Screen Sequencenvarchar60
TOPSAP Business Partner
68TB045Business Partner: Filter Values for Variants Deletion Selecn1VARNRVariant / BAdI Filter for Selection of Data to Be Archivednvarchar100
69TB045TBusiness Partner: Texts for Variants Deletion Selection2VARNRVariant / BAdI Filter for Selection of Data to Be Archivednvarchar100
70TB050Screen Config. (Obsolete from Second Edition VCT)4VARNRBDT: Screen sequencenvarchar60
71TBZ0BDT Object Parts4VARNRBDT: Screen sequencenvarchar60
72TBZ0GBDT Object Part Grouping4VARNRBDT: Screen sequencenvarchar60
73TBZ0JAssign BDT Object Part Grouping -> BDT Screen Sequences5VARNRBDT: Screen sequencenvarchar60
74TBZ0UAssign BDT Object Part -> BDT Screen Sequences5VARNRBDT: Screen sequencenvarchar60
75TBZ3BDT Screen Sequences3VARNRBDT: Screen sequencenvarchar60
76TBZ3KAssign BDT Screen Sequence -> BDT Screen3VARNRBDT: Screen sequencenvarchar60
77TBZ3NBDT-Screen Sequence Category -> BDT-Screen Seq. Assignment4VARNRBDT: Screen sequencenvarchar60
78TBZ3TBDT Screen Sequence Variants: Texts4VARNRBDT: Screen sequencenvarchar60
79TBZ4BBDT GUI Functions: Active per View/Screen Seq.Variant (Obs)5VARNRBDT: Screen sequencenvarchar60
80TBZ6BDT: VCT Usages5VARNRBDT: Screen sequencenvarchar60
TOPUse AP-MD-BP Components
81TBZ9BP relationship categories8VARNRBDT: Screen sequencenvarchar60