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

121 columns | Print definition?ERP 6.0  | CREATE_USER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/CFUNC_DETFunction Information18CREATE_USERCreate Usernvarchar120
2/AIF/CIFPP_TJSELDefine Selection for CIF Postprocessing8CREATE_USERCreate Usernvarchar120
3/AIF/CLINKCustom Data Link10CREATE_USERCreate Usernvarchar120
4/AIF/CTEXTCustom Message Text10CREATE_USERCreate Usernvarchar120
5/AIF/DOCUDocumentation4CREATE_USERUser Namenvarchar120
6/AIF/DOCU_ID_IDXDocument search index table22CREATE_USERCreate Usernvarchar120
7/AIF/FLBOOK_IDXStandard index table19CREATE_USERCreate Usernvarchar120
8/AIF/IDC_IDX_TBLStandard index table19CREATE_USERCreate Usernvarchar120
9/AIF/MIDX_TEMPLTemplate for a multi index table20CREATE_USERCreate Usernvarchar120
10/AIF/MSGSTAT_LOGMessage statistics trace log10CREATE_USERCreate Usernvarchar120
11/AIF/NS_LOCKDefine Namespace9CREATE_USERCreate Usernvarchar120
12/AIF/PERS_QMSGAIF Persistence: Runtime Queue5CREATE_USERCreate Usernvarchar120
13/AIF/PERS_RTCFGRAIF Persistence: Runtime Configuration Group5CREATE_USERCreate Usernvarchar120
14/AIF/PERS_RUNAIF Persistence: Run8CREATE_USERCreate Usernvarchar120
15/AIF/PERS_RUNPCKAIF Persistence: Run Packet6CREATE_USERCreate Usernvarchar120
16/AIF/PERS_XMLAIF XML Persistency: Message Header8CREATE_USERCreate Usernvarchar120
17/AIF/QRFC_S_IDXqRFC Standard index table19CREATE_USERCreate Usernvarchar120
18/AIF/QRFC_TJ_SOSelection Options for qRFC transfer job6CREATE_USERCreate Usernvarchar120
19/AIF/QRFC_TJ_SYSSelection Options for qRFC Transfer Job9CREATE_USERCreate Usernvarchar120
20/AIF/Q_STD_IDX_TqRFC Standard index table19CREATE_USERCreate Usernvarchar120
21/AIF/RUNNING_WFRunning Workflow for AIF7CREATE_USERCreate Usernvarchar120
22/AIF/STD_IDX_TBLStandard index table19CREATE_USERCreate Usernvarchar120
23/AIF/TEST_BP_IDXStandard index table19CREATE_USERCreate Usernvarchar120
24/AIF/TICKETSTicket content table for Ticket System13CREATE_USERCreate Usernvarchar120
25/AIF/TIDOC_STRAIF IDoc structure mapping table9CREATE_USERCreate Usernvarchar120
26/AIF/TRFC_S_IDXtRFC Standard index table19CREATE_USERCreate Usernvarchar120
27/AIF/TRFC_TJ_SOSelection Options for tRFC transfer job3CREATE_USERCreate Usernvarchar120
28/AIF/TRFC_TJ_SYSSelection Options for Transfer Job7CREATE_USERCreate Usernvarchar120
29/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing19CREATE_USERCreate Usernvarchar120
30/AIF/T_MMSG_IDXMulti Msg class&No. search index table24CREATE_USERCreate Usernvarchar120
31/AIF/T_QRFC_LOGLog table for Playback Functions generation5CREATE_USERCreate Usernvarchar120
32/AIF/T_RFC_FGLOGFunction Module List Generation Log24CREATE_USERCreate Usernvarchar120
33/AIF/T_STD_IDX_TtRFC Standard index table19CREATE_USERCreate Usernvarchar120
34/AIF/T_TJ_SSSelection set for transfer job7CREATE_USERCreate Usernvarchar120
35/AIF/T_TRFC_FUNCPlayback Functions for tRFC Reader9CREATE_USERCreate Usernvarchar120
36/AIF/VALID_PERIOAIF Validity Period5CREATE_USERCreate Usernvarchar120
37/AIFX/ECH_STD_TBStandard ECH key fields table34CREATE_USERCreate Usernvarchar120
38/AIFX/T_PPOAIF PPO9CREATE_USERCreate Usernvarchar120
39/BOBF/ACF_MAPBOPF Configuration: ACF mapping12CREATE_USERUser that Created the Settingnvarchar120
40/BOBF/AUTH_OBJBOPF Configuration: ACF Definition8CREATE_USERUser that Created the Settingnvarchar120
41/BOBF/OBM_AK_FLDBOPF Configuration: Fieldnames for Alternative Key11CREATE_USERUser that Created the Settingnvarchar120
42/SLOAE/EX_ANALYSAnalysis table3CREATE_USERUser Namenvarchar120
43DMC_RT_VALUESDMC: Storage for temporary Parameters and Values5CREATE_USERUser Namenvarchar120
44GRACPROVCONFIGProvisioning configuration6CREATE_USERProvisioning Create Usernvarchar10
45MDS_VERSIONMDS: Headertable for analysis versions3CREATE_USERUser Namenvarchar120
46RSBPCB_TMPLBPC: BPF Template9CREATE_USERLast changed bynvarchar120
47RSBPCR_RESOURCEBPC: Persistence Resource15CREATE_USERLast changed bynvarchar120
48T7CNRMP_DREPORTReport with Dynamic Rows or Columns5CREATE_USERCreation Usernvarchar120
49TMAS_D_JOBJob table5CREATE_USERUser Namenvarchar120
50TMAS_OLA_D_JOBAnalysis jobs5CREATE_USERUser Namenvarchar120
51ZAIF_D01_SIDX_01Single index table for DEMO BUPA_IN19CREATE_USERCreate Usernvarchar120
52/BOBF/ACT_CONFBOPF Configuration: Assignment of Action to a Node Category8CREATE_USERUser that Created the Settingnvarchar120
53/BOBF/ACT_LISTBOPF Configuration: Action32CREATE_USERUser that Created the Settingnvarchar120
54/BOBF/DAC_DATABOPF: Generic Data Storage for Rapid Prototyping7CREATE_USERUser that Created the Settingnvarchar120
55/BOBF/DET_CONFBOPF Configuration: Execution times of determinations9CREATE_USERUser that Created the Settingnvarchar120
56/BOBF/DET_LISTBOPF Configuration: Determination16CREATE_USERUser that Created the Settingnvarchar120
57/BOBF/DET_NETBOPF Configuration: Determination sequence definition8CREATE_USERUser that Created the Settingnvarchar120
58/BOBF/OBM_ALTKEYBOPF Configuration: Alternative Keys21CREATE_USERUser that Created the Settingnvarchar120
59/BOBF/OBM_ASSOCBOPF Configuration: Association31CREATE_USERUser that Created the Settingnvarchar120
60/BOBF/OBM_ASSOCBBOPF Configuration: Association Binding17CREATE_USERUser that Created the Settingnvarchar120
61/BOBF/OBM_ASSOCCBOPF Configuration: Node Category assignment to associations8CREATE_USERUser that Created the Settingnvarchar120
62/BOBF/OBM_BOBOPF Configuration: Business Objects12CREATE_USERUser that Created the Settingnvarchar120
63/BOBF/OBM_CODE_LBOPF Code Lists for Code Value Sets8CREATE_USERUser that Created the Settingnvarchar120
64/BOBF/OBM_DISELBOPF Configuration: Disabled Elements8CREATE_USERUser that Created the Settingnvarchar120
65/BOBF/OBM_FINORDBOBF finalization order8CREATE_USERUser that Created the Settingnvarchar120
66/BOBF/OBM_GEN_INBOPF Configuration: Generation information12CREATE_USERUser that Created the Settingnvarchar120
67/BOBF/OBM_GROUPBOPF Configuration: Group13CREATE_USERUser that Created the Settingnvarchar120
68/BOBF/OBM_GROUPCBOPF Configuration: Assignment Group / Content9CREATE_USERUser that Created the Settingnvarchar120
69/BOBF/OBM_MAPBOPF Configuration: Mapping of External and Internal Field N15CREATE_USERUser that Created the Settingnvarchar120
70/BOBF/OBM_NCATBOPF Configuration: Node Category10CREATE_USERUser that Created the Settingnvarchar120
71/BOBF/OBM_NODEBOPF Configuration: Node50CREATE_USERUser that Created the Settingnvarchar120
72/BOBF/OBM_OBJBOPF Configuration: Version39CREATE_USERUser that Created the Settingnvarchar120
73/BOBF/OBM_PROPTYBOPF Configuration: Static Properties12CREATE_USERUser that Created the Settingnvarchar120
74/BOBF/OBM_PRXPTYBOPF Configuration: Static Proxy Properties13CREATE_USERUser that Created the Settingnvarchar120
75/BOBF/OBM_QUERYBOPF Configuration: Query22CREATE_USERUser that Created the Settingnvarchar120
76/BOBF/OBM_RTWBOPF Configuration: Dependencies between Logic and Nodes20CREATE_USERUser that Created the Settingnvarchar120
77/BOBF/OBM_RTW_ABOPF Configuration: Attributes for Trigger definitions10CREATE_USERUser that Created the Settingnvarchar120
78/BOBF/OBM_SUBSCRBOBF BO subscriptions7CREATE_USERUser that Created the Settingnvarchar120
79/BOBF/OBM_VRSBOPF Configuration: Model Versions13CREATE_USERUser that Created the Settingnvarchar120
80/BOBF/OBM_VSETBOPF Configuration: Value Set17CREATE_USERUser that Created the Settingnvarchar120
81/BOBF/STA_DERIVBOPF Configuration: Status Derivator13CREATE_USERUser that Created the Settingnvarchar120
82/BOBF/STA_SCHEMABOPF Configuration: Status Scheme9CREATE_USERUser that Created the Settingnvarchar120
83/BOBF/STA_VARBOPF Configuration: Status Variable11CREATE_USERUser that Created the Settingnvarchar120
84/BOBF/VAL_CONFBOPF Configuration: Assignment of Validations to Actions9CREATE_USERUser that Created the Settingnvarchar120
85/BOBF/VAL_LISTBOPF Configuration: List of all validations15CREATE_USERUser that Created the Settingnvarchar120
86/BOBF/VAL_NETBOPF Configuration: Sequence definition of validations8CREATE_USERUser that Created the Settingnvarchar120
TOPAccounting Interface
87GLE_ECS_ITEMECS: Error Correction Items31CREATE_USERCreated Bynvarchar120
88GLE_ECS_VARIANTVariants: Header Table4CREATE_USERCreated Bynvarchar120
TOPAnalysis Process Designer
89RSANT_UT_RSLTManagement Table for Interim Results3CREATE_USERCreated bynvarchar120
TOPClinical System
90N2AD_ALLERGYAllergy Documentation - Allergies28CREATE_USERIS-H: Name of Employee who Created Recordnvarchar120
91N2AD_PATAllergy Documentation - Overall Allergy Status (OAS)15CREATE_USERIS-H: Name of Employee who Created Recordnvarchar120
92N2AD_REACTAllergy Documentation - Reactions14CREATE_USERIS-H: Name of Employee who Created Recordnvarchar120
93N2DI_DICTATDictation - Administration Data8CREATE_USERIS-H: Name of Employee who Created Recordnvarchar120
94N2DI_RECORDAdministration Data of Speech Recording11CREATE_USERIS-H: Name of Employee who Created Recordnvarchar120
TOPCommunication
95NHCF_EVENTIS-H: HCF: Triggered Unprocessed Events19CREATE_USERIS-H: Name of Employee who Created Recordnvarchar120
TOPCross-Application Components
96PDS_COMPComponent Data for PDS17CREATE_USERUser Namenvarchar120
97PDS_HEADERHeader Data for PDS with Changes16CREATE_USERUser Namenvarchar120
98PDS_KEYKey Table for PDS Data from PDS Maintenance11CREATE_USERUser Namenvarchar120
99PDS_OPERPDS Data for Operations and Dependent Data25CREATE_USERUser Namenvarchar120
TOPEmployee Interaction Center
100THREIC_SLASLA Contracts8CREATE_USERUser Name in User Master Recordnvarchar120
TOPIncentive and Commission Management ICM
101TCACS_PATCH_U02Patch Manager: Job Log13CREATE_USERPatch Manager: Creatornvarchar120
TOPInformation Retention Manager
102SILM_VIEWView Definition: Header5CREATE_USERUser - Created bynvarchar120
TOPManagement of Internal Controls
103FOPC_BTC_REPORTSBackground Reports in System5CREATE_USERUser Namenvarchar120
TOPNetWeaver Enterprise Search
104ESH_PRC_PROCESSProcess7CREATE_USERUser Namenvarchar120
105ESH_PRC_TASKProcess step (task)9CREATE_USERUser Namenvarchar120
TOPOLAP Technology
106RSR_CACHE_STATSStatistics for Cache Entries5CREATE_USERUser Namenvarchar120
TOPProcess Controls
107GRPC_BTC_REPORTSBackground Reports in System5CREATE_USERUser Namenvarchar120
TOPProduction Orders
108NAVP_PROFILENavigation Profile12CREATE_USERNavigation Profile Created bynvarchar120
TOPSales and Distribution
109ZZDEA_MSTDrug Enforcement Administration (DEA)14CREATE_USERUser that created the transactionnvarchar120
110ZZDEA_QTYDEA quantity limits per customer and material11CREATE_USERUser that created the transactionnvarchar120
TOPSAP NetWeaver Mobile - Use subcomponents
111INST_IMGTable for Installation Toolkit - Configuration Data14CREATE_USERUser Name in User Master Recordnvarchar120
TOPService Data Download
112/SDF/CD_CCONNECTPersistency for /SDF/CD_CUSTOM_CODE_CONNECT9CREATE_USERUser Namenvarchar120
TOPTransaction Manager
113IDCFMBRSE_PSTCustomizing for creation of sales transactions for tax pmnts29CREATE_USEREntered bynvarchar120
114TCORT_CODCODeal: Conditions14CREATE_USEREntered bynvarchar120
115TCORT_CODCOFODeal: Condition's Formula13CREATE_USEREntered bynvarchar120
116TCORT_CODMDDeal: Main Data10CREATE_USEREntered bynvarchar120
117TCORT_CODPIDeal: Payment Information10CREATE_USEREntered bynvarchar120
118TCORT_CODULCODeal : Underlying's Conditions15CREATE_USEREntered bynvarchar120
119TCORT_CODULCOFODeal: Underlying's Formula15CREATE_USEREntered bynvarchar120
TOPUI Framework Service Provider Infrastructure
120/PLMB/SPI_CHECKCheck of SPI5CREATE_USERUser namenvarchar120
TOPWithout Description
121RSDMA_DBT_MODELSDB: Models3CREATE_USERChanged bynvarchar120