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

103 columns | Print definition?ERP 6.0  | CREATETIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/FHEADFile header data9CREATETIMETimenvarchar60
2/AIF/LFA_DATAFile data for Lean File Adapter8CREATETIMETimenvarchar60
3/ATL/FORECLOSUREForeclosures25CREATETIMESystem Timenvarchar60
4/PERSONAS/FLAVORPersonas Flavor Header Data11CREATETIMETime of Creationnvarchar60
5/PERSONAS/FLVVERPersonas : Flavor Version Header data7CREATETIMETime of Creationnvarchar60
6/PERSONAS/ICONSPersonas : Icons Header10CREATETIMETime of Creationnvarchar60
7/PERSONAS/MIGRSLInformation about Personas 2.0 Silverlight flavors.9CREATETIMETime of Creationnvarchar60
8/PERSONAS/RESOURPersonas : Resource (Image, Media Files etc.) Header13CREATETIMETime of Creationnvarchar60
9/PERSONAS/ROLESPersonas : Role Ranks6CREATETIMETime of Creationnvarchar60
10/PERSONAS/THEMEPersonas : Themes10CREATETIMETime of Creationnvarchar60
11BBP_SUS_NEWSSRM-SUS: News Management by Purchaser4CREATETIMETime for newsnvarchar60
12CNVA_00555_HDRHeader table for Run Time Estimation package7CREATETIMETime of Creation of the Runtime Estimation IDnvarchar60
13CNVA_00555_RUNIDHeader Information of Run Time Estimation Id10CREATETIMETime of Creation of the Runtime Estimation IDnvarchar60
14CNVA_CCD_ANA_HDRHeader table for CC Deletion Analysis Package7CREATETIMETimenvarchar60
15CNVA_CCD_ANA_SHDHeader table for CC Deletion Analysis Package in SolMan10CREATETIMETimenvarchar60
16CNVA_PCREA_RUNIDHeader Information of Profit Center Reorganization9CREATETIMESystem Timenvarchar60
17DMC_CU_RUN_HDRHeader record of a Content Upgrade Run6CREATETIMESystem Timenvarchar60
18DMC_DEVL_CSTEPSSP: Status table of ConvObj Work Steps (Development Env.)7CREATETIMESystem Timenvarchar60
19DMC_PC_COBJSTEPSSP: Status table of ConvObj Work Steps (Processing Cockpit)7CREATETIMESystem Timenvarchar60
20DMC_PC_PROJSTEPSSP: Status table of Project Work Steps (Processing Cockpit)9CREATETIMESystem Timenvarchar60
21ICFSRV4ADMINICF Services, which only have to be used for administration6CREATETIMESystem Timenvarchar60
TOPBackground Processing
22SXPGCOSTABDefinition of logical OS commands(customer table)9CREATETIMESystem Timenvarchar60
23SXPGCOTABEDefinition of logical operating system commands(SAP table)9CREATETIMESystem Timenvarchar60
24SXPGHISTORHistory of Logical Commands12CREATETIMESystem Timenvarchar60
TOPClaims Management
25ICLACTIVITYTasks in Claim10CREATETIMECreated: Date + Timedecimal150
26ICLCAREREP1Data on Care Request6CREATETIMECreated: Date + Timedecimal150
27ICLCAREREP2Data on Caregiver7CREATETIMECreated: Date + Timedecimal150
28ICLCCEVENTClaim Bundle8CREATETIMECreated: Date + Timedecimal150
29ICLCLAIMClaim8CREATETIMECreated: Date + Timedecimal150
30ICLDAMOBJDamaged Object9CREATETIMECreated: Date + Timedecimal150
31ICLEACTIVITYTasks in Claim Bundle9CREATETIMECreated: Date + Timedecimal150
32ICLIBNRHEALTHCLUCases, Quantities, and Costs (Totalled) at Evaluation Level10CREATETIMECreated: Date + Timedecimal150
33ICLIBNRHEALTHDETQuantities and Costs (Totalled, if Nec) at Single Case Level22CREATETIMECreated: Date + Timedecimal150
34ICLINDRESReserve Lot5CREATETIMECreated Atnvarchar60
35ICLNOLNotice of Loss4CREATETIMECreated: UTC Date+Timedecimal150
36ICLNOLAUNotice of Loss Vehicle4CREATETIMECreated: UTC Date+Timedecimal150
37ICLNOLDAMITEMDamage10CREATETIMECreated: UTC Date+Timedecimal150
38ICLNOLDONotice of Loss: Damaged Object5CREATETIMECreated: UTC Date+Timedecimal150
39ICLNOLDOAUNotice of Loss: Damaged Vehicle5CREATETIMECreated: UTC Date+Timedecimal150
40ICLNOLDOBINotice of Loss: Injured Person6CREATETIMECreated: UTC Date+Timedecimal150
41ICLNOLDODESCASSNDamage Descriptors per Object6CREATETIMECreated: UTC Date+Timedecimal150
42ICLNOLDORENotice of Loss: Damaged Vehicle5CREATETIMECreated: UTC Date+Timedecimal150
43ICLNOLHONotice of Loss Building4CREATETIMECreated: UTC Date+Timedecimal150
44ICLNOLPNotice of Loss Participant8CREATETIMECreated: UTC Date+Timedecimal150
45ICLNOLPARTRORole Notifier Participant6CREATETIMECreated: UTC Date+Timedecimal150
46ICLNOLPDRNotice of Loss: Driver7CREATETIMECreated: UTC Date+Timedecimal150
47ICLPAYClaim Payment10CREATETIMECreated: Date + Timedecimal150
48ICLPAYEEAdditional Payee11CREATETIMECreated: Date + Timedecimal150
49ICLPROCUREClaim Item Groupings10CREATETIMECreated: Date + Timedecimal150
50ICLSUBCLSubclaim9CREATETIMECreated: Date + Timedecimal150
51ICLSUBCLFRAUDResult from Check System9CREATETIMECreated: Date + Timedecimal150
52ICLULAERUNTimestamp for a ULAE Reserve Calculation Run4CREATETIMECreated: Date + Timedecimal150
53ICLX_PARTICIPANTError Table for Participants with XI Input7CREATETIMECreated: Date + Timedecimal150
54ICL_INVSTG_LOGClaim Investigation Messages6CREATETIMECreated: Date + Timedecimal150
55ICL_REGREP_LOGRegulatory Reporting Log5CREATETIMECreated: Date + Timedecimal150
56ICSACTIVITYActivity in the Claim10CREATETIMECreated: Date + Timedecimal150
57ICSCCEVENTShadow Table Claim Bundle8CREATETIMECreated: Date + Timedecimal150
58ICSCLAIMClaim8CREATETIMECreated: Date + Timedecimal150
59ICSDAMOBJDamaged Object9CREATETIMECreated: Date + Timedecimal150
60ICSEACTIVITYTask in Claim Bundle Shadow Table9CREATETIMECreated: Date + Timedecimal150
61ICSPAYPayment10CREATETIMECreated: Date + Timedecimal150
62ICSPAYEEAdditional Payee11CREATETIMECreated: Date + Timedecimal150
63ICSPROCUREClaim Item Groupings10CREATETIMECreated: Date + Timedecimal150
64ICSSUBCLSubclaim9CREATETIMECreated: Date + Timedecimal150
65ICSSUBCLFRAUDResult from Claims Check System9CREATETIMECreated: Date + Timedecimal150
TOPClinical System
66N2DSERIESIS-H*MED RAD: Description of a DICOM image series6CREATETIMEGeneration time of a DICOM objectnvarchar60
TOPCollectionsDisbursements
67VVKKCFRECCash Receipts to be Transferred to Claims System6CREATETIMECreated: UTC Date+Timedecimal150
TOPContract Accounts Receivable and Payable
68DFKK10991099 Statutory Reporting Data7CREATETIMECreated: UTC Date+Timedecimal150
TOPDB2 for OS39
69DB2BPTUNEDB2/390: Buffer Pool Tuning Settings3CREATETIMESystem Timenvarchar60
70STU3COTABCDefinition of DB2 OS/390 and OS/390 Commands(Customer Table)14CREATETIMESystem Timenvarchar60
71STU3COTABSDefinition of DB2 for OS/390 and OS/390 Commands (SAP Table)14CREATETIMESystem Timenvarchar60
TOPFast Search Infrastructure
72SFSRFW_TIMESTime Measurement4CREATETIMELast changed atnvarchar60
TOPFunds Management
73FMEUROPLANTable of Euro FM Areas5CREATETIMESystem Timenvarchar60
TOPHierarchy Storage
74TTREV_COMPVersions: Structure/Hierarchy Comparisons5CREATETIMECreated atnvarchar60
75TTREV_HCHIHeader table for structure versions7CREATETIMECreated atnvarchar60
76TTREV_HEADHeader table for structure versions5CREATETIMECreated atnvarchar60
TOPIndustry Solution Catch Weight Management
77CON_FIN_CKOMPUAllowance for Price Update14CREATETIMESystem Timenvarchar60
TOPMonitoring
78SQLRUSERCustomizing Table for SQL Trace Interpreter9CREATETIMESystem Timenvarchar60
79SQLRUSER1User Table for Groups for SQL Trace Interpreter6CREATETIMESystem Timenvarchar60
80SQLRUSER2User Table for Function for SQL Trace Interpreter5CREATETIMESystem Timenvarchar60
TOPProcess Controls
81GRPCCTRLPROPOSALGRPC:Control Proposal26CREATETIMETime Creatednvarchar60
82GRPCORGUGRLCRAssign Organization unit value to Organization Unit Group12CREATETIMETime Creatednvarchar60
83GRPCORGUGRPTOrganization Unit Group Description6CREATETIMETime Creatednvarchar60
84GRPCORGUNITGRPOrganization Unit Group4CREATETIMETime Creatednvarchar60
85GRPCRLCRRule Criteria8CREATETIMETime Creatednvarchar60
86GRPCRULERule16CREATETIMETime Creatednvarchar60
87GRPCRULE_SNPRule for Snapshot17CREATETIMETime Creatednvarchar60
88GRPCRULE_TEMPRule - Temporary table for installation16CREATETIMETime Creatednvarchar60
89GRPCRVVALRule Criteria Value14CREATETIMETime Creatednvarchar60
90GRPCRVVAL_SNPRule Criteria Value15CREATETIMETime Creatednvarchar60
91GRPCSCHEDULERScheduler22CREATETIMETime Creatednvarchar60
92GRPCSCRIPTScript19CREATETIMETime Creatednvarchar60
93GRPCSCRIPT_TEMPScript - Temporary table for installation19CREATETIMETime Creatednvarchar60
94GRPCTLLOGtestlog action logs7CREATETIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
95GRPCTRANSGRC Rules Analysis34CREATETIMETime Creatednvarchar60
96GRPCTRANS_SNPGRC Rules Analysis35CREATETIMETime Creatednvarchar60
97GRPC_OLSP_SNPAssign Organization unit value to Organization Unit Group14CREATETIMETime Creatednvarchar60
TOPSAP Business Workflow
98SWU5_DYNPChronology of generated program objects12CREATETIMESystem Timenvarchar60
TOPSAP NetWeaver Mobile - Use subcomponents
99MDK_INVENTORYMDK Inventory Example - Data Table10CREATETIMECreate Timenvarchar60
100MISYNMSGMI System News Messages11CREATETIMECreation Time of System Messagenvarchar60
TOPShared Service Center Framework
101SSCSRservice request in backend11CREATETIMECreation Time for Service Requestnvarchar60
TOPTransport Organizer
102GUPDLAYOUTList of Table Layouts that Need to Be Updated8CREATETIMELast changed atnvarchar60
TOPUpgrade - General
103MERGEMAPSHeader Information for Merge Maps8CREATETIMELast changed atnvarchar60