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
2OCRD332Business Partner
3OINV386A/R Invoice
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

123 columns | Print definition?ERP 6.0  | APLZL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/KBED_EXExchange Table - Capacity Requirements5APLZLGeneral counter for ordernvarchar80
2/SYCLO/AUFPL_EXSyclo Exchange Table - Maintenance Work Order5APLZLGeneral counter for ordernvarchar80
3AUAASettlement Document: Receiver Segment28APLZLInternal counternvarchar80
4BSAD_BAKAccounting: Secondary index for customers (cleared items)99APLZLInternal counternvarchar80
5BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)103APLZLInternal counternvarchar80
6BSEGAccounting Document Segment225APLZLGeneral counter for ordernvarchar80
7BSID_BAKAccounting: Secondary Index for Customers99APLZLInternal counternvarchar80
8BSIK_BAKAccounting: Secondary index for vendors103APLZLInternal counternvarchar80
9BSSEGAccounting Document Segment214APLZLGeneral counter for ordernvarchar80
10FUDT_VDOCBSEGVerification Document Item with Additional Info214APLZLGeneral counter for ordernvarchar80
11FUDT_VDOCBSEGEVVerification Document Item in the Entry View214APLZLGeneral counter for ordernvarchar80
12FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)214APLZLGeneral counter for ordernvarchar80
13GLPOS_C_CTFI Document: Entry View44APLZLGeneral counter for ordernvarchar80
14GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items44APLZLGeneral counter for ordernvarchar80
15GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items44APLZLGeneral counter for ordernvarchar80
16GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items44APLZLGeneral counter for ordernvarchar80
17GLPOS_N_CTNew General Ledger: Line Item with Currency Type44APLZLGeneral counter for ordernvarchar80
18GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type44APLZLGeneral counter for ordernvarchar80
19ODTF_IDOC_LOG_NATravel on Demand: Log f. Netw. Activity Replication via IDOC3APLZLGeneral counter for ordernvarchar80
20QAOPERATIONRelation between Keyfields of PP and QM3APLZLGeneral counter for ordernvarchar80
21REGUPProcessed items from payment program101APLZLInternal counternvarchar80
22ZPS22FProject system: Text symbol assign. Standard network seq.4APLZLInternal counternvarchar80
23ZPS23Project System: Text Symbol Assignment - Activities4APLZLGeneral counter for ordernvarchar80
TOPAccounting Interface
24GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)178APLZLInternal counternvarchar80
25GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)178APLZLInternal counternvarchar80
TOPActual CostingMaterial Ledger
26CKMLDUVCOUsage Differences for Each Account Assignment Object23APLZLGeneral counter for ordernvarchar80
TOPAlternative Valuation Run
27CKMLAVRDOCITLines for Cumulation Posting Document48APLZLInternal counternvarchar80
TOPBasic Functions
28FPLABilling Plan23APLZLGeneral counter for ordernvarchar80
29FPLAPOBilling Plan23APLZLGeneral counter for ordernvarchar80
30VFPLABilling Plan23APLZLGeneral counter for ordernvarchar80
TOPBilling
31VBRPBilling Document: Item Data202APLZLInternal counternvarchar80
TOPCapacity Evaluations
32CYOPR_MOVEOrder-/operation data3APLZLGeneral counter for ordernvarchar80
TOPCapacity Leveling
33ISTBEDActual requirements records8APLZLGeneral counter for ordernvarchar80
TOPConfirmations
34AFFWGoods Movements with Errors from Confirmations36APLZLInternal counternvarchar80
35AFRUOrder Confirmations67APLZLGeneral counter for ordernvarchar80
TOPCost Object
36FCO_DOC_HEADFailure Cost Document Header17APLZLInternal counternvarchar80
TOPCross-Application Components
37BBSIDAccounting: Secondary index for customers99APLZLInternal counternvarchar80
38ONROSObject number index for order sequence4APLZLInternal counternvarchar80
39ONROVObject number index for order process4APLZLInternal counternvarchar80
TOPDistribution of Usage Variances
40CKMLDUVACTCODistribution Acty Differences: Diff. Per Acct Assgnmt object22APLZLGeneral counter for ordernvarchar80
41CKMLDUVNCOUsage Differences for Each Account Assignment Object23APLZLGeneral counter for ordernvarchar80
42DUVMSEG_EXTRACTduv mseg extract for performance19APLZLInternal counternvarchar80
TOPExternal Services
43ESKNAccount Assignment in Service Package31APLZLInternal counternvarchar80
TOPFinancial Accounting
44ACCTITCompressed Data from FI/CO Document141APLZLInternal counternvarchar80
45BSADAccounting: Secondary Index for Customers (Cleared Items)99APLZLInternal counternvarchar80
46BSAKAccounting: Secondary Index for Vendors (Cleared Items)103APLZLInternal counternvarchar80
47BSIDAccounting: Secondary Index for Customers99APLZLInternal counternvarchar80
48BSIKAccounting: Secondary Index for Vendors103APLZLInternal counternvarchar80
TOPFreight Processing
49VFKNAccount Determination in Shipment Costs Item30APLZLInternal counternvarchar80
TOPFunds Management
50KBLPDocument Item: Manual Document Entry36APLZLGeneral counter for ordernvarchar80
TOPGeneral Ledger Accounting
51BSEG_ADDEntry View of Accounting Document for Additional Ledgers47APLZLGeneral counter for ordernvarchar80
52FAGL_SPLINFOSplittling Information of Open Items25APLZLInternal counternvarchar80
TOPGeneral Ledger Reorganization
53FAGL_R_SPLReorganization: Splitting Information of the Open Items20APLZLInternal counternvarchar80
TOPInformation System
54MCAFVGVVersions: Order Procedure6APLZLInternal counternvarchar80
55MCSFISR/2 SFIS Data: Old69APLZLInternal counternvarchar80
TOPInterest
56TZIN1Document Header Data from Source Document (PS Int.Calc.)18APLZLInternal counternvarchar80
TOPInterface to External Project Software
57NVGUIDGUIDs for Network Activity4APLZLGeneral counter for ordernvarchar80
TOPInventory Management
58MSEGDocument Segment: Material116APLZLInternal counternvarchar80
59MWXMSEGZMSEG: Interface for Posting of Value116APLZLInternal counternvarchar80
60MWZMSEGZMSEG:Interface for Posting of Value116APLZLInternal counternvarchar80
61RESBReservation/dependent requirements100APLZLInternal counternvarchar80
62RKPFDocument Header: Reservation33APLZLInternal counternvarchar80
TOPInvoice Verification
63RBCODocument Item, Incoming Invoice, Account Assignment9APLZLRouting number of operations in the ordernvarchar100
TOPJoint Venture und Production Sharing Accounting
64JVCO1JV Object Table 2 for JVTO16APLZLGeneral counter for ordernvarchar80
65JVPO1JVA: Plan Line Items33APLZLGeneral counter for ordernvarchar80
66JVPSC01OObject table 119APLZLGeneral counter for ordernvarchar80
67JVSO1JV LI Table with Objects for JVTO133APLZLGeneral counter for ordernvarchar80
68JVTO1JV Summary Table with Objects31APLZLGeneral counter for ordernvarchar80
TOPLocal Currency Changeover
69EWUFI_SCAEMU conversion: Table of the clearings to be adjusted22APLZLGeneral counter for ordernvarchar80
TOPMaintenance History
70HIVGPM order history - operations6APLZLGeneral counter for ordernvarchar80
TOPMaintenance Notifications
71OPROLAVO Link to Object List Entry3APLZLGeneral counter for ordernvarchar80
TOPMaintenance Orders
72/MRSS/D_DEM_PSRejected and/or deleted requirements3APLZLGeneral counter for ordernvarchar80
73AUFMGoods movements for order39APLZLInternal counternvarchar80
TOPMaster Data
74MDSMSimulative dependent requirements83APLZLInternal counternvarchar80
TOPNetwork and Activity
75MLSTMilestone19APLZLInternal counternvarchar80
TOPOverhead Cost Orders
76COBRBDistribution Rules Settlement Rule Order Settlement43APLZLInternal counternvarchar80
TOPPlant Maintenance
77Z9I_STK_IF_NPVPM/PS-Schnittstelle: Netzplanvorgänge29APLZLInterner Zählernvarchar80
78Z9I_STK_IF_NPV_WPM/PS-Schnittstelle: Netzplanvorgänge Werkstattsicht36APLZLInterner Zählernvarchar80
79Z9I_STK_VORGANGTerminkontrolle Stillstandsplanung: Relevante Vorgänge17APLZLAllgemeiner Zähler des Auftragsnvarchar80
TOPProcess Order
80AFFTOrder - Process Instructions3APLZLGeneral counter for ordernvarchar80
81AFFVOrder - Process Instruction Values3APLZLGeneral counter for ordernvarchar80
82COCR_CMX_DB_CSContext Data for XSteps5APLZLGeneral counter for ordernvarchar80
83OPDEVOrder Operation - Schedule Deviations3APLZLGeneral counter for ordernvarchar80
TOPProduct Cost Planning
84CKISItems Unit Costing/Itemization Product Costing88APLZLContinuous Counter for Differentiating Database Entriesnvarchar80
TOPProduct Lifecycle Management
85DIWPS_NOTI_PCOMPTable for Partically Completed Notifications9APLZLGeneral counter for ordernvarchar80
TOPProduction Orders
86AFFLWork order sequence3APLZLInternal counternvarchar80
87AFSPOPRSplit Operations in an Order Split3APLZLGeneral counter for ordernvarchar80
88AFVCOperation within an order3APLZLGeneral counter for ordernvarchar80
89AFVUDB structure of the user fields of the operation3APLZLGeneral counter for ordernvarchar80
90AFVVDB structure of the quantities/dates/values in the operation3APLZLGeneral counter for ordernvarchar80
91COWIPB_CHVWWIP Batches with Where-Used List26APLZLGeneral counter for ordernvarchar80
92ORDCOMCommunication control Operation download3APLZLGeneral counter for ordernvarchar80
TOPProduction ResourcesTools
93AFFHPRT assignment data for the work order17APLZLInternal counternvarchar80
TOPProject System
94PSHLPDB_HIER_TMPTable to store temporary hierarchy data14APLZLGeneral counter for ordernvarchar80
95PSHLP_HIER_DBLocal cache:Project/Independent Network hierarchy14APLZLGeneral counter for ordernvarchar80
TOPPurchasing
96EBKNPurchase Requisition Account Assignment33APLZLInternal counternvarchar80
97EKKNAccount Assignment in Purchasing Document36APLZLInternal counternvarchar80
TOPQuality Inspection
98QALSInspection lot record189APLZLInternal counternvarchar80
TOPQuality Notifications
99TQ8COAssignment of reference orders to notification type11APLZLInternal counternvarchar80
TOPRemaining Beverage - Obsolete Objects
100/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1216APLZLGeneral counter for ordernvarchar80
TOPRepetitive Manufacturing
101COMPMOVEGoods Movement of Components155APLZLGeneral counter for ordernvarchar80
TOPScheduling
102KBEDCapacity Requirements Records35APLZLGeneral counter for ordernvarchar80
TOPSelf-Service Procurement
103/SRMERP/D_ACC_ITAccount assignment item30APLZLInternal counternvarchar80
TOPSimulation
104VSAFFH_CNVersion: PRT allocation to work order18APLZLInternal counternvarchar80
105VSAFFL_CNVersion: Order sequences PP orders4APLZLInternal counternvarchar80
106VSAFVC_CNVersion: Operation in order4APLZLGeneral counter for ordernvarchar80
107VSAFVU_CNVersion: User fields in operation in order4APLZLGeneral counter for ordernvarchar80
108VSAFVV_CNVersion: Quantities/Dates/Values in order operation4APLZLGeneral counter for ordernvarchar80
109VSEBKN_CNVersion: Purchase requisition account assignment34APLZLInternal counternvarchar80
110VSFPLA_CNVersion: Billing schedule24APLZLGeneral counter for ordernvarchar80
111VSHIST_NVTranfer history for network activity3APLZLGeneral counter for ordernvarchar80
112VSHIST_OVTransfer history activity3APLZLGeneral counter for ordernvarchar80
113VSKBED_CNVersion: Capacity requirement records36APLZLGeneral counter for ordernvarchar80
114VSMLST_CNVersion: Milestone20APLZLInternal counternvarchar80
115VSRESB_CNVersion: Reservation/Dependent requirements101APLZLInternal counternvarchar80
TOPStructures
116PSHLP_ACT_PM_DTTable for tracking whether acty dates are determined by pmcs3APLZLGeneral counter for ordernvarchar80
TOPTechnical Application Support
117CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted19APLZLGeneral counter for ordernvarchar80
TOPWork Clearance Management
118WCAEWCM: Order Operation <-> Approval Group3APLZLGeneral counter for ordernvarchar80
119WCAEQWCM: Log (Order Operation <-> Approval Group)3APLZLGeneral counter for ordernvarchar80
120WCAFWCM: Order Operation <-> Work Clearance Document3APLZLGeneral counter for ordernvarchar80
121WCAFQWCM: Log (Order Operation <-> Work Clearance Document)3APLZLGeneral counter for ordernvarchar80
122WCASWCM: Application <-> Order Operation4APLZLGeneral counter for ordernvarchar80
123WCASQWCM: Log (Application <-> Order Operation)4APLZLGeneral counter for ordernvarchar80