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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

116 columns | Print definition?ERP 6.0  | CATEGORY_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/C_RM_CATRisk Management: Category2CATEGORY_IDCategory IDnvarchar40
2/CPD/C_RM_CAT_TRisk Management: Category Text Table2CATEGORY_IDCategory IDnvarchar40
3/CPD/C_RM_PRF_CTRisk profile category3CATEGORY_IDCategory IDnvarchar40
4/OPT/VT_CAT_IDSummary Report Category Id2CATEGORY_ID5.1: title for header displaynvarchar300
5/OPT/VT_CAT_TEXTVIM Summary Report Category Text2CATEGORY_ID5.1: title for header displaynvarchar300
6/OPT/VT_CGRP_IDSummary Report Category/Group ID2CATEGORY_ID5.1: title for header displaynvarchar300
7/OPT/VT_SUM_STATVIM Summary Report status2CATEGORY_ID5.1: title for header displaynvarchar300
8/SAPPSSRM/SOSIndex-Table con. 'Governm. Proc.'-specific sources of supply10CATEGORY_IDProduct Category IDnvarchar200
9/SAPPSSRM/THHOMPAssign Product Categories to Homogeneous Categories4CATEGORY_IDCategory IDnvarchar200
10/SAPPSSRM/THOMPTProduct Category Descriptions5CATEGORY_IDCategory IDnvarchar200
11/SAPSRM/C_PC_QSTAssignment of Product Category and Questionnaire to Country3CATEGORY_IDCategory IDnvarchar200
12/XFT/SRMCREC65Cust.: Log Categories for Records2CATEGORY_IDLog category for filesnvarchar320
13/XFT/SRMCREC65TCust.: Log Categories for Records3CATEGORY_IDLog category for filesnvarchar320
14/XFT/SRMCREC66Cust.: Log Categories for Record Nodes2CATEGORY_IDLog category for nodenvarchar320
15/XFT/SRMCREC66TCust.: Log Categories for Record Nodes3CATEGORY_IDLog category for nodenvarchar320
16/XFT/SRM_REC20Node Log: Record and templates7CATEGORY_IDCharacter field, length 32nvarchar320
17/XFT/SRM_REC21Log: Record and Template6CATEGORY_IDCharacter field, length 32nvarchar320
18ACO000SAP_GP: Communication Data Set Bidder/Vendor/Portal4CATEGORY_IDCategory IDnvarchar200
19BBPC_PRES_UNPLTemplates for Items in the Confirmation5CATEGORY_IDCategory IDnvarchar200
20BBPC_SRC_DETDetermination of Sourcing for Product Category3CATEGORY_IDCategory IDnvarchar200
21BBPC_VE_EVENTSEvents for Vendor Evaluation5CATEGORY_IDCategory IDnvarchar200
22BBPD_PD_INDEXIndex Table for Fast Access to Contracts and AVLs10CATEGORY_IDProduct Category IDnvarchar200
23BBP_CT_ATTACHMAttachment10CATEGORY_IDCategory ID Buyernvarchar800
24BBP_CT_ATTRTOCATLinks Attributes to Categories7CATEGORY_IDCategory ID Sellernvarchar600
25BBP_CT_CATSchema Category5CATEGORY_IDCategory Namenvarchar600
26BBP_CT_CATEGORYTCategory Texts8CATEGORY_IDCategory ID Sellernvarchar600
27BBP_CT_FILTERCategory Filter6CATEGORY_IDCategory IDnvarchar200
28BBP_CT_LONGTEXTLong Text10CATEGORY_IDCategory ID Sellernvarchar600
29BBP_CT_MAPCATMapping Categories6CATEGORY_IDCategory IDnvarchar200
30BBP_CT_PRODUCTProduct17CATEGORY_IDCategory ID Sellernvarchar600
31BBP_CT_VALRESTRAttribute Value Restrictions11CATEGORY_IDCategory ID Sellernvarchar600
32BBP_DET_ACCOUNTDetermination G/L Account by Product Categories4CATEGORY_IDCategory IDnvarchar200
33BBP_DET_LOGSYSDetermination of Target System by Product Categories3CATEGORY_IDCategory IDnvarchar200
34BBP_DET_TAX_CODETax Code Determination4CATEGORY_IDCategory IDnvarchar200
35BBP_DYNAT_DET1Determination of the Groups for the Dynamic Attributes3CATEGORY_IDProduct Category IDnvarchar200
36BBP_PC_CTGCategories for enabling Procurement Card.3CATEGORY_IDCategory IDnvarchar200
37BBP_PDHSBRFx11CATEGORY_IDProduct Category IDnvarchar200
38BBP_PDIGPBusiness Transaction Item-Purchasing Information4CATEGORY_IDProduct Category IDnvarchar200
39BBP_PDLIMValue Limit9CATEGORY_IDProduct Category IDnvarchar200
40BBP_PRODUCT_FAVUser-Specific Favorites for Products5CATEGORY_IDCategory IDnvarchar200
41BBP_TARGET_OBJDestination of Target Object in Backend4CATEGORY_IDCategory IDnvarchar200
42BBP_TMP_ACOTemporary: Request 'Bidder', Communication Data4CATEGORY_IDCategory IDnvarchar200
43BBP_TMP_BIDTemporary: Request 'Bidder/Vendor', Bidder Data13CATEGORY_IDCategory IDnvarchar200
44BBP_TMP_BIDCCTemporary: Request 'Bidder', Product Categories4CATEGORY_IDCategory IDnvarchar200
45BIDCCBusiness Partner: Assigned Categories4CATEGORY_IDCategory IDnvarchar200
46REQHEADSTemporary Header Data: Requirement Coverage Request (Limit)67CATEGORY_IDCategory IDnvarchar200
47REQLINEMATemporary Line Data: Requirement Coverage Request(MRO Lines)75CATEGORY_IDCategory IDnvarchar200
48REQLINESRTemporary Line Data: Requirement Coverage Request (Services)77CATEGORY_IDCategory IDnvarchar200
49ROST_PCAT_QSTNAssign Product Category and Questionnaire to Languages3CATEGORY_IDCategory IDnvarchar200
50ROST_SEL_PRODCATProduct Categories for Registration3CATEGORY_IDCategory IDnvarchar200
51ROS_BP_PC_SURVEYAssign Vendor, Product Category, Survey4CATEGORY_IDCategory IDnvarchar200
52SIMDQ_INP_MAPIM in HANA input map8CATEGORY_IDIM in HANA categorynvarchar640
53SIMDQ_MOD_DEFIM in HANA table model definition2CATEGORY_IDIM in HANA categorynvarchar640
54SIMDQ_SVC_DEFIM in HANA service definition4CATEGORY_IDIM in HANA categorynvarchar640
55SIMDQ_TASK_DEFIM in HANA task definition4CATEGORY_IDIM in HANA categorynvarchar640
56SRMSOCO_DRFT_ITMDraft Items for FIORI SOCO11CATEGORY_IDCategory IDnvarchar200
57TFW_CATEGTable of Categories2CATEGORY_IDCategory IDnvarchar60
58TFW_TAG_CATEGORYTags Category Map3CATEGORY_IDCategory IDnvarchar60
59TREATS_MLM_ACTGYTREA: Amount Categories for MLM Rules2CATEGORY_IDMargin Limit Rule Categorynvarchar30
60TREATS_MLM_CTGYTREA: Marging Limit Rule Category1CATEGORY_IDMargin Limit Rule Categorynvarchar30
61TREATS_MLM_RULETREA: Margin Limit Rule Value1CATEGORY_IDMargin Limit Rule Categorynvarchar30
TOPAppraisal, Valuation, and Survey Tool
62HRP5020DB Table for Infotype 502019CATEGORY_IDAppraisal Category IDnvarchar80
63T77HAP_CAppraisal Category3CATEGORY_IDAppraisal Category IDnvarchar80
64T77HAP_C_APPEEAppraisal Category - Appraisees3CATEGORY_IDAppraisal Category IDnvarchar80
65T77HAP_C_APPERAppraisal Category - Appraisers3CATEGORY_IDAppraisal Category IDnvarchar80
66T77HAP_C_COLAppraisal Category - Column Assignment3CATEGORY_IDAppraisal Category IDnvarchar80
67T77HAP_C_EXITAppraisal Category - Enhancement Assignment3CATEGORY_IDAppraisal Category IDnvarchar80
68T77HAP_C_OTHERAppraisal Category - Others3CATEGORY_IDAppraisal Category IDnvarchar80
69T77HAP_C_P_APPERAppraisal Category - Part Appraisers3CATEGORY_IDAppraisal Category IDnvarchar80
70T77HAP_C_ROLEAppraisal Category - Role Assignment3CATEGORY_IDAppraisal Category IDnvarchar80
71T77HAP_C_STATUSAppraisal Category - Allowed Status3CATEGORY_IDAppraisal Category IDnvarchar80
72T77HAP_C_TAppraisal Category - Text Table4CATEGORY_IDAppraisal Category IDnvarchar80
73T77HAP_C_VALTYAppraisal Category - Value Type Assignment3CATEGORY_IDAppraisal Category IDnvarchar80
74T77HAP_C_WFEAppraisal Category - Allowed WF Events3CATEGORY_IDAppraisal Category IDnvarchar80
75T77HAP_C_WFRAppraisal Category - Allowed WF Decision Maker3CATEGORY_IDAppraisal Category IDnvarchar80
TOPCentral Part of Product Master
76COMM_CATEGORYCategory3CATEGORY_IDCategory IDnvarchar200
77COMM_CATEGORYDELCategories To Be Deleted (Temporary) in Download3CATEGORY_IDCategory IDnvarchar200
78COMM_CATEGORYHCategory: History4CATEGORY_IDCategory IDnvarchar200
79COMM_PRFIN_NRELGroup Table for Number Range Object FINANCEID2CATEGORY_IDCategory IDnvarchar200
80COMM_PRFS_NRELGroup Table for Number Range Object FS_PRODID2CATEGORY_IDCategory IDnvarchar200
81COMM_PRIP_NRELGroup Table for Number Range Object IPID2CATEGORY_IDCategory IDnvarchar200
82COMM_PRMAT_NRELGroup Table for Number Range Object MATERIALID2CATEGORY_IDCategory IDnvarchar200
83COMM_PRPRDCATRProduct - Product Category Assignment5CATEGORY_IDCategory IDnvarchar200
84COMM_PRPRDCATRHProduct - Product Category Assignment: History6CATEGORY_IDCategory IDnvarchar200
85COMM_PRSRV_NRELGroup Table for Number Range Object SERVICEID2CATEGORY_IDCategory IDnvarchar200
86COMM_PRTI_NRELGroup Table for Number Range Object TI_ID2CATEGORY_IDCategory IDnvarchar200
87COMM_PRWTY_NRELGroup Table for Number Range Object WARRANTYID2CATEGORY_IDCategory IDnvarchar200
TOPClaims Management
88TICL055Benefit Type6CATEGORY_IDProduct Category ID in Procurement Systemnvarchar200
TOPConditions
89A600IDES_Global Agreement for Valuation, depend on the Catagory5CATEGORY_IDCategory IDnvarchar200
TOPControlling
90COMM_CATGRY_COProduct Category2CATEGORY_IDProdukt Category IDnvarchar180
91COMM_CATGRY_CO_TProduct Category Description2CATEGORY_IDProdukt Category IDnvarchar180
92IAOM_CRMSRV_EXATExt. Attributes of an Ext. Object (Single Obj.Controlling)12CATEGORY_IDProdukt Category IDnvarchar180
TOPE-Recruiting
93T77RCF_QAT2CATAssignment of Questionnaire Type to Category2CATEGORY_IDAppraisal Category IDnvarchar80
94T77RCF_QA_GROUPQuestionnaire Groups3CATEGORY_IDAppraisal Category IDnvarchar80
TOPExpense-Related Billing
95PRSD_DMRP_ACC_CHEngagement Mgmt: Accrual Characteristics for DMR Lines30CATEGORY_IDCategory IDnvarchar200
TOPIncentive and Commission Management ICM
96A197A1975CATEGORY_IDID categoríanvarchar200
97YCRM01_B_VAR_OBJVariants for Commission Case Object Data19CATEGORY_IDCategory IDnvarchar200
98YCRM01_DOCVACommission Document, Valuation7CATEGORY_IDCategory IDnvarchar200
99YCRM01_OBJCommission Case Object Data9CATEGORY_IDCategory IDnvarchar200
100YHITEC_B_VAR_OBJVariants for Commission Case Object Data6CATEGORY_IDCategory IDnvarchar200
101YHITEC_DOCRECommission Document, Remuneration and Liability13CATEGORY_IDCategory IDnvarchar200
102YHITEC_DOCVACommission Document, Valuation6CATEGORY_IDCategory IDnvarchar200
103YHITEC_OBJCommission Case Object Data8CATEGORY_IDCategory IDnvarchar200
104YTEL05_B_VAR_OBJVariants for Commission Case Object Data18CATEGORY_IDCategory IDnvarchar200
105YTEL05_DOCVACommission Document, Valuation6CATEGORY_IDCategory IDnvarchar200
106YTEL05_OBJCommission Case Object Data21CATEGORY_IDCategory IDnvarchar200
TOPNetWeaver Demonstration
107SDEMO_PDSAP NetWeaver Demo Model - Product5CATEGORY_IDCategory IDnvarchar400
TOPPortfolio Management
108/RPM/CAP_B_ASSGNCapacity Assignment4CATEGORY_IDCapacity Categorynvarchar150
TOPPost Processing Framework Adapter
109/BOFU/CPPFOC_CATOutput Management: Category table2CATEGORY_IDDocument Category Identifiernvarchar30
110/BOFU/CPPFOC_C_TOutput Management: Text table for /BOFU/CPPFOC_CAT2CATEGORY_IDDocument Category Identifiernvarchar30
111/BOFU/C_PPF_ACTAction Settings: Supplementary data 4 PPF Action def5CATEGORY_IDDocument Category Identifiernvarchar30
TOPPublic Sector Contract Accounts Receivable and Payable
112DPSOB_UPDOWNLOADContract Object: Mapping Up and Download4CATEGORY_IDCategory IDnvarchar200
TOPRevenues and Earnings
113AD01DLIDynamic items (DI)41CATEGORY_IDCategory IDnvarchar200
TOPSearch
114CRMD_SHORTCUTCRM Shortcuts13CATEGORY_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPTalent Management
115T77TMC_PRC_TMPL(Obsolete) Assignment of Templates to Processes6CATEGORY_IDAppraisal Category IDnvarchar80
116T77TMC_P_TAssignment of Templates to Processes5CATEGORY_IDAppraisal Category IDnvarchar80