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

82 columns | Print definition?ERP 6.0  | LINENR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/FLINEText lines3LINENRLine Numberint100
2/CIDEON/FPU_DOCCIDEON® Fast Property Update Dokument Data7LINENRLine Numberint100
3/CIDEON/FPU_TBKCIDEON® Fast Property Update TBK Update8LINENRLine Numberint100
4/CIDEON/TB_DOCCICustomizing for "Create Document" with CAD Desktop7LINENRLine Numberint100
5/SDF/TEA_CHK_TRTEA for Project: Checked transport list1LINENRDictionary: Line itemnvarchar60
6CNV_PROTDOWNK5LINENRnvarchar40
7FITDKWC_FSCLINESForm Structure: Lines4LINENRLine Numbernvarchar30
8FITDKWC_LTEXTSLinetexts for PDF Tax Declaration Output4LINENRLine Numbernvarchar30
9FITDKW_FSCLINES2Form Structure: Lines 2 (extended for new Zakat)4LINENRLine Numbernvarchar30
10FITDKW_FSCLINESTForm Structure: Lines - Texts4LINENRLine Numbernvarchar30
11FITDKW_FSCLINST2Form Structure: Lines - Texts 2 (extended for new Zakat)4LINENRLine Numbernvarchar30
12FITDKW_FSCNODESForm Structure: Nodes4LINENRLine Numbernvarchar30
13FITDKW_FSCNODES2Form Structure: Nodes 2 (extended for new Zakat)4LINENRLine Numbernvarchar30
14FITDKW_FSCSUBNODForm Structure: Subodes 2 (extended for new Zakat)4LINENRLine Numbernvarchar30
15FITDKW_FSCVALUE2Form Structure: Values 2 (extended for new Zakat)5LINENRLine Numbernvarchar30
16FITDKW_FSCVALUESForm Structure: Values5LINENRLine Numbernvarchar30
17FITDKW_FSC_ITEMForm Structure: Item5LINENRLine Numbernvarchar30
18FITDOMC_FSCLINESForm Structure: Lines (Oman)4LINENRLine Sequence Numbernvarchar30
19FITDOMC_FSCVALUEForm Structure: Values (Oman)5LINENRLine Sequence Numbernvarchar30
20FITDOM_FSCLINESTForm Structure: Lines - Texts (Oman)4LINENRLine Sequence Numbernvarchar30
21FITDOM_FSCNODESForm Structure: Nodes (Oman)4LINENRLine Sequence Numbernvarchar30
22FITDOM_FSCSUBNODForm Structure: Nodes (Oman)4LINENRLine Sequence Numbernvarchar30
23FITDQAC_FSCLINESForm Structure: Lines4LINENRLine Numbernvarchar60
24FITDQAC_FSCNODESForm Structure: Nodes4LINENRLine Numbernvarchar60
25FITDQAC_FSCVALUEForm Structure: Values5LINENRLine Numbernvarchar60
26FITDQAC_LTEXTLinetexts for PDF Tax Declaration Output (Qatar)4LINENRLine Numbernvarchar60
27IDCN_FSC_ITEMForm Structure: Item5LINENRLine Numbernvarchar30
28IDSAU_FSCLINESForm Structure: Lines4LINENRLine Numbernvarchar60
29IDSAU_FSCLINESTForm Structure: Lines - Texts4LINENRLine Numbernvarchar60
30IDSAU_FSCNODESForm Structure: Nodes4LINENRLine Numbernvarchar60
31IDSAU_FSCVALUESForm Structure: Values5LINENRLine Numbernvarchar60
32IDSAU_FSC_ITEMForm Structure: Item5LINENRLine Numbernvarchar60
33N1ME_THREC_LBMedication: Link Module Data for Therapy Recommendation3LINENRLineint100
34REP_EAPS_CZ_XMLPS-CZ: XML Nodes Definition3LINENRLine Numbernvarchar50
35REP_EAPS_DCOLN_CData Connector: Layout Customizing/Line Definition3LINENRLine Numbernvarchar50
36REP_EAPS_DCOLN_TData Connector: Layout Customizing/Line Definition Text3LINENRLine Numbernvarchar50
37REP_EAPS_DCONG_CData Connector: Group of Items in Line3LINENRLine Numbernvarchar50
38REP_EAPS_DCONO_CData Connector: Item of Line Definitions3LINENRLine Numbernvarchar50
39REP_EAPS_DCONS_CData Connector: Item of Line Definitions Grouped3LINENRLine Numbernvarchar50
40SYNTAQuellcode der Syntaxfehlertests3LINENRZeilennummer eines Syntaxfehler-Testsnvarchar60
41HRT1719Table Section for Infotype 171976LINENRLine Number in SAP TextEditnvarchar40
42HRT1891Table Part Infotype 18914LINENRLine Number in SAP TextEditnvarchar40
43HRT1892Table Part Infotype 18924LINENRLine Number in SAP TextEditnvarchar40
TOPABAP Workbench, Java IDE and Infrastructure
44WBWL_TABUser-Specific Worklist4LINENRnvarchar100
TOPBusiness Consolidation
45UCT8010Mapping Rule: Row Content3LINENRRow Numbernvarchar40
46UCT8011Mapping Rule: Details of Condition3LINENRRow Numbernvarchar40
47UCT8012Mapping Rule: Details of Reassignment3LINENRRow Numbernvarchar40
48UCT8013Mapping Rule: Header Info MOVE Operator3LINENRRow Numbernvarchar40
49UCT8014Mapping Rule: Details of Move Operator3LINENRRow Numbernvarchar40
50UCT8015Mapping Rule: Details of Apply Operator3LINENRRow Numbernvarchar40
51UCT8016Mapping Rule: Substitute for Source Field3LINENRRow Numbernvarchar40
TOPCAD Integration
52CDESK_C_DOCCREATCustomizing for "Create Document" with CAD Desktop7LINENRLine Numberint100
TOPContract Accounts Receivable and Payable
53DFKKORDERHISTRequests: Document History12LINENRLine Numbernvarchar40
54DFKKORDERLOCKSRequests: Processing Locks4LINENRLine Numbernvarchar40
55DFKKORDERLOCKS_SRequest Templates: Processing Locks4LINENRLine Numbernvarchar40
56DFKKORDERPOSRequests: Items4LINENRLine Numbernvarchar40
57DFKKORDERPOS_SRequest Templates: Items4LINENRLine Numbernvarchar40
TOPContract Billing
58EUPDLOGISU: Update Log for Upload from Selective Rate Transport3LINENRNumber of Billing Runnvarchar120
TOPeCATT Extended Computer Aided Test Tool
59ECET_BLOBSTable for Storing Test Partner Scripts as BLOBs3LINENRNatural Numberint100
60ECET_BLOBS_ENExtended Table for Storage BLOBs of External Tools4LINENRNatural Numberint100
61ECEVT_DATOBSOLETE - Table for Transfer of GUI Event Data1LINENRNatural Numberint100
TOPEngineering Desktop
62EDESK_C_DOCCREATCustomizing for Document Creation in Engineering Desktop7LINENRLine Number in Engineering Desktopint100
63EDESK_C_DOCUPDATCustomizing for Document Update in Engineering Desktop7LINENRLine Number in Engineering Desktopint100
TOPFunctions for U.S. Federal Government
64FMFGRLAYOUT_DEFDefinition for reporting layout4LINENRReporting Line Numbernvarchar60
65FMFG_PRIOR_RPTKFPrior Reported Keyfigures3LINENRReporting Line Numbernvarchar60
TOPLegacy System Migration Workbench
66/SAPDMC/LSGBDCBI Name: "Code"3LINENRFour Character Line Numbernvarchar40
TOPLocalization
67IDCN_FSCLINESForm Structure: Lines4LINENRLine Numbernvarchar30
68IDCN_FSCLINESTForm Structure: Lines - Texts4LINENRLine Numbernvarchar30
69IDCN_FSCNODESForm Structure: Nodes4LINENRLine Numbernvarchar30
70IDCN_FSCVALUESForm Structure: Values4LINENRLine Numbernvarchar30
TOPMicrosoft SQL Server
71MSSSOURCEMS SQL Server: Stored Procedures Source Code4LINENRMS SQL Server : Stored procedure line numberint100
TOPProduct Safety
72TCGRULPOSRULEHS: Easy Expert Set of Rules, Generated Sets of Rules5LINENRNatural Numberint100
TOPRevenues and Earnings
73AD01C_MATDIP profile: Material determination4LINENRDI Profile: Material determination linenvarchar50
74AD01C_MATADIP profile: Material determination criteria4LINENRDI Profile: Material determination linenvarchar50
75AD01C_SELDIP profile: Sources4LINENRSource index (DIP profile)nvarchar30
76AD01C_SELADIP profile: Selection criteria4LINENRSource index (DIP profile)nvarchar30
TOPSmart Forms
77STXFTXTSAP Smart Forms: Texts6LINENRSmart Forms: Number of a Floating Text Linenvarchar60
78STXFTXTVSAP Smart Forms: Texts - Versions8LINENRSmart Forms: Number of a Floating Text Linenvarchar60
TOPTariffs, Duties and Permits
79OIH14Tax rate revaluation - obsolete20LINENRLine numbernvarchar30
TOPTraders and Schedulers Workbench
80OIJBRDDOCRundown item / document X-ref table for Batch - WILL EXPIR8LINENROIL-TSW: Document item schedule line numbernvarchar40
81OIJRDDOCRundown item / document X-ref table/ WILL EXPIRE IN FUTURE8LINENROIL-TSW: Document item schedule line numbernvarchar40
TOPTransport Management System
82TMSTPALOGTMS: Expanded ALOG Table14LINENRnvarchar100