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)
3FMARCPAR4Parallelization of FMARC_BATCH
4/ISDFPS/CHVW_E34External Batch Where-Used List
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FMIA65Actual Line Item Table for Funds Management
8FCO_DOC_HEAD61Failure Cost Document Header
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
6OPOR386Purchase Order
7OJDT100Journal Entry
8OUSR101Users
9OWTR386Inventory Transfer
10OSHP5Delivery Types

B1 8.8: Top 10 requests

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

152 columns | Print definition?ERP 6.0  | KDAUF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEP/T_NEEDGraphischer Leitstand: Bedarfe (einzuplanende Objekte)19KDAUFVerkaufsbelegnvarchar100
2/GEP/T_SPLITGraphischer Leitstand: Splits (eingeplante Objekte)20KDAUFVerkaufsbelegnvarchar100
3/SMERP/STG_PM001Data staging - Equipment complex table192KDAUFSales Order Numbernvarchar100
4/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab186KDAUFSales Order Numbernvarchar100
5AUAASettlement Document: Receiver Segment29KDAUFSales Order Numbernvarchar100
6GLPCA_CTProfit Center Documents77KDAUFSales Order Numbernvarchar100
7GLPCA_T_CTProfit Center Documents93KDAUFSales Order Numbernvarchar100
8P2B2_C1HCM Declustering B2 - Cost Distribution Table C117KDAUFSales Order Numbernvarchar100
9P2B2_CWSTHCM Declustering B2 - PDC Time Tickets105KDAUFSales Order Numbernvarchar100
10P2B2_WSTHCM Declustering B2 - PDC Time Tickets105KDAUFSales Order Numbernvarchar100
11P2PL_RETROADJPayroll Result PL: Retro, originals and changes27KDAUFSales Order Numbernvarchar100
12P2PL_RETRODIFPayroll Result PL: Retro, originals and changes27KDAUFSales Order Numbernvarchar100
13P2PL_RETROMEMPayroll Result PL: Retro, originals and changes27KDAUFSales Order Numbernvarchar100
14P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)34KDAUFSales Order Numbernvarchar100
15P2RT_CZDAVP18_0318KDAUFSales Order Numbernvarchar100
16P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)34KDAUFSales Order Numbernvarchar100
17P2RX_C1Cost Distribution Table C115KDAUFSales Order Numbernvarchar100
18S980ORDRES DE FABRICATION52KDAUFNuméro de la commande clientnvarchar100
19S981OF ARTICLES POSTES62KDAUFNuméro de la commande clientnvarchar100
20ZEIM_AFPOOrder item11KDAUFSales order numbernvarchar100
21ZEIM_LIPSSD document: Delivery: Item data109KDAUFSales Order Numbernvarchar100
TOPAccounting Interface
22GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)195KDAUFSales Order Numbernvarchar100
23GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)195KDAUFSales Order Numbernvarchar100
TOPActual CostingMaterial Ledger
24CKMLDUVCOUsage Differences for Each Account Assignment Object17KDAUFSales Order Numbernvarchar100
25CKMLMV013Assignment table: Process for production order14KDAUFSales order numbernvarchar100
26FCML_ALTAlternatives17KDAUFSales Document Number (Alternative)nvarchar100
27FCML_PROCBusiness Processes19KDAUFSales Document Number (Process)nvarchar100
28MLCOMaterial valuation document account assignment information28KDAUFSales Order Numbernvarchar100
TOPAlternative Valuation Run
29CKMLAVRDOCITLines for Cumulation Posting Document52KDAUFSales Order Numbernvarchar100
TOPConfirmations
30AFFWGoods Movements with Errors from Confirmations15KDAUFSales Order Numbernvarchar100
31AFRVConfirmation pool25KDAUFSales Order Numbernvarchar100
32AFRV_DELBackup Copy for Confirmation Pool25KDAUFSales Order Numbernvarchar100
TOPConstruction Industry
33T5DB4HR Construction Site File9KDAUFSales Order Numbernvarchar100
34T5DB8Construction Sector: Team Assignment to Work Site32KDAUFSales Order Numbernvarchar100
35T5DBVConstruction Pay: Cost Assignment: Hostels14KDAUFSales Order Numbernvarchar100
36T5DBXConstruction Pay: Incentive Wage Connection14KDAUFSales Order Numbernvarchar100
TOPContract Accounts Receivable and Payable
37DFKKDEFREV_POSLine Item Table (Event-Based Deferred Revenues)32KDAUFSales Order Numbernvarchar100
38DFKKMOPKItems in contract account document11KDAUFSales Order Numbernvarchar100
39DFKKOPKItems in contract account document11KDAUFSales Order Numbernvarchar100
40DFKKORDERPOSRequests: Items48KDAUFSales Order Numbernvarchar100
41DFKKORDERPOS_SRequest Templates: Items42KDAUFSales Order Numbernvarchar100
42DFKKSUMPosting totals from FI-CA20KDAUFSales Order Numbernvarchar100
43DFKKSUMOLDTotals Records Without Account Assignment Changes7KDAUFSales Order Numbernvarchar100
44FKKDEFREVTrigger Table for Deferred Revenue Postings20KDAUFSales Order Numbernvarchar100
TOPCost Object
45FCO_DOC_HEADFailure Cost Document Header10KDAUFSales Order Numbernvarchar100
TOPCross-Application Components
46AAUUFKOrder master data70KDAUFSales Order Numbernvarchar100
TOPData Collection
47S225Goods receipts: repetitive manufacturing14KDAUFSales order numbernvarchar100
48S225ES225 - Structural Information9KDAUFSales order numbernvarchar100
49S226Material usage: repetitive manufacturing12KDAUFSales order numbernvarchar100
50S226ES226 - Structural Information7KDAUFSales order numbernvarchar100
51S227Product costs: repetitive manufacturing13KDAUFSales order numbernvarchar100
52S227ES227 - Structural Information8KDAUFSales order numbernvarchar100
53S279Transfer BW: Bestandsführung37KDAUFKlantordernummernvarchar100
54S279BIW1S279BIW1 * BW Transfer: Inventory Management37KDAUFSales Order Numbernvarchar100
55S279BIW2S279BIW2 * BW Transfer: Inventory Management37KDAUFSales Order Numbernvarchar100
TOPData Retention Tool
56TXW_S_MSEGRetrieve MSEG from archive34KDAUFSales Order Numbernvarchar100
TOPData Transfer
57PPDITTransfer to Accounting: Lines in HR IDOCs23KDAUFSales Order Numbernvarchar100
58PPDSTTransfer to Accounting: Substituted Acc. Assig. Object12KDAUFSales Order Numbernvarchar100
59PPKIXTransfer FI/CO: Index of Account Assignment Combinations14KDAUFSales Order Numbernvarchar100
TOPDemand Management
60PBIDPlanned independent requirements index: MRP area33KDAUFSales Order Numbernvarchar100
61PBIMIndependent Requirements for Material31KDAUFSales Order Numbernvarchar100
TOPDistribution of Usage Variances
62CKMLDUVNCOUsage Differences for Each Account Assignment Object17KDAUFSales Order Numbernvarchar100
TOPElectronic Bank Statement
63FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)44KDAUFSales Order Numbernvarchar100
64FEB_ACTAcct Assignment Templates44KDAUFSales Order Numbernvarchar100
TOPExchanges
65OIA12IMovement Based Netting document item18KDAUFSales Order Numbernvarchar100
66OIAQBExchange Movements Index25KDAUFSales Order Numbernvarchar100
TOPFinancial Accounting
67ACCTITCompressed Data from FI/CO Document70KDAUFSales Order Numbernvarchar100
68T076KFI-EDI: Additional Account Assignments11KDAUFSales Order Numbernvarchar100
69VBSEGADocument Segment for Document Parking - Asset Database46KDAUFSales Order Numbernvarchar100
70VBSEGSDocument Segment for Document Parking - G/L Account Database37KDAUFSales Order Numbernvarchar100
TOPFunds Management-Specific Postings
71FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years38KDAUFSales Order Numbernvarchar100
72PSOSEGSRecurring Request Document Segment, G/L Accounts37KDAUFSales Order Numbernvarchar100
TOPGeneral Ledger Accounting
73FAGL_SPLINFOSplittling Information of Open Items20KDAUFSales Order Numbernvarchar100
TOPGeneral Ledger Reorganization
74FAGL_R_SPLReorganization: Splitting Information of the Open Items24KDAUFSales Order Numbernvarchar100
TOPGL Account Posting
75TCJ_POSITIONSCash Journal Document Items51KDAUFSales Order Numbernvarchar100
TOPInformation System
76MCAFPOVVersions: Order Item28KDAUFSales order numbernvarchar100
77MCCOMPVVersions: Material Components18KDAUFSales Order Numbernvarchar100
78MCSFISR/2 SFIS Data: Old62KDAUFSales order numbernvarchar100
TOPInterface to Terminal Automation System
79OIK02BIS-OIL/TAS: Status of processed functions - messages18KDAUFSales Order Numbernvarchar100
80OIK29IS-OIL/TPI: Status of processed inbound IDoc OILSHI019KDAUFSales Documentnvarchar100
81OIK29CIS-OIL/TPI: Status of processed functions - messages17KDAUFSales Order Numbernvarchar100
82OIK29DIS-OIL/TPI: Status of processed inbound IDoc OILSHI0110KDAUFSales Documentnvarchar100
TOPInventory Management
83CHVWTable CHVW for Batch Where-Used List10KDAUFSales Order Numbernvarchar100
84ISEGPhysical Inventory Document Items11KDAUFSales Order Numbernvarchar100
85MSEGDocument Segment: Material21KDAUFSales Order Numbernvarchar100
86MWXMSEGZMSEG: Interface for Posting of Value21KDAUFSales Order Numbernvarchar100
87MWZMSEGZMSEG:Interface for Posting of Value21KDAUFSales Order Numbernvarchar100
88RESBReservation/dependent requirements34KDAUFSales Order Numbernvarchar100
89RKPFDocument Header: Reservation17KDAUFSales Order Numbernvarchar100
TOPLogistics Information System LIS
90S280Order header and item, BW52KDAUFSales order numbernvarchar100
91S280BIW1S280BIW1 * Order header and item, BW52KDAUFSales order numbernvarchar100
92S280BIW2S280BIW2 * Order Header and Item, BW52KDAUFSales order numbernvarchar100
93S281Order Operation, BW62KDAUFSales order numbernvarchar100
94S281BIW1S281BIW1 * Order Process, BW62KDAUFSales order numbernvarchar100
95S281BIW2S281BIW2 * Order Process, BW62KDAUFSales order numbernvarchar100
96S282Order Component, BW20KDAUFSales order numbernvarchar100
97S282BIW1S282BIW1 * Order Components, BW20KDAUFSales order numbernvarchar100
98S282BIW2S282BIW2 * Order Components, BW20KDAUFSales order numbernvarchar100
TOPMaintenance Notifications
99QMIHQuality message - maintenance data excerpt31KDAUFSales Documentnvarchar100
TOPMaintenance Orders
100AUFMGoods movements for order14KDAUFSales Order Numbernvarchar100
TOPMaintenance Program Definition
101MPDITEMMaintenance Plan Items12KDAUFSales Documentnvarchar100
TOPMaintenance Task Lists
102MPOSMaintenance item39KDAUFSales Documentnvarchar100
TOPMaster Data
103BLPKDocument log header11KDAUFSales and Distribution Document Numbernvarchar100
104KBVLIndividual Customer Plng File Entry, MRP Area Long-Term Plng7KDAUFSales Order Numbernvarchar100
105KBVMIndividual Customer Planning File Entry, MRP Area6KDAUFSales Order Numbernvarchar100
106KDPLIndex customer order -> planned order2KDAUFSales Order Numbernvarchar100
107KDVLIndividual Customer Planning File Entry, Long-Term Planning5KDAUFSales Order Numbernvarchar100
108KDVMIndividual Customer Planning File Entry4KDAUFSales Order Numbernvarchar100
109MDSMSimulative dependent requirements90KDAUFSales Order Numbernvarchar100
110PLAFPlanned Order22KDAUFSales Order Numbernvarchar100
111PSPLIndex project -> planned order7KDAUFSales Order Numbernvarchar100
112PUMSProject number new key assignment (structure)2KDAUFSales Order Numbernvarchar100
TOPMaterials Management
113/ISDFPS/CHVW_EExternal Batch Where-Used List10KDAUFSales Order Numbernvarchar100
114J_1GVL_MLMaterial Ledger93KDAUFSales Order Numbernvarchar100
TOPOverhead Cost Orders
115AUFKOrder master data70KDAUFSales Order Numbernvarchar100
116COBRBDistribution Rules Settlement Rule Order Settlement46KDAUFSales Order Numbernvarchar100
TOPPayroll
117T5TPSC1SPLITRozdelení nákladu25KDAUFCíslo zakázky odberatelenvarchar100
TOPPersonnel Time Events
118TPTCOR_KOSTLCost Assignment (Correction Scenario)7KDAUFSales Order Numbernvarchar100
TOPPersonnel Time Management
119ASSOBAssignment Objects13KDAUFSales Order Numbernvarchar100
120CC1ERPIncorrect Time Events from CC1, Postings106KDAUFSales Order Numbernvarchar100
121CC1TEVTemporary Buffer for Time Events from CC130KDAUFSales Order Numbernvarchar100
122COIFTInterface to Activity Allocation45KDAUFSales Order Numbernvarchar100
123PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)55KDAUFSales Order Numbernvarchar100
124PTEX2003GENInterface Table for IT 2003: General Information54KDAUFSales Order Numbernvarchar100
125PTEX2003SPECInterface Table for IT 2003: Interval Information30KDAUFSales Order Numbernvarchar100
126PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)54KDAUFSales Order Numbernvarchar100
127TEVEN_MOREAdditional Data for Time Events105KDAUFSales Order Numbernvarchar100
TOPPlant Data Collection
128RUECKTemp. storage for subsystem confirmations20KDAUFSales Order Numbernvarchar100
TOPProduction Backflush
129PPC_COMATMaximum Bill of Material of Backflushed Materials (for CO)8KDAUFSales Order Numbernvarchar100
130PPC_HEADDocument PP Backflush - Header13KDAUFSales Order Numbernvarchar100
131PPC_MAT_DETSuper BOM: Special Account/Batch Information4KDAUFSales Order Numbernvarchar100
132PPC_STEP2Goods Movements Table for New PPCGO Logic (2 Steps)14KDAUFSales Order Numbernvarchar100
TOPProduction Orders
133AFPOOrder item11KDAUFSales order numbernvarchar100
TOPProfit Center Accounting
134GLPCAEC-PCA: Actual Line Items72KDAUFSales Order Numbernvarchar100
135GLPCPEC-PCA: Plan Line Items130KDAUFSales Order Numbernvarchar100
TOPProfitability Analysis Basic Functions
136K840001Summarization level KT: 800 KK 01 KKROBJ 00000112KDAUFSales Order Numbernvarchar100
137K840005Summarization level KT: 800 KK 01 KKROBJ 00000312KDAUFSales Order Numbernvarchar100
138K840009Summarization level KT: 800 KK 01 KKROBJ 00000512KDAUFSales Order Numbernvarchar100
TOPQuality Inspection
139QALSInspection lot record110KDAUFSales Order Number of Valuated Sales Order Stocknvarchar100
TOPQuality Notifications
140TQ8COAssignment of reference orders to notification type12KDAUFSales Order Numbernvarchar100
TOPRepetitive Manufacturing
141COMPMOVEGoods Movement of Components116KDAUFSales Order Numbernvarchar100
142RMUSERUser Settings for REM Backflush Transactions7KDAUFSales Order Numbernvarchar100
TOPSerial Numbers
143EQBSSerial Number Stock Segment10KDAUFSales Order Numbernvarchar100
TOPShipping
144LIPSSD document: Delivery: Item data109KDAUFSales Order Numbernvarchar100
TOPSimulation
145VSAFPO_CNVersion: Order items in PP orders12KDAUFSales order numbernvarchar100
146VSAUFK_CNVersion: Order master data71KDAUFSales Order Numbernvarchar100
147VSPLAF_CNVersion: Planned order23KDAUFSales Order Numbernvarchar100
148VSRESB_CNVersion: Reservation/Dependent requirements35KDAUFSales Order Numbernvarchar100
TOPSocial Insurance
149T5D3PHR Technical Assignments for Workers' Compensation Assoc.9KDAUFSales Order Numbernvarchar100
TOPTariffs, Duties and Permits
150OIH14Tax rate revaluation - obsolete9KDAUFSales Order Numbernvarchar100
TOPTravel Expenses
151PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document22KDAUFSales Order Numbernvarchar100
TOPTravel Planning
152FTPT_REQ_ACCOUNTTravel Request Cost Assignment17KDAUFSales Order Numbernvarchar100