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

108 columns | Print definition?ERP 6.0  | GRUND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OEE/C_PRCPlant Reason Code17GRUNDReason for Variancenvarchar40
2NRIV_DOCUNon-Assigned Internal Numbers in Parallel Buffering18GRUNDCharacter field of length 40nvarchar400
3P01ZFA_ATTRAttributes of ZfA Notifications3GRUNDZfA Notification Typenvarchar40
4P2B2_CWSTHCM Declustering B2 - PDC Time Tickets71GRUNDScrap reasonnvarchar40
5P2B2_WSTHCM Declustering B2 - PDC Time Tickets71GRUNDScrap reasonnvarchar40
6P2RA_STPFBPayroll Result: Garnishment (A) - Garnishable Amt (Mst.Data)9GRUNDType of Basic Exemptionnvarchar10
7T098Basis manual property evaluation2GRUNDReason for manual valuation of net assetsnvarchar30
8T098TDescription of the reasons for manual property values3GRUNDReason for manual valuation of net assetsnvarchar30
9T157DReason for Movement3GRUNDReason for Movementnvarchar40
10T157EText Table: Reason for Movement4GRUNDReason for Movementnvarchar40
11ZEIM_LIPSSD document: Delivery: Item data234GRUNDReason for goods movmentnvarchar40
12ZSTOCKINPUTUtility table to assist with loading of Initial Stock (561)9GRUNDReason for Movementnvarchar40
TOPAdvertising Management
13TJJA3IS-M: Reason for Condition References during Order Creation4GRUNDIS-M: Reason for Entering Conditionsnvarchar20
14TJJA4IS-M/AM: Reason for Condition References - Texts4GRUNDIS-M: Reason for Entering Conditionsnvarchar20
TOPAustria
15PA0134HR Master Record: Infotype 0134 (Garnishment Amount A)28GRUNDType of Basic Exemptionnvarchar10
16PA0135HR Master Record: Infotype 0135 (Spec. Garn. Cond. A)26GRUNDBasic Exemptionnvarchar10
17T5A6HRules of a Garnishment Group8GRUNDType of basic exemptionnvarchar10
18T5A7ITransfer Payslip Tax Domestic (L16)2GRUNDTransfer Reason Payslip Tax Domestic (L16) to Other Payslipnvarchar10
19T5A7JTransfer Payslip Tax Domestic (L16) (Customer Table)2GRUNDTransfer Reason Payslip Tax Domestic (L16) to Other Payslipnvarchar10
20T5AE1Absence Types: Entry for Illness Notification4GRUNDReason for Incapacity to Work Acc. to ELDA Illness Notif.nvarchar20
21T5AE2Absence Types: Alignment for Illness Notification5GRUNDReason for Incapacity to Work Acc. to ELDA Illness Notif.nvarchar20
TOPBasic Functions
22ANLAAsset Master Record Segment70GRUNDReason for manual valuation of net assetsnvarchar30
TOPBasic functions
23HUINV_ITEMHandling Unit: Physical Inventory Document Item21GRUNDReason for Movementnvarchar40
TOPCompany Pension Scheme Germany
24P01RBM_STATNotification Status: Pension Receipt Notifications3GRUNDNotification Reasonnvarchar40
25P01RBM_STAT_RStatus of Confirmations (Pension Receipt Notifications)3GRUNDNotification Reasonnvarchar40
TOPConfirmations
26AFFWGoods Movements with Errors from Confirmations71GRUNDReason for Movementnvarchar40
27AFRDDefault values for collective confirmation39GRUNDReason for Variancenvarchar40
28AFRP0Table of planned changes for confirmation (PDC)21GRUNDReason for Variancenvarchar40
29AFRUOrder Confirmations43GRUNDReason for Variancenvarchar40
30AFRVConfirmation pool128GRUNDReason for Variancenvarchar40
31AFRV_DELBackup Copy for Confirmation Pool128GRUNDReason for Variancenvarchar40
32TRUGSUser status caused by deviation3GRUNDReason for Variancenvarchar40
TOPContract Accounts Receivable and Payable
33DFKKDOUBTD_RET_WBuffer: Printout for Ind.Val.Ad - Return Values (User Event)11GRUNDAdjustment reasonnvarchar20
34DFKKDOUBTD_WBuffer: Create Printout for Receivables Adjustment16GRUNDAdjustment reasonnvarchar20
35DFKKZWDoubtful/Individual Val. Adjust. for Receivables - Trigger13GRUNDAdjustment reasonnvarchar20
36DFKKZW2Doubtful/Indiv. Val. Adjustments for Receivables - Tfr Pstg19GRUNDAdjustment reasonnvarchar20
37DFKKZWFHDoubtful/Individually Adjusted Receivables: History15GRUNDAdjustment reasonnvarchar20
38DFKKZWFPDoubtful/Individually Adjusted Receivables: Tfrd Receivables23GRUNDAdjustment reasonnvarchar20
39DFKKZWFTDoubtful/Individually Adjusted Receivables: Trigger Table14GRUNDAdjustment reasonnvarchar20
40DFKKZWHDoubtful/Ind.Val.Adj.Receivables - History13GRUNDAdjustment reasonnvarchar20
41TFKZGRReason for Marking as Doubtful/Individual Value Adjustment2GRUNDAdjustment reasonnvarchar20
42TFKZGRDValue Adjustment Reasons4GRUNDAdjustment reasonnvarchar20
43TFKZGRDEFEXExceptions for default Value Adjustment Reason (CZ/SK)3GRUNDAdjustment reasonnvarchar20
44TFKZGRDFEXExceptions for default Value Adjustment Reason (CZ/SK)3GRUNDAdjustment reasonnvarchar20
45TFKZGRMEVariant Determination for Value Adjustments (SK/CZ/PL))3GRUNDAdjustment reasonnvarchar20
46TFKZGRTDesription of Reasons for Doubtful Items/IVA3GRUNDAdjustment reasonnvarchar20
TOPData Collection
47S271Do not use!26GRUNDReason for goods movmentnvarchar40
48S271BIW1Do not use!26GRUNDReason for goods movmentnvarchar40
49S271BIW2Do not use!26GRUNDReason for goods movmentnvarchar40
50S272Do not use!45GRUNDReason for activitynvarchar40
51S272BIW1Do not use!45GRUNDReason for activitynvarchar40
52S272BIW2Do not use!45GRUNDReason for activitynvarchar40
53S273Do not use!27GRUNDReason for goods movmentnvarchar40
54S273BIW1Do not use!27GRUNDReason for goods movmentnvarchar40
55S273BIW2Do not use!27GRUNDReason for goods movmentnvarchar40
56S277Transfer BW: VP-Umbewertung27GRUNDReden voor de goederenbewegingnvarchar40
57S277BIW1S277BIW1 * Transfer to BW: Revaluation at Retail27GRUNDReason for goods movmentnvarchar40
58S277BIW2S277BIW2 * Transfer to BW: Revaluation at Retail27GRUNDReason for goods movmentnvarchar40
59S279Transfer BW: Bestandsführung26GRUNDReden voor de goederenbewegingnvarchar40
60S279BIW1S279BIW1 * BW Transfer: Inventory Management26GRUNDReason for goods movmentnvarchar40
61S279BIW2S279BIW2 * BW Transfer: Inventory Management26GRUNDReason for goods movmentnvarchar40
TOPData Retention Tool
62TXW_S_MSEGRetrieve MSEG from archive33GRUNDReason for manual valuation of net assetsnvarchar30
TOPFinancial Accounting
63LRBKPFDocuments as Result of Logical Document Reorg. (RFB80U00)5GRUNDReason for Non-Archivabilitynvarchar50
TOPGermany
64PD3DSAPHR-DDU: Administration Record for Notifications8GRUNDSubmission Reason for DEUEV Notificationnvarchar20
TOPHandling Unit Management
65THUWBEVENTDefinition of Possible Events for HU Goods Movements9GRUNDThe Reason Field is Available for Input at Goods Movementnvarchar10
TOPHydrocarbon Product Management
66TVPODO1Proof of delivery - Oil conversion parameters3GRUNDReason for variance in PODnvarchar40
67TVPODO2Proof of delivery - Oil additional quantities3GRUNDReason for variance in PODnvarchar40
TOPInventory Management
68ISEGPhysical Inventory Document Items54GRUNDReason for inventory diff.nvarchar40
69MSEGDocument Segment: Material106GRUNDReason for Movementnvarchar40
70MWXMSEGZMSEG: Interface for Posting of Value106GRUNDReason for Movementnvarchar40
71MWZMSEGZMSEG:Interface for Posting of Value106GRUNDReason for Movementnvarchar40
72T159ITest Data for Batch Input in Inventory Management (Phys.Inv)23GRUNDReason for inventory diff.nvarchar40
73T159LDefault values for inventory management and physical invent.27GRUNDReason for inventory diff.nvarchar40
TOPLocalization
74/KJRTAX01/A02Special Rate per Reason for Manual Evaluation2GRUNDReason for manual valuation of net assetsnvarchar30
TOPMaterials Management
75/ISDFPS/LOSS_CUSCustomizing Loss Management10GRUNDReason for variance in PODnvarchar40
76/SAPNEA/J_SC_PSYPhysical Inventory Charge Customer3GRUNDReason for Movementnvarchar40
TOPNet Worth Tax
77IDFIAA_JP_RESULTResults of Property Tax Report (Japan)16GRUNDReason for manual valuation of net assetsnvarchar30
TOPNumber Range Management
78NRIV_RESTEInternal numbers not assigned in conn. with NRIV split16GRUNDCharacter field of length 40nvarchar400
TOPPatient Management
79NWANIS-H: Bad Debt Parties18GRUNDReason why Patient Designated as Bed Debt Partynvarchar500
80TN14GIS-H: Movement Reasons (EDI)4GRUNDMovement Reasonnvarchar20
81TN14RIS-H: Movement reasons (§301) - Text5GRUNDMovement Reasonnvarchar20
TOPPeriodical Sales and Distribution
82JRTTROUTEIS-M/SD: Daily Truck Routes81GRUNDIS-M: Reason for Alternative Vehiclenvarchar20
83TJR41IS-M/SD: Reason for Different Vehicle2GRUNDIS-M: Reason for Alternative Vehiclenvarchar20
84TJR42IS-M/SD: Texts on Reason for Different Vehicle3GRUNDIS-M: Reason for Alternative Vehiclenvarchar20
TOPPersonnel Time Events
85TPTCOR_LOGISTICLogistics Orders (Correction Scenario)38GRUNDScrap reasonnvarchar40
TOPPersonnel Time Management
86CC1ERPIncorrect Time Events from CC1, Postings52GRUNDScrap reasonnvarchar40
87TEVEN_MOREAdditional Data for Time Events51GRUNDScrap reasonnvarchar40
TOPPlant Data Collection
88RUECKTemp. storage for subsystem confirmations123GRUNDReason for Variancenvarchar40
TOPProduction Orders
89COCF_CU_Q_LINRows of Quantity/Error Combination8GRUNDReason for Variancenvarchar40
90TRUGReason for variances in completion confirmations3GRUNDReason for Variancenvarchar40
91TRUGTText describing the reason for a variance in a confirmation4GRUNDReason for Variancenvarchar40
TOPPublic Sector
92P01ZFA_STATUSZfA: Status Management for Notifications3GRUNDZfA Notification Typenvarchar40
TOPPurchasing
93EKBEHistory per Purchasing Document27GRUNDReason for Movementnvarchar40
94EKBEHRemoved PO History Records27GRUNDReason for Movementnvarchar40
TOPRemaining Beverage - Obsolete Objects
95/BEV1/LAAUSFALLShipping: Downtimes Loading Places11GRUNDReason for Cancellation of a Loading Placenvarchar200
96/BEV1/TRVTSTransportation Report - Rest Periods7GRUNDReasonnvarchar500
TOPRepetitive Manufacturing
97COMPMOVEGoods Movement of Components70GRUNDReason for Movementnvarchar40
98RMIOInput Structure of Repetitive Manufacturing Confirmation28GRUNDReason for scrapnvarchar40
TOPShipping
99LIPSSD document: Delivery: Item data234GRUNDReason for goods movmentnvarchar40
100TMAWBEVENTDefiniton of Possible Transactions for LE Goods Movements11GRUNDThe Reason Field is Available for Input at Goods Movementnvarchar10
101TVPODSales Document: Delivery: POD Data3GRUNDReason for variance in PODnvarchar40
102TVPODGReason for Variance in POD2GRUNDReason for variance in PODnvarchar40
103TVPODGTTEXT: Reason for Variance in POD2GRUNDReason for variance in PODnvarchar40
TOPSocial Insurance
104P01BM_STATControl Records for PPO DEUEV Notifications10GRUNDSubmission Reason for DEUEV Notificationnvarchar20
105P01DS_STATControl Records for DEUEV Immediate Notifications10GRUNDSubmission Reason for DEUEV Notificationnvarchar20
TOPTime Tickets
106EVHRHR Order Confirmations (Times/Time Events)51GRUNDScrap reasonnvarchar40
107LSHRHR Order Confirmations (Durations/Time Tickets)51GRUNDScrap reasonnvarchar40
TOPTransportation and Distribution
108TOIGS41TD Reason code convert to proof of delivery3GRUNDReason for variance in PODnvarchar40