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

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

171 columns | Print definition?ERP 6.0  | AWORG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_05_ACCTHCollected Header Document Numbers for TDMS_Time-ACCTHD5AWORGAWORG for CNVTDMS_05_ACCTHDnvarchar100
2GLPCA_CTProfit Center Documents47AWORGReference Organizational Unitsnvarchar100
3GLPCA_T_CTProfit Center Documents63AWORGReference Organizational Unitsnvarchar100
4VIYCEXPITEMExpense Items6AWORGReference Organizational Unitsnvarchar100
5ZSAWAActual line item table45AWORGReference Organizational Unitsnvarchar100
6ZSAWPPlan line items table125AWORGReference Organizational Unitsnvarchar100
7ZSEMBPSAActual line item table41AWORGReference Organizational Unitsnvarchar100
8ZSEMBPSPPlan line items table121AWORGReference Organizational Unitsnvarchar100
9ZSPLITAIsteinzelposten-Tabelle45AWORGReferenzorganisationseinheitennvarchar100
10ZSPLITPPlaneinzelposten-Tabelle125AWORGReferenzorganisationseinheitennvarchar100
11ZZ001AActual Line Item Table52AWORGReference Organizational Unitsnvarchar100
12ZZ001PPlan Line Items Table132AWORGReference Organizational Unitsnvarchar100
13ZZLINEAActual line item table46AWORGReference Organizational Unitsnvarchar100
14ZZLINEPPlan line items table110AWORGReference Organizational Unitsnvarchar100
15ZZSL01AActual line item table54AWORGReference Organizational Unitsnvarchar100
16ZZSL01PPlan line items table134AWORGReference Organizational Unitsnvarchar100
17ZZSPECAActual line item table45AWORGReference Organizational Unitsnvarchar100
18ZZSPECPPlan line item table109AWORGReference Organizational Unitsnvarchar100
TOPAccounting Interface
19GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)5AWORGReference Organizational Unitsnvarchar100
20GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)5AWORGReference Organizational Unitsnvarchar100
TOPActual CostingMaterial Ledger
21CKMI1Index for Accounting Documents for Material7AWORGReference Organizational Unitsnvarchar100
22MLHDMaterial Ledger Document: Header7AWORGReference Organizational Unitsnvarchar100
TOPAvailability Control
23FMAVCAActual line item table44AWORGReference Organizational Unitsnvarchar100
24FMAVCPPlan line items table92AWORGReference Organizational Unitsnvarchar100
TOPBasic Functions
25ANEKDocument Header Asset Posting45AWORGReference Organizational Unitsnvarchar100
26ARC_IDX_ATIndex table for ACCTIT/ACCTHD/ACCTCR archives3AWORGReference Organizational Unitsnvarchar100
27ETXDCHExternal tax document: header info5AWORGReference Organizational Unitsnvarchar100
28FDS2CM&F Line Items in SD Documents (fromr Release 4.0)4AWORGReference Organizational Unitsnvarchar100
29FDSPCash Mgmt Adjustment Items from Document Splitting5AWORGReference Organizational Unitsnvarchar100
30FILCAFI-LC: Actual journal entry table with 2 object tables57AWORGReference Organizational Unitsnvarchar100
31FILCPFI-LC: Plan line items for object table133AWORGReference Organizational Unitsnvarchar100
32GGREFAExample for Global FI-SL Line Items (Actual)47AWORGReference Organizational Unitsnvarchar100
33GGREFPExample for Global FI-SL Line Items (Plan)127AWORGReference Organizational Unitsnvarchar100
34GLFUNCAActual Line Items Table for Cost of Sales Accounting45AWORGReference Organizational Unitsnvarchar100
35GLFUNCPPlan Line Items Table for Cost of Sales Accounting109AWORGReference Organizational Unitsnvarchar100
36GLFUNCURollup line item tables with function area for IDES45AWORGReference Organizational Unitsnvarchar100
37GLFUNCVRollup plan line items table with function area for IDES109AWORGReference Organizational Unitsnvarchar100
38GLIDXAIndex to Find FI-SL Documents Based on AWKEY4AWORGReference Organizational Unitsnvarchar100
39GLP0Local Logical General Ledger Plan Line Items80AWORGReference Organizational Unitsnvarchar100
40GLREFAExample for Local FI-SL Line Items (Actual)45AWORGReference Organizational Unitsnvarchar100
41GLREFPExample for Local FI-SL Line Items (Plan)125AWORGReference Organizational Unitsnvarchar100
42GLREFUExample for FI-SL Rollup Line Items (Actual)47AWORGReference Organizational Unitsnvarchar100
43GLREFVExample for Rollup FI-SL Line Items (Plan)127AWORGReference Organizational Unitsnvarchar100
44TTXIExternal tax interface: index file4AWORGReference Organizational Unitsnvarchar100
45TTXUExternal tax interface: Audit file update information11AWORGReference Organizational Unitsnvarchar100
46TTXYExternal tax interface: tax information4AWORGReference Organizational Unitsnvarchar100
TOPBudgeting
47FMBDAActual line item table45AWORGReference Organizational Unitsnvarchar100
48FMBDPFM Budget change line items table93AWORGReference Organizational Unitsnvarchar100
49FMBHFunds management budget header (entry documents)27AWORGReference Organizational Unitsnvarchar100
50FMRBAActual line item table43AWORGReference Organizational Unitsnvarchar100
51FMRBPPlan line items table91AWORGReference Organizational Unitsnvarchar100
TOPBudgeting and Availability Control
52GMBDGTHEADERBudget Document Header26AWORGReference Organizational Unitsnvarchar100
TOPCentral Cash Desk Procedure
53FMFG_PPA_INV_LNReason Codes for Accounting Documents (Item Level)3AWORGReference Organizational Unitsnvarchar100
TOPCollectionsDisbursements
54GLISDEAActual Line Item Tables for Insurance (DE)57AWORGReference Organizational Unitsnvarchar100
55GLISDEPPlan Line Item Table for Insurance (DE)121AWORGReference Organizational Unitsnvarchar100
56GRISDEAActual Line Item Table for Insurance (DE) - Rollup57AWORGReference Organizational Unitsnvarchar100
57GRISDEPPlan Line Item Table for Insurance (DE) - Rollup121AWORGReference Organizational Unitsnvarchar100
TOPConsolidation
58ECMCASAP Cons.: Journal Entry Table (Actual)59AWORGReference Organizational Unitsnvarchar100
TOPControlling
59COK41C_IXIndex Table for Documents in a Posting Run8AWORGReference Organizational Unitsnvarchar100
60COPPP_HDRCO Postprocessing List - Headers35AWORGReference Organizational Unitsnvarchar100
TOPCost Element Accounting
61COFIPSingle plan items for reconciliation ledger121AWORGReference Organizational Unitsnvarchar100
62COFISActual line items for reconciliation ledger58AWORGReference Organizational Unitsnvarchar100
TOPData Retention Tool
63TXW_S_ANEKRetrieve ANEP from archive33AWORGReference Organizational Unitsnvarchar100
64TXW_S_BKPFRetrieve BKPF from archive31AWORGReference Organizational Unitsnvarchar100
65TXW_S_COBKRetrieve COBK from archive24AWORGReference Organizational Unitsnvarchar100
TOPEnterprise Services - Personnel Time Management
66TIM_SE_EXT_KEYMapping Table for IT2004: External Key and Infotype Key4AWORGReference Organizational Unitsnvarchar100
TOPFinancial Accounting
67ACCTCRCompressed Data from FI/CO Document - Currencies4AWORGReference Organizational Unitsnvarchar100
68ACCTHDCompressed Data from FI/CO Document - Header4AWORGReference Organizational Unitsnvarchar100
69ACCTITCompressed Data from FI/CO Document4AWORGReference Organizational Unitsnvarchar100
70ARIX_BKPFFI_DOCUMNT: Header-Oriented Document Index for Archive7AWORGReference Organizational Unitsnvarchar100
71FBICRC001AICRC: Open Items GL Accounts: Documents35AWORGReference Organizational Unitsnvarchar100
72FBICRC001PNot in use50AWORGReference Organizational Unitsnvarchar100
73FBICRC002AICRC: GL Accounts: Documents35AWORGReference Organizational Unitsnvarchar100
74FBICRC002PNot in use50AWORGReference Organizational Unitsnvarchar100
75FBICRC003AICRC: Open Items Customers/Vendors: Documents36AWORGReference Organizational Unitsnvarchar100
76FBICRC003PNot in use51AWORGReference Organizational Unitsnvarchar100
77FERC_D2Documents per sender and account18AWORGReference Organizational Unitsnvarchar100
TOPFinancial Services Localization
78/CEEIS/RUAActual line item table56AWORGReference Organizational Unitsnvarchar100
79/CEEIS/RUPPlan line items table136AWORGReference Organizational Unitsnvarchar100
TOPFlexible Real Estate Management
80VIPRLEDTAGRAIsteinzelposten-Tabelle35AWORGReferenzorganisationseinheitennvarchar100
81VIPRLEDTAGRPPlaneinzelposten-Tabelle99AWORGReferenzorganisationseinheitennvarchar100
TOPFund Accounting
82FMCCAVCAActual line item table41AWORGReference Organizational Unitsnvarchar100
83FMCCAVCPPlan line items table89AWORGReference Organizational Unitsnvarchar100
TOPFunds Management
84BPDKHeader Entry Document20AWORGReference Organizational Unitsnvarchar100
85FCABKFI-CA: Document Header10AWORGReference Organizational Unitsnvarchar100
86FMFG_PO_SUBSETZEKKN number to correct invoices for SES12AWORGReference Organizational Unitsnvarchar100
87FMFG_PO_ZEKKNZEKKN data for all FI items referencing service POs12AWORGReference Organizational Unitsnvarchar100
88FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60047AWORGReference Organizational Unitsnvarchar100
89FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60051AWORGReference Organizational Unitsnvarchar100
90FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60047AWORGReference Organizational Unitsnvarchar100
91FMFG_SAV_GLIDXASaved GLIDXA data for docs excluded from SL Repost for 6004AWORGReference Organizational Unitsnvarchar100
92FMIAActual Line Item Table for Funds Management48AWORGReference Organizational Unitsnvarchar100
93FMIFIHDFI Header Table in Funds Management14AWORGReference Organizational Unitsnvarchar100
94FMIPPlan Line Items Table for Funds Management80AWORGReference Organizational Unitsnvarchar100
95FMSPLITAActual line item table49AWORGReference Organizational Unitsnvarchar100
96FMSPLITPPlan line items table81AWORGReference Organizational Unitsnvarchar100
97FMUSFGAActual line item table for US Federal Government.47AWORGReference Organizational Unitsnvarchar100
98FMUSFGFACTS1A4Actual line item table47AWORGReference Organizational Unitsnvarchar100
99FMUSFGFACTS1PPlan line items table78AWORGReference Organizational Unitsnvarchar100
100FMUSFGFACTS2AActual line item table51AWORGReference Organizational Unitsnvarchar100
101FMUSFGFACTS2PPlan line items table82AWORGReference Organizational Unitsnvarchar100
102FMUSFGPPlan line items table78AWORGReference Organizational Unitsnvarchar100
103KBLEDocument Item Processing: Manual Document Entry36AWORGReference Organizational Unitsnvarchar100
TOPGeneral Ledger Accounting
104FAGLCOFITRACELog of Real-Time Integration CO->FI8AWORGReference Organizational Unitsnvarchar100
105FAGL_SPLINFOSplittling Information of Open Items10AWORGReference Organizational Unitsnvarchar100
106GLFLEXAFlexible general ledger: Actual line items49AWORGReference Organizational Unitsnvarchar100
107GLFLEXPFlexible G/L: Plan line items127AWORGReference Organizational Unitsnvarchar100
TOPGrantee Management
108GMAVCAActual line item table44AWORGReference Organizational Unitsnvarchar100
109GMAVCPPlan line items table108AWORGReference Organizational Unitsnvarchar100
110GMIAActual Line Item Table43AWORGReference Organizational Unitsnvarchar100
111GMIPPlan line items table90AWORGReference Organizational Unitsnvarchar100
TOPInput Tax Treatment
112VIBETAXDZuordnung Vorsteuerbeleg zum Berichtigungsobjekt4AWORGReferenzorganisationseinheitennvarchar100
TOPJoint Venture und Production Sharing Accounting
113JVPO1JVA: Plan Line Items140AWORGReference Organizational Unitsnvarchar100
114JVPSC01AActual line item table55AWORGReference Organizational Unitsnvarchar100
115JVPSC01PPlan line item table119AWORGReference Organizational Unitsnvarchar100
116JVSO1JV LI Table with Objects for JVTO176AWORGReference Organizational Unitsnvarchar100
117JVSO2JV Billing FI-SL Line Item44AWORGReference Organizational Unitsnvarchar100
118T8J_POST_ERRORDocuments with errors in JV posting4AWORGReference Organizational Unitsnvarchar100
119T8J_POST_ERROR_CDocuments with errors in JV posting (Open Items)4AWORGReference Organizational Unitsnvarchar100
TOPLease Accounting
120FILA_GF_ITEMDOCSAssignment of Process - FI/CO Document Numbers8AWORGReference Organizational Unitsnvarchar100
121FILA_GF_ITEMLINKAssignment of Objects to Assets14AWORGReference Organizational Unitsnvarchar100
TOPLoans Management
122VDCHK_AWKEYStorage of unique links between FI and CML doc6AWORGReference Organizational Unitsnvarchar100
TOPLocalization
123J_1AINFINVInflation: Invoices for Replacement Value Determination7AWORGReference Organizational Unitsnvarchar100
124J_1B_CIAP_OBJECTCIAP document data53AWORGReference Organizational Unitsnvarchar100
125J_1IEWTPROVTable for TDS provisions9AWORGReference Organizational Unitsnvarchar100
126J_1ISERVCService tax details5AWORGReference organisational unitsnvarchar100
127J_3RFTAXRATax Accounting: Actual line item table56AWORGReference Organizational Unitsnvarchar100
128J_3RFTAXRPTax Accounting: Plan line item table104AWORGReference Organizational Unitsnvarchar100
129J_3RFTAXRVATax Accounting: Actual line item table56AWORGReference Organizational Unitsnvarchar100
130J_3RFTAXRVPTax Accounting: Plan line item table104AWORGReference Organizational Unitsnvarchar100
TOPNew Zealand
131PT2001HR Time Record: Infotype 2001 (Absences)69AWORGReference Organizational Unitsnvarchar100
TOPOverhead Cost Controlling
132COBKCO Object: Document Header34AWORGReference Organizational Unitsnvarchar100
TOPPersonnel Time Management
133PA2001HR Time Record: Infotype 2001 (Absences)69AWORGReference Organizational Unitsnvarchar100
134PA2002HR Time Record: Infotype 2002 (Attendances)51AWORGReference Organizational Unitsnvarchar100
135PA2003HR Time Record: Infotype 2003 (Substitutions)65AWORGReference Organizational Unitsnvarchar100
136PA2010HR Time Record: Infotype 2010 (Employee Remuneration Info.)51AWORGReference Organizational Unitsnvarchar100
TOPProfit Center Accounting
137GLPCAEC-PCA: Actual Line Items49AWORGReference Organizational Unitsnvarchar100
138GLPCPEC-PCA: Plan Line Items137AWORGReference Organizational Unitsnvarchar100
TOPProfitability Analysis
139CEERRORCO-PA: Incorrect records from SD62AWORGReference Organizational Unitsnvarchar100
TOPReal Estate Management
140VIMIRAInstalments for Lease-Out7AWORGReference Organizational Unitsnvarchar100
141VITAXALine items for correction items5AWORGReference Organizational Unitsnvarchar100
142VITAXDTax Shares per Real Estate Account Assignment4AWORGReference Organizational Unitsnvarchar100
143VITAXROutflows for correction items5AWORGReference Organizational Unitsnvarchar100
144VITAXUTax transfer posting for advance payments with jurisdiction9AWORGReference Organizational Unitsnvarchar100
TOPRegulatory reporting for insurance companies
145ISSRFLDEAActual line item table79AWORGReference Organizational Unitsnvarchar100
146ISSRFLDEPPlan line items table159AWORGReference Organizational Unitsnvarchar100
147ISSRPREFLOWISSR: Basistabelle/Bewegungstabelle44AWORGUnità organizzative di riferimentonvarchar100
TOPRemaining Beverage - Obsolete Objects
148/BEV3/CHFIAActual line item table43AWORGReference Organizational Unitsnvarchar100
149/BEV3/CHFIPPlan Line Items Table123AWORGReference Organizational Unitsnvarchar100
150/BEV3/CHVGRAActual line item table45AWORGReference Organizational Unitsnvarchar100
151/BEV3/CHVGRPPlan Line Items Table125AWORGReference Organizational Unitsnvarchar100
TOPRetail Ledger
152PCRRETAILAActual line item table44AWORGReference Organizational Unitsnvarchar100
153PCRRETAILPPlan line items table124AWORGReference Organizational Unitsnvarchar100
TOPSpecial Purpose Ledger
154/CCIS/PBU18APBU18: Actual line item table58AWORGReference Organizational Unitsnvarchar100
155/CCIS/PBU18PPBU18: Plan line item table138AWORGReference Organizational Unitsnvarchar100
TOPTariffs, Duties and Permits
156OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger59AWORGReference Organizational Unitsnvarchar100
157OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger139AWORGReference Organizational Unitsnvarchar100
158OIHSLATDP (excise duty) special ledger actual line item table64AWORGReference Organizational Unitsnvarchar100
TOPTransfer to Financial Accounting
159TRACTSLAActual Line Item Table37AWORGReference Organizational Unitsnvarchar100
160TRACTSLPPlan Line Items Table117AWORGReference Organizational Unitsnvarchar100
161TRACT_DOCUMENTTreasury: Accounting Adaptor Document8AWORGReference Organizational Unitsnvarchar100
TOPTravel Expenses
162PTRV_DOC_HDTransfer Travel -> FI/CO: Header of TRV int. document3AWORGReference Organizational Unitsnvarchar100
163PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document3AWORGReference Organizational Unitsnvarchar100
164PTRV_DOC_MESSTransfer Travel -> FI/CO: CO Replacements of TRV Receipt3AWORGReference Organizational Unitsnvarchar100
165PTRV_DOC_TAXTransfer Travel -> FI/CO: Tax lines of TRV document3AWORGReference Organizational Unitsnvarchar100
166PTRV_ROT_AWKEYAssignment of Trip Results to Posting Doc. Number and Line14AWORGReference Organizational Unitsnvarchar100
167PTRV_RPRPOSTDLog of Posting Program RPRPOSTD4AWORGReference Organizational Unitsnvarchar100
TOPUS Prompt Payment Act
168FMFG_PPA_INVSTATPPA Invoice Status Table3AWORGReference Organizational Unitsnvarchar100
169FMFG_PPA_INV_HDPPA invoice header information (reason codes)3AWORGReference Organizational Unitsnvarchar100
170FMFG_PPA_INV_HISPPA Invoice Status Change History3AWORGReference Organizational Unitsnvarchar100
171FMFG_PPA_LINKLink the application log to an Invoice (PPA)4AWORGReference Organizational Unitsnvarchar100