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

115 columns | Print definition?ERP 6.0  | TEXT3

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DVKTXR/2-R/3 Link: Delivery texts R2 -> R310TEXT3Text R/2-R/3 Linknvarchar720
2PB0290HR Master Record: Infotype 0290 - Identity card CIS33TEXT3Additional Informationnvarchar500
3PYC_D_PY_MSGPYC: payroll message44TEXT3Text Element for Structure PLOG_TEXTnvarchar1320
4PYC_D_PY_MSG_JOBPYC: payroll message27TEXT3Text Element for Structure PLOG_TEXTnvarchar1320
5ZML_MAILSETTINGMail settings for OTM10TEXT3Textnvarchar2550
TOPBasic Functions
6EIKPForeign Trade: Export/Import Header Data45TEXT3Comments: Text for foreign trade processingnvarchar400
7EIPOForeign Trade: Export/Import: Item Data22TEXT3Comments: Text for foreign trade processingnvarchar400
8MAZOForeign Trade: Customs Law Description8TEXT3Description for customs descriptionnvarchar700
9T604DPreference: Description of Preference Procedure Code8TEXT3Text, 40 Characters Longnvarchar400
10T604NImport Processing: Control Code Description7TEXT3Description of rulenvarchar600
11T604OForeign Trade: Sections With Regard to Customs Law - Descr.7TEXT3Text, 40 Characters Longnvarchar400
12T604TForeign Trade: Commodity Code/Import Code No. Description7TEXT3Text, 40 Characters Longnvarchar400
13T604ZForeign Trade: Chapter - Descriptions8TEXT3Text, 40 Characters Longnvarchar400
14T605TForeign Trade: Business Transaction Type - Descriptions7TEXT3Text Field of Length 60nvarchar600
15T609GPForeign Trade: PRODCOM/GP Number (Prod.Stat.) - Descriptions7TEXT3Description of rulenvarchar600
16T610CTImport Processing: CAS No. for Pharmaceut.Products - Descr.7TEXT3Description of rulenvarchar600
17T615TForeign Trade: Customs Offices - Descriptions7TEXT3Text Field of Length 60nvarchar600
18T616TForeign Trade: Procedures - Descriptions7TEXT3Text Field of Length 60nvarchar600
19T618MTEU Market: EU Market Products List No. - Descriptions7TEXT3Description of rulenvarchar600
TOPCentral Part of Product Master
20CRMC_TAX_TCODE_TDescription for Assignment of Tax Scale Code to a Country7TEXT3Description of Tax Scale Codenvarchar600
TOPClinical System
21N2MV_DISREQDispatch Request Data Table40TEXT3Free Text 3nvarchar720
22N2MV_VSDATRecipient Data Table39TEXT3Free Text 3nvarchar720
TOPDenmark
23PA0073HR Master Record: Infotype 0073 (Private Pensions - DK)46TEXT3Supplementary pension text 3nvarchar200
TOPFinancial Accounting
24T007FTaxes on Sales/Purchases Groups10TEXT3Text Namenvarchar320
TOPForeign Trade
25/SAPSLL/T604R3GTS: Worklist: Retransfer of Commodity Code10TEXT3Text, 40 Characters Longnvarchar400
26/SAPSLL/T606GTR3GTS: Legal Services: Legal Regulations - Name6TEXT3Description of Length 60 for GTSnvarchar600
TOPFunds Management
27FMCITCommitment items texts9TEXT3Description 3nvarchar500
28FMDECKRGTCover Pool Texts9TEXT3Description 3nvarchar500
29FMHVMTXTTBudget Memo Texts, language dependent8TEXT3Description 3nvarchar500
30FMPPTCommitment Item in Chart of Commitment Items: Texts9TEXT3Description 3nvarchar500
TOPGlobal Trade Services
31/SAPSLL/CCGRTLegal Control: Control Groupings for Products - Relation.7TEXT3Text 60 Characters Longnvarchar600
32/SAPSLL/CCSHTLegal Control: Peculiarity Code for Products - Text7TEXT3Text 60 Characters Longnvarchar600
33/SAPSLL/CTYGPTLegal Services: Country Group - Text6TEXT3Text 60 Characters Longnvarchar600
34/SAPSLL/CUCAARTSLL: Toll Types - Description7TEXT3Text 60 Characters Longnvarchar600
35/SAPSLL/CUCAFATGTS: Description of Requested Concession7TEXT3Text 60 Characters Longnvarchar600
36/SAPSLL/CUCAGGTGTS: Tax Assessment Duty Group - Description7TEXT3Text 60 Characters Longnvarchar600
37/SAPSLL/CUCAPRTSLL: Additional Procedures - Description7TEXT3Text 60 Characters Longnvarchar600
38/SAPSLL/CUCBMSTGTS: Tax Assessment Measure - Description7TEXT3Text 60 Characters Longnvarchar600
39/SAPSLL/CUCDADTDefinition of Customs Duty Types: Text Table7TEXT3Text 60 Characters Longnvarchar600
40/SAPSLL/CUCINDTGTS: Customs Processing Indicator8TEXT3Text 60 Characters Longnvarchar600
41/SAPSLL/CUCMTRTSLL: Description of Type of Transport7TEXT3Text 60 Characters Longnvarchar600
42/SAPSLL/CUCNGATSLL: Range of Goods - Description7TEXT3Text 60 Characters Longnvarchar600
43/SAPSLL/CUCPATTSLL: Description of Preliminary Docmt Types8TEXT3Text 60 Characters Longnvarchar600
44/SAPSLL/CUCPROTGTS: Place into a Customs Status - Description7TEXT3Text 60 Characters Longnvarchar600
45/SAPSLL/CUCPSTTStatus of a Document - Name7TEXT3Text 60 Characters Longnvarchar600
46/SAPSLL/CUCZAFTGTS: Payment Demand for Tax Assessment - Description8TEXT3Text 60 Characters Longnvarchar600
47/SAPSLL/LCPROTProject Master - Text Table11TEXT3Text 60 Characters Longnvarchar600
48/SAPSLL/LC_CUSB1GTS: Custs Prcssng: Duty Cat: Non-EU Country Duty, Pharmac.27TEXT3Text 60 Characters Longnvarchar600
49/SAPSLL/LC_CUSB2GTS Customs Management: Toll Category: Preferred Customs28TEXT3Text 60 Characters Longnvarchar600
50/SAPSLL/LC_CUSMNGTS: Customs Processing: Measures Relating to Duty Rate23TEXT3Text 60 Characters Longnvarchar600
51/SAPSLL/PRECONDTGTS: preference: additional cond's (upload data provider -B)7TEXT3Text 60 Characters Longnvarchar600
52/SAPSLL/PSVCONDTGTS: Preference: Additional Conditions (Manual Entry)7TEXT3Text 60 Characters Longnvarchar600
53/SAPSLL/T606DLTLegal Control: Text for Procedure for Determining Lic. Types6TEXT3Text 60 Characters Longnvarchar600
54/SAPSLL/T606DRTLegal Control: Text for Procedure for Determining Leg. Regs6TEXT3Text 60 Characters Longnvarchar600
55/SAPSLL/T606GTLegal Services: Texts for Legal Regulations6TEXT3Text 60 Characters Longnvarchar600
56/SAPSLL/T606STLeg. Control: Text for Status of License of Legal Regulation7TEXT3Text 60 Characters Longnvarchar600
57/SAPSLL/T606TSLL: Legal Control: License Type - Description7TEXT3Text 60 Characters Longnvarchar600
58/SAPSLL/T608GTSanctioned Party List: Group of List - Name7TEXT3Text 60 Characters Longnvarchar600
59/SAPSLL/T608ITSanctioned Party List: Type of Identification - Name7TEXT3Text 60 Characters Longnvarchar600
60/SAPSLL/T608LTLegal Control - SPL - Type of List - Reference7TEXT3Text 60 Characters Longnvarchar600
61/SAPSLL/T608RTLegal Control: SPL - Type of Reference - Text7TEXT3Text 60 Characters Longnvarchar600
62/SAPSLL/TBO00TGTS: Description for BOP Category7TEXT3Text Field of Length 60nvarchar600
63/SAPSLL/TBO01TGTS: Bill of Product - Item Category - Description7TEXT3Text 60 Characters Longnvarchar600
64/SAPSLL/TCOCMPTText for Rule Set for Comparing Addresses/Strings6TEXT3Text 60 Characters Longnvarchar600
65/SAPSLL/TCOGVSTText for Feeder System Grouping5TEXT3Text 60 Characters Longnvarchar600
66/SAPSLL/TCOPSTPartner Group Relevant for Letter of Credit - Description6TEXT3Text 60 Characters Longnvarchar600
67/SAPSLL/TCOTSTBasic Structure of Customs Tariff System - Text6TEXT3Text 60 Characters Longnvarchar600
68/SAPSLL/TCSIDDOTIdentification Types - Names7TEXT3Text 60 Characters Longnvarchar600
69/SAPSLL/TCSIDDTSchema for Identification Types - Name6TEXT3Text 60 Characters Longnvarchar600
70/SAPSLL/TCSSCHOTOptions for Release Reason - Name7TEXT3Text 60 Characters Longnvarchar600
71/SAPSLL/TCSSCHTDetermination Procedure for Release Reason - Name6TEXT3Text 60 Characters Longnvarchar600
72/SAPSLL/TFCTRTAggregation Schema - Description6TEXT3Text 60 Characters Longnvarchar600
73/SAPSLL/TLAGRTGTS: Aggregation Rules for Customs Doc. - Description6TEXT3Text 60 Characters Longnvarchar600
74/SAPSLL/TLEBTSTRule Set for Customs Business Transaction Types - Text6TEXT3Text 60 Characters Longnvarchar600
75/SAPSLL/TLECHTLegal Services: Text for Document Type of Customs Document6TEXT3Text 60 Characters Longnvarchar600
76/SAPSLL/TLECITLegal Services: Customs Document- Item Category Text6TEXT3Text 60 Characters Longnvarchar600
77/SAPSLL/TLECPTGTS: Supplementary Declaration: Document Type - Description6TEXT3Text 60 Characters Longnvarchar600
78/SAPSLL/TLEDPGTLegal Services: Depreciation Group Texts6TEXT3Text 60 Characters Longnvarchar600
79/SAPSLL/TLEMOTGTS: Definition of Model for BOM Cost Estimate - Description6TEXT3Text 60 Characters Longnvarchar600
80/SAPSLL/TRS01TGTS: Restitution: CAP Recoding - Reference Type7TEXT3Text 60 Characters Longnvarchar600
TOPGRC Access Control Plug-In
81/VIRSA/CRAUTHC1TRestricted Critical Authorizations Text8TEXT3Descriptionnvarchar1200
82/VIRSA/ZCRAUTHC1Restricted Critical Authorizations15TEXT3Descriptionnvarchar1200
TOPI18N Unicode
83UM4MAINLOGSPUMG: Main Log table8TEXT3nvarchar400
84UMGMAINLOGSPUMG: Main Log table8TEXT3SPUMG: Parameter for main log messagesnvarchar400
85UMG_TEST_13Unicode conversion testtable3TEXT3nvarchar100
TOPImplementation Guide
86TIMG1Status Fields for Customizing Transaction12TEXT3Text (20 Characters)nvarchar200
TOPInternationalization I18N
87CFONT_MAINLOGI18N:Cascading font, log table8TEXT3nvarchar400
TOPLocalization
88J_3RFF4DATACash flow statement customizing10TEXT3Item Descriptionnvarchar450
89J_3RFF4DATATCash flow statement row texts8TEXT3Item Descriptionnvarchar450
TOPMaterial Groups
90WTREEVersion Management for Reclassification Trees38TEXT3Text/Icon/Symbolnvarchar750
TOPMaterial Master
91MGVSPECTYPETEXTSText for specialization types7TEXT3Header table material master specializationnvarchar800
TOPNetWeaver Enterprise Search
92ESH_TST_EH_RTTText table of ESH_TST_EH_RTI6TEXT3Character field, length 64nvarchar640
TOPOLAP Technology
93RSR_CACHE_LOGOLAP Cache Table for Saving Log Entries13TEXT3Character Field of Length 40nvarchar400
TOPPayroll
94T5TPSCHODNTabulka hodností10TEXT3Textové pole o délce 60 znakunvarchar600
TOPPeriodical Sales and Distribution
95JKAKPRAd Pre-Print Order: Header Data27TEXT3Text (80 Characters)nvarchar800
96JVTFAHRMIS-M: Driver Notification (Shipping Documents)6TEXT3Text (80 Characters)nvarchar800
97JVTZUSTMIS-M/SD: Carrier Notification (Shipping Documents)10TEXT3Text (80 Characters)nvarchar800
TOPPersonnel Administration
98T7PL08Conversion table for leave codes7TEXT3Text field - 60 charactersnvarchar600
99T7PLT0Conversion table for leave codes fot tempolary workers7TEXT3Text field - 60 charactersnvarchar600
TOPReal Estate Management
100VZWDVLBuffer for sends within Financial Assets Management19TEXT3Text (20 Characters)nvarchar200
TOPRemaining Beverage - Obsolete Objects
101/BEV1/CLT998Table for Border Crossing Points5TEXT3Table textnvarchar600
102/BEV3/CHCDPCUSTCDP: Contract Data Customer22TEXT3CH: Free Text 30 Charactersnvarchar300
103/BEV3/CHWDCMMNTInternal memos / comments on CHD9TEXT3Check: Character Field length = 80, Upper and Lower Casenvarchar800
TOPRisk Analysis
104JBRNODETXTAll Information for Display of Hierarchies34TEXT3Text/Icon/Symbolnvarchar750
TOPRussia
105PA0290HR Master Record: Infotype 0290 - Identity card CIS33TEXT3Additional Informationnvarchar500
TOPTransportation
106VTTKShipment Header94TEXT3Addit.text 3nvarchar400
TOPWarehouse Management
107LL01Whse Activity Monitor: Critical Transfer Order Items17TEXT3Processing note for a critical activitynvarchar400
108LL02Whse Activity Monitor: Critical Transfer Requirement Items18TEXT3Processing note for a critical activitynvarchar400
109LL03Whse Activity Monitor: Critical Posting Change Documents14TEXT3Processing note for a critical activitynvarchar400
110LL04Whse Activity Monitor: Critical Deliveries14TEXT3Processing note for a critical activitynvarchar400
111LL05Whse Activity Monitor: Critical Stocks14TEXT3Processing note for a critical activitynvarchar400
112LL06Whse Activity Monitor: Critical Storage Bins14TEXT3Processing note for a critical activitynvarchar400
113LL07Whse Activity Monitor: Critical Production Orders14TEXT3Processing note for a critical activitynvarchar400
TOPWorkbench Tools Editors, Painters, Modelers
114COVMVDATTable for Storing Coverage Results from Coverage Analyzer31TEXT3For General Use of Names of Length < 30nvarchar300
115COVMVHISTable for Storing the History from Coverage Analyzer33TEXT3For General Use of Names of Length < 30nvarchar300