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  | SDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_A_1_TYPEType Pool Information Table(CMIS)29SDATEStandard selection screen generation: Datenvarchar80
2DFKKPDCFI-CA: Postdated Checks19SDATEDate for Status Changenvarchar80
3DFKKPDCSFI-CA: Status Changes for Postdated Checks8SDATEDate for Status Changenvarchar80
4EAM_REG_PLANRegular Task Planning Schedule4SDATEDatenvarchar80
5IUUC_SIZE_STATSSLT Sizing Statistics3SDATESystem Datenvarchar80
6NWS_EXT_PROTHData Transport Management Tool Log Header4SDATEDatenvarchar80
7NWS_EXT_PROTNMessage Log, R/3 Extractor4SDATEDatenvarchar80
8NWS_EXT_PROTRData Transport Management Tool Log Header3SDATEDatenvarchar80
9NWS_EXT_PROTSData Transport Management Tool Log Statistics4SDATEDatenvarchar80
10NWS_EXT_SVALUEData Transport Management Tool SELECT OPTIONS, Values3SDATEDatenvarchar80
11P08P1CLSCLASS CPX INTERFACE Snapshot Table3SDATECLASS CPX INTERFACE Control File Snapshot Datenvarchar80
12P08P1CNTCLASS Interface Control Table (OBSOLETE from 46C)2SDATECLASS CPX INTERFACE Control File Snapshot Datenvarchar80
13P2NZ_TAXPPayroll Result: Taxation TAXP - NZ21SDATES/L Special Rate End Datenvarchar80
14SCI_CALL_GRAPHCode Inspector: Call Graph3SDATEField of type DATSnvarchar80
15SCI_CALL_GRAPH_HCode Inspector: Call Graph5SDATEField of type DATSnvarchar80
16SCI_PROG_INFOInfo.5SDATEField of type DATSnvarchar80
17SCR_ABAP_ASTCL_ABAP_COMPILER: Analysis Structure5SDATEField of type DATSnvarchar80
18SCR_ABAP_SCANScan Results4SDATEField of type DATSnvarchar80
19SCR_ABAP_SYMBScan Results4SDATEField of type DATSnvarchar80
20SFTT_REG_TASKRegular Tasks List for Item Data4SDATEDatenvarchar80
21T5Q_SUPERSTREAMSuper Stream Master Table14SDATEDate of updation of Recordnvarchar80
22T7CNREW_APRDELPayroll renewal - Approval set delegation4SDATEStart Datenvarchar80
23VERI_PROG_DIRVerzeichnis für Anweisungs-Index2SDATEGenerierung Standardselektionsbild: Datumnvarchar80
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
24TCNVDATAAdditional Information about Conversion18SDATEDatenvarchar80
TOPArchiveLink
25TOACRAsynchronous ArchiveLink Requests16SDATESAP ArchiveLink: Storage datenvarchar80
TOPAustria
26PC03_SE16N_CD_KETable Display: Change Documents - Header5SDATEDatenvarchar80
TOPBasic Functions
27T243LSLogging Table for Distributed CM Data6SDATEDate: TR-CM subsystem for sending data requestednvarchar80
TOPBelgium
28T5BSDSI Declaration: directory table15SDATESelection date payroll results in SI declarationnvarchar80
TOPBudget Management
29HRPMPROTHR-FPM Log Table22SDATEDatenvarchar80
TOPBusiness Accounting
30URBWTSRealigner: Processed Time Intervals7SDATEStart Date: Datenvarchar80
TOPBusiness Consolidation
31UCL2040Log: Stored Logs6SDATEDatenvarchar80
32UCST001SEM-BCS: Performance Statistics4SDATESystem Datenvarchar80
TOPClientServer Technology
33REPOSRCReport Source Code27SDATEStandard selection screen generation: Datenvarchar80
TOPCompensation Management
34PA0382HR Master Data Record Infotype 0382 (Award)43SDATESale datenvarchar80
TOPControlling
35SE16N_CD_KEYTable Display: Change Documents - Header5SDATEStart Datenvarchar80
TOPCost Center Accounting
36T811CAllocations: Cycles4SDATEStart Datenvarchar80
37T811DAllocations: Document Numbers4SDATEStart Datenvarchar80
38T811DAAllocations: Dependent Document Numbers4SDATEStart Datenvarchar80
39T811DHAllocations: Header Fields4SDATEStart Datenvarchar80
40T811DSAllocations: Document Numbers for Segment Reverse/Rebook4SDATEStart Datenvarchar80
41T811EAllocations: Save Results List and Names4SDATEStart Datenvarchar80
42T811FAllocations: Element Table4SDATEStart Datenvarchar80
43T811GField Groups for Allocation Cycle4SDATEStart Datenvarchar80
44T811KAllocations: Key Fields4SDATEStart Datenvarchar80
45T811LAssessments/Distributions: Long Text5SDATEStart Datenvarchar80
46T811RAllocation table for receiver assignments4SDATEStart Datenvarchar80
47T811SAllocations: Segments4SDATEStart Datenvarchar80
48T811VRSSpecification of Version Change for Cycles4SDATEStart Datenvarchar80
49T811ZAllocations: Data for Runtime Analysis6SDATEStart Datenvarchar80
50T811ZCCycles for Runtime Analysis5SDATEStart Datenvarchar80
51T811ZTCycles for Runtime Analysis4SDATEStart Datenvarchar80
TOPCross-Application Components
52AAUUFKOrder master data49SDATEStart Datenvarchar80
TOPData Retention Tool
53TXX_ADMI_EXTRDART-Administration --- Extract_Data---10SDATEExtract Creation Date: Startnvarchar80
TOPeCATT Extended Computer Aided Test Tool
54ECATT_MCV_HEADeCATT - Mass Change of the Versioning - Log HEAD2SDATEStart Datenvarchar80
TOPExternal Services
55ESLLLines of Service Package77SDATEDatenvarchar80
TOPFinancial Accounting
56AVIPPayment Advice Line Item41SDATEEntry Field for Search Criteria (Date Fields)nvarchar80
TOPGeneral Application Functions
57BAM5RTIMERuntime analysis4SDATESystem Datenvarchar80
TOPGeneral Ledger Accounting
58FAGL_RMIGR_LOG1Report Migration: Log Status4SDATEReport Transfer: Execution Datenvarchar80
TOPGlobal Trade Services
59/SAPSLL/IVMCST01Indiv. Stock Item: Special Customs Procedures: Inward Proc.14SDATEDue Datenvarchar80
60/SAPSLL/IVMCST02Totals Stock: Special Customs Procedure: Inward Processing10SDATEDue Datenvarchar80
61/SAPSLL/IVMFST01Individual Stock Item Free Circulation for Prescribed EndUse10SDATEDue Datenvarchar80
62/SAPSLL/IVMPST01Processing Stock12SDATEDue Datenvarchar80
TOPGreat Britain
63PA0070HR Master Record: Infotype 0070 (Court Orders - GB)56SDATEStop Identification issued or received onnvarchar80
TOPI18N Unicode
64UM4PMIGWorklist for Scan Levels20SDATEnvarchar80
65UMGPMIGWorklist for Scan Levels20SDATEStart Datenvarchar80
TOPInterface to SAP record feedback
66BCOS_PROTCreate Messages: Log File2SDATESystem Datenvarchar80
TOPJoint Venture und Production Sharing Accounting
67JVPO1JVA: Plan Line Items133SDATEStart Datenvarchar80
68JVSO1JV LI Table with Objects for JVTO169SDATEStart Datenvarchar80
69T8J4ACash Call Header table5SDATEJV date of record savenvarchar100
70T8J4CBill Trans Fields Table (Deprecated -> replaced by T8J4G)5SDATEJV date of record savenvarchar100
71T8J4GNon-Op saved bills - Header Info (for holding bills)6SDATEJV date of record savenvarchar100
TOPLocal Currency Changeover
72EWUCLSTATEMU Cnv: Status Table for Conversion with Clusters17SDATEStart date of the programnvarchar80
TOPLocalization
73J_3RFTAX_CHAINDTax chain details6SDATEStart Datenvarchar80
TOPNew Zealand
74PA0313Employee Taxation Detail Infotype NZ35SDATES/L Special Rate End Datenvarchar80
TOPOverhead Cost Controlling
75PFALVPeriod-End Partner: Log (ALV Information)10SDATE(8-character) Date for SYSTnvarchar80
TOPOverhead Cost Orders
76AUFKOrder master data49SDATEStart Datenvarchar80
TOPPerformance Monitors TCC
77TRS35Control Table RSSTAT35 Collector Run2SDATEDate of statistics recordnvarchar80
TOPPortfolio Management
78RPM_USERDATAUser data6SDATESystem Datenvarchar80
TOPPrint Workbench
79EFRMGENTRDIRPrint Workbench: TRDIR Entry in Form Class Library in Gener.13SDATEStandard selection screen generation: Datenvarchar80
TOPProduction Orders
80AFSPRELRelation Between Orders in an Order Split10SDATECreated onnvarchar80
TOPProfile Maintenance
81TPFYPROPTYParameter attributes23SDATEData part last profile generationnvarchar80
TOPProfitability Analysis
82TKEBWLGNCO-PA Connectn to SAP BW: Status Information for InfoSource19SDATEStart Time: Datenvarchar80
83TKEBWTSCO-PA Connection to SAP BW: Processed Time Intervals8SDATEStart Time: Datenvarchar80
84TKEBWTSNCO-PA Connection to SAP BW: Processed Time Intervals10SDATEStart Time: Datenvarchar80
TOPRemaining Beverage - Obsolete Objects
85/BEV3/CHPROCESSNotifications at the end of a CH process5SDATECreation datenvarchar80
TOPReport Tree
86SREPOLISTReporting: Lists8SDATE(8-character) Date for SYSTnvarchar80
TOPReporting
87MCIPMISPMIS: Master data characteristics for PMIS before image18SDATEDatenvarchar80
TOPReuse Services for Country Development
88T5F99SESubdocument status table13SDATEStatus setting datenvarchar80
89T5F99SRDocument status table10SDATEStatus setting datenvarchar80
TOPSAP Business Workflow
90TOJTLObjects in the SAP System: object types with definition5SDATEDate savednvarchar80
TOPSchedule Manager
91SMMAINMain Information for an Entry in the Monitor5SDATEStart date of processingnvarchar80
TOPServices
92UASE16N_CD_KEYTable Display: Change Documents - Header5SDATESE16N: Start Datenvarchar80
TOPSimulation
93VSAUFK_CNVersion: Order master data50SDATEStart Datenvarchar80
TOPTime Sheet
94CATS_MY_PUSHCATS notebook: Synchronize Static Objects3SDATEDatenvarchar80
95PTRV_SYNCCustomizing Synchronization with Offline Device5SDATEComparison Date for Synchronization with Offline Toolnvarchar80
TOPTour Status
96/DSD/ST_STATUSCurrent tour status4SDATETour execution date (start)nvarchar80
TOPUSA
97PA0076HR Master Record: Infotype 0076 (Workers Compensation NA)26SDATEDatenvarchar80
TOPWeb Service and SOAP - ABAP
98UDDICL_SEARCHUDDI Client: Temporary Store for Search Results(OverviewURL)4SDATEDatenvarchar80
TOPWorkbench Tools Editors, Painters, Modelers
99DELWBCROSSFind Type Group Deletion2SDATEDatenvarchar80
100EUINFOLIRepository Infosystem: Save background lists5SDATEDatenvarchar80