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
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

123 columns | Print definition?ERP 6.0  | NPLNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item41NPLNRNetwork Number for Account Assignmentnvarchar120
2/OPT/VIM_TITEMDocument Item41NPLNRNetwork Number for Account Assignmentnvarchar120
3AUAASettlement Document: Receiver Segment26NPLNRNetwork Number for Account Assignmentnvarchar120
4BSAD_BAKAccounting: Secondary index for customers (cleared items)97NPLNRNetwork Number for Account Assignmentnvarchar120
5BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)101NPLNRNetwork Number for Account Assignmentnvarchar120
6BSEGAccounting Document Segment223NPLNRNetwork Number for Account Assignmentnvarchar120
7BSID_BAKAccounting: Secondary Index for Customers97NPLNRNetwork Number for Account Assignmentnvarchar120
8BSIK_BAKAccounting: Secondary index for vendors101NPLNRNetwork Number for Account Assignmentnvarchar120
9BSSEGAccounting Document Segment212NPLNRNetwork Number for Account Assignmentnvarchar120
10FUDT_VDOCBSEGVerification Document Item with Additional Info212NPLNRNetwork Number for Account Assignmentnvarchar120
11FUDT_VDOCBSEGEVVerification Document Item in the Entry View212NPLNRNetwork Number for Account Assignmentnvarchar120
12FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)212NPLNRNetwork Number for Account Assignmentnvarchar120
13GLPOS_C_CTFI Document: Entry View181NPLNRNetwork Number for Account Assignmentnvarchar120
14GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items181NPLNRNetwork Number for Account Assignmentnvarchar120
15GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items181NPLNRNetwork Number for Account Assignmentnvarchar120
16GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items181NPLNRNetwork Number for Account Assignmentnvarchar120
17GLPOS_N_CTNew General Ledger: Line Item with Currency Type184NPLNRNetwork Number for Account Assignmentnvarchar120
18GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type184NPLNRNetwork Number for Account Assignmentnvarchar120
19P2B2_C1HCM Declustering B2 - Cost Distribution Table C115NPLNRNetwork Number for Account Assignmentnvarchar120
20P2B2_CWSTHCM Declustering B2 - PDC Time Tickets103NPLNRNetwork Number for Account Assignmentnvarchar120
21P2B2_WSTHCM Declustering B2 - PDC Time Tickets103NPLNRNetwork Number for Account Assignmentnvarchar120
22P2PL_RETROADJPayroll Result PL: Retro, originals and changes25NPLNRNetwork Number for Account Assignmentnvarchar120
23P2PL_RETRODIFPayroll Result PL: Retro, originals and changes25NPLNRNetwork Number for Account Assignmentnvarchar120
24P2PL_RETROMEMPayroll Result PL: Retro, originals and changes25NPLNRNetwork Number for Account Assignmentnvarchar120
25P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)32NPLNRNetwork Number for Account Assignmentnvarchar120
26P2RT_CZDAVP18_0316NPLNRNetwork Number for Account Assignmentnvarchar120
27P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)32NPLNRNetwork Number for Account Assignmentnvarchar120
28P2RX_C1Cost Distribution Table C113NPLNRNetwork Number for Account Assignmentnvarchar120
29P2RX_FUNDAccounting Structure for Funds Management25NPLNRNetwork Number for Account Assignmentnvarchar120
30REGUPProcessed items from payment program99NPLNRNetwork Number for Account Assignmentnvarchar120
31YVIM_1ITEMDocument Item41NPLNRNetwork Number for Account Assignmentnvarchar120
TOPAccounting Interface
32GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)176NPLNRNetwork Number for Account Assignmentnvarchar120
33GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)176NPLNRNetwork Number for Account Assignmentnvarchar120
TOPActual CostingMaterial Ledger
34MLCOMaterial valuation document account assignment information23NPLNRNetwork Number for Account Assignmentnvarchar120
TOPAlternative Valuation Run
35CKMLAVRDOCITLines for Cumulation Posting Document49NPLNRNetwork Number for Account Assignmentnvarchar120
TOPConfirmations
36AFRVConfirmation pool23NPLNRNetwork Number for Account Assignmentnvarchar120
37AFRV_DELBackup Copy for Confirmation Pool23NPLNRNetwork Number for Account Assignmentnvarchar120
TOPConstruction Industry
38T5DB4HR Construction Site File7NPLNRNetwork Number for Account Assignmentnvarchar120
39T5DB8Construction Sector: Team Assignment to Work Site29NPLNRNetwork Number for Account Assignmentnvarchar120
40T5DBVConstruction Pay: Cost Assignment: Hostels12NPLNRNetwork Number for Account Assignmentnvarchar120
41T5DBXConstruction Pay: Incentive Wage Connection12NPLNRNetwork Number for Account Assignmentnvarchar120
TOPCross-Application Components
42BBSIDAccounting: Secondary index for customers97NPLNRNetwork Number for Account Assignmentnvarchar120
TOPData Retention Tool
43TXW_S_BSEGRetrieve BSEG from archive67NPLNRNetwork Number for Account Assignmentnvarchar120
44TXW_S_MSEGRetrieve MSEG from archive40NPLNRNetwork Number for Account Assignmentnvarchar120
TOPData Transfer
45PPDITTransfer to Accounting: Lines in HR IDOCs21NPLNRNetwork Number for Account Assignmentnvarchar120
46PPDSTTransfer to Accounting: Substituted Acc. Assig. Object10NPLNRNetwork Number for Account Assignmentnvarchar120
47PPKIXTransfer FI/CO: Index of Account Assignment Combinations12NPLNRNetwork Number for Account Assignmentnvarchar120
TOPElectronic Bank Statement
48FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)32NPLNRNetwork Number for Account Assignmentnvarchar120
49FEB_ACTAcct Assignment Templates32NPLNRNetwork Number for Account Assignmentnvarchar120
TOPExternal Services
50ESKNAccount Assignment in Service Package28NPLNRNetwork Number for Account Assignmentnvarchar120
TOPFinancial Accounting
51/OPT/VIM_1ITEMDocument Item41NPLNRNetwork Number for Account Assignmentnvarchar120
52ACCTITCompressed Data from FI/CO Document67NPLNRNetwork Number for Account Assignmentnvarchar120
53BSADAccounting: Secondary Index for Customers (Cleared Items)97NPLNRNetwork Number for Account Assignmentnvarchar120
54BSAKAccounting: Secondary Index for Vendors (Cleared Items)101NPLNRNetwork Number for Account Assignmentnvarchar120
55BSIDAccounting: Secondary Index for Customers97NPLNRNetwork Number for Account Assignmentnvarchar120
56BSIKAccounting: Secondary Index for Vendors101NPLNRNetwork Number for Account Assignmentnvarchar120
57EBSEGDoc.Segment of Fin.Accntng External Documents69NPLNRNetwork Number for Account Assignmentnvarchar120
58KMZEIFI: Account Assignment Model Item Information47NPLNRNetwork Number for Account Assignmentnvarchar120
59KOMUAccount Assignment Templates for G/L Account Items47NPLNRNetwork Number for Account Assignmentnvarchar120
60T076KFI-EDI: Additional Account Assignments15NPLNRNetwork Number for Account Assignmentnvarchar120
61VBSEGADocument Segment for Document Parking - Asset Database50NPLNRNetwork Number for Account Assignmentnvarchar120
62VBSEGSDocument Segment for Document Parking - G/L Account Database76NPLNRNetwork Number for Account Assignmentnvarchar120
TOPFreight Processing
63VFKNAccount Determination in Shipment Costs Item26NPLNRNetwork Number for Account Assignmentnvarchar120
TOPFunds Management
64KBLPDocument Item: Manual Document Entry39NPLNRNetwork Number for Account Assignmentnvarchar120
TOPFunds Management-Specific Postings
65FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years75NPLNRNetwork Number for Account Assignmentnvarchar120
66PSOSEGSRecurring Request Document Segment, G/L Accounts74NPLNRNetwork Number for Account Assignmentnvarchar120
TOPGeneral Ledger Accounting
67BSEG_ADDEntry View of Accounting Document for Additional Ledgers45NPLNRNetwork Number for Account Assignmentnvarchar120
68FAGL_SPLINFOSplittling Information of Open Items24NPLNRNetwork Number for Account Assignmentnvarchar120
TOPGeneral Ledger Reorganization
69FAGL_R_SPLReorganization: Splitting Information of the Open Items21NPLNRNetwork Number for Account Assignmentnvarchar120
TOPGL Account Posting
70TCJ_POSITIONSCash Journal Document Items39NPLNRNetwork Number for Account Assignmentnvarchar120
TOPInterest
71TZIN1Document Header Data from Source Document (PS Int.Calc.)20NPLNRNetwork Number for Account Assignmentnvarchar120
TOPInventory Management
72MSEGDocument Segment: Material114NPLNRNetwork Number for Account Assignmentnvarchar120
73MWXMSEGZMSEG: Interface for Posting of Value114NPLNRNetwork Number for Account Assignmentnvarchar120
74MWZMSEGZMSEG:Interface for Posting of Value114NPLNRNetwork Number for Account Assignmentnvarchar120
75RKPFDocument Header: Reservation31NPLNRNetwork Number for Account Assignmentnvarchar120
TOPInvoice Verification
76RBCODocument Item, Incoming Invoice, Account Assignment64NPLNRNetwork Number for Account Assignmentnvarchar120
TOPJapan
77T7JPSK_CONTTShukko Contract Template12NPLNRNetwork Number for Account Assignmentnvarchar120
TOPJoint Venture und Production Sharing Accounting
78JVCO1JV Object Table 2 for JVTO13NPLNRNetwork Number for Account Assignmentnvarchar120
79JVPO1JVA: Plan Line Items31NPLNRNetwork Number for Account Assignmentnvarchar120
80JVSO1JV LI Table with Objects for JVTO131NPLNRNetwork Number for Account Assignmentnvarchar120
81JVTO1JV Summary Table with Objects28NPLNRNetwork Number for Account Assignmentnvarchar120
TOPLocal Currency Changeover
82EWUFI_SCAEMU conversion: Table of the clearings to be adjusted20NPLNRNetwork Number for Account Assignmentnvarchar120
TOPLocalization
83J_1BNFLINNota Fiscal line items93NPLNRNetwork Number for Account Assignmentnvarchar120
84J_1B_CIAP_OBJECTCIAP document data22NPLNRNetwork Number for Account Assignmentnvarchar120
85J_3RNDSINVTarget use of ingoing invoice positions for AuC16NPLNRNetwork Number for Account Assignmentnvarchar120
TOPMaintenance Orders
86AUFMGoods movements for order37NPLNRNetwork Number for Account Assignmentnvarchar120
TOPMaterials Management
87J_1GVL_MLMaterial Ledger89NPLNRNetwork Number for Account Assignmentnvarchar120
TOPOverhead Cost Orders
88COBRBDistribution Rules Settlement Rule Order Settlement41NPLNRNetwork Number for Account Assignmentnvarchar120
TOPPayment Transactions
89CRACCPayment Cards: Account Assignments in Card Master Record29NPLNRNetwork Number for Account Assignmentnvarchar120
90CRNUMPayment cards: Card master record50NPLNRNetwork Number for Account Assignmentnvarchar120
91FPRL_ITEMItem Data57NPLNRNetwork Number for Account Assignmentnvarchar120
TOPPayroll
92T5TPSC1SPLITRozdelení nákladu23NPLNRCís.sít.diagramu pro prirazení úctunvarchar120
TOPPersonnel Time Events
93TPTCOR_KOSTLCost Assignment (Correction Scenario)6NPLNRNetwork Number for Account Assignmentnvarchar120
TOPPersonnel Time Management
94ASSOBAssignment Objects11NPLNRNetwork Number for Account Assignmentnvarchar120
95CC1ERPIncorrect Time Events from CC1, Postings105NPLNRNetwork Number for Account Assignmentnvarchar120
96CC1TEVTemporary Buffer for Time Events from CC128NPLNRNetwork Number for Account Assignmentnvarchar120
97COIFTInterface to Activity Allocation43NPLNRNetwork Number for Account Assignmentnvarchar120
98PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)53NPLNRNetwork Number for Account Assignmentnvarchar120
99PTEX2003GENInterface Table for IT 2003: General Information52NPLNRNetwork Number for Account Assignmentnvarchar120
100PTEX2003SPECInterface Table for IT 2003: Interval Information28NPLNRNetwork Number for Account Assignmentnvarchar120
101PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)52NPLNRNetwork Number for Account Assignmentnvarchar120
102TEVEN_MOREAdditional Data for Time Events104NPLNRNetwork Number for Account Assignmentnvarchar120
TOPPlant Data Collection
103RUECKTemp. storage for subsystem confirmations18NPLNRNetwork Number for Account Assignmentnvarchar120
TOPPosition Budgeting and Control
104HRFPM_DIFFERENCEHRFPM: Personnel Costs Savings/ Overrun34NPLNRNetwork Number for Account Assignmentnvarchar120
105HRFPM_FM_POSHRFPM: FM Documents - Items18NPLNRNetwork Number for Account Assignmentnvarchar120
106HRFPM_FM_POS_BUHRFPM: FM Documents - Items for Budget19NPLNRNetwork Number for Account Assignmentnvarchar120
107HRFPM_FPM_POSHRFPM: FPM Documents - Items32NPLNRNetwork Number for Account Assignmentnvarchar120
108HRFPM_FPM_POS_BUHRFPM: FPM Documents - Items for Budget33NPLNRNetwork Number for Account Assignmentnvarchar120
109HRFPM_OBJECTSHRFPM: Object table of the commitment engine28NPLNRNetwork Number for Account Assignmentnvarchar120
TOPPurchasing
110EBKNPurchase Requisition Account Assignment30NPLNRNetwork Number for Account Assignmentnvarchar120
111EKCPAPurchasing Contract Commitment Plan Account Assignment Data15NPLNRNetwork Number for Account Assignmentnvarchar120
112EKKNAccount Assignment in Purchasing Document33NPLNRNetwork Number for Account Assignmentnvarchar120
TOPQuality Inspection
113QALSInspection lot record188NPLNRNetwork Number for Account Assignmentnvarchar120
TOPQuality Notifications
114TQ8COAssignment of reference orders to notification type10NPLNRNetwork Number for Account Assignmentnvarchar120
TOPRemaining Beverage - Obsolete Objects
115/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1214NPLNRNetwork Number for Account Assignmentnvarchar120
TOPRemote Logistics Management
116OIO_RT_RTDOC_MTReturns document - material items17NPLNRNetwork Number for Account Assignmentnvarchar120
TOPRepetitive Manufacturing
117COMPMOVEGoods Movement of Components119NPLNRNetwork Number for Account Assignmentnvarchar120
TOPSelf-Service Procurement
118/SRMERP/D_ACC_ITAccount assignment item27NPLNRNetwork Number for Account Assignmentnvarchar120
TOPSimulation
119VSEBKN_CNVersion: Purchase requisition account assignment31NPLNRNetwork Number for Account Assignmentnvarchar120
TOPSocial Insurance
120T5D3PHR Technical Assignments for Workers' Compensation Assoc.7NPLNRNetwork Number for Account Assignmentnvarchar120
TOPTechnical Application Support
121CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted17NPLNRNetwork Number for Account Assignmentnvarchar120
TOPTravel Expenses
122PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document20NPLNRNetwork Number for Account Assignmentnvarchar120
TOPTravel Planning
123FTPT_REQ_ACCOUNTTravel Request Cost Assignment15NPLNRNetwork Number for Account Assignmentnvarchar120