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

87 columns | Print definition?ERP 6.0  | RESPONSIBLE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IAM/D_ACT_PARTYParty8RESPONSIBLEResponsible Indicatornvarchar10
2/XFT/SRM_DEMO_10Patent5RESPONSIBLEResponsible personnvarchar120
3SNAP_ADTSNAP for ADT18RESPONSIBLEnvarchar600
4VIXCITCADAOTemporary architectural object data27RESPONSIBLEPerson Responsiblenvarchar120
5VIXCITCADROTemporary rental object data18RESPONSIBLEPerson Responsiblenvarchar120
6VIYCEXPPOOLExpense Pool in CAM14RESPONSIBLEPerson Responsiblenvarchar120
7ZTR_CATTScatts to be executed in teach systems8RESPONSIBLEnvarchar150
8ZTR_COUNTRYtraining courses3RESPONSIBLEnvarchar200
9ZTR_COURSEStraining courses14RESPONSIBLEnvarchar150
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
10SATC_AC_RSLT_AEOBSOLETE: 'Display Load' aspect failure (plug-in error)8RESPONSIBLEnvarchar120
11SATC_AC_RSLT_VTOBSOLETE: 'Display Load' aspect findings (verdicts)7RESPONSIBLEnvarchar120
TOPAccounts Receivable Accounting Process Integration
12TFDM_WRITEOFF01FSCM-DM: Default Values for Writing Off Dispute Cases3RESPONSIBLEPerson Responsiblenvarchar120
TOPArchive Development Kit
13ARCH_USRCustomizing Table for Archiving24RESPONSIBLEPerson Responsible for Performing Archivingnvarchar120
TOPBasic Data
14VIBDAOArchitectural Object23RESPONSIBLEPerson Responsiblenvarchar120
15VIBDBEBusiness Entity16RESPONSIBLEPerson Responsiblenvarchar120
16VIBDBUBuilding17RESPONSIBLEPerson Responsiblenvarchar120
17VIBDPRLand17RESPONSIBLEPerson Responsiblenvarchar120
18VIBDRORental Object17RESPONSIBLEPerson Responsiblenvarchar120
TOPBI Content Analyzer
19RSCONTACT_COLMapping of Objects to Source Systems for Content Activator5RESPONSIBLEPerson Responsible for Entrynvarchar300
TOPBRFplus - ABAP-Based Business Rules
20FDTRESERVEDFDT: Reserved ID Patterns4RESPONSIBLEUser Namenvarchar120
TOPBusiness Configuration Sets
21SCPRSTRANSPSwitch BC Sets: Transport Recording Tables3RESPONSIBLEUser Namenvarchar120
TOPBusiness Planning and Simulation
22UPS_SUBSTITUTETable for Substitute Concept3RESPONSIBLEUser Namenvarchar120
TOPCase Management
23SCMG_T_CASE_ATTRCase Attributes14RESPONSIBLEPerson Responsiblenvarchar120
TOPClinical System
24N2AD_ALLERGYAllergy Documentation - Allergies22RESPONSIBLEEmployee Responsiblenvarchar100
25N2AD_PATAllergy Documentation - Overall Allergy Status (OAS)11RESPONSIBLEEmployee Responsiblenvarchar100
26N2DWSWL_TASKDProvisional Task14RESPONSIBLEResponsibility Keynvarchar40
TOPContract Billing
27ISU_ERREXTR_BIDescription of all Extracts for a Backlog Set6RESPONSIBLEPerson responsiblenvarchar120
28ISU_ERREXTR_BILLDescription of all extracts of a set6RESPONSIBLEPerson responsiblenvarchar120
29ISU_ERR_RESPONSPersons responsible for processing error extracts2RESPONSIBLEPerson responsiblenvarchar120
30ISU_SOLMODULESFunction Module for Solution Methodes8RESPONSIBLEPerson responsiblenvarchar120
TOPCross-Application Components
31CACNS_CU_HISTProjects at Customer6RESPONSIBLEName of responsible person (Project manager)nvarchar250
32ETP_TASKSEasy Task Planning: Tasks8RESPONSIBLEPerson Responsible for Tasknvarchar120
TOPEmployee Interaction Center
33THREIC_IBSEARCHEIC Inbox Initial Search Profile4RESPONSIBLEEIC: Responsibility for Inbox Entriesnvarchar100
TOPFlexible Real Estate Management
34VICAAROBJArchived Data Object16RESPONSIBLEPerson Responsiblenvarchar120
35VICARGRegistration Entry11RESPONSIBLEPerson Responsiblenvarchar120
36VICARGDONECompleted Registration Entry11RESPONSIBLEPerson Responsiblenvarchar120
37VICARSDATEResubmission Date6RESPONSIBLEPerson Responsiblenvarchar120
38VIITTCCorrection Object14RESPONSIBLEPerson Responsiblenvarchar120
TOPHR Administrative Services
39T5ASRFSCNPRPForm Scenarios (Properties)4RESPONSIBLEPerson Responsible for Objectnvarchar120
40T5ASRPROCPRPProcesses (Properties)4RESPONSIBLEPerson Responsible for Objectnvarchar120
TOPInformation Quality Management
41SIQMRUNSInspection Runs (Header Table)9RESPONSIBLEUser namenvarchar120
TOPIntegrated Product and Process Engineering
42PPESSTATUSiPPE Status, Central Data6RESPONSIBLEPerson Responsible for iPPE Status Objectnvarchar120
TOPLand Use Management
43VILMJLJoint Liability14RESPONSIBLEPerson Responsiblenvarchar120
44VILMLRLand Register16RESPONSIBLEPerson Responsiblenvarchar120
45VILMNANotice of Assessment14RESPONSIBLEPerson Responsiblenvarchar120
46VILMPEOther Public Register14RESPONSIBLEPerson Responsiblenvarchar120
47VILMPLParcel of Land16RESPONSIBLEPerson Responsiblenvarchar120
48VILMRCParcel Update16RESPONSIBLEPerson Responsiblenvarchar120
TOPLegal Case Management for ILM
49SLHM_CASE_HEADLegal Hold Management - Cases (Header Data)5RESPONSIBLEPerson Responsiblenvarchar120
TOPLoans Management
50TDCUSTFIELDSTField Catalog - Customizing Field Status14RESPONSIBLEField Status Defined bynvarchar10
51TDFIELDCATALOGField Catalog - Field Catalog13RESPONSIBLEField Status Defined bynvarchar10
52TDPROFILEFIELDField Catalog - Field Status for Profiles10RESPONSIBLEField Status Defined bynvarchar10
TOPManagement of Internal Controls
53FOPCRBFISReporting Buffer: Cases - Issues10RESPONSIBLEUser Name in User Master Recordnvarchar120
54FOPCRBFPLReporting Buffer: Cases - Remediation Plans10RESPONSIBLEUser Name in User Master Recordnvarchar120
TOPOffer and Rental Request
55VIOROFContract Offer14RESPONSIBLEPerson Responsiblenvarchar120
56VIOROOOffered Object14RESPONSIBLEPerson Responsiblenvarchar120
57VIORRRRental Request14RESPONSIBLEPerson Responsiblenvarchar120
TOPPackage Tools
58AKB_TRANS_CHECKObsolete: Compatibility Control11RESPONSIBLEPerson responsible for a packagenvarchar120
59AKB_USG_INFOObsolete: Additional Information for Client Objects6RESPONSIBLEPerson responsible for a packagenvarchar120
TOPPrint Workbench
60EFRMTRLSTWorklists for Application Form Translation15RESPONSIBLEPerson Responsible for Translation Worklistnvarchar120
TOPProcess Controls
61GRPCRBFISReporting Buffer: Cases - Issues10RESPONSIBLEUser Name in User Master Recordnvarchar120
62GRPCRBFPLReporting Buffer: Cases - Remediation Plans10RESPONSIBLEUser Name in User Master Recordnvarchar120
TOPQuality Inspection
63QALSInspection lot record227RESPONSIBLEResponsiblenvarchar450
TOPReal Estate Contract
64VICNCNReal Estate Contract16RESPONSIBLEPerson Responsiblenvarchar120
TOPReal Estate Management
65VIAK03Settlement Unit Master Record33RESPONSIBLEPerson Responsiblenvarchar120
66VICN01Real Estate Contract: Contract Data95RESPONSIBLEPerson Responsiblenvarchar120
67VIMI01Rental unit - Master data97RESPONSIBLEPerson Responsiblenvarchar120
68VIOB01Business entities52RESPONSIBLEPerson Responsiblenvarchar120
69VIOB02Property master data70RESPONSIBLEPerson Responsiblenvarchar120
70VIOB03Real estate building master83RESPONSIBLEPerson Responsiblenvarchar120
TOPRegulatory reporting for insurance companies
71ISSR_BASI_RGRegistrierungseintrag21RESPONSIBLEVerantwortlichernvarchar120
72ISSR_BASI_RGDONEErledigter Registrierungseintrag21RESPONSIBLEVerantwortlichernvarchar120
TOPRent Adjustment
73VIAJATAdjustment Measure14RESPONSIBLEPerson Responsiblenvarchar120
74VIAJCOMPGRPComparative Group of Apartments18RESPONSIBLEPerson Responsiblenvarchar120
TOPResourcen Management
75RMXTT_TRIAL_HDTrial: Header Data11RESPONSIBLEResponsibilitynvarchar450
TOPResources
76DPR_ENTITY_LINKRole Assignments15RESPONSIBLEResponsibilitynvarchar10
TOPRoom Reservations and Seating Arrangements
77VIORMPMove Plan - Header Data23RESPONSIBLEPerson Responsiblenvarchar120
TOPSAP Healthcare - Industry-Specific Components for Hospitals
78N2DWSWL_PATTTask Template15RESPONSIBLEResponsibility Keynvarchar40
79N2DWSWL_PATT1Task Template / Changes15RESPONSIBLEResponsibility Keynvarchar40
80N2DWSWL_TASKTask14RESPONSIBLEResponsibility Keynvarchar40
TOPService Charge Settlement
81VISCPGParticipation Group10RESPONSIBLEPerson Responsiblenvarchar120
82VISCSUSettlement unit18RESPONSIBLEPerson Responsiblenvarchar120
TOPStatus and Action Management
83/PLMB/SAM_OBJSTPLM Status management - Otype Schema,Status, Date And User11RESPONSIBLEUser Namenvarchar120
TOPSyntax, Compiler, Runtime
84SNAPTIDABAP Runtime Errors (Texts in SNAPT)3RESPONSIBLEUser Namenvarchar120
TOPThird Party ManagementCOA
85VIMMMNMandate14RESPONSIBLEPerson Responsiblenvarchar120
TOPUser and Authorization Management
86USR21User Name/Address Key Assignment10RESPONSIBLEUser Responsible for Technical User Accountnvarchar120
87USR21SShadow table: Assignment of user name to address key11RESPONSIBLEUser Responsible for Technical User Accountnvarchar120