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  | PTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_MSG_TTable to store messages3PTYPEProcess Typenvarchar30
2/SAPPSSRM/MQ_PERIBU PS: "Maximum Quantity per Period" Periods5PTYPEPeriod Typenvarchar10
3/SAPSRM/D_PARMSTParticipant Master11PTYPEType of a Participant of a SRM Surveynvarchar10
4/SAPSRM/D_SURPARSurvey Participant12PTYPEType of a Participant of a SRM Surveynvarchar10
5/SAPSRM/TT_DATATest Data for SRM Test Tool5PTYPEBusiness Transaction Typenvarchar40
6P2RK_WTDTPayroll Results - Wage type processing information6PTYPEPayroll Results - Canada - Process typenvarchar10
7P2RM_MPENSPrivate Pension (DK)8PTYPEPension Categoriesnvarchar20
8T5FN4DS005S408PTYPENot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
9T5M2P!Not Used: Pension Type (Denmark)3PTYPEPension categorynvarchar20
10T7CNRM_PSTATSReporting Period Status5PTYPEReporting Typenvarchar10
11T7CNRM_REPORTReport12PTYPEReporting Typenvarchar10
12T7CNRM_RPDATAKReport Data Key5PTYPEReporting Typenvarchar10
13T7CNRM_RPTPRDReporting Period Definition2PTYPEReporting Typenvarchar10
14T7QA86Allowance Contribution Rule4PTYPESI Contribution Period Typenvarchar10
15TSP07Spool: Paper used by the printer1PTYPESpool: Device type namenvarchar80
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
16DDPATHDD: Definition of access paths3PTYPEType of access pathnvarchar10
TOPArchiveLink
17OAPRISAP ArchiveLink: Temporary table for print parameters25PTYPESpool Parameter: Type of Spool Requestnvarchar120
TOPAustralia
18T5QRSTerminations Redundancy Payments Australia3PTYPERedundancy Payment Typenvarchar10
TOPBackground Processing
19TBTCPBackground Job Step Overview47PTYPEPrint: Type of spool requestnvarchar120
TOPBatch-Oriented Parallel Processing of Mass Data
20BANK_PP_TECHSETTechnical Parameters for Parallel Processing25PTYPESpool Parameter: Type of Spool Requestnvarchar120
TOPBusiness Planning and Simulation
21UPB_PS_DESIGNStructure of Planning Interfaces2PTYPEPlanning Applicationnvarchar40
22UPB_PS_DESIGN_TText Table of Planning Objects2PTYPEPlanning Applicationnvarchar40
23UPB_PS_NAMEBalance Sheet Planning Interfaces2PTYPEPlanning Applicationnvarchar40
24UPB_PS_NAME_TText Table of Planning Books2PTYPEPlanning Applicationnvarchar40
25UPB_PS_PROPAttributes of Planning Objects2PTYPEPlanning Applicationnvarchar40
TOPClaims Management
26ICLITEMClaim Item63PTYPETransaction Type in Procurement Processnvarchar40
27ICLITEMAUDamaged Vehicle77PTYPETransaction Type in Procurement Processnvarchar40
28ICLPARTSPParticipant: Vendor12PTYPETransaction Type in Procurement Processnvarchar40
29ICL_CINSTSERVOrder Type - Transaction Type3PTYPETransaction Type in Procurement Processnvarchar40
30ICSITEMClaim Item63PTYPETransaction Type in Procurement Processnvarchar40
31ICSITEMAUDamaged Vehicle77PTYPETransaction Type in Procurement Processnvarchar40
32ICSPARTSPClaim Participant: Vendor12PTYPETransaction Type in Procurement Processnvarchar40
33TICL056Internal Claim Type: Permitted Benefit Type31PTYPETransaction Type in Procurement Processnvarchar40
34TICL121Weighting, Prioritization of Evaluation Criteria2PTYPETransaction Type in Procurement Processnvarchar40
35TICL123Transaction Type for Procurement Process2PTYPETransaction Type in Procurement Processnvarchar40
36TICL123TTransaction Type Text for Procurement Process3PTYPETransaction Type in Procurement Processnvarchar40
37TICL125Permitted Roles per Transaction Type in Procurement Process2PTYPETransaction Type in Procurement Processnvarchar40
38TICL126Insurance Lines of Business and Their Procurement Processes3PTYPETransaction Type in Procurement Processnvarchar40
39TICL162Benefit Type Tree: Permitted Benefit Type31PTYPETransaction Type in Procurement Processnvarchar40
TOPClinical System
40N1PATEXi.s.h.med: Connectivity, External Partner5PTYPEConnectivity: Patient Categorynvarchar10
TOPCompany Pension Scheme Germany
41P01RBM_HEADERHeader Data: Pension Receipt Notifications8PTYPENotification Reasonnvarchar40
TOPCompensation Management
42T71C01Fixed Compensation Components6PTYPEPrerequisite compensation componentnvarchar40
43T71C02Variable Compensation Components8PTYPEPrerequisite compensation componentnvarchar40
44T71C03Stock Components9PTYPEPrerequisite compensation componentnvarchar40
TOPContract Accounts Receivable and Payable
45DFKKOPUSTAXIN00Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
46DFKKOPUSTAXIN01Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
47DFKKOPUSTAXIN02Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
48DFKKOPUSTAXIN03Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
49DFKKOPUSTAXIN04Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
50DFKKOPUSTAXIN05Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
51DFKKOPUSTAXIN06Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
52DFKKOPUSTAXIN07Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
53DFKKOPUSTAXIN08Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
54DFKKOPUSTAXIN09Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
55DFKKOPUSTAXIN10Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
56DFKKOPUSTAXIN11Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
57DFKKOPUSTAXIN12Basic Data for Tax Calculation - Telco Tax (U.S.A.)32PTYPEType of Postingnvarchar10
TOPCorporate Performance Monitor
58UMK_MB020Measure Hierarchy6PTYPEObject Typenvarchar10
59UMR_RI020Risk: Catalog Hierarchy4PTYPENode Typenvarchar10
TOPCross-Application Components
60J_5KFH_CLFORMLegal forms20PTYPESpool Parameter: Type of Spool Requestnvarchar120
61J_5KFH_LFHDRLegal form header44PTYPESpool Parameter: Type of Spool Requestnvarchar120
TOPDenmark
62PA0073HR Master Record: Infotype 0073 (Private Pensions - DK)31PTYPEPension Categoriesnvarchar20
63T5M7RText Table - Pension Types3PTYPEPension Categoriesnvarchar20
TOPEnd User Technology
64RSRA_PACKAGEScheduling Packages for the Report Agent30PTYPESpool Parameter: Type of Spool Requestnvarchar120
TOPExcise Duty
65/BEV2/ED917Table for Print Control23PTYPEPrint: Type of spool requestnvarchar120
TOPForms
66T514BPage Types for From Classes3PTYPEPage Type in Formnvarchar20
67T514RPage Type Texts4PTYPEPage Type in Formnvarchar20
TOPGreat Britain
68T5G10Pension Fund: OBSOLETE5PTYPEPension categorynvarchar10
69T5G30Pension Schemes7PTYPEPension scheme typenvarchar50
TOPIndustry-Specific Component Automotive
70DPSPPC_WD_ADDRMapping table: Formatting country - WD component/window4PTYPEPartner Typenvarchar30
TOPInformation System
71T044GValuation Adjustment Key10PTYPEPosting type for adjustment postingnvarchar10
TOPList Processing
72TPRI_PARABAP print parameter storage23PTYPEPrint: Type of spool requestnvarchar120
TOPLocalization
73J_3RS_CCD_FIPOSTPosting Rules for Customs Fees and Duties3PTYPEFees or Duties Posting Type in FInvarchar30
74J_3R_LFHDRLegal form header44PTYPESpool Parameter: Type of Spool Requestnvarchar120
TOPNorway
75T5VM1Pension type2PTYPEPension Typenvarchar20
76T5VM1TPension type text3PTYPEPension Typenvarchar20
77T5VM2Pension variant3PTYPEPension Typenvarchar20
TOPPayment Transactions
78FIBL_RPCODEMaster Data for Repetitive Code13PTYPECategory of Business Partner Receiving Paymentnvarchar20
79TFIBLOPAYOrigin of Online Payments12PTYPECategory of Business Partner Receiving Paymentnvarchar20
TOPPayroll General Parts
80T512QInformation in Fixed Positions4PTYPEPage type in formnvarchar20
TOPPerformance Assessment Workbench
81SLS_PTYPESPAW - Person Types related to HR Object-Types2PTYPEParticipant type (PAW)nvarchar20
TOPPortfolio Management
82/RPM/ITEM_DOperational item persisted data9PTYPEGroupnvarchar40
83RPM_ITEM_D_CDItem details - Pseudo table for change documents9PTYPEGroupnvarchar40
84RPM_PROJECTProject data6PTYPEGroupnvarchar40
85RPM_PROJ_TYPEProject Type3PTYPEGroupnvarchar40
86RPM_PROJ_TYPE_TProject Type4PTYPEGroupnvarchar40
TOPPortugal
87T5PP3HR-PT: Professional classification (CNP or CPP)3PTYPEHR-PT: Professional classification type (CNP or CPP)nvarchar10
TOPPrint and Output Management
88TSP06ASpool: Implemented format type of a device type1PTYPESpool: Device type namenvarchar80
TOPProcess Management
89CMX_XS_DB_PSXSteps: Parameter, Definition in DB Format SMALL9PTYPEXSteps: Parameter Typenvarchar10
90CMX_XS_DB_PSLXSteps: Parameter, LIVE Data in DB Format SMALL12PTYPEXSteps: Parameter Typenvarchar10
TOPProduct Safety
91CVCHDEHS: Assignment table for default printer24PTYPESpool Parameter: Type of Spool Requestnvarchar120
92CVDDHEHS: Report shipping orders93PTYPESpool Parameter: Type of Spool Requestnvarchar120
TOPProduction and Revenue Accounting
93OIU_ME_MREAD_DVMeasurement Reading Derivation5PTYPEMeasurement parameter typenvarchar10
94OIU_ME_MTYPE_CDMeasurement Type Calculation Detail4PTYPEMeasurement parameter typenvarchar10
TOPPublic Sector
95PA0495HR-PS-SG: Pensions Scheme25PTYPEPayment Optionnvarchar60
96T5RPBS8BDefine Superannuation Scheme Payment Option2PTYPEPayment Optionnvarchar60
97T5RPBS8BTText Table for Superannuation Scheme Payment Option3PTYPEPayment Optionnvarchar60
98T5RPBS8COBSOLETE(Pensions Scheme Payment Option Eligibility Crite)3PTYPEPayment Optionnvarchar60
99T5RPBS8EOBSOLETE (SG Public Sector Pensions Scheme Constants Tab)3PTYPEPayment Optionnvarchar60
100T5RPBS8HAssign Options, Components, Val. Model to Elig. Grouping3PTYPEPayment Optionnvarchar60
TOPRevenue
101OIUE2_ESCH_MDDProc 2.0 - Escheat - Mass Due Diligence Print Info39PTYPESpool Parameter: Type of Spool Requestnvarchar120
TOPRoyalty Reporting
102OIUREP_2014_REPMMS-2014 - Supplemental Reports From Report Executions28PTYPESpool Parameter: Type of Spool Requestnvarchar120
TOPShift Planning
103PSOLLShift Planning: Target Plan4PTYPEObject Typenvarchar20
TOPTariffs, Duties and Permits
104OIH_J1B_SSTADBrazil tax: Determines Accounts for posting Split of S. T.4PTYPEParcel typenvarchar20
TOPTools
105T52SMPHRPAY-Status Management: Default Values1PTYPEAssignment of Default Valuesnvarchar120
106T52SMPCHRPAY-Status Management: Categories for Default Values1PTYPEAssignment of Default Valuesnvarchar120
107T52SMPMHRPAY-Status Management: Default Values with Clients2PTYPEAssignment of Default Valuesnvarchar120
108T52SMPM_CHRPAY-Status Management:Default Values with Clients/Customer2PTYPEAssignment of Default Valuesnvarchar120
109T52SMP_CHRPAY-Status Management: Default Values1PTYPEAssignment of Default Valuesnvarchar120
TOPTravel Expenses
110T706FORM_BCKGRNDForm background4PTYPEPage Typenvarchar20
111T706FORM_FLDSInformation in fixed positions4PTYPEPage Typenvarchar20
TOPTreasury
112VTB_DFPRTDatafeed: Printer/Login Information for Asynchronous Users20PTYPEPrint: Type of spool requestnvarchar120
TOPVehicle Management System
113CVLC17VELO : Assignment of Vehicle Attributes to Actions4PTYPEField from the Header- or Item Part of the VLCACTDATAnvarchar10
TOPVenezuela
114T7VE90Rules for calculating compensation5PTYPEEmployment Termination Codenvarchar40
115T7VEPNNotice or seniority days2PTYPEEmployment Termination Codenvarchar40
TOPWithout Description
116RSRPRVARGROUPVariant groups for batch printing28PTYPESpool Parameter: Type of Spool Requestnvarchar120