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

24 columns | Print definition?ERP 6.0  | CHANGEABLE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/C_PGSDDefinition of PArtner Grouping Schema6CHANGEABLELimit Choice of Partners to Those on Parent Levelnvarchar10
2COMC_TEXT_PDDefinition of Text Determination Procedure6CHANGEABLEControl for Text Changesnvarchar10
3COMC_TEXT_PROTLog Text - Text Types5CHANGEABLEControl for Text Changesnvarchar10
TOPBalanced Scorecard
4UMB_RB100Report Builder: Header Table3CHANGEABLEFlag (X or Blank)nvarchar10
TOPBilling in Contract Accounts Receivable and Payable
5TFK8014Operand Category and Relevant Class and Generator Class4CHANGEABLEOperand Values of This Category Can Be Changednvarchar10
6TFK8018Operand Categories for Each Billing Rule Item4CHANGEABLEOperand Values Can Be Changednvarchar10
TOPCross-Application Components
7/IXOS/DC_TCDSData sources (attribute objects) (j_8AGTC05)17CHANGEABLEFlag for changeable WORD documentsnvarchar10
TOPExpense-Related Billing
8PRSC_CATEngagement mgmt: Categories4CHANGEABLEChangeablenvarchar10
TOPIndustry Solution Catch Weight Management
9CON_FIN_CONT_IDSContent Catalog2CHANGEABLEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPLocalization
10FPIA_FIELDSTAT_CField status control for IoA fields5CHANGEABLEChange Mode Enablednvarchar10
11FPIA_FIELDSTAT_SField status control for IoA fields (SAP)4CHANGEABLEChange Mode Enablednvarchar10
TOPMaster Data Framework
12DML_OWNERTYPEMDF Owners5CHANGEABLEChangeabilitynvarchar10
TOPMaterial Categories
13/ISDFPS/CPRMPOSEAssignment of Additional Parts4CHANGEABLEChangeable Additional Part Assignmentnvarchar10
TOPMessages
14DNOC_TYPE_TEXTText Segment Types4CHANGEABLEChangeable (Never, Always, Last Changed By)nvarchar20
TOPMetadata Repository
15RSOCLASSATTRBW Metadata Repository: Attributes for a Class5CHANGEABLEBooleannvarchar10
16RSOCLASSREFBW Metadata Repository: References for a Class6CHANGEABLEBooleannvarchar10
17RSTRACTIVEBW CTO Status - Content Can Not Be Changed3CHANGEABLEChangeability of BW Object Type in Non-Changeable Systemnvarchar10
TOPPost Processing Framework
18PPFTTRIGGPPF: Actions22CHANGEABLEAction Manually Modifiablenvarchar10
19PPFTTTCUPPF: Action Definition in Customizing4CHANGEABLEAction Manually Modifiablenvarchar10
TOPService Data Download
20/SDF/CMO_T_11CMO Service: System Change Option for Software Components2CHANGEABLESystem Change Option for Software Componentnvarchar10
21/SDF/CMO_T_BI_1CMO Service: BI Object Changeability3CHANGEABLESingle-Character Indicatornvarchar10
TOPTransport Organizer
22DLV_SYSTCSystem Change Option for Software Components2CHANGEABLESystem Change Option for Software Componentnvarchar10
TOPWaste Management
23EWAOBJHeader Data for Service Frequency12CHANGEABLEContainer category can be replacednvarchar10
TOPWork Clearance Management
24WCCLUWCM: Lineup Usage5CHANGEABLEChange Possiblenvarchar10