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

65 columns | Print definition?ERP 6.0  | IDENTIFIER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLOAP/OUT_PRSLOAP Output Profile10IDENTIFIERSLOAS Identification-tag for report generationnvarchar80
2/SLOAP/OUT_PRTtransport tables for /SLOAS/OUT_PR12IDENTIFIERSLOAS Identification-tag for report generationnvarchar80
3CNVCHECKPROFILESCheck profiles4IDENTIFIERIdentifier for check profilesnvarchar20
4CNVMBTRULESconversion rules18IDENTIFIERIdentifier for Consistent scramblingnvarchar150
5CNVTDMSBW_TIMSEQTime characteristic sequence3IDENTIFIERIdentifier for time characteristicsnvarchar20
6CNVTDMSSCR_KEYSTable Keys for Conditional Scrambling4IDENTIFIERScrambling Identifiernvarchar300
7CNVTDMSSCR_RULEScrambling Rules9IDENTIFIERScrambling Identifiernvarchar300
8CNV_20100_TABCHKTable fields to be analyzed5IDENTIFIERCharacter Field Length = 10nvarchar100
9CNV_20200_SP_TABDefinition of tables for the Special Priority Handling3IDENTIFIERnvarchar500
10CNV_20200_SP_VALControl Table for the Special Priority Handling3IDENTIFIERnvarchar300
11CNV_MBT_ME_SIM_CCustomizing Table to store a Fieldcats to an identifier1IDENTIFIERnvarchar500
12DDREPLITST1DD: Test for Replication4IDENTIFIERnvarchar200
13EBPTOOLTIPTooltip Texts for the Launchpad3IDENTIFIERnvarchar950
14EINV_BSIC_COM_TRTurkey e-Invoice- Customers data Basic/Commercial Scenario11IDENTIFIERTurkey e-Invoice ACP/ASP Identifiernvarchar500
15EINV_BS_CM_MM_TRTurkey e-Invoice- Vendor data Basic/Commercial Scenario11IDENTIFIERTurkey e-Invoice ACP/ASP Identifiernvarchar500
16GRACROLERole34IDENTIFIERRole Identifiernvarchar1000
17RSOSRUNTIMEBW Search: View Runtime Information4IDENTIFIERIdentifiernvarchar1000
18TSRCGList of tables from which source coding is generated1IDENTIFIERGroup key from TSRCGnvarchar200
TOPAMI Event Management
19TEAMI_EM_EVTATTRIS-U Event Management Attributes for AMI Events17IDENTIFIEREvent Attribute Identifiernvarchar600
TOPBasic Data
20TN00LIS-H: Log Table for Special Usage3IDENTIFIERIS-H: Special key for log file (e.g. report program name)nvarchar400
TOPBusiness Process Engine
21SWFBRULECOMBAM: Client-Specific Conditions17IDENTIFIERWF: Name of contextnvarchar320
22SWFBRULECOUBAM: Cross-Client Condition16IDENTIFIERWF: Name of contextnvarchar320
TOPCollaborative Cross Applications
23/POA/D_CTX_HDRPOA SBC Business Context Header3IDENTIFIERBusiness Context Identifiernvarchar2550
TOPDatabase Monitors
24ALLAZYMTALERTS NEXT GEN: Whole Database Monitoring Tree Infrastr.1IDENTIFIERALERTS NEXT GEN: identifier: 'Database',...nvarchar400
25ALLAZYMT2ALERTS NEXT GEN: NEW (>=4.6A) Database Monitoring Tree2IDENTIFIERALERTS NEXT GEN: identifier: 'Database',...nvarchar400
TOPGeneral Application Functions
26TABADRSFCharacteristic Derivation: Steps, Fields9IDENTIFIEROriginnvarchar320
TOPGeneral Ledger Accounting
27FAGLSKF_APPLAssignment of Application to ID for Statistical Key Figures3IDENTIFIERID String of Applicationnvarchar100
28FAGLSKF_TABTable Names and Structures1IDENTIFIERID String of Applicationnvarchar100
29FAGLSKF_TRANSAssignment of Field Names in Different Tables1IDENTIFIERID String of Applicationnvarchar100
30FAGL_DATAC_STRUCCoding of Structure Data1IDENTIFIERHash Codenvarchar300
TOPGRC Access Control Plug-In
31/VIRSA/MGMTIDSRules information classified according business entities4IDENTIFIERIdentifier like User Group/Business Unit/Business Processnvarchar30
TOPIncentive and Commission Management ICM
32FPP_STRUCCoding of Structure Data1IDENTIFIERHash Codenvarchar300
33TCACS_NAMEIDName Formation Rules in Commission System2IDENTIFIERnvarchar60
TOPLease Accounting
34TFILA_GF_100Assignment of Derivations for Validations/Substitutions8IDENTIFIERIdentifier for Derivation of Validation/Substitutionnvarchar320
TOPOLAP Technology
35RSRTSDIRMETADATADirectory of the implementations for transient meta data1IDENTIFIERSingle-Character Indicatornvarchar10
TOPPayment Transactions
36FIEB_PASSWORDPasswords (stored in encrypted form)2IDENTIFIERIdentifier for a Passwordnvarchar630
TOPPrint Workbench
37EFGSTTXTINFOVersion Information Standard Text10IDENTIFIERIndicator for a Translatornvarchar40
38EFG_SPOOL_BUFFSpool IDs Saved with Identifier2IDENTIFIERIdentifier for Spool Requestsnvarchar400
39EFRMTRLSTWorklists for Application Form Translation3IDENTIFIERIndicator for a Translatornvarchar40
40EFRMTRLSTSTRLines of a Translation List3IDENTIFIERIndicator for a Translatornvarchar40
TOPProcess Management
41POC_DB_C_METADATDomain Model: Local Value Collection7IDENTIFIERData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPProfitability Analysis
42TKEDRSFCharacteristic Derivation: Steps, Fields9IDENTIFIEROriginnvarchar320
TOPRecords and Case Management
43RMPSDOD_PRLSTGDod : Parallel Stage Information2IDENTIFIERUnique Key of a Disposal Schedulenvarchar240
44RMPSDOD_RBASEHISTNA: Historical Data Disposal Schedules2IDENTIFIERUnique Key of a Disposal Schedulenvarchar240
45RMPSDOD_RULEBASEDisposal Rulebase2IDENTIFIERUnique Key of a Disposal Schedulenvarchar240
46RMPSDOD_RULEBASTText Table XML Categories3IDENTIFIERUnique Key of a Disposal Schedulenvarchar240
47RMPSPRO_MULTISTGMultistage Disposal2IDENTIFIERUnique Key of a Disposal Schedulenvarchar240
48RMPSPRO_RBASEHISHistorical Data Disposal Schedules2IDENTIFIERUnique Key of a Disposal Schedulenvarchar240
49RMPSPRO_RBASMHISHistorical Data: Multistage Disposal Rules2IDENTIFIERUnique Key of a Disposal Schedulenvarchar240
50RMPSPRO_RULEBASEDisposal Rulebase2IDENTIFIERUnique Key of a Disposal Schedulenvarchar240
51RMPSPRO_RULEBASTText Table XML Categories3IDENTIFIERUnique Key of a Disposal Schedulenvarchar240
52RMPSTNA_RBASEHISTNA: Historical Data Disposal Schedules2IDENTIFIERUnique Key of a Disposal Schedulenvarchar240
53RMPSTNA_RULEBASETNA: Schedules for the Disposal According to PRO Standard2IDENTIFIERUnique Key of a Disposal Schedulenvarchar240
54RMPSTNA_RULEBASTText Table XML Categories3IDENTIFIERUnique Key of a Disposal Schedulenvarchar240
TOPRisk Analysis
55AFWCH_DRSF_SAMPSample Customizing for Derivation (Fields for Steps)8IDENTIFIEROriginnvarchar320
56RMDRTYPEDerivation Type3IDENTIFIERRM: Description within a Derivation Strategynvarchar320
TOPSAP Business Workflow
57SWBRULECOMWF: Client-specific start conditions18IDENTIFIERWF: Name of contextnvarchar320
58SWBRULECOUWF: Connecting Condition/Context to Event Linkage17IDENTIFIERWF: Name of contextnvarchar320
59SWBSAPDFLTSAP Default Values for Prog./Trans./FMs (Applic.-Specific)3IDENTIFIERID (unique) for a display elementnvarchar320
60SWBUSRDFLTDefault Values of SAP User for Prog./Trans./FMs4IDENTIFIERID (unique) for a display elementnvarchar320
TOPTransport Organizer
61VRSTC_IDSSystem Comparison: IDs of Saved Comparisons1IDENTIFIERSystem Comparison: Table Comparison IDnvarchar200
62VRSTC_RESULTSSystem Comparison: Results from Comparison of Table Contents1IDENTIFIERSystem Comparison: Table Comparison IDnvarchar200
63VRSTC_RES_INFOSystem Comparison: Org. Information of Compared Tables1IDENTIFIERSystem Comparison: Table Comparison IDnvarchar200
TOPTravel Planning
64TA23PROFILE_SYNCAssignment Parameters for Preference Synchronization4IDENTIFIERUsernvarchar300
TOPWeb Survey
65TUXS_QUEST_TRANSTranslation Table for Questionnaires4IDENTIFIERChar 20nvarchar200