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

118 columns | Print definition?ERP 6.0  | PRZNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item85PRZNRBusiness Processnvarchar120
2/OPT/VIM_TITEMDocument Item85PRZNRBusiness Processnvarchar120
3AUAASettlement Document: Receiver Segment36PRZNRBusiness Processnvarchar120
4BSEGAccounting Document Segment298PRZNRBusiness Processnvarchar120
5BSSEGAccounting Document Segment287PRZNRBusiness Processnvarchar120
6CE1PR22Périm. résultat IDES32PRZNRProcessus de gestion émetteurnvarchar120
7CE2PR22Périm. résultat IDES23PRZNRProcessus de gestion émetteurnvarchar120
8FUDT_VDOCBSEGVerification Document Item with Additional Info287PRZNRBusiness Processnvarchar120
9FUDT_VDOCBSEGEVVerification Document Item in the Entry View287PRZNRBusiness Processnvarchar120
10FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)287PRZNRBusiness Processnvarchar120
11GLPOS_C_CTFI Document: Entry View201PRZNRBusiness Processnvarchar120
12GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items201PRZNRBusiness Processnvarchar120
13GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items201PRZNRBusiness Processnvarchar120
14GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items201PRZNRBusiness Processnvarchar120
15GLPOS_N_CTNew General Ledger: Line Item with Currency Type206PRZNRBusiness Processnvarchar120
16GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type206PRZNRBusiness Processnvarchar120
17P2B2_ANWESHCM Declustering B2 - Attendances (Table ANWES)7PRZNRPointer to attendancesvarbinary20
18P2B2_C1HCM Declustering B2 - Cost Distribution Table C120PRZNRBusiness Processnvarchar120
19P2B2_CWSTHCM Declustering B2 - PDC Time Tickets107PRZNRBusiness Processnvarchar120
20P2B2_WSTHCM Declustering B2 - PDC Time Tickets107PRZNRBusiness Processnvarchar120
21P2B2_ZLHCM Declustering B2 - Time Wage Types (Table ZL)16PRZNRPointer to attendancesvarbinary20
22P2PL_RETROADJPayroll Result PL: Retro, originals and changes30PRZNRBusiness Processnvarchar120
23P2PL_RETRODIFPayroll Result PL: Retro, originals and changes30PRZNRBusiness Processnvarchar120
24P2PL_RETROMEMPayroll Result PL: Retro, originals and changes30PRZNRBusiness Processnvarchar120
25P2RF_ZLPTime Wage Types (Table ZL)14PRZNRPointer to attendancesvarbinary20
26P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)37PRZNRBusiness Processnvarchar120
27P2RP_OVTime Wage Types (Table ZL)14PRZNRPointer to attendancesvarbinary20
28P2RR_RMPayroll Results: Table for Master data (SG)68PRZNRPointer to attendancesvarbinary20
29P2RT_CZDAVP18_0321PRZNRBusiness Processnvarchar120
30P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)37PRZNRBusiness Processnvarchar120
31P2RX_C1Cost Distribution Table C118PRZNRBusiness Processnvarchar120
32S843ES843 - Strukturinformationen6PRZNRGeschäftsprozeßnvarchar120
33YVIM_1ITEMDocument Item85PRZNRBusiness Processnvarchar120
34ZTRCO1RIS/ABC: Weighting Factors for Purchase Order Processing4PRZNRBusiness Processnvarchar120
35ZTRCO3RIS/ABC: Assign Storage Pr./UOM Grp/LH Group to BProc.5PRZNRBusiness Processnvarchar120
TOPAccounting Interface
36GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)170PRZNRBusiness Processnvarchar120
37GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)170PRZNRBusiness Processnvarchar120
TOPActivity-Based Costing
38CBPRCO-ABC: Activity Master Table3PRZNRBusiness Processnvarchar120
39CBPTText Table for Business Process Master4PRZNRBusiness Processnvarchar120
40CMDT_BPGeneric master record business process enhancements7PRZNRBusiness Processnvarchar120
TOPActual CostingMaterial Ledger
41FCML_MATML Characteristics for Material (Selection Criteria)21PRZNRBusiness Processnvarchar120
42MLCOMaterial valuation document account assignment information32PRZNRBusiness Processnvarchar120
TOPAlternative Valuation Run
43CKMLAVRDOCITLines for Cumulation Posting Document59PRZNRBusiness Processnvarchar120
TOPConfirmations
44AFRVConfirmation pool28PRZNRBusiness Processnvarchar120
45AFRV_DELBackup Copy for Confirmation Pool28PRZNRBusiness Processnvarchar120
TOPConstruction Industry
46T5DBVConstruction Pay: Cost Assignment: Hostels17PRZNRBusiness Processnvarchar120
47T5DBXConstruction Pay: Incentive Wage Connection17PRZNRBusiness Processnvarchar120
TOPCross-Application Components
48ONRBPObject number index: Business process4PRZNRBusiness Processnvarchar120
TOPData Collection
49S843RIS/ABC Lagerprozeß Verrechng11PRZNR??????-???????nvarchar120
TOPElectronic Bank Statement
50FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)28PRZNRBusiness Processnvarchar120
51FEB_ACTAcct Assignment Templates28PRZNRBusiness Processnvarchar120
TOPExpense-Related Billing
52PRSD_DMRP_ACC_CHEngagement Mgmt: Accrual Characteristics for DMR Lines25PRZNRBusiness Processnvarchar120
TOPExternal Services
53ESKNAccount Assignment in Service Package57PRZNRBusiness Processnvarchar120
TOPFinancial Accounting
54/OPT/VIM_1ITEMDocument Item85PRZNRBusiness Processnvarchar120
55ACCTITCompressed Data from FI/CO Document146PRZNRBusiness Processnvarchar120
56VBSEGSDocument Segment for Document Parking - G/L Account Database121PRZNRBusiness Processnvarchar120
TOPFreight Processing
57VFKNAccount Determination in Shipment Costs Item41PRZNRBusiness Processnvarchar120
TOPFunds Management-Specific Postings
58FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years124PRZNRBusiness Processnvarchar120
59PSOSEGSRecurring Request Document Segment, G/L Accounts136PRZNRBusiness Processnvarchar120
TOPGeneral Ledger Accounting
60BSEG_ADDEntry View of Accounting Document for Additional Ledgers69PRZNRBusiness Processnvarchar120
TOPGL Account Posting
61TCJ_POSITIONSCash Journal Document Items35PRZNRBusiness Processnvarchar120
TOPInventory Management
62MSEGDocument Segment: Material180PRZNRBusiness Processnvarchar120
63RKPFDocument Header: Reservation53PRZNRBusiness Processnvarchar120
TOPInvoice Verification
64RBCODocument Item, Incoming Invoice, Account Assignment50PRZNRBusiness Processnvarchar120
TOPMaintenance Notifications
65QMFEQuality notification - items54PRZNRBusiness Processnvarchar120
TOPOverhead Cost Orders
66COBRBDistribution Rules Settlement Rule Order Settlement52PRZNRBusiness Processnvarchar120
67TKZU3Overhead Credit15PRZNRBusiness Processnvarchar120
TOPPayroll
68T5TPSC1SPLITRozdelení nákladu28PRZNRObchodní procesnvarchar120
TOPPersonnel Time Events
69TPTCOR_KOSTLCost Assignment (Correction Scenario)9PRZNRBusiness Processnvarchar120
TOPPersonnel Time Management
70ASSOBAssignment Objects16PRZNRBusiness Processnvarchar120
71CC1ERPIncorrect Time Events from CC1, Postings108PRZNRBusiness Processnvarchar120
72CC1TEVTemporary Buffer for Time Events from CC132PRZNRBusiness Processnvarchar120
73COIFTInterface to Activity Allocation48PRZNRBusiness Processnvarchar120
74PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)57PRZNRBusiness Processnvarchar120
75PTEX2003GENInterface Table for IT 2003: General Information56PRZNRBusiness Processnvarchar120
76PTEX2003SPECInterface Table for IT 2003: Interval Information32PRZNRBusiness Processnvarchar120
77PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)56PRZNRBusiness Processnvarchar120
78TEVEN_MOREAdditional Data for Time Events107PRZNRBusiness Processnvarchar120
TOPPlant Data Collection
79RUECKTemp. storage for subsystem confirmations23PRZNRBusiness Processnvarchar120
TOPProduct Cost Planning
80CKISItems Unit Costing/Itemization Product Costing127PRZNRBusiness Processnvarchar120
TOPProfitability Analysis
81CE1850032PRZNRSender Business Processnvarchar120
82CE1BGISErgebnisbereich für32PRZNRSender Geschäftsprozeßnvarchar120
83CE1E_B1Model Bank32PRZNRSender Business Processnvarchar120
84CE1IDEAOp. Concern BR World32PRZNRSender Business Processnvarchar120
85CE1IDEBErgebnisbereich IDES32PRZNRSender Geschäftsprozeßnvarchar120
86CE1IDESErgebnisbereich IDES32PRZNRSender Geschäftsprozeßnvarchar120
87CE1INT1Ergebnisbereich IDES32PRZNRSender Geschäftsprozeßnvarchar120
88CE1OC01Bike International32PRZNRSender Business Processnvarchar120
89CE1R300Operating Concern IDES32PRZNRSender Business Processnvarchar120
90CE1S001Sample operating concern32PRZNRSender Business Processnvarchar120
91CE1S300Operating Concern IDES32PRZNRSender Business Processnvarchar120
92CE1S_ALAirline Route Profit32PRZNRSender Business Processnvarchar120
93CE1S_CPTemplate for Consumer Goods Industry32PRZNRSender Business Processnvarchar120
94CE1S_GOQuickstart Template32PRZNRSender Business Processnvarchar120
95CE2850023PRZNRSender Business Processnvarchar120
96CE2BGISErgebnisbereich für23PRZNRSender Geschäftsprozeßnvarchar120
97CE2E_B1Model Bank23PRZNRSender Business Processnvarchar120
98CE2IDEAOp. Concern BR World23PRZNRSender Business Processnvarchar120
99CE2IDEBErgebnisbereich IDES23PRZNRSender Geschäftsprozeßnvarchar120
100CE2IDESErgebnisbereich IDES23PRZNRSender Geschäftsprozeßnvarchar120
101CE2INT1Ergebnisbereich IDES23PRZNRSender Geschäftsprozeßnvarchar120
102CE2OC01Bike International23PRZNRSender Business Processnvarchar120
103CE2R300Operating Concern IDES23PRZNRSender Business Processnvarchar120
104CE2S001Sample operating concern23PRZNRSender Business Processnvarchar120
105CE2S300Operating Concern IDES23PRZNRSender Business Processnvarchar120
106CE2S_ALAirline Route Profit23PRZNRSender Business Processnvarchar120
107CE2S_CPTemplate for Consumer Goods Industry23PRZNRSender Business Processnvarchar120
108CE2S_GOQuickstart Template23PRZNRSender Business Processnvarchar120
TOPPurchasing
109EBKNPurchase Requisition Account Assignment59PRZNRBusiness Processnvarchar120
110EKKNAccount Assignment in Purchasing Document64PRZNRBusiness Processnvarchar120
TOPRepetitive Manufacturing
111COMPMOVEGoods Movement of Components130PRZNRBusiness Processnvarchar120
TOPRevenues and Earnings
112AD01DLIDynamic items (DI)24PRZNRBusiness Processnvarchar120
TOPSelf-Service Procurement
113/SRMERP/D_ACC_ITAccount assignment item44PRZNRBusiness Processnvarchar120
TOPSimulation
114VSEBKN_CNVersion: Purchase requisition account assignment60PRZNRBusiness Processnvarchar120
TOPTravel Planning
115FTPT_REQ_ACCOUNTTravel Request Cost Assignment20PRZNRBusiness Processnvarchar120
TOPWaste Management
116EHSWAT001ACCMD (BDT): Generator/Disposer/Transporter - Accnt Assignment23PRZNRBusiness Processnvarchar120
117EHSWAT_ENACCDisposal Processing: Account Assignments for Entry Document20PRZNRBusiness Processnvarchar120
118EHSWAT_MNACCAccount Assignments for Disposal Document19PRZNRBusiness Processnvarchar120