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  | ISSRPREFLOW
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Financial Services :: Regulatory reporting for insurance companies
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ISSRPREFLOW679ISSR: Basistabelle/BewegungstabelleRegulatory reporting for insurance companies
SQL:  selectupdate insert create

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

SELECT MANDT, PREFLOW_GUID, PREFLOW_GUID_REV, BUKRS, ACCOUNTING_CODE, VAL_AREA, BP_PARTNR, RANTYP, PRODUCT_CAT, PRODUCT_TYPE, LEDGERTYPE, ASSET_NR, SECURITY_ACCOUNT, PRIMANOTA, FTP, BUDAT, VALUT, TSL, TSLCUR, HSL, HSLCUR, NSL, NSLCUR, UNITS, SGTXT, PRESYSTEM, PRESYSTEMDB, VS_GFTYP, VS_BELNR, VS_POSNR, VS_BELNR_REV, VS_VAL_AREA, VS_FLOWTYPE, VS_RANTYP, VS_PCAT, VS_PTYPE, VS_PRIMANOTA, VS_OBJNR, VS_CPUDT, VS_CPUTM, VS_ENAME, AWSYS, AWTYP, AWORG, AWREF, AWPOSNR, AWORG_REV, AWREF_REV, GLVOR, GJAHR, MONAT, HKONT, SHKZG, FI_BELNR, FI_BUZEI, BUTIME, ECOMPONENT, EPGM, ENAME, EDATUM, ETIME, PORTFOLIO, ACCOUNT_GRP, TRADER, ANLN1, ANLN2, VALUATION_CLASS FROM ISSRPREFLOW
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTMandantenvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PREFLOW_GUIDISSR: UUID für Basistabellenvarchar320CHAR(N' ')NoISSR_FLOW_NR Allow NULL? 
3PREFLOW_GUID_REVVerweis zu Originalbeleg, der mit diesem storniert wirdnvarchar320CHAR(N' ')YesISSR_PREFLOW_REV Allow NULL? 
4BUKRSSocietànvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
5ACCOUNTING_CODEISSR: ACCOUNTING/REPORTING KREISnvarchar40CHAR(N' ')YesISSR_ACC_CODE Allow NULL? 
6VAL_AREAMW-Bewertungsbereichnvarchar30CHAR(N' ')YesTISSR_MAVAARISSR_VAL_AREA Allow NULL? 
7BP_PARTNRNumero business partnernvarchar100CHAR(N' ')YesBUT000BU_PARTNER Allow NULL? 
8RANTYPIndicatore sist. est. tipo investimento cap. per Reportingchar10CHAR(N' ')YesISSR_RANTYP Allow NULL? 
9PRODUCT_CATISSR: categoria prodotto reportingnvarchar30CHAR(N' ')YesTISSR_IFPCATISSR_PRODUCT_CATEGORY Allow NULL? 
10PRODUCT_TYPEISSR: tipo prodotto di reportingnvarchar80CHAR(N' ')YesTISSR_IFPTYPISSR_PRODUCT_TYPE Allow NULL? 
11LEDGERTYPEISSR: tipo Ledger per reporting esternochar10CHAR(N' ')YesTISSR_MALETYISSR_LEDGERTYPE Allow NULL? 
12ASSET_NRNumero investimento capitali per Statutory Reportingnvarchar130CHAR(N' ')YesISSR_ASSET_NR Allow NULL? 
13SECURITY_ACCOUNTDepositonvarchar100CHAR(N' ')YesISSR_SECURITY_ACCOUNT Allow NULL? 
14PRIMANOTAGeschäftsvorfallklammerungnvarchar240CHAR(N' ')YesISSR_PRIMANOTA Allow NULL? 
15FTPMW-Bewegungsteilnvarchar150CHAR(N' ')YesTISSR_MAFTPISSR_FTP Allow NULL? 
16BUDATData di registrazione nel documentonvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
17VALUTData valutanvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
18TSLBestandsverändernder Betrag in Transaktionswährungdecimal172CURR((0))YesISSR_TSL
19TSLCURDivisa transazionenvarchar50CUKY(N' ')Yes*ISSR_TSLCUR Allow NULL? 
20HSLImporto di modifica posizione in divisa internadecimal172CURR((0))YesISSR_HSL
21HSLCURDivisa internanvarchar50CUKY(N' ')Yes*ISSR_HSLCUR Allow NULL? 
22NSLBestandsverändernder Betrag in Nominalwährungdecimal172CURR((0))YesISSR_NSL
23NSLCURNominalwährungnvarchar50CUKY(N' ')Yes*ISSR_NSLCUR Allow NULL? 
24UNITSISSR: Stückedecimal226DEC((0))YesISSR_UNITS
25SGTXTTesto posizionenvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
26PRESYSTEMISSR: sistema preesistente registrato in identificativo ISSRnvarchar100CHAR(N' ')Yes*ISSR_PRESYSTEM Allow NULL? 
27PRESYSTEMDBMW-Kennung für Vorsystemdatenbanknvarchar150CHAR(N' ')Yes*ISSR_PRESYSDB Allow NULL? 
28VS_GFTYPISSR: Vorsystem-Geschäftsvorfalltypnvarchar40NUMC(N'0000')Yes*ISSR_VORSYSTEM_GFTYP Allow NULL? 
29VS_BELNRISSR: Vorsystem Belegnummernvarchar320CHAR(N' ')YesISSR_VORSYSTEM_BLNR Allow NULL? 
30VS_POSNRISSR: Vorsystem Positionsnummer eines Belegnvarchar60NUMC(N'000000')Yes*ISSR_VORSYSTEM_POSNR Allow NULL? 
31VS_BELNR_REVISSR: Vorsystem Belegnummer des stornierten Belegesnvarchar320CHAR(N' ')YesISSR_VORSYSTEM_BLNR_REV Allow NULL? 
32VS_VAL_AREAISSR: Vorsystem-Bewertungsbereichnvarchar30CHAR(N' ')Yes*ISSR_VORSYSTEM_VAL_AREA Allow NULL? 
33VS_FLOWTYPEISSR: Vorsystem Fortschreibungsart/Bewegungsartnvarchar80CHAR(N' ')Yes*ISSR_VORSYSTEM_FLOWTYPE Allow NULL? 
34VS_RANTYPISSR: Vorsystem-Kapitalanlagenart für Reportingchar10CHAR(N' ')YesISSR_VORSYSTEM_RANTYP Allow NULL? 
35VS_PCATISSR: Vorsystem Produktkategorie Meldewesennvarchar30CHAR(N' ')Yes*ISSR_VS_PRODUCT_CATEGORY Allow NULL? 
36VS_PTYPEISSR: Vorsystem-Produktartnvarchar80CHAR(N' ')YesISSR_VS_PRODUCT_TYPE Allow NULL? 
37VS_PRIMANOTAISSR: VS-Geschäftsvorfallklammerungnvarchar320CHAR(N' ')YesISSR_VS_PRIMANOTA Allow NULL? 
38VS_OBJNRNumero oggettonvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
39VS_CPUDTISSR: giorno di acquisizione documento in sistema preesist.nvarchar80DATS(N'00000000')YesISSR_VS_CREATE_DATE Allow NULL? 
40VS_CPUTMISSR: Uhrzeit der Erfassung im Vorsystemnvarchar60TIMS(N'000000')YesISSR_VS_CREATE_TIME Allow NULL? 
41VS_ENAMEISSR: Erfasser im Vorsystemnvarchar120CHAR(N' ')YesISSR_VS_CREATER Allow NULL? 
42AWSYSSistema logico del documento originalenvarchar100CHAR(N' ')Yes*AWSYS Allow NULL? 
43AWTYPOperazione di riferimentonvarchar50CHAR(N' ')Yes*AWTYP Allow NULL? 
44AWORGUnità organizzative di riferimentonvarchar100CHAR(N' ')YesAWORG Allow NULL? 
45AWREFNumero documento di riferimentonvarchar100CHAR(N' ')YesAWREF Allow NULL? 
46AWPOSNRNumero posizione del documento contabilenvarchar100NUMC(N'0000000000')YesPOSNR_ACC Allow NULL? 
47AWORG_REVStorno: organizzazione di rif. del documento da stornarenvarchar100CHAR(N' ')YesAWORG_REV Allow NULL? 
48AWREF_REVStorno: n. doc. di riferimento del documento da stornarenvarchar100CHAR(N' ')YesAWREF_REV Allow NULL? 
49GLVOROperazione gestionalenvarchar40CHAR(N' ')YesGLVOR Allow NULL? 
50GJAHREsercizionvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
51MONATMese esercizionvarchar20NUMC(N'00')YesMONAT Allow NULL? 
52HKONTConto Co.Ge. contabilità generalenvarchar100CHAR(N' ')Yes*HKONT Allow NULL? 
53SHKZGIndicatore dare/averechar10CHAR(N' ')YesSHKZG Allow NULL? 
54FI_BELNRnvarchar100CHAR(N' ')YesISSR_FI_BELNR Allow NULL? 
55FI_BUZEIISSR:Nummer der Buchungszeile innerhalb des Buchhalt.-Belegsnvarchar30NUMC(N'000')YesISSR_FI_POSNR Allow NULL? 
56BUTIMEISSR: Buchungsuhrzeitnvarchar60TIMS(N'000000')YesISSR_FI_TIME Allow NULL? 
57ECOMPONENTArbeitsgebiet für ISSRnvarchar40CHAR(N' ')YesTISSR_ARGBISSR_ARBGB Allow NULL? 
58EPGMnvarchar600CHAR(N' ')YesISSR_DESCRIPTION Allow NULL? 
59ENAMENome utentenvarchar120CHAR(N' ')YesUNAME Allow NULL? 
60EDATUMDatanvarchar80DATS(N'00000000')YesDATUM Allow NULL? 
61ETIMEOra sistemanvarchar60TIMS(N'000000')YesSYUZEIT Allow NULL? 
62PORTFOLIOPortafoglionvarchar100CHAR(N' ')Yes*RPORTB Allow NULL? 
63ACCOUNT_GRPGruppo dep.nvarchar100CHAR(N' ')Yes*TPM_SEC_ACCT_GRP Allow NULL? 
64TRADEROperatorenvarchar120CHAR(N' ')Yes*RDEALER Allow NULL? 
65ANLN1Numero principale cespitenvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
66ANLN2N. secondario cespitenvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
67VALUATION_CLASSBewertungsklassenvarchar40NUMC(N'0000')YesISSR_VALUATION_CLASS Allow NULL? 
NamePrimaryUniqueTypeColumns
ISSRPREFLOW~0YesYesCLUSTEREDPREFLOW_GUID, MANDT
ISSRPREFLOW~001NoNoNONCLUSTEREDFI_BUZEI, FI_BELNR, SHKZG, BUKRS, MANDT
ISSRPREFLOW~002NoNoNONCLUSTEREDPREFLOW_GUID_REV, MANDT
ISSRPREFLOW~003NoNoNONCLUSTEREDBUDAT, FTP, SECURITY_ACCOUNT, ASSET_NR, PRODUCT_TYPE, LEDGERTYPE, VAL_AREA, BUKRS, MANDT
ISSRPREFLOW~004NoNoNONCLUSTEREDFI_BELNR, SECURITY_ACCOUNT, ASSET_NR, PRODUCT_TYPE, PRODUCT_CAT, RANTYP, VAL_AREA, LEDGERTYPE, BUKRS, PRESYSTEM
ISSRPREFLOW~005NoNoNONCLUSTEREDAWREF, AWORG, SECURITY_ACCOUNT, ASSET_NR, PRODUCT_TYPE, PRODUCT_CAT, RANTYP, VAL_AREA, LEDGERTYPE, BUKRS, PRESYSTEM
ISSRPREFLOW~006NoNoNONCLUSTEREDVS_BELNR, SECURITY_ACCOUNT, ASSET_NR, PRODUCT_TYPE, PRODUCT_CAT, RANTYP, VAL_AREA, LEDGERTYPE, BUKRS
ISSRPREFLOW~007NoNoNONCLUSTEREDAWSYS, AWREF, AWORG, AWTYP, MANDT
ISSRPREFLOW~008NoNoNONCLUSTEREDFTP, VS_BELNR, VS_VAL_AREA, BUKRS, MANDT

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