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

87 columns | Print definition?ERP 6.0  | REASON_CODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/C_REASON_CDMilestone Checklist: Reason Codes2REASON_CODEMilestone Checklist: Reason Codesnvarchar40
2/CPD/C_REASON_CTMilestone Checklist: Reason Codes (Text)2REASON_CODEMilestone Checklist: Reason Codesnvarchar40
3/GBT/O_ADINAdministrative Data of Internally Generated Events13REASON_CODEReason for Creating an Event Manually in SAP GBTnvarchar20
4/GRCPI/GRIAFFLOGDetails related to Firefighter ID Log On Information7REASON_CODEUUID of the GRC object (char32)nvarchar320
5/GRCPI/GRIARCODEMaster table for Reason Codes2REASON_CODEUUID of the GRC object (char32)nvarchar320
6/GRCPI/GRIARCODTText table for GRACREASONCOD table3REASON_CODEUUID of the GRC object (char32)nvarchar320
7BBP_IMREAReasons Code for Movement Type3REASON_CODEReason for movementnvarchar40
8BBP_IMREATReason Text for Reason Code and Movement Type4REASON_CODEReason for movementnvarchar40
9BBP_IVREAReasons Code for Movement Type2REASON_CODEReason for movementnvarchar40
10BBP_IVREATReason Text for the Reason Code3REASON_CODEReason for movementnvarchar40
11BBP_PDHGPBusiness Transaction Purchasing Information36REASON_CODEReason for Rejectionnvarchar40
12BKKPOMNDPayment order Enriched with Mandate details12REASON_CODEReason Code for Status Changenvarchar30
13BUT_UNBLK_REASONReasons of Unblocking Business Partners2REASON_CODEDescription Code for the Reason to Unblocknvarchar30
14BUT_UNBLK_RESN_TText Table For BUT_UNBLK_REASON3REASON_CODEDescription Code for the Reason to Unblocknvarchar30
15FARR_C_RW_REASONReview reason configuration table2REASON_CODEReview Reason Codenvarchar30
16FARR_C_RW_RSN_TText table of review reason3REASON_CODEReview Reason Codenvarchar30
17GRACFFLOGDetails related to Firefighter ID Log On Information7REASON_CODEUUID of the GRC object (char32)nvarchar320
18GRACREASONCODMaster table for Reason Codes2REASON_CODEUUID of the GRC object (char32)nvarchar320
19GRACREASONCODTText table for GRACREASONCOD table3REASON_CODEUUID of the GRC object (char32)nvarchar320
20GRACREASONSYSReason Code and System assignments2REASON_CODEUUID of the GRC object (char32)nvarchar320
21GRACREVITEMReview Request related items10REASON_CODEReason codenvarchar20
22GRACSODREVIEWItem Table for SOD Request14REASON_CODEReason for Rejectionnvarchar30
23ITC_RCODE_DEFReason Codes type Definition2REASON_CODEReason Codenvarchar30
24ITC_RCODE_DEF_TText table for Time collection Reason Code2REASON_CODEReason Codenvarchar30
25ITC_RCODE_MAPReason Codes Profile and Definition Mapping Table3REASON_CODEReason Codenvarchar30
26OIUX8_NM_DC_MEMOTax 2.0 - New Mexico Debit and Credit Memo7REASON_CODETax 2.0 - New Mexico Reason Codenvarchar20
27SATC_CI_REASONSExemption reasons1REASON_CODEExemption reason - categorynvarchar40
28SATC_CI_REASONSTReasons for exemptions (text table)1REASON_CODEExemption reason - categorynvarchar40
29SEPA_RC_CUSTSEPA Mandate: Customizing for Reason Code4REASON_CODEReason Code for Status Changenvarchar30
30SEPA_RC_CUST_TXTSEPA Mandate: Text table for Reason Code4REASON_CODEReason Code for Status Changenvarchar30
31T028Y_SEPAReturns Activities: Change Mandate Status6REASON_CODEReason Code for Status Changenvarchar30
TOPAccounts Receivable Accounting Process Integration
32TEBPPINQUIRYRESReason code of the vendor inquiry2REASON_CODEInquiry Reason Codenvarchar40
33TEBPPINQUIRYRESTText table of TEBPPQINUIRYRES3REASON_CODEInquiry Reason Codenvarchar40
34TFDM_BDREASONFSCM-DM: Default Values for Company Code3REASON_CODEReason for Dispute Casenvarchar40
35TFDM_BDREASONTFSCM-DM: Default Values for Company Code4REASON_CODEReason for Dispute Casenvarchar40
36TFDM_DEFCCFSCM-DM: Default Values for Company Code7REASON_CODEReason for Dispute Casenvarchar40
37TFDM_DEFRCFSCM-DM: Default Values for Company Code5REASON_CODEReason for Dispute Casenvarchar40
38TFDM_WRITEOFF02FSCM-DM: Default Values for Writing Off Dispute Cases4REASON_CODEReason for Dispute Casenvarchar40
TOPAuto-ID Infrastructure
39/AIN/DM_DOC_STADocument status5REASON_CODEReason codenvarchar20
TOPBank
40SEPA_MANDATESEPA Mandate12REASON_CODEReason Code for Status Changenvarchar30
TOPCapacity and Resource Planning
41/MRSS/C_RM_SLAExclude From SLA Tracking2REASON_CODEReason code for Exclude from SLAnvarchar20
42/MRSS/C_RM_SLA_TText Table for SLA Exclude Reason codes2REASON_CODEReason code for Exclude from SLAnvarchar20
TOPCase Management
43SCMGATTR_REASONCase: Reasons3REASON_CODEReason for Casenvarchar40
44SCMGATTR_REASONTCase: Reasons4REASON_CODEReason for Casenvarchar40
45SCMG_T_CASE_ATTRCase Attributes26REASON_CODEReason for Casenvarchar40
TOPContract Accounts Receivable and Payable
46TFKDMC_EXTCase: Categorization of Internal Dispute Types3REASON_CODEReason for Dispute Casenvarchar40
47TFKDMC_EXTTCase: Categorization of Internal Dispute Types (Texts)4REASON_CODEReason for Dispute Casenvarchar40
TOPCustomer Interaction Center
48ECCPCALLBACKRVReasons for callback2REASON_CODEReason for Callbacknvarchar200
49ECCPCALLBACKRVTReasons for callback (texts)3REASON_CODEReason for Callbacknvarchar200
TOPE-Recruiting
50HRP5121DB Table for Infotype 512135REASON_CODEStatus Reasonnvarchar20
51HRP5125DB Table for Infotype 512529REASON_CODEStatus Reasonnvarchar20
52HRP5132DB Table for Infotype 513222REASON_CODEStatus Reasonnvarchar20
53HRP5133DB Table for Infotype 513320REASON_CODEStatus Reasonnvarchar20
54HRP5139DB Table for Infotype 513935REASON_CODEStatus Reasonnvarchar20
55T77RCF_RCD2STATAssignment of Status Reason to Status5REASON_CODEStatus Reasonnvarchar20
56T77RCF_RSNCODE_TStatus Reasons3REASON_CODEStatus Reasonnvarchar20
57T77RCF_RSN_CODEStatus Reasons2REASON_CODEStatus Reasonnvarchar20
TOPFunctions for U.S. Federal Government
58FMFG_TROR_CONFIGConfiguration for TROR lines11REASON_CODEReason Code for Paymentsnvarchar30
59FMFG_TROR_RCTROR Reason code group detail5REASON_CODEReason Code for Paymentsnvarchar30
TOPFunds Management
60FMFG_HEAD_INVHeader Data for Improper Invoices5REASON_CODECodes for Invoicesnvarchar20
TOPGeneral Ledger Accounting
61FAGLCOFITRACELog of Real-Time Integration CO->FI11REASON_CODEReason for (Non-)Transferral of CO Document to FInvarchar20
TOPGRC Access Control Plug-In
62/VIRSA/ZVIRFFLOGFirefighter Action Log12REASON_CODEMaintain Reason Codesnvarchar600
TOPJoint Venture und Production Sharing Accounting
63T8PSA_ADJ_REASONPSA Reason Code for Adjustment3REASON_CODEPSA Reason Codenvarchar20
64T8PSA_ADJ_RSN_TPSA Reason Code for Adjustment4REASON_CODEPSA Reason Codenvarchar20
65T8PSA_STOCK_ADJPSA Stock Adjustment15REASON_CODEPSA Reason Codenvarchar20
TOPMedia Product Sales and Distribution
66JKSDUNSOLDITEMIS-M: Item Data on Unsold Copies/Credit Memos19REASON_CODEIS-M: Reasonnvarchar30
TOPNetwork Objects
67GHO_NETOBJ_TDWell Time Dependency10REASON_CODEReason Codenvarchar30
TOPPublic Sector Contract Accounts Receivable and Payable
68DFMCA_TAX_CASEData Table for Tax Cases8REASON_CODECode Values for Creation Reaons for Tax Casenvarchar100
69TFMCA_TC_RCCustomizing Table for Reason Code for Tax Cases2REASON_CODECode Values for Creation Reaons for Tax Casenvarchar100
70TFMCA_TC_RCTText Table for Reason Codes for Tax Cases3REASON_CODECode Values for Creation Reaons for Tax Casenvarchar100
TOPPurchasing
71EKKOPurchasing Document Header78REASON_CODEGoods Receipt Reason Codenvarchar40
72EKPOPurchasing Document Item226REASON_CODEGoods Receipt Reason Codenvarchar40
TOPSAP Retail Store
73WOSCR_RSNReasons for Deviations (SRS Cash Balancing)3REASON_CODECash Balancing: Reason for Deviationsnvarchar40
74WOSCR_RSNTReasons for Deviations (SRS Cash Balancing)4REASON_CODECash Balancing: Reason for Deviationsnvarchar40
TOPStock Transfers
75/SPE/EXCP_REASMapping Table (Reason Code ERP to Exception Code EWM)3REASON_CODEReason Code R3 for Quantity Differencenvarchar40
TOPTransaction Tax Engine
76TTEPDT_EXEMPVALUPersistency TTE Document Item Exemption Value15REASON_CODEReason Codenvarchar60
77TTEPDT_ITEMPersistency TTE Document Item27REASON_CODEReason Codenvarchar60
78TTESDT_EXEMPVALUDocument business partner exemption values for with. tax.15REASON_CODEReason Codenvarchar60
TOPTravel Planning
79FTPT_CARTravel Request Item - Car Rental Service71REASON_CODEReason Codenvarchar20
80FTPT_FLIGHTTravel Request Item - Flight Service39REASON_CODEReason Codenvarchar20
81FTPT_HOTELTravel Request Item - Hotel Service73REASON_CODEReason Codenvarchar20
82FTPT_SERVICEGeneral Services9REASON_CODEReason Codenvarchar20
83TA20KReasons6REASON_CODEReason Codenvarchar20
84TA20K1Reasons (Language-Dependent)7REASON_CODEReason Codenvarchar20
TOPUS Prompt Payment Act
85FMFGRCReason Codes for Invoices3REASON_CODECodes for Invoicesnvarchar20
86FMFGRCTReason Code texts4REASON_CODECodes for Invoicesnvarchar20
87FMFG_PPA_INV_HDPPA invoice header information (reason codes)5REASON_CODECodes for Invoicesnvarchar20