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

Home | ERP 6.0  | VIAJRECORD
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Real Estate Management :: Flexible Real Estate Management :: Rent Adjustment
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VIAJRECORD819Adjustment recordRent Adjustment
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, RECORDGUID, PROCESSGUID, INTRENO, TERMNO, ADJMRULE, ADJMSUBRULE, ADJMSUBMETH, ADJMDRECORDSTAT, ADJMRULEDEFAULT, ADJMRECSTEPNO, DERF, TERF, RERF, FDELETE, CONDGUIDOLD, CONDGUIDNEW, CONDGUIDREF, ADJMFROMOLD, ADJMFROMCALC, ADJMFROMMOD, UNITPRICEOLD, UNITPRICECALC, UNITPRICEMOD, ADJMCONDDELETE, METHREFGUID, ADJMFROMMODDATE, ADJMFROMMODUSER, UNITPRICEMODDATE, UNITPRICEMODUSER, CONDVALIDTOOLD, ADJMCONDNEW, UPBEFORECAPPING, MONTHCAPPING, DISSOLVEINGUID, ADJMREASON, CHGREASON, CHGREASONOLD, CARRYFROMGUID, CARRYOVERCT, RECGROUPGUID, INTRENODEPEND, RECORDUPDATE, UNITPRICEANN, ADJMFROMANN, CONDPURPOSENEW, CONDTYPECEA, CONDTYPENEW, TERMNOAJNEW, TAKETERMNO, MAXINCREL, UPLESSCAPMONTH, ADJMFROMLESSCM, UPPOSMARGIN, UPPOSMARGINUSED, UPINCALLOWED, ADJMACTIVDATE, ADJMACTIVUSER, DUEDATEUP, DUEDATEUPOLD, ADJMANNOUNCETO, ADJMANNOUNCEDATE, ADJMANNOUNCEUSER, ADJMAPPROVALTO, ADJMAPPROVALDATE, ADJMAPPROVALUSER, ADJMDECLINEDATE, ADJMDECLINEUSER, ADJMREVERSALDATE, ADJMREVERSALUSER, ADJMDOCDATE, ADJMDOCCOUNT, ADJMDUNLEVEL, ADJMDUNDATE, ADJMDUNCOUNT, ADJMAPPDATE, ADJMAPPCOUNT, ADJMANNDATE, ADJMANNCOUNT, ADJMDEACTIVDATE, ADJMDEACTIVUSER FROM VIAJRECORD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2RECORDGUIDGeneric Key of Adjustment Recordvarbinary160RAWNoREAJRECORDGUID
3PROCESSGUIDGeneric Key of Processvarbinary160RAWYesVICAPROCESSIDRECAPROCESSGUID
4INTRENOInternal Key of Real Estate Objectnvarchar130CHAR(N' ')YesRECAINTRENO Allow NULL? 
5TERMNOTerm Numbernvarchar40CHAR(N' ')YesRETMTERMNO Allow NULL? 
6ADJMRULEAdjustment Rulenvarchar100CHAR(N' ')YesTIVAJRULEREAJADJMRULE Allow NULL? 
7ADJMSUBRULEElementary Adjustment Rule (Part of Comb. Rule)nvarchar100CHAR(N' ')YesTIVAJRULEREAJADJMSUBRULE Allow NULL? 
8ADJMSUBMETHAdjustment Methodnvarchar40CHAR(N' ')YesTIVAJMETHREAJADJMMETH Allow NULL? 
9ADJMDRECORDSTATStatus of an Adjustment Recordchar10NUMC(N'0')YesREAJADJMDRECORDSTAT Allow NULL? 
10ADJMRULEDEFAULTAlternative Adjustment Rulenvarchar100CHAR(N' ')YesTIVAJRULEREAJADJMRULEDEFAULT Allow NULL? 
11ADJMRECSTEPNOSequential Number of Adjustment Stepnvarchar80NUMC(N'00000000')YesREAJADJMRECSTEPNO Allow NULL? 
12DERFFirst Entered onnvarchar80DATS(N'00000000')YesDERF Allow NULL? 
13TERFTime of Initial Entrynvarchar60TIMS(N'000000')YesTERF Allow NULL? 
14RERFEntered bynvarchar120CHAR(N' ')YesRERF Allow NULL? 
15FDELETEDeletion Indicator for Archivingchar10CHAR(N' ')YesRECAARDELETEIND Allow NULL? 
16CONDGUIDOLDGUID (RAW16) for Conditionsvarbinary160RAWYesRECDCONDGUID
17CONDGUIDNEWGUID (RAW16) for Conditionsvarbinary160RAWYesRECDCONDGUID
18CONDGUIDREFGUID (RAW16) for Conditionsvarbinary160RAWYesRECDCONDGUID
19ADJMFROMOLDValid-From Date of New Condition Itemnvarchar80DATS(N'00000000')YesREAJADJMVALIDFROM Allow NULL? 
20ADJMFROMCALCValid-From Date of New Condition Itemnvarchar80DATS(N'00000000')YesREAJADJMVALIDFROM Allow NULL? 
21ADJMFROMMODValid-From Date of New Condition Itemnvarchar80DATS(N'00000000')YesREAJADJMVALIDFROM Allow NULL? 
22UNITPRICEOLDUnit Pricedecimal196DEC((0))YesRECDUNITPRICE
23UNITPRICECALCUnit Pricedecimal196DEC((0))YesRECDUNITPRICE
24UNITPRICEMODUnit Pricedecimal196DEC((0))YesRECDUNITPRICE
25ADJMCONDDELETECondition Is Deletedchar10CHAR(N' ')YesREAJADJMCONDDELETE Allow NULL? 
26METHREFGUIDReference to Process-Specific Data for Adjustment Recordvarbinary160RAWYesREAJMETHREFGUID
27ADJMFROMMODDATEValid-From Date Changed Onnvarchar80DATS(N'00000000')YesREAJADJMFROMMODDATE Allow NULL? 
28ADJMFROMMODUSERValid-From Date Changed Bynvarchar120CHAR(N' ')YesREAJADJMFROMMODUSER Allow NULL? 
29UNITPRICEMODDATEValid-From Date Changed Onnvarchar80DATS(N'00000000')YesREAJUNITPRICEMODDATE Allow NULL? 
30UNITPRICEMODUSERPrice Changed Bynvarchar120CHAR(N' ')YesREAJUNITPRICEMODUSER Allow NULL? 
31CONDVALIDTOOLDDate up to when condition is validnvarchar80DATS(N'00000000')YesRECDVALIDTO Allow NULL? 
32ADJMCONDNEWNew Condition on Targetchar10CHAR(N' ')YesREAJNEWCOND Allow NULL? 
33UPBEFORECAPPINGUnit Price Before Cappingdecimal196DEC((0))YesREAJUPBEFORECAPPING
34MONTHCAPPINGTime in Monthsnvarchar30NUMC(N'000')YesREAJPERIODMONTH Allow NULL? 
35DISSOLVEINGUIDReference to Condition That Contains the Cancellationvarbinary160RAWYesREAJDISSOLVEINGUID
36ADJMREASONAdjustment Reasonnvarchar100CHAR(N' ')YesTIVAJREASONREAJADJMREASON Allow NULL? 
37CHGREASONReason for Changenvarchar100CHAR(N' ')YesTIVCDCHGREASRECDCHGREASON Allow NULL? 
38CHGREASONOLDReason for Changenvarchar100CHAR(N' ')Yes*RECDCHGREASON Allow NULL? 
39CARRYFROMGUIDReference to Transferred Conditionvarbinary160RAWYesREAJCARRYFROMGUID
40CARRYOVERCTCondition Typenvarchar40CHAR(N' ')YesTIVCDCONDTYPERECDCONDTYPE Allow NULL? 
41RECGROUPGUIDGUID for Grouping Adjustment Recordsvarbinary160RAWYesREAJRECGROUPGUID
42INTRENODEPENDInternal Key of Real Estate Objectnvarchar130CHAR(N' ')YesRECAINTRENO Allow NULL? 
43RECORDUPDATERecord Was Updatedchar10CHAR(N' ')YesREAJRECORDUPDATE Allow NULL? 
44UNITPRICEANNUnit Pricedecimal196DEC((0))YesRECDUNITPRICE
45ADJMFROMANNValid-From Date of New Condition Itemnvarchar80DATS(N'00000000')YesREAJADJMVALIDFROM Allow NULL? 
46CONDPURPOSENEWConditions - External Purposenvarchar40CHAR(N' ')YesTIVCDCOPUEXTRECDCONDPURPOSEEXT Allow NULL? 
47CONDTYPECEACondition Typenvarchar40CHAR(N' ')Yes*RECDCONDTYPE Allow NULL? 
48CONDTYPENEWCondition Typenvarchar40CHAR(N' ')YesTIVCDCONDTYPERECDCONDTYPE Allow NULL? 
49TERMNOAJNEWTerm Numbernvarchar40CHAR(N' ')YesRETMTERMNO Allow NULL? 
50TAKETERMNOCopy Termschar10CHAR(N' ')YesREAJTAKETERMNO Allow NULL? 
51MAXINCRELMaximum Increase in Percentdecimal72DEC((0))YesREAJMAXINCREL
52UPLESSCAPMONTHUnit Pricedecimal196DEC((0))YesRECDUNITPRICE
53ADJMFROMLESSCMValid-From Date of New Condition Itemnvarchar80DATS(N'00000000')YesREAJADJMVALIDFROM Allow NULL? 
54UPPOSMARGINUnit Pricedecimal196DEC((0))YesRECDUNITPRICE
55UPPOSMARGINUSEDUnit Pricedecimal196DEC((0))YesRECDUNITPRICE
56UPINCALLOWEDUnit Pricedecimal196DEC((0))YesRECDUNITPRICE
57ADJMACTIVDATEActivated Onnvarchar80DATS(N'00000000')YesREAJADJMACTIVDATE Allow NULL? 
58ADJMACTIVUSERActivated Bynvarchar120CHAR(N' ')YesREAJADJMACTIVUSER Allow NULL? 
59DUEDATEUPDue Date for Follow-Up Postingsnvarchar80DATS(N'00000000')YesRECDDUEDATEUP Allow NULL? 
60DUEDATEUPOLDDue Date for Follow-Up Postingsnvarchar80DATS(N'00000000')YesRECDDUEDATEUP Allow NULL? 
61ADJMANNOUNCETODate Reply to Notification Is Requirednvarchar80DATS(N'00000000')YesREAJADJMANNOUNCETO Allow NULL? 
62ADJMANNOUNCEDATENotification Datenvarchar80DATS(N'00000000')YesREAJADJMANNOUNCEDATE Allow NULL? 
63ADJMANNOUNCEUSERNotified Bynvarchar120CHAR(N' ')YesREAJADJMANNOUNCEUSER Allow NULL? 
64ADJMAPPROVALTODate Up to Which the Approval Must Occurnvarchar80DATS(N'00000000')YesREAJADJMAPPROVALTO Allow NULL? 
65ADJMAPPROVALDATEApproval Onnvarchar80DATS(N'00000000')YesREAJADJMAPPROVALDATE Allow NULL? 
66ADJMAPPROVALUSERApproved Bynvarchar120CHAR(N' ')YesREAJADJMAPPROVALUSER Allow NULL? 
67ADJMDECLINEDATERejected Onnvarchar80DATS(N'00000000')YesREAJADJMDECLINEDATE Allow NULL? 
68ADJMDECLINEUSERRejected Bynvarchar120CHAR(N' ')YesREAJADJMDECLINEUSER Allow NULL? 
69ADJMREVERSALDATEReversed Onnvarchar80DATS(N'00000000')YesREAJADJMREVERSALDATE Allow NULL? 
70ADJMREVERSALUSERReversed bynvarchar120CHAR(N' ')YesREAJADJMREVERSALUSER Allow NULL? 
71ADJMDOCDATEAdjustment Letter Onnvarchar80DATS(N'00000000')YesREAJADJMDOCDATE Allow NULL? 
72ADJMDOCCOUNTNumber of Adjustment Letterstinyint30INT1((0))YesREAJADJMDOCCOUNT
73ADJMDUNLEVELDunning Leveltinyint30INT1((0))YesREAJADJMDUNLEVEL
74ADJMDUNDATEReminder Letter Onnvarchar80DATS(N'00000000')YesREAJADJMDUNDATE Allow NULL? 
75ADJMDUNCOUNTNumber of Reminder Letterstinyint30INT1((0))YesREAJADJMDUNCOUNT
76ADJMAPPDATEApproval Confirmation Letter Onnvarchar80DATS(N'00000000')YesREAJADJMAPPDATE Allow NULL? 
77ADJMAPPCOUNTNumber of Approval Confirmation Letterstinyint30INT1((0))YesREAJADJMAPPCOUNT
78ADJMANNDATEDate of Last Notification Letternvarchar80DATS(N'00000000')YesREAJADJMANNDATE Allow NULL? 
79ADJMANNCOUNTNumber of Notification Letterstinyint30INT1((0))YesREAJADJMANNCOUNT
80ADJMDEACTIVDATEDeactivated Onnvarchar80DATS(N'00000000')YesREAJADJMDEACTIVDATE Allow NULL? 
81ADJMDEACTIVUSERDeactivated Bynvarchar120CHAR(N' ')YesREAJADJMDEACTIVUSER Allow NULL? 
NamePrimaryUniqueTypeColumns
VIAJRECORD~0YesYesCLUSTEREDMANDT, RECORDGUID
VIAJRECORD~007NoNoNONCLUSTEREDMANDT, RECGROUPGUID
VIAJRECORD~1NoNoNONCLUSTEREDMANDT, INTRENO
VIAJRECORD~2NoNoNONCLUSTEREDMANDT, PROCESSGUID
VIAJRECORD~3NoNoNONCLUSTEREDMANDT, CONDGUIDOLD
VIAJRECORD~4NoNoNONCLUSTEREDMANDT, CONDGUIDNEW
VIAJRECORD~5NoNoNONCLUSTEREDMANDT, METHREFGUID
VIAJRECORD~6NoNoNONCLUSTEREDMANDT, DISSOLVEINGUID
VIAJRECORD~7NoNoNONCLUSTEREDMANDT, CARRYFROMGUID

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy