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

119 columns | Print definition?ERP 6.0  | MOREI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTTM/BL_T_ARUAutomation and Assignment2MOREITrip Provision Variantnvarchar20
2/OTTM/BL_T_DMCCustomizing table for default mappings of e-receipt types2MOREITrip Provision Variantnvarchar20
3/OTTM/BL_T_EDCCustomizing table for mapping of expense and doc types2MOREITrip Provision Variantnvarchar20
4/OTTM/BL_T_ENCCustomizing table for e-mail notification content2MOREITrip Provision Variantnvarchar20
5/OTTM/BL_T_ENICCustomizing table for email notification input channels2MOREITrip Provision Variantnvarchar20
6/OTTM/BL_T_MACMapping of Classification to Expense Types2MOREITrip Provision Variantnvarchar20
7/OTTM/BL_T_PRECustomizing table for e-receipt preview2MOREITrip Provision Variantnvarchar20
8/OTTM/OCR_T_OCICInput Channels for OCR2MOREITrip Provision Variantnvarchar20
9PAOC_CLAIM_CATObsolete: Travel Expense FIORI Claim Categories2MOREITrip Provision Variantnvarchar20
10PAOC_CLM_CATMap Text Fields for Travel and Expenses2MOREITrip Provision Variantnvarchar20
11T5GPBS41Vehicle classes for car mileage2MOREITrip Provision Variantnvarchar20
12T5GPBS42Declare vehicle types for private and business miles2MOREITrip Provision Variantnvarchar20
13T5GPBS43Lump sum payment for car mileage2MOREITrip Provision Variantnvarchar20
14T5GPBS_VEHCLASSDerive vehicle class from car manufacturer and model4MOREITrip Provision Variantnvarchar20
15T5GPBS_VEHTYPEDerive vehicle types from car information4MOREITrip Provision Variantnvarchar20
16T706_CITYCD_CHGReplacement/Combination of Community Code Numbers, Date-Dep.2MOREITrip Provision Variantnvarchar20
TOPLocalization
17GLO_PTRV_COSTCLCost Classification2MOREITrip Provision Variantnvarchar20
18GLO_PTRV_COSTCLTCost Classification (Text)3MOREITrip Provision Variantnvarchar20
19PTRV_FUEL_TYPTXTNames of Types of Fuel3MOREITrip Provision Variantnvarchar20
20PTRV_FUEL_TYP_PRTable for Fuel Type and Prices2MOREITrip Provision Variantnvarchar20
TOPTravel Expenses
21PTRV_ARCH_HEADPrearchiving FI-TV: Entries from PTRV_HEAD (Temporary)6MOREITrip Provision Variantnvarchar20
22PTRV_HEADGeneral Trip Data6MOREITrip Provision Variantnvarchar20
23PTRV_TRIPCHN_46CTable of all Trip Destinations f. Processing Recurring Dest.9MOREITrip Provision Variantnvarchar20
24PTRV_TRIP_CHAINTable of all Trip Destinations f. Processing Recurring Dest.9MOREITrip Provision Variantnvarchar20
25T702AEmployee Grouping for Travel Expense Type2MOREITrip Provision Variantnvarchar20
26T702BCredit Card Clearing Assignment Table2MOREITrip Provision Variantnvarchar20
27T702CName for Employee Grouping for Travel Expense Type3MOREITrip Provision Variantnvarchar20
28T702EVehicle Types2MOREITrip Provision Variantnvarchar20
29T702GStatutory trip types2MOREITrip Provision Variantnvarchar20
30T702HCaculation Guide Lines: Meals PD/Max.Amounts Scaled by Time2MOREITrip Provision Variantnvarchar20
31T702IStatutory Reimbursement Groups for Meals/Accommodations2MOREITrip Provision Variantnvarchar20
32T702JEnterprise-spec.Reimbursement Groups for Meals/Accomm.2MOREITrip Provision Variantnvarchar20
33T702KService provider2MOREITrip Provision Variantnvarchar20
34T702LName of Service Provider3MOREITrip Provision Variantnvarchar20
35T702NTrip Provision Variants2MOREITrip Provision Variantnvarchar20
36T702OTrip country/Trip region/Trip country group2MOREITrip Provision Variantnvarchar20
37T702PReimbursement Groups for Travel Costs/Add.Flat Rate Types2MOREITrip Provision Variantnvarchar20
38T702QName: Reimburs.Group for Travel Costs/Add.Flat Rate Types3MOREITrip Provision Variantnvarchar20
39T702RTrip Activity Types2MOREITrip Provision Variantnvarchar20
40T702VCalc.Guide Lines for Scaling Meals PD/Max.Amounts by Hours2MOREITrip Provision Variantnvarchar20
41T702WVehicle Classes2MOREITrip Provision Variantnvarchar20
42T702XEnterprise-specific Trip Types2MOREITrip Provision Variantnvarchar20
43T702YEmployee Groupings for Travel Management2MOREITrip Provision Variantnvarchar20
44T702_BEREI_RELAssignment of Trip Types Enterprise-Specific (PS AT)2MOREITrip Provision Variantnvarchar20
45T706ATrip Provision Deduction Amount/Percentage2MOREITrip Provision Variantnvarchar20
46T706BTravel Expense Types2MOREITrip Provision Variantnvarchar20
47T706B1Travel Expense Types2MOREITrip Provision Variantnvarchar20
48T706B2Travel Expense Types: Default Value/Maximum Amounts2MOREITrip Provision Variantnvarchar20
49T706B3Travel Expense Type Grouping2MOREITrip Provision Variantnvarchar20
50T706B4Travel Expense Types: Assignment of Wage Types2MOREITrip Provision Variantnvarchar20
51T706B4_ALTERNTravel Expense Type: Alternative Assignment of Wage Types2MOREITrip Provision Variantnvarchar20
52T706B5Names for Travel Expense Types3MOREITrip Provision Variantnvarchar20
53T706B6Default Values When Difference Values Are Exceeded2MOREITrip Provision Variantnvarchar20
54T706B6_TDefault Values When Difference Values Are Exceeded3MOREITrip Provision Variantnvarchar20
55T706CNames for Travel Expense Types3MOREITrip Provision Variantnvarchar20
56T706DDefault Values for Dialog2MOREITrip Provision Variantnvarchar20
57T706ENames for vehicle types3MOREITrip Provision Variantnvarchar20
58T706ESS2Travel Expenses Customizing for ESS Scenario2MOREITrip Provision Variantnvarchar20
59T706FTrip Provision: Flat Rates for Travel Costs2MOREITrip Provision Variantnvarchar20
60T706F1Cumulation Procedure Dependent on Vehicle Type/Class2MOREITrip Provision Variantnvarchar20
61T706F2Amount Accumulation Depending on Vehicle Type/Class2MOREITrip Provision Variantnvarchar20
62T706FORM_BCKGRNDForm background2MOREITrip Provision Variantnvarchar20
63T706FORM_BLKATTRForm block attributes2MOREITrip Provision Variantnvarchar20
64T706FORM_BLKHDLSForm block titles3MOREITrip Provision Variantnvarchar20
65T706FORM_BLK_HDLForm block titles2MOREITrip Provision Variantnvarchar20
66T706FORM_CLMATTRSuppressable columns per block2MOREITrip Provision Variantnvarchar20
67T706FORM_FIXTXTFixed texts2MOREITrip Provision Variantnvarchar20
68T706FORM_FIXTXTSFixed texts (language-dependent)3MOREITrip Provision Variantnvarchar20
69T706FORM_FLDSInformation in fixed positions2MOREITrip Provision Variantnvarchar20
70T706FORM_VARForm variant2MOREITrip Provision Variantnvarchar20
71T706FORM_VAR_TXTForm variant (language-dependent)3MOREITrip Provision Variantnvarchar20
72T706GNames for statutory trip types3MOREITrip Provision Variantnvarchar20
73T706HTrip Provision:Per-diem/Maximum Amount for Meals by Time2MOREITrip Provision Variantnvarchar20
74T706IName for statutory reimbursement group for meals/accomm.3MOREITrip Provision Variantnvarchar20
75T706JName for enterprise-specific reimburs.group for meals/acc.3MOREITrip Provision Variantnvarchar20
76T706KInitial Account Assignment for FI2MOREITrip Provision Variantnvarchar20
77T706LAssignment of Trip Country - Country Group - Region2MOREITrip Provision Variantnvarchar20
78T706MInput Tax for International Per Diems2MOREITrip Provision Variantnvarchar20
79T706NNames for trip provision variants3MOREITrip Provision Variantnvarchar20
80T706ONames for Trip Country/Trip Country Group/Trip Region3MOREITrip Provision Variantnvarchar20
81T706PDate Interval for Miles/Kms Accumulation2MOREITrip Provision Variantnvarchar20
82T706QNames for period indicator for miles/kms accumulation3MOREITrip Provision Variantnvarchar20
83T706RNames for trip activity types3MOREITrip Provision Variantnvarchar20
84T706STrip Schema2MOREITrip Provision Variantnvarchar20
85T706S_RECEIPTTrip Schemas: Assignment of Travel Expense Types2MOREITrip Provision Variantnvarchar20
86T706TNames for trip schema3MOREITrip Provision Variantnvarchar20
87T706T_ABWHTexts for Absence Types (PS Separation Allowance)3MOREITrip Provision Variantnvarchar20
88T706UTrip Provision: Per Diem for Accommodations2MOREITrip Provision Variantnvarchar20
89T706VTrip Provision: Meals Per-diem/Maximum Amount by Hours2MOREITrip Provision Variantnvarchar20
90T706WNames for vehicle classes3MOREITrip Provision Variantnvarchar20
91T706WWWHTML Links and File Paths2MOREITrip Provision Variantnvarchar20
92T706WWW_TXTText Table HTML Links and File Paths3MOREITrip Provision Variantnvarchar20
93T706XNames for enterprise-specific trip types3MOREITrip Provision Variantnvarchar20
94T706YNames for Employee Groupings for Travel Management3MOREITrip Provision Variantnvarchar20
95T706ZSingle Field Control for Dialog2MOREITrip Provision Variantnvarchar20
96T706Z1Single Field Control for Dialog2MOREITrip Provision Variantnvarchar20
97T706Z1_TXTText table: Individual Field Control for Dialog3MOREITrip Provision Variantnvarchar20
98T706_ABWHAbsence Types from Place of Work (PS; Separation Allowance)2MOREITrip Provision Variantnvarchar20
99T706_CITY_CD_46CTable for Specifying the City Code/Community Code Number2MOREITrip Provision Variantnvarchar20
100T706_CITY_CD_DDefinition: City Codes / Community Code No., Date-Dependent2MOREITrip Provision Variantnvarchar20
101T706_CITY_CD_D_2Definition: City Codes / Community Code No., Date-Dependent2MOREITrip Provision Variantnvarchar20
102T706_CITY_CODETable for Specifying the City Code/Community Code Number2MOREITrip Provision Variantnvarchar20
103T706_CONSTPA parameters: Travel Management2MOREITrip Provision Variantnvarchar20
104T706_CONSTTEXTNames of Accounting Constants for Travel Expenses3MOREITrip Provision Variantnvarchar20
105T706_COST_CPCost Comparison on Trip Level: Maximum Difference2MOREITrip Provision Variantnvarchar20
106T706_COST_CP_RCost Comparison at Trip Level: Default Values2MOREITrip Provision Variantnvarchar20
107T706_COST_CP_R_TCost Comparison at Trip Level: Default Values3MOREITrip Provision Variantnvarchar20
108T706_DEFAULTTEXTNames of Reference Texts for Entering Trips2MOREITrip Provision Variantnvarchar20
109T706_LGARTWage Type Assignmt Table for Clearing Add.Amts/Inc.Rel Exp.2MOREITrip Provision Variantnvarchar20
110T706_REQ_CATTypes of Transport/Accomm. and Est.Cost of Travel Request2MOREITrip Provision Variantnvarchar20
111T706_REQ_CATTEXTName for Types of Transp/Accomm. and Est.Cost of Travel Req.3MOREITrip Provision Variantnvarchar20
112T706_TEXTNAMESNames of Reference Texts for Entering Trips2MOREITrip Provision Variantnvarchar20
113T706_VAT_DEFLTCountry- and Expense Type-Dependent Defaults f. Receipt Data2MOREITrip Provision Variantnvarchar20
114T706_VAT_FLDSCountry-Dependent Field Control for Receipt Data2MOREITrip Provision Variantnvarchar20
115T706_VAT_POSTINGData Entry and Posting of VAT Amount per Country of Receipt2MOREITrip Provision Variantnvarchar20
TOPTravel Management
116T706_WEB_DOCUDocumentation for a Web Application2MOREITrip Provision Variantnvarchar20
117T706_WEB_DOCUTXTDocumentation for a Web Application3MOREITrip Provision Variantnvarchar20
TOPTravel Planning
118TA22AAssignment table expense code - service category2MOREITrip Provision Variantnvarchar20
119TA22BAssignment trip schema - travel plan type2MOREITrip Provision Variantnvarchar20