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

100 columns | Print definition?ERP 6.0  | SPLIT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P05T_IRS_CWTIncome Relationship Split Types CWT Split6SPLITHandling of Income Relationship Split in Wage Returnnvarchar10
2T5A4AGeneral Absence Data18SPLITNo Change During Absencenvarchar10
3T5GPBSP_PSCHLocal Government Pension Schemes7SPLITLGPS SPLIT (Split Records)nvarchar10
4TIVXCITCADCPYCadastral Data to Transfer4SPLITSplitting Processnvarchar10
5TIVXCITCADFLDDatabase fields to transfer5SPLITSplitting Processnvarchar10
6TIVXCITCADMSRDefine the editable measurements4SPLITSplitting Processnvarchar10
7ZCATSDBRecords changed with processing status '10'33SPLITtinyint30
8ZCATSDB2Records changed with processing status '10'34SPLITtinyint30
TOPAustralia
9PA0626158SPLITnvarchar10
10PA0701HR Terminations Data Container : Infotype 0701196SPLITTest Run (no update)nvarchar10
11PA0850Infotype for Eligible Termination Payment65SPLITPayment Summary for Split ETPnvarchar10
TOPBank Customer Accounts
12TBKKIHB5Payt Method Determination HQ FI for Payment In-House Bank16SPLITSplittingnvarchar10
TOPBasic Functions
13FDSB2CMF Totals Records for G/L Accounts (As of Release 604)15SPLITSplit Criterion in Cash Managementnvarchar10
14FDSPCash Mgmt Adjustment Items from Document Splitting23SPLITSplit Criterion in Cash Managementnvarchar10
15FDSR2CMF Totals Records for Planning Groups (As of Release 604)15SPLITSplit Criterion in Cash Managementnvarchar10
TOPBudgeting
16FMBWUSBudgeting Workbench User settings6SPLITSplit flag for transfer in two screensnvarchar10
TOPCapacity Leveling
17ISTBEDActual requirements records16SPLITSplit numbertinyint30
TOPCase Management
18SCMGCOPYCASECustomizing for Case Copy6SPLITParameters for Splitting Casesnvarchar10
TOPConfirmations
19AFRDDefault values for collective confirmation87SPLITSplit numbertinyint30
20AFRP0Table of planned changes for confirmation (PDC)17SPLITSplit numbertinyint30
21AFRUOrder Confirmations102SPLITSplit numbertinyint30
22AFRVConfirmation pool71SPLITSplit numbertinyint30
23AFRV_DELBackup Copy for Confirmation Pool71SPLITSplit numbertinyint30
TOPCross-Application Components
24/IXOS/DC_TACAAdministrator maintenance for Editing15SPLITCheckbox for splitting the display in the edit screennvarchar10
25ALM_ME_SYNC_ARCHMAM 1.0 Obsolete9SPLITtinyint30
TOPData Conversion
26DMC_FIELDDMC: Data Field of a Structure10SPLITDMC: Feature if field is relevant for split or notnvarchar10
TOPData Transfer
27T52E2Posting to Accounting: Posting Variants7SPLITSplit for posting documents (document split)nvarchar10
TOPDenmark
28PA0314I0314: Days for Vacation Bonus and Sal. Deducs (DK/N)30SPLITPayment distribution over several payroll periods (DK/N)nvarchar10
29T5M9HSplit Indicators for Wage Types Sent to PBS8SPLITSplit indicator for PBSnvarchar60
TOPESS Based on WD ABAP
30HRESS_D_CATS_FAVCATS Favorites: database table40SPLITSplit numbertinyint30
TOPExchanges
31OIA01Exchange header (IS-Oil EXG standard/core object)14SPLITHow to split quantity in quantity schedulenvarchar10
32OIA05HQuantity schedule header table - sales side18SPLITHow to split quantity in quantity schedulenvarchar10
33OIA06HQuantity schedule header table - purchasing side19SPLITHow to split quantity in quantity schedulenvarchar10
34TOIA2Exchange types11SPLITHow to split quantity in quantity schedulenvarchar10
TOPExternal Services
35T260HText Module Description6SPLITIndicator: Whether splitting allowednvarchar10
TOPGL Account Posting
36TCJ_DOCUMENTSCash Journal Documents (Header Data)35SPLITSplit Information for Cash Journal Documentnvarchar10
TOPItaly
37PA3206HR Master Record: Infotype 320627SPLITDMA Split Number (Hex)varbinary10
TOPJust-In-Time Processing
38CJIT13SumJC: JIT Customer Dependent Profile Settings3SPLITQuantity Change Within Summarized JIT Callsnvarchar10
TOPLoans Management
39TTONFTVDARLTest neue Fima: Grunddaten und VDARL107SPLITSplitting von Sollstellungennvarchar10
40VDARLLoans93SPLITDebit position splittingnvarchar10
TOPMaintenance Processing
41ALM_ME_SYNCSync Status9SPLITSplit numbertinyint30
TOPMedia Product Sales and Distribution
42JKSDCONTRACTMIXIS-M: Mix for Contract - Lower Level Issues6SPLITIS-M: Media Issue Mixnvarchar60
43JKSDISSUEGROUPInsert Planning: Assigned Mixes for Insert Group4SPLITIS-M: Media Issue Mixnvarchar60
44JKSDORDERADDMIXIS-M: Mix for Contract5SPLITIS-M: Media Issue Mixnvarchar60
45JKSDORDERADMIXPLIS-M: Mix for Contract (Planned)5SPLITIS-M: Media Issue Mixnvarchar60
46JKSDORDERBOOKIS-M: Planned Purchase Quantities10SPLITIS-M: Media Issue Mixnvarchar60
47JKSDPORDERFLOWIS-M: Assignment of Purchase Order Book to Purchase Order11SPLITIS-M: Media Issue Mixnvarchar60
48JVSDBLGZUSIS-M: Insert Combination for Carrying Media Issue3SPLITIS-M: Media Issue Mixnvarchar60
49JVSDBLGZUSPLANIS-M: Insert Combination for Media Issue (Planned)3SPLITIS-M: Media Issue Mixnvarchar60
50JVSDPACKRULEIS-M/SD: Packaging Rules for Media Issues4SPLITIS-M: Media Issue Mixnvarchar60
51JVSDSHIPPRIOISSIS-M/SD: Del. Priority for Each Contract Item & Media Issue5SPLITIS-M/SD: Split for Delivery Prioritiestinyint30
52JVSDSHIPPRIOPRODIS-M/SD: Del.Priority for Each Contract Item & Media Product5SPLITIS-M/SD: Split for Delivery Prioritiestinyint30
53JVSDSPLITIS-M: Media Issue Mix3SPLITIS-M: Media Issue Mixnvarchar60
54JVSDSPLITPLANIS-M: Issue Split (Planned)3SPLITIS-M: Media Issue Mixnvarchar60
55JVSDSPLITSUBIS-M: Issue Split for Lower Level Issues4SPLITIS-M: Media Issue Mixnvarchar60
TOPMigration
56TEMJOBIS-U Migration: Definition of Import Job24SPLITMigration: File Was Splitnvarchar10
TOPPatient Accounting
57NVBRPIS-H: Billing document item data80SPLITCombination Criteria Billing Itemsnvarchar30
TOPPayroll
58T5H4PGenerate new wage types on the basis of ones with SI split3SPLITHR-H SI auxiliary split typenvarchar10
TOPPayroll General Parts
59T515SRelationships between Tables in Payroll Results5SPLITField Namenvarchar300
60T515TSplits in Payroll Results1SPLITField Namenvarchar300
61T515UHierarchy of Tables in Payroll Results2SPLITField Namenvarchar300
62T515VElement Tables in Payroll Results Tables2SPLITField Namenvarchar300
TOPPeriodical Sales and Distribution
63JDTVASPLITIS-M/SD: Issue Split6SPLITIS-M: Issue mixnvarchar60
64JRTABLGIS-M: Drop-Off23SPLITIS-M: Issue mixnvarchar60
65JVTLFNGIS-M/SD: Delivery/Home Delivery25SPLITIS-M: Issue mixnvarchar60
66JVTPRODIS-M/SD: Production Units13SPLITIS-M: Issue mixnvarchar60
67MJD5AIS-M: Selection Method JDTVASPLIT6SPLITIS-M: Issue mixnvarchar60
TOPPersonnel Administration
68PA0226Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.)79SPLITPfandungen Ungarn - Variable splitnvarchar20
69PA0308Infotyp 0308 (H)29SPLITPfandungen Ungarn - Variable splitnvarchar20
TOPPersonnel Time Events
70TPTCOR_LOGISTICLogistics Orders (Correction Scenario)25SPLITSplit numbertinyint30
TOPPersonnel Time Management
71CC1ERPIncorrect Time Events from CC1, Postings39SPLITSplit numbertinyint30
72TEVENTime Events29SPLITDummy for B20 int1 (Local Everywhere)tinyint30
73TEVEN_MOREAdditional Data for Time Events38SPLITSplit numbertinyint30
TOPPlant Data Collection
74RUECKTemp. storage for subsystem confirmations66SPLITSplit numbertinyint30
TOPProfitability Analysis
75TKETRAPROFCO-PA: Transport Settings per Operating Concern4SPLITSplit Objects into Workbench and Customizing Requestsnvarchar10
TOPPublic Sector
76PA0573Master leave code for Public Sector Australia33SPLITSplit across financial year check boxnvarchar10
TOPRecipe Development
77/PLMB/GSS_R2B_CUR2B customizing7SPLITAllow Splitting of Recipes with Streamnvarchar10
TOPRecycling Administration Core Functions
78J_7LC191REA Data Filters: Splitting for Sales Transactions13SPLITSplitting Quota in Percentdecimal74
79J_7LC192REA Data Filters: Splitting for Purchasing Transactions11SPLITSplitting Quota in Percentdecimal74
80J_7LC23REA Customizing: Assignments for Automatic Article Managemnt8SPLITSplitting Quota in Percentdecimal74
81J_7LM05REA Article Master: Recycling Partner Assignment11SPLITSplitting Quota in Percentdecimal74
82J_7LM10REA Article Master: Filters for Regional Processing16SPLITSplitting Quota in Percentdecimal74
83J_7LV03REA Packaging Master Data: Recycling Partner Assignment10SPLITSplitting Quota in Percentdecimal74
84J_7LV1PREA Document: Item Data44SPLITSplitting Quota in Percentdecimal74
TOPScheduling
85KBEDCapacity Requirements Records52SPLITSplit numbertinyint30
TOPService Station Retailing
86OIRECCTYPSSR PC: Company code / credit card types8SPLITSSR PC: Splitting indicatornvarchar20
87OIRESPCRSSR PC: Splitting criteria2SPLITSSR PC: Splitting indicatornvarchar20
88OIRESPLITSSR PC: Splitting Indicator2SPLITSSR PC: Splitting indicatornvarchar20
89OIRESPLITSSSR PC: Splitting routine assignment to splitting indicato2SPLITSSR PC: Splitting indicatornvarchar20
90OIRESPLITTSSR PC: Splitting Indicator text3SPLITSSR PC: Splitting indicatornvarchar20
TOPSimulation
91VSKBED_CNVersion: Capacity requirement records53SPLITSplit numbertinyint30
TOPTime Sheet
92CATSDBCATS: Database Table for Time Sheet33SPLITSplit numbertinyint30
93CATSPMCross-Application Time Sheet (CATS): Transfer to PM/CS10SPLITSplit numbertinyint30
94CATSPSCross-Application Time Sheet (CATS): Transfer to PS10SPLITSplit numbertinyint30
95CATS_TEMPCATS: Database Table for Templates35SPLITSplit numbertinyint30
TOPTime Tickets
96EVHRHR Order Confirmations (Times/Time Events)38SPLITSplit numbertinyint30
97LSHRHR Order Confirmations (Durations/Time Tickets)38SPLITSplit numbertinyint30
TOPTravel Expenses
98T706STrip Schema11SPLITDefault value: several destinationsnvarchar10
TOPUnited Kingdom
99T56E4HR: Exception Reporting-Subrule details16SPLITHR-XX: Split Flagnvarchar10
TOPWarranty Claim Processing
100PVWTYWarranty Claim Item (PPE Variant)26SPLITGrouping Number for Version Splitnvarchar40