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

104 columns | Print definition?ERP 6.0  | ITEM_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/O_SALO_ITMSales Document Item for Tracking13ITEM_TYPEItem Typenvarchar10
2/MRSS/C_PLANSTATDetermination of 'Planned Status' of a demand'3ITEM_TYPEDemand Item Categorynvarchar40
3/OTTM/BL_T_ERAE-Receipt assignments5ITEM_TYPEItem type of e-receiptnvarchar300
4/OTTM/BL_T_ERME-Receipt metadata5ITEM_TYPEItem type of e-receiptnvarchar300
5/RPM/PORT_ITM_MPMapping: Item Types with Portfolio Types (Note 1748331)3ITEM_TYPETypenvarchar150
6/SAPSRM/C_IT_TYItem Types of SRM Procurement Documents incl. initial entry1ITEM_TYPEItem Type of Procurement Documentsnvarchar40
7/SAPSRM/C_IT_TY0Item Types of SRM Procurement Documents, '0' replaces ''1ITEM_TYPEItem Type of Procurement Documentsnvarchar40
8/SAPSRM/C_IT_TYAItem Types of SRM Procurement Documents, '0' and ' '1ITEM_TYPEItem Type of Procurement Documentsnvarchar40
9/SAPSRM/C_IT_TYTText Table for Item Types of SRM Procurement Documents1ITEM_TYPEItem Type of Procurement Documentsnvarchar40
10/SAPSRM/C_MDA_I1Meta Data Configuration for Business Object Item Fields5ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
11/SAPSRM/C_MDA_ICCustomer Meta Data Configuration for BO Item Fields7ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
12/SAPSRM/C_MDA_ILLook-Up Table for Meta Data Configuration for Item Actions6ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
13/SAPSRM/C_MDA_ITMeta Data Configuration for Business Object Item Fields7ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
14/SAPSRM/C_MDF_I1Meta Data Configuration for Business Object Item Fields5ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
15/SAPSRM/C_MDF_IBBackground Table for Meta Data Configuration for Item Fields5ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
16/SAPSRM/C_MDF_ICCustomer Meta Data Configuration for BO Item Fields6ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
17/SAPSRM/C_MDF_ILLook-Up Table for Meta Data Configuration for Item Fields5ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
18/SAPSRM/C_MDF_ITMeta Data Configuration for Business Object Item Fields6ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
19/SAPSRM/C_MDS_I1Meta Data Configuration for Business Object Item Fields4ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
20/SAPSRM/C_MDS_ICCustomer Metadata Configuration for Item Set Types6ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
21/SAPSRM/C_MDS_ILLook-Up Table for Metadata Configuration for Item Set Types5ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
22/SAPSRM/C_MDS_ITMeta Data Configuration for Business Object Item Fields6ITEM_TYPEItem Type of Purchasing Document with ' ' Replaced by '0'nvarchar40
23/XPPM/GW_PRT_CUSDefaults Customzing6ITEM_TYPETypenvarchar150
24BBPC_META_ITMMeta Data for Items Types1ITEM_TYPEItem Categorynvarchar40
25GRACREVITEMReview Request related items11ITEM_TYPEItem type for UAR requestsnvarchar10
26PSSCC_DBA_ITEMDecision Basis: Item Control Parameters2ITEM_TYPEItem Category (CRM)nvarchar40
27RSBPC_EN_DEFPREE&N Master User Preferences for Default Values3ITEM_TYPEItem Types for User Preferencesnvarchar100
28RSDB2A_CONTROLDB2 Accelerator: conrol center TOC5ITEM_TYPEDB2 Accelerator: Flagnvarchar10
29RSDB2A_STATDB2 Accelerator: Load statistics5ITEM_TYPEDB2 Accelerator: Flagnvarchar10
30SRMSOCO_DRFT_ITMDraft Items for FIORI SOCO267ITEM_TYPESingle-Character Indicatornvarchar10
31T7CNRMP_DETITMDetermining Factor Item5ITEM_TYPEDetermining Item Typenvarchar20
32T7CNRMP_RPTGRPGrouping Dimension for Report5ITEM_TYPEGrouping Item Typenvarchar10
33T7CNRMP_RPTSTAStatistical Dimension for Report13ITEM_TYPEStatistical Item Typenvarchar10
34T7CNRMP_SUMITMSummary Structure Item5ITEM_TYPESummary Item Typenvarchar10
35ZRPM_STATUSRPM Status3ITEM_TYPEItem_typenvarchar150
36ZRPM_WF_RECIRPM WF Recipient2ITEM_TYPEItem_typenvarchar150
TOPAccounts Receivable Accounting Process Integration
37FDM_DOC_MIRRORDocument Information (Raw Data in Substitute System)3ITEM_TYPEObject Type of Accounting Documentnvarchar100
TOPAdvertising Management
38TJJCAMP_AM_ITYPEIS-M/AM: Marketing Campaign - Item Type3ITEM_TYPEIS-M: Order-Publishing-Media - Item Typenvarchar20
TOPBasic functions
39HUWM_LOAD_PROTLog Table of Initial Data Transfer for Subsequent Posting5ITEM_TYPERecord Typenvarchar10
TOPBusiness Navigator
40DF54SActive nodes for a variant3ITEM_TYPEItem typenvarchar20
TOPCollaborative Cross Applications
41/POA/D_ENDEFPREFE&N Master User Preferences for Default Values3ITEM_TYPEItem Types for User Preferencesnvarchar100
TOPCommunication Channel
42ICI_CCS_PARAMCCS Properties2ITEM_TYPECMSS Parameter Typenvarchar20
TOPCorporate Performance Monitor
43UMC_TD100Task List20ITEM_TYPETodo item type (info, task, warning, ...)nvarchar10
TOPCross-Application Components
44/MRSS/C_CSG_CTRLMRS relevance of CRM Service orders3ITEM_TYPEDemand Item Categorynvarchar40
45/MRSS/C_CSG_LOCLocation of Service3ITEM_TYPEDemand Item Categorynvarchar40
46/MRSS/C_CSG_PROFMRS : Demand profile mapping3ITEM_TYPEDemand Item Categorynvarchar40
TOPExchanges
47OIA08LIA Document: Item Data5ITEM_TYPELIA item typenvarchar10
48OIAQBExchange Movements Index17ITEM_TYPELIA item typenvarchar10
TOPFinancial Accounting
49J_5KFH_CADVTYPEAdvance accounting control settings5ITEM_TYPEAdvance item typenvarchar10
TOPGovernance, Risk and Compliance
50GRFNMENUITEMMenu Item3ITEM_TYPE(Obsolete) Menu Item Typenvarchar50
51GRFNMENUITEMCMenu Item - Customer enhancement4ITEM_TYPE(Obsolete) Menu Item Typenvarchar50
TOPLogistics - General
52CRMD_CO_ITEMCO Account Assignment of Sales Items4ITEM_TYPEItem Categorynvarchar40
53CRM_SRV_SCENARIOService Logistics Scenarios for Material Withdrawal3ITEM_TYPEItem Categorynvarchar40
TOPMaintenance Orders
54/MRSS/C_AUT_ASGSControl Automatic Asssignment Creation Based on Status Type3ITEM_TYPEDemand Item Categorynvarchar40
55/MRSS/C_CSG_SLCustomize the Unit of Measure for slots3ITEM_TYPEDemand Item Categorynvarchar40
56/MRSS/C_NW_AFDAssignment follows Demand (NW Addon)3ITEM_TYPEDemand Item Categorynvarchar40
TOPPeriodical Sales and Distribution
57JITCIRCBOOKIS-M/SD: Circulation Book with Delivery Quantities26ITEM_TYPEInternal Item Type for Sales Ordernvarchar20
58TJD75IS-M: Issue Change Type for Each IS-M/AM Item Category3ITEM_TYPEIS-M: Item Category for Sales Documentnvarchar40
TOPPortfolio
59VDBILL_ITEMSBilling Items3ITEM_TYPEBill Item Typenvarchar10
TOPPortfolio Management
60/RPM/CPDP_MAPDecision Points to cProjects Phase Mapping3ITEM_TYPETypenvarchar150
61/RPM/CPIT_MAPItem Type to cProjects Templates Mapping3ITEM_TYPETypenvarchar150
62/RPM/DP_DP_MAPDecision Point to Target Decision Point Mapping2ITEM_TYPETypenvarchar150
63/RPM/DP_ITEM_TYPFor decision points permitted item types for switching to2ITEM_TYPETypenvarchar150
64/RPM/DP_STATUSDecision Point Status2ITEM_TYPETypenvarchar150
65/RPM/DP_STATUS_NDecision Point Status:Next Possible Statuses2ITEM_TYPETypenvarchar150
66/RPM/DP_STATUS_TDecision Point Status Text3ITEM_TYPETypenvarchar150
67/RPM/DP_STA_MAPDecision Point Status Mapping2ITEM_TYPETypenvarchar150
68/RPM/ITEM_CYCLEDefining Item types in a Life Cycle3ITEM_TYPETypenvarchar150
69/RPM/ITEM_DOperational item persisted data31ITEM_TYPETypenvarchar150
70/RPM/ITEM_PHASEDecision points per Item/Initiative Type2ITEM_TYPETypenvarchar150
71/RPM/ITEM_STATUSDecision Point Status2ITEM_TYPETypenvarchar150
72/RPM/ITEM_STAT_NDecision Point Status:Next Possible Statuses2ITEM_TYPETypenvarchar150
73/RPM/ITEM_STAT_TDecision Point Status Text3ITEM_TYPETypenvarchar150
74/RPM/ITEM_TYPEItem Type2ITEM_TYPETypenvarchar150
75/RPM/ITEM_TYPE_TItem Text3ITEM_TYPETypenvarchar150
76/RPM/ITEM_TYP_MPFor Item Types permitted Target Item Types for switching to2ITEM_TYPETypenvarchar150
77/RPM/ITM_STA_MAPItem Type Status Mapping2ITEM_TYPETypenvarchar150
78/RPM/ITPSPP_MAPItem Type to PS Project Profile2ITEM_TYPETypenvarchar150
79/RPM/LTXT_I_TYPELongtext for Item/Initiative Type4ITEM_TYPEItem_typenvarchar150
80/RPM/METRICApplication specific customization for Metric3ITEM_TYPETypenvarchar150
81/RPM/MET_GRPApplication specific customizing for Metric Group3ITEM_TYPETypenvarchar150
82/RPM/NADP_MAPItem Type Decision Point - PS Project Template NA Mapping3ITEM_TYPETypenvarchar150
83/RPM/PDDP_MAPMapping of PD Phase to RPM Decision point2ITEM_TYPETypenvarchar150
84/RPM/PDPIT_MAPMapping of PD Concept -ProcessTemplate to RPM Portfolio item2ITEM_TYPETypenvarchar150
85/RPM/PHASE_TPhase Text3ITEM_TYPEItem_typenvarchar150
86/RPM/PORT_IP_UIOverride Portfolio Item UI fields-Phase4ITEM_TYPETypenvarchar150
87/RPM/PORT_I_UIOverride Portfolio UI fields-Item4ITEM_TYPETypenvarchar150
88/RPM/PSPTIT_MAPItem Type to PS Project template mapping table2ITEM_TYPETypenvarchar150
89/RPM/PTIT_MAPItem Type to Project Type Mapping3ITEM_TYPETypenvarchar150
90/RPM/VAL_TYPApplication specific customization for value Type3ITEM_TYPETypenvarchar150
91/RPM/WBSDP_MAPItem Type DecisionPoint - PS Project Template WBS Mapping3ITEM_TYPETypenvarchar150
92RPM_ITEM_D_CDItem details - Pseudo table for change documents31ITEM_TYPETypenvarchar150
93ZNPDI_XRPM2CPR_TxRPM -> cPro Integration2ITEM_TYPETypenvarchar150
TOPProcess Controls
94GRPCMENUITEMMenu Item2ITEM_TYPEMenu Item Typenvarchar50
95GRPCMENUITEMCMenu Item - Customer enhancement3ITEM_TYPEMenu Item Typenvarchar50
TOPPublic Sector Contract Accounts Receivable and Payable
96TFMCA_BRF222BRF: Parameters for Refund Line Items7ITEM_TYPERefund Item Typenvarchar10
97TFMCA_REFUNDMain/Subtransaction for Refund Items4ITEM_TYPERefund Item Typenvarchar10
TOPPurchasing
98WRFT_POHF_POLFOrder List Screen Layout2ITEM_TYPEType of Data Recordnvarchar10
TOPRecipe Development
99/PLMI/RFO_SUBCATAllowed Specification Types for Stream Specifications2ITEM_TYPEFormula Item Typenvarchar20
TOPSAP Multiresource Scheduling
100/MRSS/C_APPT_TYPAppointment booking type for PM/CS/CRM Order Types3ITEM_TYPEDemand Item Categorynvarchar40
TOPShipping
101FIP_D_WORKLISTWorklist Substitution during Goods Receipt18ITEM_TYPEItem Typenvarchar10
TOPUnique Identification
102IUID_MAN_DATAManually Maintained Values for IUID Messages15ITEM_TYPEItem Type (End Item or Embedded Item)nvarchar30
103IUID_PEDIGREEUII IDoc Message Data for Supporting Supplier Collaboration15ITEM_TYPEItem Type (End Item or Embedded Item)nvarchar30
TOPWorkforce Management Core
104WFDSD_DEMANDWork Force Deployment Demand17ITEM_TYPEItem Categorynvarchar40