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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

82 columns | Print definition?ERP 6.0  | TRANS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLCE/CFG_SCENConfiguration Scenario3TRANSTransactionnvarchar10
2/SMERP/STG_PM004Data staging - Equipment list set - Measuring Points43TRANSMeasuring Point from Which Meas. Reading Was Transferrednvarchar120
3/SMERP/STG_PM009Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab43TRANSMeasuring Point from Which Meas. Reading Was Transferrednvarchar120
4P2B2_QTACCHCM Declustering B2 - Generating Absence Quotas13TRANSNumber of Employee Time Quotadecimal105
5P2RM_MGARGarnishments DK19TRANSOSI transfer (Denmark)nvarchar10
6P2RM_MPACPrior Pension Accumulations after PBS Splits15TRANSOSI transfer (Denmark)nvarchar10
7P2RM_MPENSPrivate Pension (DK)29TRANSOSI transfer (Denmark)nvarchar10
8PPHMRPLOGMRP Live Log Header8TRANSInclude Stock Transfer Materials in Planningnvarchar10
9T7RU_521BPayee Keys (Russia extension for T521B)9TRANSPBSI-Transfer (Russia)nvarchar10
TOPAsset Maintenance
10TAMLAYATabs in master data: Applications4TRANSCustomizing transaction of application for tab layout maint.nvarchar200
TOPAustralia
11T5QITCalculation rule for transfer frequency9TRANSTransfer Frequencynvarchar60
TOPBasic Functions
12T850Company data for Consolidation3TRANSData transfer to the FI-LC Systemnvarchar10
TOPBrazil
13PA0410Infotype 0410 - Transportation ticket24TRANSTransportation codenvarchar40
14T7BRTPTransportation ticket description3TRANSTransportation codenvarchar40
15T7BRTRTransportation ticket2TRANSTransportation codenvarchar40
TOPBulk Distribution Requirements Planning
16OIIRFCDESTRFC destination for IS-Oil BDRP remote function calls4TRANSRFC destination for transaction datanvarchar320
TOPBusiness Consolidation
17UCMA10CType of Assets/Liabilities4TRANSUsenvarchar10
TOPCapacity Leveling
18TOKOMTechnical Parameters for Communications Module7TRANSConfirmation transactionnvarchar40
TOPConsolidation
19TF165Consolidation Units Version-Dependent5TRANSData transfer methodnvarchar10
20TF90QActive Attributes in Consolidation9TRANSAttribute is multi-level (flag)nvarchar10
21TF90QSAttributes Basis Field Catalog Consolidation (Fixed Fields)9TRANSAttribute is multi-level (flag)nvarchar10
22TF91QAttributes in Consolidation9TRANSAttribute is multi-level (flag)nvarchar10
TOPContract Accounts Receivable and Payable
23TFK053CChange Payment Data: Processing Variants4TRANSChange Payment Data: Transfer Modenvarchar10
TOPData Collection
24TKAQGeneral accounting attributes10TRANSAttribute is multi-level (flag)nvarchar10
25TKCQAttributes SAP-EIS9TRANSAttribute is multi-level (flag)nvarchar10
26TKCQSAttributes of basic field catalog SAP-EIS (fixed fields)9TRANSAttribute is multi-level (flag)nvarchar10
TOPDenmark
27PA0073HR Master Record: Infotype 0073 (Private Pensions - DK)72TRANSOSI transfer (Denmark)nvarchar10
28PA0200HR Master Record, Infotype 0200 (Garnishments DK)51TRANSOSI transfer (Denmark)nvarchar10
TOPDepreciation Simulation
29IMCKFIM Summarization: Key figures13TRANSBusiness Transactionnvarchar40
TOPDocument Management Framework
30SKWS_ACTNStatus Management: Actions3TRANSStatus Management: ID of Status Transfernvarchar320
31SKWS_EVENTStatus Management: Events2TRANSStatus Management: ID of Status Transfernvarchar320
32SKWS_EVTTStatus Management: Events (Texts)3TRANSStatus Management: ID of Status Transfernvarchar320
33SKWS_GUARDStatus Management: Conditions for Status Transfers2TRANSStatus Management: ID of Status Transfernvarchar320
34SKWS_TRANSStatus Management: Status Transfers2TRANSStatus Management: ID of Status Transfernvarchar320
35SKWS_TRNSTStatus Management: Status Transfers (Texts)3TRANSStatus Management: ID of Status Transfernvarchar320
TOPExternal personnel administration
36HRWFD_DATAHCM - WFD Data interface table7TRANSTransfer indicator HCM - WFD interfacenvarchar10
TOPFlexible Real Estate Management
37TIVCASTATUSOBJAllowed Status Activity for Display per Object Type2TRANSBusiness Transactionnvarchar40
38TIVCASTATUSOBJTAlternative Text for Activity3TRANSBusiness Transactionnvarchar40
TOPFrance
39T5FPD28Public Revenue Office position8TRANSTransport payment reimbursementnvarchar10
TOPGrantee Management
40GMIOObject table GMIO14TRANSBusiness Transactionnvarchar40
TOPHong Kong
41PA0347HR Master Record: Infotype 0347 (Entitlement plan)46TRANSIndicator of entitlement settlednvarchar10
TOPI18N Unicode
42UMGSETTINGUnicode conversion Tool: Settings (obsolete)15TRANSR3trans codepage mappingnvarchar10
TOPLocalization
43VIXCFRSRULOGLog of SRU Postings13TRANSTransaction IDnvarchar30
TOPMaster Data
44GMREPORTGM Report Tracking9TRANSTransaction in GM reporting trackingnvarchar200
45T444BSettings for Flexible Transaction Calls19TRANSApplication component for transactionnvarchar10
46T444CSettings for Flexible Transaction Calls for each MRP Element16TRANSApplication component for transactionnvarchar10
47U444BUser Settings for Flexible Transaction Calls22TRANSApplication component for transactionnvarchar10
48U444CUser Settings For Flexible Transaction Calls Per MRP Element19TRANSApplication component for transactionnvarchar10
TOPMaterial Master
49WGDS_CONF_MSGData pool item confirmation message7TRANSMessage transaction IDnvarchar30
TOPMeasuring Points and Counters
50IMPHMeasurement and Counter Reading Transmission History11TRANSMeasuring Point from Which Meas. Reading Was Transferrednvarchar120
51IMPTTMeasuring Point (Table)37TRANSMeasuring Point from Which Meas. Reading Was Transferrednvarchar120
TOPPatient Transport Service
52N1CTRIS-H*MED: Transport Order Data in Order Items15TRANSMeans of Transportnvarchar30
53N1FATIS-H*MED: Transport Orders37TRANSMeans of Transportnvarchar30
54N1TRANSi.s.h.med: Transport Medium3TRANSMeans of Transportnvarchar30
55N1TRANSTi.s.h.med: Means of Transport Texts4TRANSMeans of Transportnvarchar30
56N1TRANSTAi.s.h.med: Means of Transport - Transport Types Assignment3TRANSMeans of Transportnvarchar30
TOPPayroll
57T7SIBUBank Units Slovenia15TRANSTransfernvarchar10
58T7SIBUXConversion to TRR 20034TRANSTransfernvarchar10
59T7UA_521BPayee Keys (Ukranian extension for table T521B)7TRANSPayment Informationnvarchar10
TOPPerformance Assessment Workbench
60SLS_PAWMENPAW - Menu entries3TRANSPAW - Transaction Namenvarchar40
TOPPersonnel Administration
61T521BPayee Keys19TRANSOSI transfer (Denmark)nvarchar10
62T7SIF0Konfiguration food and transport4TRANSType acountingnvarchar10
TOPPortioning and scheduling
63TE421Control Parameters for Scheduling2TRANSDeactivate automatic transportnvarchar10
TOPPublic Sector
64T5QPBS2GAccrual Transfer Frequency Rules6TRANSTransfer frequencynvarchar20
65T7PBSWB1CAssignment of transaction code to Business & Obj scenario7TRANSTransaction Codenvarchar200
TOPPublic Sector Contract Accounts Receivable and Payable
66DFMCA_BRF790BRF: Trigger Transaction for Status Change7TRANSBusiness Transactionnvarchar40
TOPRussia
67T7RU1BPayee Keys of receiving orders (Russia standard)23TRANSPBSI-Transfer (Russia)nvarchar10
TOPSales and Distribution SD enhancements
68MILL_VS_FIELDSVersion Management: Fields4TRANSTransfer field contentnvarchar10
TOPSecurity
69SEC_TEST_MAPTable with Test Data3TRANSnvarchar1280
TOPShipping
70KNVSCustomer Master Shipping Data4TRANSTransit route (sequence of the countries for transportation)nvarchar30
TOPSmart Forms
71STXSCHARSmart Styles: Character Formats26TRANSSmart Forms: Color valuenvarchar30
72STXSHEADSmart Styles: Style Header23TRANSSmart Forms: Color valuenvarchar30
73STXSPARASmart Styles: Paragraph Formats49TRANSSmart Forms: Color valuenvarchar30
TOPSpain
74T5E60Contract entity according to the company13TRANSContracts: Transformation methodnvarchar40
TOPSyntax, Compiler, Runtime
75AAB_TRANS_LINKAAB: Assignment of Activation IDs to Components1TRANSTransaction Codenvarchar200
TOPTransaction Manager
76THMHRT_HI_MEASFair value change of the hedge comp. in an effective hedge15TRANSChange in fair value of the hedged item has been transferredtinyint30
TOPTransportation
77T644Routes: Transit Route(s) (Country Sequence)2TRANSTransit route (sequence of the countries for transportation)nvarchar30
TOPUI Services, Screen, Batch Input
78APQDDATA DEFINITION Queue2TRANSTransaction counter: Batch input, statisticsint100
TOPWaste Management
79EHSWAC_EAOPTYPEApplication Functions4TRANSTransaction Code or Reportnvarchar200
80TEWA_EL_OBJTRAObject Transaction Configuration (CL_EEWA_TRANSACTION)1TRANSObject Transaction Namenvarchar200
81TEWA_EL_OBJTRAMObject Transaction Configuration (Overriding Clients)2TRANSObject Transaction Namenvarchar200
82TEWA_EL_OBJTRATObject Transaction - Texts1TRANSObject Transaction Namenvarchar200