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

134 columns | Print definition?ERP 6.0  | RATING

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/TRB_ECF_PCORBD ECF - Provision Collateral24RATINGRBD: Credit Standing of Collateral Providernvarchar30
2/IBS/TRB_ECF_VCORBD ECF - Value Adjustment - Collateral22RATINGRBD: Credit Standing of Collateral Providernvarchar30
3/IBS/TRB_ECH_PCORBD ECF - Provision History - Collateral25RATINGRBD: Credit Standing of Collateral Providernvarchar30
4/IBS/TRB_ECH_VCORBD ECF - Value Adjustment History - Collateral23RATINGRBD: Credit Standing of Collateral Providernvarchar30
5/IBS/TRB_ECI_CORBD ECF - Import Table for Collateral18RATINGRBD: Credit Standing of Collateral Providernvarchar30
6/SOMO/JOBMON14Job metric information21RATINGtinyint30
7CNVTDMS_01_EVALTable to hold From Dates and their Evaluation4RATINGDummy for B20 int1 (Local Everywhere)tinyint30
8FTBB_YC_REF_ENTAttributes of Reference Entity7RATINGRatingnvarchar100
9GRFNQRATINGQustion Ratings3RATINGAnswer ratingnvarchar20
10GRFNQRATINGTQustion Rating Texts4RATINGAnswer ratingnvarchar20
11HRPAD790Additional Data Relationship 'Has Curric BundleType Element'6RATINGCourse Type Element Alternative: Rankingnvarchar20
12HRPAD791Additional Data Relationship 'Has Curriculum Bundle Element'5RATINGCourse Type Element Alternative: Rankingnvarchar20
13HRPAD792Additional Data Relationship 'Has Subscription_Type Element'5RATINGCourse Type Element Alternative: Rankingnvarchar20
14HRPAD794Additional Data Relationship 'Has MixandMatch Type Element'5RATINGCourse Type Element Alternative: Rankingnvarchar20
15HRPAD795Additional Data Relationship 'Has MixandMatch Element'5RATINGCourse Type Element Alternative: Rankingnvarchar20
16HRPBSUSRIFBONRIF Bonus Years for Federal Performance Appraisals5RATINGRating of an Appraisal Elementdecimal153
17HRRCF_D_CHANINFOApplication Table to Store Channel Rating and Efficiency4RATINGRating of Posting Channelnvarchar10
18SNWD_REV_ITEMEPM: Review Item Table6RATINGEPM: Review Ratingdecimal42
19SNWD_REV_RATINGEPM: Review Rating Table6RATINGEPM: Review Ratingdecimal42
20T5UPBSTC41Assign Classifications to Qualification Groups6RATINGProficiency of a Quality Scalenvarchar40
21TFW_OBJECT_RATNGTable to save rating of an object9RATINGRating information for the feature of a business objecttinyint30
22TISSR_RATING_HBHistorie des Wertpapier-Ratings10RATINGRatingeinstufung des Fondsnvarchar30
23TZ01Table for maintenance of ratings3RATINGRatingnvarchar30
24ZZHR_DOBJEDomaine - objectif économique5RATINGValorisation d'un élément d'évaluationdecimal153
TOPAppraisal Systems
25HRT1045Infotype 1045 Table Section10RATINGRating of an Appraisal Elementdecimal153
26HRT1048Table Section of Infotype 10485RATINGProficiency of a Quality Scalenvarchar40
TOPBank Components
27JBKLOBJ1Segment Table for Financial Transactions, CL Part6RATINGRatingnvarchar30
TOPBasis Components
28/XFT/INV_QInvoice receipt queue: Header5RATINGRatingnvarchar40
29/XFT/INV_Q_SInvoice receipt queue: Header5RATINGRatingnvarchar40
TOPBusiness Partner
30BP1010Creditworthiness Data14RATINGRatingnvarchar30
31BPCC_MIGCS_MAPAssignment of Rating Procedure/Rating to Institution/Rating3RATINGRatingnvarchar30
32RATCE_RATINGRating Procedure4RATINGRatingnvarchar100
33RATCE_RATING_TXTTexts for Ratings5RATINGRatingnvarchar100
34RATCE_SET_RATINGAssignment of Rating to Rating Set4RATINGRatingnvarchar100
35RATINGSRatings7RATINGRatingnvarchar100
36TP06Business Partner: Rating2RATINGRatingnvarchar30
37TP06TBusiness Partner: Rating Description3RATINGRatingnvarchar30
TOPCommunication Services Mail, Fax, SMS, Telephony
38SXCONVERTSAPconnect: Conversion functions4RATINGSAPconnect: Ratingnvarchar10
TOPContract Billing
39TLOSSPARAMParameters for Formula-Based Calc. of Power Transformer Loss3RATINGPower Transformer: Ratingnvarchar110
40TLOSSZONESPower Transformer Loss by Consumption Zones3RATINGPower Transformer: Ratingnvarchar110
TOPDefault Risk and Limit System
41KLARPDefault Risk Line Items15RATINGRatingnvarchar30
42KLAUSFWKTDefault Risk Probabilities4RATINGRatingnvarchar30
43KLRATINGRRFZUAssignment of Rating to Recovery Rate Determination2RATINGRatingnvarchar30
44KLREPRisk Line Items14RATINGRatingnvarchar30
45KLSDCPROT3Log Gen. for Single Transaction Check: Result in ALV Format20RATINGRatingnvarchar30
46KLSI06Global Collateral (Assignment)14RATINGRatingnvarchar30
47KLSI06_BAKBackup for Euro Changeover for Global Collateral (Assignmt)14RATINGRatingnvarchar30
48VTBLIDLimit: Details of Utilizations (Single Records)19RATINGRatingnvarchar30
49VTBLSLimits: Mapping Logical - Physical Keys16RATINGRatingnvarchar30
50VTBLSDGlobal Collateral: Utilizations - Details19RATINGRatingnvarchar30
TOPDevice Management
51EGERHHistorical Data of ISU Device Master Record20RATINGPower Transformer: Ratingnvarchar110
52EGERRDevice data: Info record for point of delivery - historical38RATINGPower Transformer: Ratingnvarchar110
53ETYPDev. Cat.: IS-U Additional Material Data60RATINGPower Transformer: Ratingnvarchar110
54TE1002Combination of Rating, Primary, and Secondary Voltage2RATINGPower Transformer: Ratingnvarchar110
55TE1002TCombination of Rating, Primary, and Secondary Voltage (Text)3RATINGPower Transformer: Ratingnvarchar110
TOPE-Recruiting
56HRP5141DB Table for Infotype 514139RATINGOverall Result for Rating of Questionnairenvarchar10
TOPGovernance, Risk and Compliance
57GRFNDMFPCASDataMart: Facts PC Case13RATINGRatingnvarchar10
58GRFNDMFPCCNDataMart: Facts PC Control11RATINGRatingnvarchar10
59GRFNDMFPCECDataMart: Facts ELC10RATINGRatingnvarchar10
60GRFNDMFPCSPDataMart: Facts PC Subprocess10RATINGRatingnvarchar10
TOPIndustrial Hygiene and Safety
61CCIHC_AY05EHS: Assignment Risk to Rating5RATINGExposure Ratingnvarchar30
62CCIHC_AY06EHS: Analysis Method Questionnaire - Rating7RATINGExposure Ratingnvarchar30
63CCIHC_IH07EHS: Exposure Rating2RATINGExposure Ratingnvarchar30
64CCIHC_IH09EHS: Categorized Exposure Rating3RATINGExposure Ratingnvarchar30
65CCIHC_IH10EHS: Categ. Exposure Rating - Language-Dependent Description4RATINGExposure Ratingnvarchar30
66CCIHC_QT06EHS: Assignment Measured Value-Reference Value and Rating5RATINGExposure Ratingnvarchar30
67CCIHT_AD08EHS: Customer Analysis Method 08 Detail Data19RATINGExposure Ratingnvarchar30
68CCIHT_AD09EHS: Customer Analysis Method 09 Detail Data19RATINGExposure Ratingnvarchar30
69CCIHT_AD10EHS: Customer Analysis Method 10 Detail Data19RATINGExposure Ratingnvarchar30
70CCIHT_AM01EHS: Customer Analysis Method 0119RATINGExposure Ratingnvarchar30
71CCIHT_AM02EHS: Customer Analysis Method 0219RATINGExposure Ratingnvarchar30
72CCIHT_AM03EHS: Customer Analysis Method 0319RATINGExposure Ratingnvarchar30
73CCIHT_AM04EHS: Customer Analysis Method 0419RATINGExposure Ratingnvarchar30
74CCIHT_AM05EHS: Customer Analysis Method 0519RATINGExposure Ratingnvarchar30
75CCIHT_AM06EHS: Customer Analysis Method 0619RATINGExposure Ratingnvarchar30
76CCIHT_AM07EHS: Customer Analysis Method 0719RATINGExposure Ratingnvarchar30
77CCIHT_AM08EHS: Customer Analysis Method 0819RATINGExposure Ratingnvarchar30
78CCIHT_AM09EHS: Customer Analysis Method 0919RATINGExposure Ratingnvarchar30
79CCIHT_AM10EHS: Customer Analysis Method 1019RATINGExposure Ratingnvarchar30
80CCIHT_ANMLEHS: Analysis Method - Meas. Value - Ref. Value Comparison45RATINGExposure Ratingnvarchar30
81CCIHT_ANNCEHS: Analysis Method - Standardized Criteria21RATINGExposure Ratingnvarchar30
82CCIHT_ANQSEHS: Analysis Method Questionnaire20RATINGExposure Ratingnvarchar30
83CCIHT_ANSEEHS: Analysis Method - Summated Rating (Details)45RATINGExposure Ratingnvarchar30
TOPMaintenance Orders
84/MRSS/D_SQP_ESTREmployee Profile - Structured Qualifications8RATINGSkill Levelnvarchar40
85/MRSS/D_SQP_RSTRRequirements Profile : Structured Qualifications7RATINGSkill Levelnvarchar40
TOPManagement of Internal Controls
86FOPCCASETEAttributes: Testing9RATINGRatingnvarchar10
TOPObjective Setting and Appraisals
87HRP5029DB Table for Infotype 502920RATINGCascading Goals: Rating Valueint100
TOPOffer and Rental Request
88TIVORHMCMPATTRComparison Pairs for Attrib. of Person and Accommod.Profiles6RATINGRanking of Comparisonnvarchar20
TOPPerformance Assessment Workbench
89SLS_PRESPAW - Person Results Structure40RATINGScale rating of a proficiency assigned to qualificationnvarchar40
90SLS_QLOGPAW - Qualification Generation Log22RATINGScale rating of a proficiency assigned to qualificationnvarchar40
91SLS_TTYQUPAW - Test Type Qualifications10RATINGScale rating of a proficiency assigned to qualificationnvarchar40
TOPProcess Controls
92GRPCCASETEAttributes: Testing10RATINGRatingnvarchar10
93GRPCQANSWERSurvey question answers5RATINGAnswer ratingnvarchar20
94GRPCRATINGVALRating Set Value3RATINGAttribute Valuenvarchar100
95GRPCRATINGVALTText table for GRPCRATINGVAL4RATINGAttribute Valuenvarchar100
TOPQualifications and Requirements
96T77SPHR-PD: Quality Scale Proficiencies3RATINGProficiency of a Quality Scalenvarchar40
97T77SP_DESCRPA-PD: Proficiency Descriptions for a Quality Scale3RATINGProficiency of a Quality Scalenvarchar40
98T77SP_DESCRIPTPA-PD: Proficiency Descriptions for a Quality Scale (Text)4RATINGProficiency of a Quality Scalenvarchar40
99T77TPHR-PD: Proficiency Texts for Quality Scale4RATINGProficiency of a Quality Scalenvarchar40
TOPRecipe Development
100/PLMI/LBL_LPLANGTarget Locations: Languages Assigned to Location of Profile3RATINGRatingnvarchar400
101/PLMI/LBL_LPLOCTarget Locations Assigned to a Profile3RATINGRatingnvarchar400
TOPRegulatory reporting for insurance companies
102TISSR_RATING_DSRatingeinstufung je Fonds für Durchsicht Fonds7RATINGRatingeinstufung des Fondsnvarchar30
103TISSR_RATING_DSRRatingeinstufung je Fonds für Durchsicht Fonds8RATINGRatingeinstufung des Fondsnvarchar30
104TISSR_RATING_HHistorie des Wertpapier-Ratings9RATINGRatingeinstufung des Fondsnvarchar30
TOPResourcen Management
105RMSLA_DILIHeader Data of Diet Label List7RATINGRatingnvarchar400
106RMSLA_HDHTime-Dependent Header Data of Label Set9RATINGRatingnvarchar400
107RMSLA_INLIHeader Data of Ingredient Label List7RATINGRatingnvarchar400
108RMSLA_LOCTarget Locations for Label Set4RATINGRatingnvarchar400
109RMSLA_NULIHeader Data of Nutrition Label List9RATINGRatingnvarchar400
110RMSLA_USAGELabel Set Usage5RATINGRatingnvarchar400
TOPRisk Assessment
111EHHSSD_RSK_OELOEL Comparison Values11RATINGExposure Rating Codenvarchar30
TOPSAP Records Management
112SRM_INDX1Table for Queue Elements14RATINGIcon in text fields (substitute display, alias)nvarchar40
113SRM_INDX3Table for Deleted Queue Elements14RATINGIcon in text fields (substitute display, alias)nvarchar40
TOPService Data Download
114/BDL/BDLSERTRANService Definition, Important information to functions11RATINGStatus of objectnvarchar10
115/BDL/HEADNachbau: DSVAS: Session data (header)12RATINGnvarchar10
116/BDL/STABCopy of structure of table dsvassessadmin8RATINGSingle-Character Indicatornvarchar10
117/BDL/STAB2Copy of structure of table dsvassessadmin8RATINGSingle-Character Indicatornvarchar10
118BDLHEADNachbau: DSVAS: Session data (header)12RATINGnvarchar10
119BDLSERTRANImportant information to functional modules (download)10RATINGStatus of objectnvarchar10
120BDLSESSIONHEADNachbau: DSVAS: Session data (header)12RATINGnvarchar10
121DSVAS_STABCopy of structure of table dsvassessadmin8RATINGSingle-Character Indicatornvarchar10
TOPTraining Management
122HRPAD612Additional Data Relationship 'Has Curriculum Element'5RATINGCourse Type Element Alternative: Rankingnvarchar20
123HRPAD613Additional Data Relationship 'Has Curriculum Element'5RATINGCourse Type Element Alternative: Rankingnvarchar20
TOPTransaction Management
124VTBRATINGRating for Financial Transaction6RATINGRatingnvarchar30
TOPTransaction Manager
125VWPPOOLRATINGRating for an Asset Pool5RATINGRatingnvarchar30
126VWPRATINGRating5RATINGRatingnvarchar30
TOPTreasury
127VWPANLAAsset master for securities48RATINGRatingnvarchar30
TOPValue Adjustment
128/IBS/CRB_IASCOLRBD Collateral Valuation per IAS3RATINGRBD: Credit Standing of Collateral Providernvarchar30
129/IBS/CRB_IASHDGRBD Hedge Valuation per IAS3RATINGRBD: Credit Standing of Collateral Providernvarchar30
130/IBS/TRB_IASCOLRBD IAS-GATE Collateral Data6RATINGRBD: Credit Standing of Collateral Providernvarchar30
131/IBS/TRB_SCHISTRBD IAS - History Value Adjustment Collateral9RATINGRBD: Credit Standing of Collateral Providernvarchar30
132/IBS/TRB_SCHISTRRBD IAS - History Provision Collaterals18RATINGRBD: Credit Standing of Collateral Providernvarchar30
133/IBS/TRB_SHCOLRBD IAS - Value Adjustment Collateral8RATINGRBD: Credit Standing of Collateral Providernvarchar30
134/IBS/TRB_SHCOL_RRBD IAS - Provision Collaterals17RATINGRBD: Credit Standing of Collateral Providernvarchar30