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

34 columns | Print definition?ERP 6.0  | TXTNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T050TGeneral texts4TXTNRText Numbernvarchar40
2T512HAssignment of Text Elements to Forms6TXTNREight-digit numeric valuenvarchar80
3T5A5TPrint Position Texts for Sickness Certificates4TXTNRText Numbernvarchar40
4TCNRTTexts for RMCS0F00 (Project Information System)2TXTNRSerial numbernvarchar30
5ZPS11Project system: Text symbol assignment standard project5TXTNRInternal ABAP/4 text numbernvarchar80
6ZPS12Project system: Text symbol assign. Standard netw/Routing7TXTNRInternal ABAP/4 text numbernvarchar80
7ZPS12FProject system: Text symbol assign. Standard netw/Routing8TXTNRInternal ABAP/4 text numbernvarchar80
8ZPS13Proj.system: Text symbol assign. proced. std.netw./wrk ctr7TXTNRInternal ABAP/4 text numbernvarchar80
9ZPS14Project System: Text Symbol Assignment - Milestones6TXTNRInternal ABAP/4 text numbernvarchar80
10ZPS21Project system: Text symbol assignment standard project5TXTNRInternal ABAP/4 text numbernvarchar80
11ZPS22Project system: Text symbol assign. Standard network5TXTNRInternal ABAP/4 text numbernvarchar80
12ZPS22FProject system: Text symbol assign. Standard network seq.5TXTNRInternal ABAP/4 text numbernvarchar80
13ZPS23Project System: Text Symbol Assignment - Activities5TXTNRInternal ABAP/4 text numbernvarchar80
TOPAustria
14T5A5DPrint Positions for Sickness Certificates4TXTNRText Numbernvarchar40
TOPBasic Functions
15T857PValidation Rules6TXTNRStandard text numbernvarchar50
16T862SStandard reports: Column layout18TXTNRStandard text numbernvarchar50
17T879Standard texts4TXTNRStandard text numbernvarchar50
TOPCharacteristics
18CAWNCharacteristic values14TXTNRNumber of Related Textnvarchar40
TOPCompany Pension Scheme Germany
19T5DWTText Modules for Pension Calculation3TXTNRText Keynvarchar60
TOPConsolidation
20TF101FS Items: Short and Medium Texts5TXTNRText numbernvarchar80
TOPData Collection
21TMCELIS - Environment generation sample reports and references5TXTNRText number report textsnvarchar30
TOPFinancial Accounting
22AVITAdvice Header: User-Definable Text6TXTNRCopied record numbernvarchar30
23FERC_L1Message log9TXTNRMessage numbernvarchar30
TOPFunds Management
24BPTXBudgeting Text13TXTNRSequence Number for a Budget Textnvarchar40
TOPIncentive and Commission Management ICM
25CACS_BUFFLOGCommissions: Log Table of Commission Objects11TXTNRMessage numbernvarchar30
26CACS_EDTPROTCommissions: Log for EDT Interface Supply13TXTNRMessage numbernvarchar30
27TCACS_INCUSTContains the Number of Valid Runtime Errors5TXTNRMessage numbernvarchar30
TOPMaterial Master
28WSTN_AL_MSGPrepack allocation table posting messages8TXTNRMessage numbernvarchar30
TOPPatient Accounting
29NFAMIS-H: Messages for Case Selection - Billing9TXTNRMessage numbernvarchar30
TOPPayment Transactions
30CRFILESTATPayment Card File: Status Information for Individual Records28TXTNRMessage numbernvarchar30
TOPPersonnel Time Management
31HRAAERRError Table for Activity Allocation Documents in HR7TXTNRMessage numbernvarchar30
TOPProduction Orders
32COMPMSGMessages from checks for leveling steps9TXTNRMessage numbernvarchar30
TOPReporting
33TMCRTTexts for RMCS0F00 (LIS Standard Analyses)2TXTNRSerial numbernvarchar30
TOPTreasury
34SMESGTMessage collector with time stamp6TXTNRMessage numbernvarchar30