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  | VIYCADVPAY
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
1ERP EHP76.0VIYCADVPAY1303Advance Payments
SQL:  selectupdate insert create

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

SELECT MANDT, CAM_ADVPAY_GUID, SETTL_GUID, CAM_POOL_GUID, CNOBJNR, CFPAYGUID, CONDGUID, CONDVALIDFROM, REFGUID, INTRENO, RERF, DERF, TERF, REHER, RBEAR, DBEAR, TBEAR, RBHER, BBWHR, BNWHR, DBERVON, SEXCLVON, SULTVON, DBERBIS, SINCLBIS, SULTBIS, DVALUT, SINCL, SVINCL, SVULT, DFAELL, SFINCL, SFULT, DDISPO, SINCLVERR, SULTVERR, ATAGE, ABASTAGE, APERTAGE, STGMETH, STGBASIS, SZBMETH, DBPERIOD, SPAEXCL, SPAULT, DEPERIOD, SPEINCL, SPEULT, SWHRKOND, BKOND, SSTAFF, SBASIS, JSOFVERR, AMMRHY, ATTRHY, SSORTZIT, SZEITANT, SSALBAS, SKONDGRP, LCNETAMOUNT, LCGROSSAMOUNT, LCTAXAMOUNT, LOCALCURR, CCNETAMOUNT, CCGROSSAMOUNT, CCTAXAMOUNT, CONDCURR, TAXTYPE, TAXGROUP, TXJCD, ISGROSS, WHEREFROM, FLOWTYPE, ORIGFLOWTYPE, REFFLOWREL, CFSTATUS, FDLEV, FDUPD, FDELETE, ORIGDUEDATE, PARTNER, PARTNEROBJNR, CONDTYPE, TERMNOPY, TERMNORH, TERMNOAJ, TERMNOOA, TERMNOSR, TERMNOMR, TERMNOWT, ORIGEXDUEDATE, SEAPSTATUS, POSTINGDATE, DOCUMENTDATE, VALUATIONDATE, REVERSAL_FOR, REVERSAL_BY, FOLLOWUP_FOR, BOOK_FLOWTYPE, BOOK_REFFLOWREL, TAXDATE, MODDUEDATE, CALCDUEDATE, CFSPLITFORGUID, CFSPLITBASIS, CDSPLITNO, COMPANYCODE, CMCFGROUP, CTRULE, CTLCNETAMOUNT, CTLCGROSSAMOUNT, CTLCTAXAMOUNT, CTRATE, CTRATEORIG, CTPOSTCDCURR, CTDATEREQ, CTDATEACT, CTDATEACTORIG, CTDATEFROMCFPOS, CTFCCURRKEY, IS_ITAX_OPTING, ISCDSPLIT, CTFCPOST, POSTCDCURR, ADVPAYWHEREFROM, INFOCOND, ADD_OBJNR, CDGUIDINVALID, CTFCNETAMOUNT, CTFCTAXAMOUNT FROM VIYCADVPAY
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2CAM_ADVPAY_GUIDAdvance Payment in CAM Recoveryvarbinary160RAWNoREYCADVPAYGUID
3SETTL_GUIDUnique Key of Settlementvarbinary160RAWYesVISCSETTLRECASETTLGUID
4CAM_POOL_GUIDExpense Pool in CAM Recoveryvarbinary160RAWYesREYCPOOLGUID
5CNOBJNRObject Numbernvarchar220CHAR(N' ')Yes*RECAOBJNR Allow NULL? 
6CFPAYGUIDGUID (RAW16) for Payment-Related Cash Flowvarbinary160RAWYesRECDCFPAYGUID
7CONDGUIDGUID (RAW16) for Conditionsvarbinary160RAWYesRECDCONDGUID
8CONDVALIDFROMDate from when condition is validnvarchar80DATS(N'00000000')YesRECDVALIDFROM Allow NULL? 
9REFGUIDGUID (RAW16) for Document References in Cash Flowvarbinary160RAWYesRECDREFGUID
10INTRENOInternal Key of Real Estate Objectnvarchar130CHAR(N' ')YesRECAINTRENO Allow NULL? 
11RERFEntered bynvarchar120CHAR(N' ')YesRERF Allow NULL? 
12DERFFirst Entered onnvarchar80DATS(N'00000000')YesDERF Allow NULL? 
13TERFTime of Initial Entrynvarchar60TIMS(N'000000')YesTERF Allow NULL? 
14REHERSource of initial entrynvarchar100CHAR(N' ')YesREHER Allow NULL? 
15RBEAREmployee IDnvarchar120CHAR(N' ')YesRBEAR Allow NULL? 
16DBEARLast Edited onnvarchar80DATS(N'00000000')YesDBEAR Allow NULL? 
17TBEARLast Edited atnvarchar60TIMS(N'000000')YesTBEAR Allow NULL? 
18RBHEREditing Sourcenvarchar100CHAR(N' ')YesRBHER Allow NULL? 
19BBWHRAmount which changes positiondecimal232CURR((0))YesTFM_BBWHR
20BNWHRNominal amountdecimal232CURR((0))YesTFM_BNWHR
21DBERVONStart of Calculation Periodnvarchar80DATS(N'00000000')YesDBERVON Allow NULL? 
22SEXCLVONExclusive Indicator for the Start of a Calculation Periodchar10NUMC(N'0')YesVVSEXCLVON Allow NULL? 
23SULTVONMonth-End Indicator for Start of a Calculation Periodchar10CHAR(N' ')YesVVSULTVON Allow NULL? 
24DBERBISEnd of Calculation Periodnvarchar80DATS(N'00000000')YesDBERBIS Allow NULL? 
25SINCLBISInclusive Indicator for the End of a Calculation Periodchar10NUMC(N'0')YesVVSINCLBIS Allow NULL? 
26SULTBISMonth-End Indicator for the End of a Calculation Periodchar10CHAR(N' ')YesVVSULTBIS Allow NULL? 
27DVALUTCalculation Datenvarchar80DATS(N'00000000')YesDVALUT Allow NULL? 
28SINCLInclusive indicator for beginning and end of a periodchar10NUMC(N'0')YesVVSINCL Allow NULL? 
29SVINCLInclusive indicator for value datechar10NUMC(N'0')YesVVSVINCL Allow NULL? 
30SVULTMonth-End Indicator for Value Datechar10CHAR(N' ')YesVVSVULT Allow NULL? 
31DFAELLDue datenvarchar80DATS(N'00000000')YesDFAELL Allow NULL? 
32SFINCLInclusive Indicator for Due Datechar10NUMC(N'0')YesVVSFINCL Allow NULL? 
33SFULTMonth-End Indicator for Due Datechar10CHAR(N' ')YesSFULT Allow NULL? 
34DDISPOPayment Datenvarchar80DATS(N'00000000')YesDDISPO Allow NULL? 
35SINCLVERRInclusive Indicator for Clearing Datechar10NUMC(N'0')YesVVSINCLVER Allow NULL? 
36SULTVERRMonth-End Indicator for Clearing Datechar10CHAR(N' ')YesVVSULTVERR Allow NULL? 
37ATAGENumber of Daysint100INT4((0))YesTFMATAGE Allow NULL? 
38ABASTAGEAmount in floating point format for recursive determinationfloat1516FLTP((0))YesBITER
39APERTAGENo. of days of a (calculation) period in cash flownvarchar60NUMC(N'000000')YesVVAPERTAGE Allow NULL? 
40STGMETHDaily Methodchar10NUMC(N'0')YesVVSTGMETH Allow NULL? 
41STGBASISBase Days Methodchar10CHAR(N' ')YesVVSTGBASIS Allow NULL? 
42SZBMETHInterest Calculation Methodchar10CHAR(N' ')YesSZBMETH Allow NULL? 
43DBPERIODPeriod startnvarchar80DATS(N'00000000')YesVVDBPERIOD Allow NULL? 
44SPAEXCLExclusive Indicator for Start Date of a Periodchar10NUMC(N'0')YesTFMSPAEXCL Allow NULL? 
45SPAULTMonth-End Indicator for Start Date of a Periodchar10CHAR(N' ')YesTFMSPAULT Allow NULL? 
46DEPERIODPeriod Endnvarchar80DATS(N'00000000')YesVVDEPERIOD Allow NULL? 
47SPEINCLInclusive Indicator for End Date of a Periodchar10NUMC(N'0')YesTFMSPEINCL Allow NULL? 
48SPEULTMonth-End Indicator for End of a Periodchar10CHAR(N' ')YesTFMSPEULT Allow NULL? 
49SWHRKONDCurrency of Condition Itemnvarchar50CUKY(N' ')Yes*TFMWHRKOND Allow NULL? 
50BKONDCondition item currency amountdecimal172CURR((0))YesTFM_BKOND
51SSTAFFType of Scaled Calculationchar10NUMC(N'0')YesTFMSSTAFF Allow NULL? 
52SBASISCalculation Base Referencenvarchar40CHAR(N' ')YesTFM_SBASIS Allow NULL? 
53JSOFVERRIndicator for Immediate Settlement (Financial Mathematics)char10CHAR(N' ')YesTFMSOFVERR Allow NULL? 
54AMMRHYFrequency in monthsnvarchar30NUMC(N'000')YesAMMRHY Allow NULL? 
55ATTRHYFrequency in Daysnvarchar30NUMC(N'000')YesATTRHY Allow NULL? 
56SSORTZITSort indicator for financial mathematic calculationsnvarchar20NUMC(N'00')YesTFM_SORT Allow NULL? 
57SZEITANTIndicator for Pro Rata Temporis Calculationschar10NUMC(N'0')YesVVSZEITANT Allow NULL? 
58SSALBASIndicator for debit position/incoming pmnt (internal FiMa)char10CHAR(N' ')YesTFMSSALBAS Allow NULL? 
59SKONDGRPCondition group in cash flow calculatornvarchar40NUMC(N'0000')YesSKONDGRP Allow NULL? 
60LCNETAMOUNTNet Amount of Cash Flow Item in Local Currencydecimal152CURR((0))YesRECDCFLCVALUENET
61LCGROSSAMOUNTGross Amount of Cash Flow Item in Local Currencydecimal152CURR((0))YesRECDCFLCVALUEGROSS
62LCTAXAMOUNTSales/Purch. Tax Amount of Cash Flow Item in Local Currencydecimal152CURR((0))YesRECDCFLCTAXVALUE
63LOCALCURRLocal Currency of Cash Flow Itemnvarchar50CUKY(N' ')Yes*RECDCFLCCURR Allow NULL? 
64CCNETAMOUNTNet Amount of Cash Flow Item in Condition Currencydecimal152CURR((0))YesRECDCFVALUENET
65CCGROSSAMOUNTGross Amount of Cash Flow Item in Condition Currencydecimal152CURR((0))YesRECDCFVALUEGROSS
66CCTAXAMOUNTTax on Sales/Purch. of Cash Flow Item in Condition Currencydecimal152CURR((0))YesRECDCFTAXVALUE
67CONDCURRCondition Currency of Cash Flow Itemnvarchar50CUKY(N' ')Yes*RECDCFCURR Allow NULL? 
68TAXTYPETax Typenvarchar40CHAR(N' ')YesTIVRATAXTYPERERATAXTYPE Allow NULL? 
69TAXGROUPTax Groupnvarchar200CHAR(N' ')YesTIVRATAXGROUPRERATAXGROUP Allow NULL? 
70TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
71ISGROSSCondition Amount Is Gross Amountchar10CHAR(N' ')YesRECDISGROSS Allow NULL? 
72WHEREFROMFlow Originchar10CHAR(N' ')YesRECDWHEREFROM Allow NULL? 
73FLOWTYPEFlow Typenvarchar40CHAR(N' ')Yes*RECDFLOWTYPE Allow NULL? 
74ORIGFLOWTYPEOriginal Flow Typenvarchar40CHAR(N' ')Yes*RECDORIGFLOWTYPE Allow NULL? 
75REFFLOWRELType of Relationship Between Flow Type and Refer.Flow Typenvarchar30CHAR(N' ')Yes*RECDREFFLOWREL Allow NULL? 
76CFSTATUSIndicates Status of Flowchar10CHAR(N' ')YesRECDCFSTATUS Allow NULL? 
77FDLEVPlanning levelnvarchar20CHAR(N' ')Yes*FDLEV Allow NULL? 
78FDUPDFlag as to whether record enters cash management + forecastchar10CHAR(N' ')YesFDUPD Allow NULL? 
79FDELETEDeletion Indicator for Archivingchar10CHAR(N' ')YesRECAARDELETEIND Allow NULL? 
80ORIGDUEDATEOriginal Due Datenvarchar80DATS(N'00000000')YesRECDORIGDUEDATE Allow NULL? 
81PARTNERBusiness Partner Numbernvarchar100CHAR(N' ')Yes*BU_PARTNER Allow NULL? 
82PARTNEROBJNRObject Numbernvarchar220CHAR(N' ')Yes*RECAOBJNR Allow NULL? 
83CONDTYPECondition Typenvarchar40CHAR(N' ')Yes*RECDCONDTYPE Allow NULL? 
84TERMNOPYNumber of Posting Termnvarchar40CHAR(N' ')YesRECDTERMNOPY Allow NULL? 
85TERMNORHNumber of Frequency Termnvarchar40CHAR(N' ')YesRECDTERMNORH Allow NULL? 
86TERMNOAJNumber of Adjustment Termnvarchar40CHAR(N' ')YesRECDTERMNOAJ Allow NULL? 
87TERMNOOANumber of Organizational Assignment Termnvarchar40CHAR(N' ')YesRECDTERMNOOA Allow NULL? 
88TERMNOSRNumber of Sales Termnvarchar40CHAR(N' ')YesRECDTERMNOSR Allow NULL? 
89TERMNOMRNumber of Peak Sales Termnvarchar40CHAR(N' ')YesRECDTERMNOMR Allow NULL? 
90TERMNOWTNumber of Withholding Tax Termnvarchar40CHAR(N' ')YesRECDTERMNOWT Allow NULL? 
91ORIGEXDUEDATEOriginal Due Datenvarchar80DATS(N'00000000')YesRECDORIGDUEDATE Allow NULL? 
92SEAPSTATUSStatus of Advance Payment Relevant to SCSchar10CHAR(N' ')YesRERASEAPSTATUS Allow NULL? 
93POSTINGDATEPosting Datenvarchar80DATS(N'00000000')YesRECDPOSTINGDATE Allow NULL? 
94DOCUMENTDATEDocument Datenvarchar80DATS(N'00000000')YesRECDDOCUMENTDATE Allow NULL? 
95VALUATIONDATEDate for Translation of Contract Currency to Local Currencynvarchar80DATS(N'00000000')YesRECDVALUATIONDATE Allow NULL? 
96REVERSAL_FORGUID (RAW16) for 'Reversal for' Referencesvarbinary160RAWYesRECDREVERSALFORGUID
97REVERSAL_BYGUID (RAW16) for 'Reversed by' Referencesvarbinary160RAWYesRECDREVERSALBYGUID
98FOLLOWUP_FORGUID (RAW16) for 'Follow-Up Posting for' Referencesvarbinary160RAWYesRECDFOLLOWUPFORGUID
99BOOK_FLOWTYPEFlow Typenvarchar40CHAR(N' ')Yes*RECDFLOWTYPE Allow NULL? 
100BOOK_REFFLOWRELType of Relationship Between Flow Type and Refer.Flow Typenvarchar30CHAR(N' ')Yes*RECDREFFLOWREL Allow NULL? 
101TAXDATEDate of Calculation of Sales/Purchase Taxnvarchar80DATS(N'00000000')YesRECDTAXDATE Allow NULL? 
102MODDUEDATEModified Due Datenvarchar80DATS(N'00000000')YesRECDMODDUEDATE Allow NULL? 
103CALCDUEDATECalculated Due Datenvarchar80DATS(N'00000000')YesRECDCALCDUEDATE Allow NULL? 
104CFSPLITFORGUIDGUID (RAW16) of Cash Flow Record That Was Splitvarbinary160RAWYesRECDCFSPLITFORGUID
105CFSPLITBASISCash Flow Record Was Basis for Splitchar10CHAR(N' ')YesRECDCFSPLITBASIS Allow NULL? 
106CDSPLITNONumber of Condition Splitnvarchar40NUMC(N'0000')YesRETMCDSPLITNO Allow NULL? 
107COMPANYCODECompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
108CMCFGROUPPlanning Groupnvarchar100CHAR(N' ')Yes*FDGRP Allow NULL? 
109CTRULECurrency Translation Rulenvarchar200CHAR(N' ')Yes*RECACTRULE Allow NULL? 
110CTLCNETAMOUNTNet Amount in Local Currencydecimal152CURR((0))YesRECACTLCNETAMOUNT
111CTLCGROSSAMOUNTGross Amount in Local Currencydecimal152CURR((0))YesRECACTLCGROSSAMOUNT
112CTLCTAXAMOUNTTax Amount in Local Currencydecimal152CURR((0))YesRECACTLCTAXAMOUNT
113CTRATEExchange Ratedecimal95DEC((0))YesRECACTRATE
114CTRATEORIGExchange Ratedecimal95DEC((0))YesRECACTRATE
115CTPOSTCDCURRPost in Condition Currencychar10CHAR(N' ')YesRECACTPOSTCDCURR Allow NULL? 
116CTDATEREQPlanned Translation Datenvarchar80DATS(N'00000000')YesRECACTDATEREQ Allow NULL? 
117CTDATEACTActual Translation Datenvarchar80DATS(N'00000000')YesRECACTDATEACT Allow NULL? 
118CTDATEACTORIGActual Translation Datenvarchar80DATS(N'00000000')YesRECACTDATEACT Allow NULL? 
119CTDATEFROMCFPOSUse Translation Date from Cash Flowchar10CHAR(N' ')YesRECDCTDATEFROMCFPOS Allow NULL? 
120CTFCCURRKEYForeign Currencynvarchar50CUKY(N' ')Yes*RECACTFCCURRKEY Allow NULL? 
121IS_ITAX_OPTINGOptschar10CHAR(N' ')YesRESCISITAXOPTING Allow NULL? 
122ISCDSPLITCondition Splitchar10CHAR(N' ')YesRETMISCDSPLIT Allow NULL? 
123CTFCPOSTPost in Foreign Currencychar10CHAR(N' ')YesRECACTFCPOST Allow NULL? 
124POSTCDCURRPost in Condition Currencychar10CHAR(N' ')YesRECACTPOSTCDCURR Allow NULL? 
125ADVPAYWHEREFROMOrigin of Data Recordchar10CHAR(N' ')YesREYCADVPAYWHEREFROM Allow NULL? 
126INFOCONDStatistical or Informational Conditionchar10CHAR(N' ')YesRECDINFOCOND Allow NULL? 
127ADD_OBJNRObject Number for Additional Account Assignmentnvarchar220CHAR(N' ')Yes*RERAADDOBJNR Allow NULL? 
128CDGUIDINVALIDCONDGUID Invalid - Data Record Is Summarizedchar10CHAR(N' ')YesRERACDGUIDINVALID Allow NULL? 
129CTFCNETAMOUNTNet Amount of Advance Payment in Foreign Currencydecimal152CURR((0))YesRERAAPCTFCNETAMOUNT
130CTFCTAXAMOUNTTax Amount of Advance Payment in Foreign Currencydecimal152CURR((0))YesRERAAPCTFCTAXAMOUNT
NamePrimaryUniqueTypeColumns
VIYCADVPAY~0YesYesCLUSTEREDMANDT, CAM_ADVPAY_GUID
VIYCADVPAY~001NoNoNONCLUSTEREDMANDT, SETTL_GUID
VIYCADVPAY~002NoNoNONCLUSTEREDMANDT, CNOBJNR, CONDGUID, DBERBIS, CDSPLITNO

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