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

109 columns | Print definition?ERP 6.0  | REFACTIV

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GLPCA_CTProfit Center Documents99REFACTIVFI-SL Business Transactionnvarchar40
2GLPCA_T_CTProfit Center Documents115REFACTIVFI-SL Business Transactionnvarchar40
3ZSAWAActual line item table40REFACTIVFI-SL Business Reference Transactionnvarchar40
4ZSAWPPlan line items table120REFACTIVFI-SL Business Reference Transactionnvarchar40
5ZSEMBPSAActual line item table36REFACTIVFI-SL Business Reference Transactionnvarchar40
6ZSEMBPSPPlan line items table116REFACTIVFI-SL Business Reference Transactionnvarchar40
7ZSPLITAIsteinzelposten-Tabelle40REFACTIVBetriebswirtschaftlicher Referenz-Vorgang FI-SLnvarchar40
8ZSPLITPPlaneinzelposten-Tabelle120REFACTIVBetriebswirtschaftlicher Referenz-Vorgang FI-SLnvarchar40
9ZZ001AActual Line Item Table47REFACTIVFI-SL Business Reference Transactionnvarchar40
10ZZ001PPlan Line Items Table127REFACTIVFI-SL Business Reference Transactionnvarchar40
11ZZLINEAActual line item table41REFACTIVFI-SL Business Reference Transactionnvarchar40
12ZZLINEPPlan line items table105REFACTIVFI-SL Business Reference Transactionnvarchar40
13ZZSL01AActual line item table49REFACTIVFI-SL Business Reference Transactionnvarchar40
14ZZSL01PPlan line items table129REFACTIVFI-SL Business Reference Transactionnvarchar40
15ZZSPECAActual line item table40REFACTIVBusiness Transactionnvarchar40
16ZZSPECPPlan line item table104REFACTIVBusiness Transactionnvarchar40
TOPAvailability Control
17FMAVCAActual line item table39REFACTIVFI-SL Business Reference Transactionnvarchar40
18FMAVCPPlan line items table87REFACTIVFI-SL Business Reference Transactionnvarchar40
TOPBasic Functions
19FILCAFI-LC: Actual journal entry table with 2 object tables50REFACTIVBusiness Transactionnvarchar40
20FILCPFI-LC: Plan line items for object table128REFACTIVBusiness Transactionnvarchar40
21GGREFAExample for Global FI-SL Line Items (Actual)42REFACTIVFI-SL Business Reference Transactionnvarchar40
22GGREFPExample for Global FI-SL Line Items (Plan)122REFACTIVFI-SL Business Reference Transactionnvarchar40
23GLFUNCAActual Line Items Table for Cost of Sales Accounting40REFACTIVFI-SL Business Reference Transactionnvarchar40
24GLFUNCPPlan Line Items Table for Cost of Sales Accounting104REFACTIVFI-SL Business Reference Transactionnvarchar40
25GLFUNCURollup line item tables with function area for IDES40REFACTIVFI-SL Business Reference Transactionnvarchar40
26GLFUNCVRollup plan line items table with function area for IDES104REFACTIVFI-SL Business Reference Transactionnvarchar40
27GLP0Local Logical General Ledger Plan Line Items78REFACTIVBusiness Transactionnvarchar40
28GLPO1Plan Line Items for Object Table130REFACTIVBusiness Transactionnvarchar40
29GLPO2Plan Line Items for Object Table Global138REFACTIVBusiness Transactionnvarchar40
30GLPO3Plan Line Items for Object Table130REFACTIVBusiness Transactionnvarchar40
31GLREFAExample for Local FI-SL Line Items (Actual)40REFACTIVFI-SL Business Reference Transactionnvarchar40
32GLREFPExample for Local FI-SL Line Items (Plan)120REFACTIVFI-SL Business Reference Transactionnvarchar40
33GLREFUExample for FI-SL Rollup Line Items (Actual)42REFACTIVBusiness Transactionnvarchar40
34GLREFVExample for Rollup FI-SL Line Items (Plan)122REFACTIVFI-SL Business Reference Transactionnvarchar40
35GLSO1FI-SL Line Item Table with Objects for GLTO151REFACTIVBusiness Transactionnvarchar40
36GLSO2FI-SL Table with Objects, Structure corresponds to GLS259REFACTIVBusiness Transactionnvarchar40
37GLSO3FI-SL LI Table with Objects for GLTO351REFACTIVBusiness Transactionnvarchar40
TOPBudgeting
38FMBDAActual line item table40REFACTIVFI-SL Business Reference Transactionnvarchar40
39FMBDPFM Budget change line items table88REFACTIVFI-SL Business Reference Transactionnvarchar40
40FMRBAActual line item table38REFACTIVFI-SL Business Reference Transactionnvarchar40
41FMRBPPlan line items table86REFACTIVFI-SL Business Reference Transactionnvarchar40
TOPCollectionsDisbursements
42GLISDEAActual Line Item Tables for Insurance (DE)52REFACTIVBusiness Transactionnvarchar40
43GLISDEPPlan Line Item Table for Insurance (DE)116REFACTIVBusiness Transactionnvarchar40
44GRISDEAActual Line Item Table for Insurance (DE) - Rollup52REFACTIVBusiness Transactionnvarchar40
45GRISDEPPlan Line Item Table for Insurance (DE) - Rollup116REFACTIVBusiness Transactionnvarchar40
TOPConsolidation
46ECMCASAP Cons.: Journal Entry Table (Actual)49REFACTIVBusiness Transactionnvarchar40
TOPCost Element Accounting
47COFIPSingle plan items for reconciliation ledger116REFACTIVBusiness Transactionnvarchar40
48COFISActual line items for reconciliation ledger53REFACTIVBusiness Transactionnvarchar40
TOPFinancial Accounting
49FBICRC001AICRC: Open Items GL Accounts: Documents30REFACTIVFI-SL Business Reference Transactionnvarchar40
50FBICRC001PNot in use45REFACTIVFI-SL Business Reference Transactionnvarchar40
51FBICRC002AICRC: GL Accounts: Documents30REFACTIVFI-SL Business Reference Transactionnvarchar40
52FBICRC002PNot in use45REFACTIVFI-SL Business Reference Transactionnvarchar40
53FBICRC003AICRC: Open Items Customers/Vendors: Documents31REFACTIVFI-SL Business Reference Transactionnvarchar40
54FBICRC003PNot in use46REFACTIVFI-SL Business Reference Transactionnvarchar40
TOPFinancial Services Localization
55/CEEIS/RUAActual line item table51REFACTIVFI-SL Business Reference Transactionnvarchar40
56/CEEIS/RUPPlan line items table131REFACTIVFI-SL Business Reference Transactionnvarchar40
TOPFlexible Real Estate Management
57VIPRLEDTAGRAIsteinzelposten-Tabelle30REFACTIVBetriebswirtschaftlicher Referenz-Vorgang FI-SLnvarchar40
58VIPRLEDTAGRPPlaneinzelposten-Tabelle94REFACTIVBetriebswirtschaftlicher Referenz-Vorgang FI-SLnvarchar40
TOPFund Accounting
59FMCCAVCAActual line item table36REFACTIVFI-SL Business Reference Transactionnvarchar40
60FMCCAVCPPlan line items table84REFACTIVFI-SL Business Reference Transactionnvarchar40
TOPFunds Management
61FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60042REFACTIVFI-SL Business Reference Transactionnvarchar40
62FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60046REFACTIVFI-SL Business Reference Transactionnvarchar40
63FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60042REFACTIVFI-SL Business Reference Transactionnvarchar40
64FMIAActual Line Item Table for Funds Management43REFACTIVBusiness Transactionnvarchar40
65FMIPPlan Line Items Table for Funds Management75REFACTIVBusiness Transactionnvarchar40
66FMSPLITAActual line item table44REFACTIVFI-SL Business Reference Transactionnvarchar40
67FMSPLITPPlan line items table76REFACTIVFI-SL Business Reference Transactionnvarchar40
68FMUSFGAActual line item table for US Federal Government.42REFACTIVFI-SL Business Reference Transactionnvarchar40
69FMUSFGFACTS1A4Actual line item table42REFACTIVFI-SL Business Reference Transactionnvarchar40
70FMUSFGFACTS1PPlan line items table73REFACTIVFI-SL Business Reference Transactionnvarchar40
71FMUSFGFACTS2AActual line item table46REFACTIVFI-SL Business Reference Transactionnvarchar40
72FMUSFGFACTS2PPlan line items table77REFACTIVFI-SL Business Reference Transactionnvarchar40
73FMUSFGPPlan line items table73REFACTIVFI-SL Business Reference Transactionnvarchar40
74PSBM_EVENTPS Budget Monitoring Events9REFACTIVFI-SL Business Transactionnvarchar40
TOPGeneral Ledger Accounting
75GLFLEXAFlexible general ledger: Actual line items44REFACTIVFI-SL Business Reference Transactionnvarchar40
76GLFLEXPFlexible G/L: Plan line items122REFACTIVFI-SL Business Reference Transactionnvarchar40
TOPGrantee Management
77GMAVCAActual line item table39REFACTIVFI-SL Business Reference Transactionnvarchar40
78GMAVCPPlan line items table103REFACTIVFI-SL Business Reference Transactionnvarchar40
79GMIAActual Line Item Table37REFACTIVFI-SL Business Reference Transactionnvarchar40
80GMIPPlan line items table85REFACTIVFI-SL Business Reference Transactionnvarchar40
TOPJoint Venture und Production Sharing Accounting
81JVPO1JVA: Plan Line Items115REFACTIVBusiness Transactionnvarchar40
82JVPSC01AActual line item table50REFACTIVBusiness Transactionnvarchar40
83JVPSC01PPlan line item table114REFACTIVBusiness Transactionnvarchar40
84JVSO1JV LI Table with Objects for JVTO151REFACTIVBusiness Transactionnvarchar40
85JVSO2JV Billing FI-SL Line Item35REFACTIVBusiness Transactionnvarchar40
86T8JMUSEField movement for JADE - Usage3REFACTIVFI-SL Business Transactionnvarchar40
87T8JVBADocuments included in Bank Account Switching14REFACTIVBusiness Transactionnvarchar40
88T8J_JVECJVA equity change document relationship16REFACTIVBusiness Transactionnvarchar40
TOPLocalization
89J_3RFTAXRATax Accounting: Actual line item table51REFACTIVBusiness Transactionnvarchar40
90J_3RFTAXRPTax Accounting: Plan line item table99REFACTIVBusiness Transactionnvarchar40
91J_3RFTAXRVATax Accounting: Actual line item table51REFACTIVBusiness Transactionnvarchar40
92J_3RFTAXRVPTax Accounting: Plan line item table99REFACTIVBusiness Transactionnvarchar40
TOPProfit Center Accounting
93GLPCAEC-PCA: Actual Line Items47REFACTIVFI-SL Business Transactionnvarchar40
94GLPCPEC-PCA: Plan Line Items108REFACTIVFI-SL Business Transactionnvarchar40
TOPRegulatory reporting for insurance companies
95ISSRFLDEAActual line item table74REFACTIVFI-SL Business Reference Transactionnvarchar40
96ISSRFLDEPPlan line items table154REFACTIVFI-SL Business Reference Transactionnvarchar40
TOPRemaining Beverage - Obsolete Objects
97/BEV3/CHFIAActual line item table38REFACTIVBusiness Transactionnvarchar40
98/BEV3/CHFIPPlan Line Items Table118REFACTIVBusiness Transactionnvarchar40
99/BEV3/CHVGRAActual line item table40REFACTIVBusiness Transactionnvarchar40
100/BEV3/CHVGRPPlan Line Items Table120REFACTIVBusiness Transactionnvarchar40
TOPRetail Ledger
101PCRRETAILAActual line item table39REFACTIVFI-SL Business Reference Transactionnvarchar40
102PCRRETAILPPlan line items table119REFACTIVFI-SL Business Reference Transactionnvarchar40
TOPSpecial Purpose Ledger
103/CCIS/PBU18APBU18: Actual line item table53REFACTIVFI-SL Business Reference Transactionnvarchar40
104/CCIS/PBU18PPBU18: Plan line item table133REFACTIVFI-SL Business Reference Transactionnvarchar40
TOPTariffs, Duties and Permits
105OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger54REFACTIVFI-SL Business Reference Transactionnvarchar40
106OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger134REFACTIVFI-SL Business Reference Transactionnvarchar40
107OIHSLATDP (excise duty) special ledger actual line item table59REFACTIVBusiness Transactionnvarchar40
TOPTransfer to Financial Accounting
108TRACTSLAActual Line Item Table32REFACTIVFI-SL Business Reference Transactionnvarchar40
109TRACTSLPPlan Line Items Table112REFACTIVFI-SL Business Reference Transactionnvarchar40