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

128 columns | Print definition?ERP 6.0  | MODIF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/X164Name of Items in Field Selection Definitions4MODIFModification group 1nvarchar30
2/OPT/Y164Name of Items in Field Selection Definitions4MODIFModification group 1nvarchar30
3/OPT/Z164Name of Items in Field Selection Definitions4MODIFModification group 1nvarchar30
4/ORS/TMODPName of Items in Field Selection Definitions4MODIFModification group 1nvarchar30
5J_3RFREP_ADP_XXML Data Provider Parameters of Reporting Object6MODIFValue Modifierint100
6P2RC_CHVSHR-CH: Payroll result insurance11MODIFInsurance groupingnvarchar20
7T510LStep Table3MODIFPayroll Modifiernvarchar20
8T510YSpecial Rules for Wage Type Generation2MODIFModifier T510Ynvarchar20
9T512CWage Types to be Distributed2MODIFCountry Groupingnvarchar20
10T555SPDC Record Type Conversion2MODIFModifier for PDC PC uploadnvarchar20
11T5A7SSwitch Table for PCALZ Checks2MODIFOrganizational Grouping for PCALZ Checknvarchar50
12T5CS7_CEHR-CH-CE: Grouping for Insurances CE4MODIFInsurance groupingnvarchar20
13T5D0CAbsence Distribution2MODIFEmployee Grouping for Absence Valuationnvarchar20
14T5D1NCalculation of HI Amount2MODIFHI modifiernvarchar20
15T5D1USI Processing3MODIFSI Modifiernvarchar20
16T77KZGRParameters for Grossing Up Taxes and Contributions3MODIFGrouping for Gross-Upnvarchar20
17T7AE16Absence Distribution UAE5MODIFEmployee Grouping for Absence Valuationnvarchar20
18T7KW09Absence Distribution Kuwait5MODIFEmployee Grouping for Absence Valuationnvarchar20
19T7OM28Absence Distribution Oman5MODIFEmployee Grouping for Absence Valuationnvarchar20
20T7QA16Absence Distribution Qatar5MODIFEmployee Grouping for Absence Valuationnvarchar20
21T7RU51AV_PRelation between Year and WType for income for this year3MODIFCalculation Modifiernvarchar40
22T7RU554SAdditional property of SocInsurance Absence Types6MODIFCalculation Modifiernvarchar40
23T7RU_DISCENDDetermine End Dates of Disciplinary Measures4MODIFPersonal Modifiernvarchar40
24T7SA16Absence Distribution KSA5MODIFEmployee Grouping for Absence Valuationnvarchar20
25T7SAPBS31Absence Distribution KSA Public Sector6MODIFEmployee Grouping for Absence Valuationnvarchar20
26T7SAPBS32Absence Distribution KSA Public Sector6MODIFEmployee Grouping for Absence Valuationnvarchar20
27T7SI04Absence valuation rule additional properties2MODIFEmployee Grouping for Absence Valuationnvarchar20
28TBLP_MODOItems in Field Selection Definitions2MODIFModification group 1nvarchar30
29TBLP_MODPName of Items in Field Selection Definitions3MODIFModification group 1nvarchar30
30TMODOItems in Field Selection Definitions2MODIFModification group 1nvarchar30
31TMODPName of Items in Field Selection Definitions3MODIFModification group 1nvarchar30
TOPActual CostingMaterial Ledger
32MLPPMaterial Ledger Document: Posting Periods and Quantities15MODIFType of BOM itemnvarchar10
TOPApplications
33MDG_ECC_CUST_FGAttribution Entity/DB/Modification group (Customer)8MODIFModification group 1nvarchar30
TOPAustria
34T5A0PPersonnel Area/Subarea AT10MODIFGrouping for Multiple Assignment of Municipal Taxnvarchar50
35T5A9MMultiple Assignment for Municipal Tax2MODIFGrouping for Multiple Assignment of Municipal Taxnvarchar50
36T5A9NMultiple Assignment for Municipal Tax (Name)2MODIFGrouping for Multiple Assignment of Municipal Taxnvarchar50
TOPBrazil
37T7BR0ASplit of absence valuation periods2MODIFEmployee Grouping for Absence Valuationnvarchar20
38T7BR0FThird-party payment assignment2MODIFEmployee Grouping for Absence Valuationnvarchar20
39T7BR4CWage types for leave valuation2MODIFEmployee Grouping for Absence Valuationnvarchar20
40T7BRWTAssignment of wage types for absence in double2MODIFEmployee Grouping for Absence Valuationnvarchar20
TOPCanada
41T5K0CAbsence Breakdown2MODIFEmployee Grouping for Absence Valuationnvarchar20
42T5KYRAssociation of wage type with registration number, Canada3MODIFPayroll Modifiernvarchar20
43T5UBX_GTL_AWARTProcessing group for absence types5MODIFTextnvarchar20
44T5UBX_GTL_SUBTYProcessing group definition for Beneficiaries4MODIFTextnvarchar20
TOPConstruction Industry
45T5DB9Construction Pay Evaluation Records for Social Fund Proc.11MODIFModification Status for Evaluation Records SFP Constructionnvarchar10
TOPContract Accounts Receivable and Payable
46TFK004MField name allocation in FI-CA -> FI field selection item1MODIFModification group 1nvarchar30
TOPCustomer Enhancements
47CUATEXTSModifications of GUI Interface: Menu Texts Changed by Cust.9MODIFFunction is flagged for user modificationnvarchar10
TOPFinancial Accounting
48TMODUCross Reference Field Name - MODIF12MODIFModification group 1nvarchar30
TOPGreat Britain
49T5G_ERPENAbsence Valuation3MODIFEmployee Grouping for Absence Valuationnvarchar20
TOPHong Kong
50T7HK2NSource of pre-prorated calc. base for retirement plan3MODIFRetirement plan grouping for pre-prorated calc. basenvarchar20
TOPIndonesia
51T7ID0AAbsence Split Assignment3MODIFEmployee Grouping for Absence Valuationnvarchar20
52T7ID0LContinued Absence Linking3MODIFEmployee Grouping for Absence Valuationnvarchar20
TOPInformation System
53TCNDBProfile: Database parameters in Project Info System33MODIFCheckboxnvarchar10
54TCNDB_PSJTProfile: as TCNDB, only for verification of LDB PSJ!!33MODIFCheckboxnvarchar10
TOPIreland
55T7IEAIrish PRSI Calculation and Absence Valuation3MODIFEmployee Grouping for Absence Valuationnvarchar20
TOPItaly
56T5ITI8Old evalution basis for absences3MODIFEmployee Grouping for Absence Valuationnvarchar20
57T5ITI9Table to split AB2MODIFEmployee Grouping for Absence Valuationnvarchar20
58T5ITIN0INAIL table to update group data15MODIFnvarchar10
59T5ITIN1Contribution INAIL table12MODIFnvarchar10
60T5ITIQEvalution rules for reimbursements and integrations2MODIFEmployee Grouping for Absence Valuationnvarchar20
61T5ITIRMaximum number of days for integration and reimbursement2MODIFEmployee Grouping for Absence Valuationnvarchar20
62T5ITITSpecial parameters for grace2MODIFEmployee Grouping for Absence Valuationnvarchar20
63T5ITIUGeneral parameters for grace2MODIFEmployee Grouping for Absence Valuationnvarchar20
TOPKorea
64T7KRS2Separation payment average calculation period5MODIFPayroll Modifiernvarchar20
65T7KRS6Cumulation method4MODIFPayroll Modifiernvarchar20
66T7KRS8Service period calculation method4MODIFPayroll Modifiernvarchar20
TOPLoans Management
67TDA12Loans master data field control2MODIFModification group 1nvarchar30
68TDCONDVER_FPCondition Verfier: Field Item Customizing2MODIFModification group 1nvarchar30
TOPMDG Business Partner Central Part
69MDG_ECC_BPFLDMAPMapping of CVI-structures to modif-groups6MODIFModification group 1nvarchar30
TOPMDG Supplier Central Parts
70MDG_BS_SUPPL_FGAttribution Entity/DB/Modification group (Supplier)8MODIFModification group 1nvarchar30
TOPNorway
71T5VA6Norwegian absence evaluation rules2MODIFEmployee Grouping for Absence Valuationnvarchar20
TOPPayroll
72T5T0CPartitioning of absences2MODIFEmployee Grouping for Absence Valuationnvarchar20
73T7BG0CPartitioning of absences2MODIFEmployee Grouping for Absence Valuationnvarchar20
74T7SI0CPartitioning of absences2MODIFEmployee Grouping for Absence Valuationnvarchar20
75T7SK0CPartitioning of absences2MODIFEmployee Grouping for Absence Valuationnvarchar20
76T7UAADP3MODIF??????????? ??? ????????? ?????????nvarchar20
77T7UAD13MODIFnvarchar20
TOPPayroll General Parts
78T510JConstant Valuations3MODIFPayroll Modifiernvarchar20
79T51D1Limits for Deductions3MODIFPayroll Modifiernvarchar20
80T7CCE_CUM_RT_PERCumulate Wage Types from RT in RT_PERSON4MODIFEmployee Grouping for Wage Type Cumulation in RT_PERSONnvarchar20
TOPPegging, Grouping, and Distribution
81TBLP_MODUCross Reference Field Name - MODIF12MODIFModification group 1nvarchar30
TOPPersonnel Administration
82T7CO02Social insurance general parameters3MODIFPayroll Modifiernvarchar20
83T7CO07Absence general configuration4MODIFGrouper by employee typenvarchar20
84T7CO21Provision calculation parameters2MODIFGrouper by employee typenvarchar20
85T7CO22Calculation functions2MODIFGrouper by employee typenvarchar20
86T7CO25Calculation parameters for social benefits2MODIFGrouper by employee typenvarchar20
87T7CO26Employee grouping for calculation types2MODIFGrouper by employee typenvarchar20
88T7CO27Output item for settlement calculation and provisions2MODIFGrouper by employee typenvarchar20
89T7CO29Basics for benefits calculation2MODIFGrouper by employee typenvarchar20
90T7CO33Concept by which the payments are advanced2MODIFGrouper by employee typenvarchar20
TOPPersonnel Management
91/BKC/S21_CUSREXC&T! - Definition of user exits for comparison programs2MODIFC&T! - Modifier for user exitsnvarchar20
92/BKC/S21_CUSREXTC&T! - Texts of user exits of comparison programs2MODIFC&T! - Modifier for user exitsnvarchar20
93/BKC/S21_FLD_MAPC&T! - Field mapping for data transfer2MODIFC&T! - Modifier for field mappingnvarchar20
94/BKC/S21_TAB_MAPC&T! - Table mapping for data transfer2MODIFC&T! - Modifier for table mappingnvarchar20
95/BKC/S21_USREXC&T! - Definition of user exits for data conversion2MODIFC&T! - Modifier for user exitsnvarchar20
96/BKC/S21_USREX_TC&T! - Texts of user exits (copy programs)2MODIFC&T! - Modifier for user exitsnvarchar20
TOPPersonnel Time Management
97T510PPremium Table2MODIFPersonnel subarea grouping for premiumsnvarchar20
98T554CAbsence Valuation3MODIFEmployee Grouping for Absence Valuationnvarchar20
99T555YProcessing Type/Time Type According to Att./Absence Class3MODIFTime type determination groupnvarchar20
100T555ZTime Type Determination3MODIFTime type determination groupnvarchar20
101T569REarliest Recalculation Dates for Time Management2MODIFModifier for determining earliest recalculation datenvarchar20
102T599YConvert External Wage Types3MODIFPayroll Modifiernvarchar20
103T599ZTime Wage Types to Third-Party Systems3MODIFPayroll Modifiernvarchar20
TOPPublic sector Sweden
104T5S0Q_CEAbsence split rules for SNABC2MODIFEmployee Grouping for Absence Valuationnvarchar20
TOPReuse Services for Country Development
105T599ETime-Dependent Rounding for Operation RNDC9MODIFField parameternvarchar50
TOPRussia
106T7RUG0HR: Garnishment Order Types16MODIFGarnishment Groupingnvarchar20
107T7RUG3Rules for Calculation of Garnishment Order Types2MODIFGarnishment Groupingnvarchar20
108T7RUGVRules for Calculation of garnishment order type3MODIFGarnishment Groupingnvarchar20
109T7RUT_XABCover processing to refine AB in RUNAB6MODIFEmployee Grouping for Absence Valuationnvarchar20
TOPSAP Query
110AQGTBSAP Query: Texts for User Groups4MODIFSAP Query (S): Modification numbernvarchar40
111AQGTQSP Query: Texts for Queries6MODIFSAP Query (S): Modification numbernvarchar40
112AQGTSSAP Query: Texts for Functional Areas5MODIFSAP Query (S): Modification numbernvarchar40
113AQLTQSP Query: Texts for Queries7MODIFSAP Query (S): Modification numbernvarchar40
114AQLTSSAP Query: Texts for Functional Areas6MODIFSAP Query (S): Modification numbernvarchar40
TOPSingapore
115T5R3AHR-SG: AWS Union Subscription Rates3MODIFHR-SG: Modifier for AWS union subscription ratenvarchar10
TOPSocial Insurance
116T5D18Processing of Assessment Thresholds3MODIFSI Modifiernvarchar20
TOPSwitzerland
117T5CS7HR-CH: Premium Rates for Insurance4MODIFInsurance groupingnvarchar20
118T5CS8HR-CH: Texts for Contribution Rates for Insurance5MODIFInsurance groupingnvarchar20
119T5CSCHR-CH: Payroll Unit: Voluntary Accident Insurance6MODIFInsurance groupingnvarchar20
120T5CSDHR-CH: Payroll Unit - Sickness Indemnity Insurance6MODIFInsurance groupingnvarchar20
121T5CSIGrouping for Insurances2MODIFInsurance groupingnvarchar20
122T5CSITGrouping for Social Insurance Switzerland3MODIFInsurance groupingnvarchar20
123T5CSXHR-CH: Payroll unit: Customer insurance 16MODIFInsurance groupingnvarchar20
124T5CSYHR-CH: Payroll unit: Customer insurance 26MODIFInsurance groupingnvarchar20
125T5CSZHR-CH: Payroll unit: Customer insurance 36MODIFInsurance groupingnvarchar20
TOPTaiwan
126T7TW50Rate for multiple payment4MODIFEmployee grouping for multiple paymentnvarchar20
127T7TWABAbsence Split Assignment3MODIFEmployee Grouping for Absence Valuationnvarchar20
TOPTransaction Manager
128TMODVField Selection: Assign Fields to Field Groups2MODIFModification group 1nvarchar30