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

46 columns | Print definition?ERP 6.0  | AUTOM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GLPCA_CTProfit Center Documents46AUTOMIndicator: Automatic posting linesnvarchar10
2GLPCA_T_CTProfit Center Documents62AUTOMIndicator: Automatic posting linesnvarchar10
3P2RA_SPPayroll Results: Special Payments30AUTOMAutomatic indicatornvarchar10
4P2RB_SPPayroll Results: Special Payments30AUTOMAutomatic indicatornvarchar10
5P2RD_SPPayroll Results: Special Payments30AUTOMAutomatic indicatornvarchar10
6P2RE_SPPayroll Results: Special Payments30AUTOMAutomatic indicatornvarchar10
7P2RI_SPPayroll Results: Special Payments30AUTOMAutomatic indicatornvarchar10
8P2RN_SPPayroll Results: Special Payments30AUTOMAutomatic indicatornvarchar10
9P2RR_SPPayroll Results: Special Payments30AUTOMAutomatic indicatornvarchar10
10ZZSPECAActual line item table31AUTOMIndicator: Automatic posting linesnvarchar10
11ZZSPECPPlan line item table95AUTOMIndicator: Automatic posting linesnvarchar10
TOPBasic Functions
12FILCAFI-LC: Actual journal entry table with 2 object tables41AUTOMIndicator: Automatic posting linesnvarchar10
13FILCPFI-LC: Plan line items for object table120AUTOMIndicator: Automatic posting linesnvarchar10
14GLFUNCAActual Line Items Table for Cost of Sales Accounting31AUTOMIndicator: Automatic posting linesnvarchar10
15GLFUNCPPlan Line Items Table for Cost of Sales Accounting95AUTOMIndicator: Automatic posting linesnvarchar10
16GLFUNCURollup line item tables with function area for IDES31AUTOMIndicator: Automatic posting linesnvarchar10
17GLFUNCVRollup plan line items table with function area for IDES95AUTOMIndicator: Automatic posting linesnvarchar10
18GLP0Local Logical General Ledger Plan Line Items71AUTOMIndicator: Automatic posting linesnvarchar10
19GLPO1Plan Line Items for Object Table121AUTOMIndicator: Automatic posting linesnvarchar10
20GLPO2Plan Line Items for Object Table Global129AUTOMIndicator: Automatic posting linesnvarchar10
21GLPO3Plan Line Items for Object Table121AUTOMIndicator: Automatic posting linesnvarchar10
22GLREFUExample for FI-SL Rollup Line Items (Actual)33AUTOMIndicator: Automatic posting linesnvarchar10
23GLREFVExample for Rollup FI-SL Line Items (Plan)113AUTOMIndicator: Automatic posting linesnvarchar10
24GLSO1FI-SL Line Item Table with Objects for GLTO141AUTOMIndicator: Automatic posting linesnvarchar10
25GLSO2FI-SL Table with Objects, Structure corresponds to GLS249AUTOMIndicator: Automatic posting linesnvarchar10
26GLSO3FI-SL LI Table with Objects for GLTO341AUTOMIndicator: Automatic posting linesnvarchar10
TOPCollectionsDisbursements
27GLISDEAActual Line Item Tables for Insurance (DE)43AUTOMIndicator: Automatic posting linesnvarchar10
28GLISDEPPlan Line Item Table for Insurance (DE)107AUTOMIndicator: Automatic posting linesnvarchar10
29GRISDEAActual Line Item Table for Insurance (DE) - Rollup43AUTOMIndicator: Automatic posting linesnvarchar10
30GRISDEPPlan Line Item Table for Insurance (DE) - Rollup107AUTOMIndicator: Automatic posting linesnvarchar10
TOPConsolidation
31ECMCASAP Cons.: Journal Entry Table (Actual)40AUTOMIndicator: Automatic posting linesnvarchar10
TOPCost Element Accounting
32COFIPSingle plan items for reconciliation ledger107AUTOMIndicator: Automatic posting linesnvarchar10
33COFISActual line items for reconciliation ledger43AUTOMIndicator: Automatic posting linesnvarchar10
TOPFunds Management
34FMIAActual Line Item Table for Funds Management34AUTOMIndicator: Automatic posting linesnvarchar10
35FMIPPlan Line Items Table for Funds Management66AUTOMIndicator: Automatic posting linesnvarchar10
TOPJoint Venture und Production Sharing Accounting
36JVPO1JVA: Plan Line Items105AUTOMIndicator: Automatic posting linesnvarchar10
37JVSO1JV LI Table with Objects for JVTO141AUTOMIndicator: Automatic posting linesnvarchar10
38JVSO2JV Billing FI-SL Line Item25AUTOMIndicator: Automatic posting linesnvarchar10
TOPProcess Controls
39GRPCCTRLPROPOSALGRPC:Control Proposal16AUTOMAutomationnvarchar100
TOPProfit Center Accounting
40GLPCAEC-PCA: Actual Line Items38AUTOMIndicator: Automatic posting linesnvarchar10
41GLPCPEC-PCA: Plan Line Items99AUTOMIndicator: Automatic posting linesnvarchar10
TOPTariffs, Duties and Permits
42OIHSLATDP (excise duty) special ledger actual line item table50AUTOMIndicator: Automatic posting linesnvarchar10
TOPTravel Planning
43FTPT_CARTravel Request Item - Car Rental Service66AUTOMAutomatic Transmission Requestednvarchar10
44FTPT_CAR_PREFRental car service preferences of a travel plan12AUTOMAutomatic Transmission Requestednvarchar10
45PA0473HR master record infotype 0473 (rental car preferences)27AUTOMAutomatic Transmission Requestednvarchar10
TOPWarranty Claim Processing
46CWTYA04Action Matrix6AUTOMCall Up Action Automaticallynvarchar10