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

190 columns | Print definition?ERP 6.0  | PERIO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000164000PSA for 0FI_AP_20 T90CLNT090 Vendor Balances10PERIOnvarchar30
2/BIC/B0000167000PSA for 0FI_AR_20 T90CLNT090 Customer Balances10PERIOnvarchar30
3/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items149PERIOnvarchar70
4/SAPF15/XXBPDKF15 FI DUMMY5PERIOnvarchar30
5AUATSettlement Document: Totals Segment Per Period3PERIOSettlement Periodnvarchar30
6CE1PR22Périm. résultat IDES5PERIOPériode/exercicenvarchar70
7CNVTDMS_05_CKML4Collect Table for Material Ledger5PERIOPeriodnvarchar30
8CNV_20100_COESDuplicate COES keys (target values)11PERIOPeriodnvarchar30
9FIEUD_MMINV_HSAFT:MM: Header table for XML Purchase Invoice13PERIOFiscal Periodnvarchar20
10FIKZD_CUST_DECLCustoms Declarations5PERIOQuarters Tax CISnvarchar20
11FITV_MEAL_ACCOMAdditional Amounts for Meals in Accommodations Receipts4PERIOTrip Period Numbernvarchar30
12FITV_NOT_CH_TRKey Fields of Temp. Non-Changeable Trips/Duty Allocation4PERIOTrip Period Numbernvarchar30
13GLE_ADB_OPEN_PERPeriods/Company Codes Without Current Average Balances5PERIOPosting periodnvarchar30
14J_1UF_REEI_XML_AXML table for J_1UF_REEI with User6PERIOFiscal Periodnvarchar20
15J_1UF_REP_XMLXML table for J_1UF_REP5PERIOFiscal Periodnvarchar20
16J_1UF_REP_XML_AXML table for J_1UF_REEI with User6PERIOFiscal Periodnvarchar20
17J_1UF_RES_XMLXML table for J_1UF_RES5PERIOFiscal Periodnvarchar20
18J_3RTTAXADVPMNTSAdvanced payments for russian transport tax7PERIOReporting Periodnvarchar10
19P2FI_GARGarnishment results Finland33PERIOGarnishment period fix amount.nvarchar50
20P2RB_PENSPensioner's data (B)5PERIOPeriodicitynvarchar10
21PA3340Infotype 334024PERIOCorrections infotype: incorporation period(s)nvarchar10
22PTRV_DELETE_LOGLog Table for Deleted Trips4PERIOTrip Period Numbernvarchar30
23T437DControl Parameter Plant for Repetitive Mfg6PERIOTime bucketnvarchar10
24T5BPBS02Description of payscale rule Jumps11PERIOPeriodicity of Jump (in Years)nvarchar20
25WFAFC_CALCPARAMSForecasting method parameters - Y*,Z* reserved for customers18PERIONumber of periods per seasonal cycledecimal30
TOPActual CostingMaterial Ledger
26CKMLMV003Process model: Receipts / mixing strategies4PERIOPosting periodnvarchar30
27CKMLMV004Process model: Withdrawals4PERIOPosting periodnvarchar30
28CKMLMV004WIPProcess Model: Deductions WIP4PERIOPosting periodnvarchar30
29MLWIPHDWIP Document in Material Ledger - Header10PERIOPeriodnvarchar30
TOPActual Payments and Forecast
30COFPDocument Lines (project cash management)8PERIOPeriodnvarchar30
TOPBasic Functions
31FPLABilling Plan12PERIORule for Origin of Next Billing/Invoice Datenvarchar20
32FPLAPOBilling Plan12PERIORule for Origin of Next Billing/Invoice Datenvarchar20
33FPLTBilling Plan: Dates16PERIORule for Origin of Next Billing/Invoice Datenvarchar20
34FPLTPOBilling Plan: Dates16PERIORule for Origin of Next Billing/Invoice Datenvarchar20
35TFPLABilling Plan Type9PERIORule for Origin of Next Billing/Invoice Datenvarchar20
36TFPLTDate Type for Billing Plan Type11PERIORule for Origin of Next Billing/Invoice Datenvarchar20
37VFPLABilling Plan12PERIORule for Origin of Next Billing/Invoice Datenvarchar20
38VFPLTBilling Plan: Dates16PERIORule for Origin of Next Billing/Invoice Datenvarchar20
TOPBelgium
39PA0504Pensioner's Advantage B32PERIOPeriodicitynvarchar10
40T5B22Periodicity2PERIOPeriodicitynvarchar10
41T5B2BPeriodicity Text3PERIOPeriodicitynvarchar10
42T5BVCSpecial contributions SI2PERIOPeriod of calculationnvarchar10
43T5BVMSI special contributions 19962PERIOPeriod of calculationnvarchar10
TOPBenefits
44PA0167HR Master Record: Infotype 0167 (Health Plans)45PERIOBenefit Period for Calculationsnvarchar20
45PA0168HR Master Record: Infotype 0168 (Insurance Plans)45PERIOBenefit Period for Calculationsnvarchar20
46PA0169HR Master Record: Infotype 0169 (Savings Plan)34PERIOBenefit Period for Calculationsnvarchar20
47PA0236HR Master Record: Infotype 0236 (Credit Plans)35PERIOBenefit Period for Calculationsnvarchar20
48PA0377HR Master Record: Infotype 0377 (Miscellaneous Plans)51PERIOBenefit Period for Calculationsnvarchar20
49PA0379HR Master Record: Infotype 0379 (Stock Purchase Plans)35PERIOBenefit Period for Calculationsnvarchar20
50T5UBHBenefit cost rule variant8PERIOBenefit Period for Calculationsnvarchar20
51T5UDMTo be deleted - no longer used!7PERIOBenefit Period for Calculationsnvarchar20
52T74FEBenefit employer contribution rule variant5PERIOBenefit Period for Calculationsnvarchar20
53T74FGBenefit employee contribution rule variant5PERIOBenefit Period for Calculationsnvarchar20
54T74FJBenefit credit rule variant5PERIOBenefit Period for Calculationsnvarchar20
55T74FMBenefit Standard Savings Selection23PERIOBenefit Period for Calculationsnvarchar20
56T74FPBenefit Standard Miscellaneous Selection25PERIOBenefit Period for Calculationsnvarchar20
57T74FQBenefit standard stock purchase selection9PERIOBenefit Period for Calculationsnvarchar20
58T74FWBenefit combined contribution limit14PERIOBenefit Period for Calculationsnvarchar20
TOPBrazil
59T7BRTRTransportation ticket8PERIOTransportation ticket frequencynvarchar10
TOPBusiness Package for Manager Self-Service FI
60FCOM_KFPRICEKey Figure Prices8PERIOPeriodnvarchar30
TOPBW Service API
61ROVERCUBE1Transaction Data for Verification Scenarios9PERIOFiscal Year / Periodnvarchar70
62ROVERCUBE3Transaction Data for Verification Scenarios (from 4.0B)9PERIOFiscal Year / Periodnvarchar70
TOPCompensation Management
63HRP1051DB Table for Infotype 1051 (Survey Results)23PERIOUnit of Time for Compensationnvarchar10
64T710SSurvey Data10PERIOUnit of Time for Compensationnvarchar10
TOPConstruction Progress Report
65/SAPPCE/TPNVConstruction Progress Report8PERIOPeriodnvarchar30
TOPCost Center Accounting
66T811DAllocations: Document Numbers6PERIOPosting periodnvarchar30
67T811DAAllocations: Dependent Document Numbers6PERIOPosting periodnvarchar30
68T811DHAllocations: Header Fields6PERIOPosting periodnvarchar30
69T811DSAllocations: Document Numbers for Segment Reverse/Rebook7PERIOPosting periodnvarchar30
TOPCost Object
70COEPBCO Object: Line Items Variance/Period-Based Results Analysis5PERIOPeriodnvarchar30
71PZPELine Items for Measuring Point Update5PERIOPeriodnvarchar30
TOPCosting
72COESCO Object: Sales Order Value Line Items10PERIOPeriodnvarchar30
TOPData Retention Tool
73TXW_S_COEPRetrieve COEP from archive9PERIOFiscal Periodnvarchar20
TOPFinancial Accounting
74FERC_R0Execution history5PERIOPeriodnvarchar30
75J_1UF_REEII_XMLXML table for J_1UF_REEII5PERIOFiscal Periodnvarchar20
76J_1UF_REEI_XMLXML table for J_1UF_REEI5PERIOFiscal Periodnvarchar20
TOPFinland
77PA0228HR Master Record: Infotype 0228 (garnishments Finland)41PERIOGarnishment period fix amount.nvarchar50
TOPFunds Management
78BPBKDoc.Header Controlling Obj.9PERIOPosting periodnvarchar30
79BPDKHeader Entry Document5PERIOPosting periodnvarchar30
80FCABPFI-CA: Document Item9PERIOPeriodnvarchar30
81FMEPFI-FM Line Items5PERIOPeriodnvarchar30
82FMICOITFM/CO integration: Line item11PERIOPeriodnvarchar30
83FMIFIITFI Line Item Table in Funds Management11PERIOPeriodnvarchar30
84FMIOICommitment Documents Funds Management17PERIOPeriodnvarchar30
85FMLGD_H_VG_01_01Budget Type 01: Customer Down Payment4PERIOPeriod/yearnvarchar70
86FMLGD_H_VG_02_01Posting Type 02: Vendor Down Payment4PERIOPeriod/yearnvarchar70
87FMLGD_H_VG_03_01Posting Type 03: G/L Account Debit Posting4PERIOPeriod/yearnvarchar70
88FMLGD_H_VG_04_01Posting Type 04: G/L Account Credit Posting4PERIOPeriod/yearnvarchar70
89FMLGD_H_VG_05_01Posting Type 05: Down Payment with General Request (01)4PERIOPeriod/yearnvarchar70
90FMLGD_H_VG_05_02Posting Type 05:Vendor Down Payment with General Request(02)3PERIOPeriod/yearnvarchar70
91FMLGD_H_VG_06_01Posting Type 06:Customer Down Payment with General Request4PERIOPeriod/yearnvarchar70
TOPGeneral Ledger Accounting
92FAGL_RSNAPSHOTReorganization: Snapshot10PERIOPosting periodnvarchar30
TOPGeneral Ledger Reorganization
93FAGL_R_PER_TRACKReorganization: Log of Changed Posting Periods9PERIOPosting periodnvarchar30
TOPGeneral Parts
94T74_FBN_GB07Flexible Benefits Cost Period for Company Car (GB)5PERIOFlexible benefit period for calculation of company carnvarchar20
TOPInformation system
95FMKF_REPTERMKey Figure Terms for Reporting Because of New Budget Tables12PERIOKey Figures - Periodnvarchar30
96FMKF_REPTERM2Key Figure Terms for Reporting Because of New Budget Tables14PERIOKey Figures - Periodnvarchar30
TOPInformation System
97FTI_BI_REP_ODSReparation Records for Inconsistent Data in ODS 0CFM_O01 /BW54PERIOPeriod/yearnvarchar70
TOPInformation System, iViews
98COOI_PIBW CO-OM: Commitment Management: Deleted Line Items27PERIOPeriodnvarchar30
TOPInventory Controlling
99PROPForecast parameters22PERIONumber of periods per seasonal cycledecimal30
TOPLocalization
100GLO_PTRV_TRANSPReimbursement Amounts for Transport4PERIOTrip Period Numbernvarchar30
TOPMaster Data
101SAFKRun Schedule Master Data36PERIOTime bucketnvarchar10
TOPMaterial Master
102MPOP_TMPFile for Incorrect Data in Direct Input24PERIONumber of periods per seasonal cycledecimal30
103MPRPForecast Profiles8PERIONumber of periods per seasonal cycledecimal30
104MVOPMaterial data material versions21PERIONumber of periods per seasonal cycledecimal30
TOPOverhead Cost Controlling
105COEPCO Object: Line Items (by Period)5PERIOPeriodnvarchar30
106COEPLCO Object: Line Items for Activity Types (by Period)5PERIOPeriodnvarchar30
107COEPRCO Object: Line Items for Stat. Key Figs (by Period)5PERIOPeriodnvarchar30
108COEPTCO Object: Line Items for Prices (by Period)5PERIOPeriodnvarchar30
109COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis7PERIOPeriodnvarchar30
110T823DRevaluation document numbers7PERIOPosting periodnvarchar30
TOPOverhead Cost Orders
111AUAKDocument Header for Settlement10PERIOSettlement Periodnvarchar30
112COOICommitments Management: Line Items27PERIOPeriodnvarchar30
TOPPatient Accounting
113NLCOIS-HCO: Transfer information27PERIOIS-H: Posting periodnvarchar30
114NMCOIS-H MM: CO Transfer Information21PERIOIS-H: Posting periodnvarchar30
TOPPayroll
115T7SIBKReduced service retirement benefit category5PERIOPeriod from kategorynvarchar20
116T7SIBKIReduced service retirement benefit category8PERIOPeriod from kategorynvarchar20
TOPPegging, Grouping, and Distribution
117DIS_ADMINDistribution - Administration Table28PERIOPeriodnvarchar30
118DIS_TOBJS_COSPDistribution: Objects distributed to per Group WBS (Cost)6PERIOPeriodnvarchar30
TOPPersonnel Cost Planning and Simulation
119HRP5010Database Table for Infotype 501026PERIOPayroll time unitsnvarchar20
120PA0666HR Master Record Infotype 066632PERIOPayroll time unitsnvarchar20
121T77HCP_LIMICost Item Limits8PERIOPayroll time unitsnvarchar20
TOPPosition Budgeting and Control
122HRFPM_DIFFERENCEHRFPM: Personnel Costs Savings/ Overrun27PERIOPayroll time unitsnvarchar20
123HRFPM_FPM_POSHRFPM: FPM Documents - Items25PERIOPayroll time unitsnvarchar20
124HRFPM_FPM_POS_BUHRFPM: FPM Documents - Items for Budget26PERIOPayroll time unitsnvarchar20
TOPProduct Cost by Period
125CEZPReporting Points Line Items5PERIOPeriodnvarchar30
TOPProfitability Analysis
126CE185005PERIOPeriod/yearnvarchar70
127CE1BGISErgebnisbereich für5PERIOPeriode/Jahrnvarchar70
128CE1E_B1Model Bank5PERIOPeriod/yearnvarchar70
129CE1IDEAOp. Concern BR World5PERIOPeriod/yearnvarchar70
130CE1IDEBErgebnisbereich IDES5PERIOPeriode/Jahrnvarchar70
131CE1IDESErgebnisbereich IDES5PERIOPeriode/Jahrnvarchar70
132CE1INT1Ergebnisbereich IDES5PERIOPeriode/Jahrnvarchar70
133CE1OC01Bike International5PERIOPeriod/yearnvarchar70
134CE1R300Operating Concern IDES5PERIOPeriod/yearnvarchar70
135CE1S001Sample operating concern5PERIOPeriod/yearnvarchar70
136CE1S300Operating Concern IDES5PERIOPeriod/yearnvarchar70
137CE1S_ALAirline Route Profit5PERIOPeriod/yearnvarchar70
138CE1S_CPTemplate for Consumer Goods Industry5PERIOPeriod/yearnvarchar70
139CE1S_GOQuickstart Template5PERIOPeriod/yearnvarchar70
140CEALE01CO-PA Distribution: Line Item Reference for Distribution10PERIOPeriod/yearnvarchar70
141CECOEPCO-PA Account Based Line Items7PERIOPeriodnvarchar30
142TKEHDB_CE1_ERRHANA CO-PA Integration: CE1 Error with HANA Replication6PERIOPeriod/yearnvarchar70
143TKETD_RUNCO-PA Top-Down: Top-Down Distribution Runs4PERIOPeriod/yearnvarchar70
144TKETD_RUN_DOCNRCO-PA Top-Down: Top-Down Distribution Runs: Document Numbers4PERIOPeriod/yearnvarchar70
145TKETRLGPSSummarization Levels: Period Statuses During Build Up6PERIOPeriod/yearnvarchar70
146TKE_DIST_EXECDocument Numbers in CO-PA Distribution5PERIOPeriod/yearnvarchar70
TOPProfitability Analysis Basic Functions
147K840002Summarization level ST: 800 KK 01 KKROBJ 0000012PERIOPeriodnvarchar30
148K840004Summarization level ST: 800 KK 01 KKROBJ 0000022PERIOPeriodnvarchar30
149K840006Summarization level ST: 800 KK 01 KKROBJ 0000032PERIOPeriodnvarchar30
150K840008Summarization level ST: 800 KK 01 KKROBJ 0000042PERIOPeriodnvarchar30
151K840010Summarization level ST: 800 KK 01 KKROBJ 0000052PERIOPeriodnvarchar30
152K840012Summarization level ST: 800 KK 01 KKROBJ 0000062PERIOPeriodnvarchar30
TOPRecycling Administration Core Functions
153J_7LE10REA Partner Master: Document Types Periodicity6PERIOREA Declaration Periodicitynvarchar10
TOPRepetitive Manufacturing
154UMD04Default Values for Planning Table in Repetitive Mfg33PERIOTime bucketnvarchar10
TOPReport Selection for Product Costing
155CKBOBKKB: Object Record (Fixed Database Portion)5PERIOPeriodnvarchar30
TOPReuse Services for Country Development
156T5F99MCReimbursement Settings by Groups13PERIOPayment Frequencynvarchar10
TOPSales Plan
157T440PProfiles for Function Module PROGNOSE_DIALOG20PERIONumber of periods per seasonal cycledecimal30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
158NWCHLCOEAIS-HCO: Überleitungsinformationen27PERIOIS-H: periodo contabilenvarchar30
TOPSCM Basis
159/SAPAPO/DP440PUnivariate Forecast Profile (APO0326)15PERIONumber of Periods per Seasonal Cycledecimal50
160/SAPAPO/FCST_56Log: Strategy 568PERIONumber of Periods per Seasonal Cycledecimal50
TOPSimulation
161VSFPLA_CNVersion: Billing schedule13PERIORule for Origin of Next Billing/Invoice Datenvarchar20
162VSFPLT_CNVersion: Billing schedule: Dates17PERIORule for Origin of Next Billing/Invoice Datenvarchar20
TOPSpain
163T5EA1Seniority payment methods5PERIOSeniority: Maintenance regularitynvarchar20
TOPTechnical Application Support
164CNV_20365_CURControlling area currencies for conversion5PERIOPosting periodnvarchar30
TOPTravel Expenses
165FITV_HINZ_WERB_BAdditional Amounts and Income-Related Expenses for Receipts4PERIOTrip Period Numbernvarchar30
166FITV_HINZ_WERB_SAdditional Amounts and Income-Related Expenses4PERIOTrip Period Numbernvarchar30
167PTRV_ARCH_PERIOPrearchiving FI-TV: Entries from PTRV_PERIO (Temporary)4PERIOTrip Period Numbernvarchar30
168PTRV_BEIH_BELAssignment of Receipts to a Subsidy for Trips Home4PERIOTrip Period Numbernvarchar30
169PTRV_BEIH_TAGAssignment of Days to a Subsidy for Trips Home4PERIOTrip Period Numbernvarchar30
170PTRV_BEIH_WEGAssignment of Trip Segments to a Subsidy for Trips Home4PERIOTrip Period Numbernvarchar30
171PTRV_CHANGEChange to Trip4PERIOTrip Period Numbernvarchar30
172PTRV_COMM_AMTDetail Data: Transfer to FM When Trip Saved4PERIOTrip Period Numbernvarchar30
173PTRV_COMM_ITMHeader Data: Transfer to FM When Trip Saved4PERIOTrip Period Numbernvarchar30
174PTRV_COMPComparison Calculation Results PS4PERIOTrip Period Numbernvarchar30
175PTRV_NOT_CH_TRStorage of New Data from Temporarily Unchangable Trips5PERIOTrip Period Numbernvarchar30
176PTRV_PERIOPeriod Data of a Trip4PERIOTrip Period Numbernvarchar30
177PTRV_REASGN_FMConversion of FM Data in Trip (e.g. Fiscal Year Change)4PERIOTrip Period Numbernvarchar30
178PTRV_RECDETAILParticipant(s) in Entertainment Receipts4PERIOTrip Period Numbernvarchar30
179PTRV_ROT_AWKEYAssignment of Trip Results to Posting Doc. Number and Line4PERIOTrip Period Numbernvarchar30
180PTRV_SADDTrip Statistics - Add. Receipt Data4PERIOTrip Period Numbernvarchar30
181PTRV_SBACKLOGTrip Statistics - Batch/Backlog Processing4PERIOTrip Period Numbernvarchar30
182PTRV_SCOMTravel Statistic - Request/Plan/Settlement Cost Comparison4PERIOTrip Period Numbernvarchar30
183PTRV_SCOSTrip Statistics - Cost Assignment4PERIOTrip Period Numbernvarchar30
184PTRV_SHDRTrip Statistics - Trip Amounts4PERIOTrip Period Numbernvarchar30
185PTRV_SRECTrip Statistics - Receipts4PERIOTrip Period Numbernvarchar30
186PTRV_TRIPCHN_46CTable of all Trip Destinations f. Processing Recurring Dest.5PERIOTrip Period Numbernvarchar30
187PTRV_TRIP_CHAINTable of all Trip Destinations f. Processing Recurring Dest.5PERIOTrip Period Numbernvarchar30
188PTRV_VATDETAILSupplier Data for VAT Refund in Travel Management4PERIOTrip Period Numbernvarchar30
189PTRV_VERSIONHistory Table4PERIOTrip Period Numbernvarchar30
TOPTravel Management
190FITV_REJECTRejected Trips4PERIOTrip Period Numbernvarchar30