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

24 columns | Print definition?ERP 6.0  | ORDNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing38ORDNONumber of an Object Transferred with Errorsnvarchar120
2FIAPSAD_ACHMT_IDLinking Attachment With the Document4ORDNOExpenditure/Payment Order Numbernvarchar100
3FIAPSAD_ATCHMTAttachment details for Expenditure/Payment order3ORDNOExpenditure/Payment Order Numbernvarchar100
4FIAPSAD_ORDR_HDOrder Number Header KSA3ORDNOExpenditure/Payment Order Numbernvarchar100
5FIAPSAD_ORDR_LTLine Item for Order Number KSA3ORDNOExpenditure/Payment Order Numbernvarchar100
6FIAPSAD_WF_STATIntermediate status of Expenditure Order/Payment approval3ORDNOExpenditure/Payment Order Numbernvarchar100
7P2RT_CZMSGStructure for error messages in CZMSG5ORDNOOrder number of errorvarbinary30
8P2SK_SKMSGStructure of warning messages for operation SKMSG5ORDNOOrder numbervarbinary30
9T7RU_STAT_VFLDView Variant Fields9ORDNOSequencenvarchar30
TOPCross-Application Components
10FRE_BIF_OPH_INInbound interface table order proposal header2ORDNOOrder Proposal Document Numbernvarchar100
11FRE_BIF_OPI_INInbound Interface Table Order Proposal Item2ORDNOOrder Proposal Document Numbernvarchar100
12FRE_IF_HEADERR/3 Outbound Header Interface Table4ORDNOOrder Proposal Document Numbernvarchar100
13FRE_IF_ITEMF&R Order Outbound IF: internal Item Table6ORDNOOrder Proposal Document Numbernvarchar100
14FRE_OP_PO_KEYKey-Completion F&R Order Proposal <-> R/3 Purchase Order7ORDNOOrder Proposal Document Numbernvarchar100
TOPliveCache Applications
15/SAPAPO/ORDKEYKey and descriptive data for order5ORDNOOrder Numbernvarchar120
TOPPayroll
16T5T4DConfiguration of parameters of reports5ORDNOSequencenvarchar30
17T7RO4DReporting engine - Parameters5ORDNOSequencenvarchar30
18T7SI4DConfiguration of parameters of reports5ORDNOSequencenvarchar30
19T7SK4DConfiguration of parameters of reports5ORDNOSequencenvarchar30
20T7UA_STAT_VFLDView Variant Fields9ORDNOSequencenvarchar30
TOPPayroll General Parts
21PA0128HR Master Record: Infotype 0128 (Notifications)29ORDNOSequencenvarchar30
TOPReporting
22P05T_WCR_ER_INFOWCR Info on Employer Level11ORDNOPurchase Order Numbernvarchar120
TOPSCM Basis
23CIFERRCTRLControl for Enhanced CIF Error Handling8ORDNODocument Number (Purchasing/Sales...)nvarchar120
24CIFERRLOGError Recording in Enhanced CIF Error Handling26ORDNONumber of Object Transferred with Errorsnvarchar120