SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OPCH386A/P Invoice

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

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