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  | J_1BNFE_INVALID
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 Accounting :: Localization
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0J_1BNFE_INVALID282Electronic Nota Fiscal: Invalid Status ActionsLocalization
SQL:  selectupdate insert create

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

SELECT MANDT, DOCNUM, COUNTER, DOCSTA, SCSSTA, CONTING, CANCEL, ACTION_DATE, ACTION_TIME, ACTION_USER, REGIO, NFYEAR, NFMONTH, STCD1, MODEL, SERIE, NFNUM9, DOCNUM9, CDV, AUTHCOD, CODE, MESSAGE_TYPE, MESSAGE_ID, MESSAGE_NO, CONTING_S, MSSTAT, AUTHDATE, AUTHTIME FROM J_1BNFE_INVALID
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DOCNUMDocument Numbernvarchar100NUMC(N'0000000000')No*J_1BDOCNUM Allow NULL? 
3COUNTERNF-e: Counter for Table J_1BNFE_INVALIDnvarchar50NUMC(N'00000')NoJ_1B_NFE_COUNTER Allow NULL? 
4DOCSTADocument Statuschar10CHAR(N' ')YesJ_1BNFEDOCSTATUS Allow NULL? 
5SCSSTASystem Communication Statuschar10CHAR(N' ')YesJ_1BNFESCSSTATUS Allow NULL? 
6CONTINGDocument Posted under Contingencychar10CHAR(N' ')YesJ_1BCONTINGENCY Allow NULL? 
7CANCELCanceledchar10CHAR(N' ')YesJ_1BCANCEL Allow NULL? 
8ACTION_DATEDate of Change to Documentnvarchar80DATS(N'00000000')YesJ_1BNFE_ACTION_DATE Allow NULL? 
9ACTION_TIMETime of Change to Documentnvarchar60TIMS(N'000000')YesJ_1BNFE_ACTION_TIME Allow NULL? 
10ACTION_USERUser Who Made Change to Documentnvarchar120CHAR(N' ')YesJ_1BNFE_ACTION_USER Allow NULL? 
11REGIORegion of Document Issuernvarchar20CHAR(N' ')YesJ_1BREGIO Allow NULL? 
12NFYEARYear of Document Datenvarchar20CHAR(N' ')YesJ_1BYEAR Allow NULL? 
13NFMONTHMonth of Document Datenvarchar20CHAR(N' ')YesJ_1BMONTH Allow NULL? 
14STCD1CNPJ Number of Document Issuernvarchar140CHAR(N' ')YesJ_1BSTCD1 Allow NULL? 
15MODELModel of Nota Fiscalnvarchar20NUMC(N'00')YesJ_1BMODEL Allow NULL? 
16SERIESeriesnvarchar30CHAR(N' ')YesJ_1BSERIES Allow NULL? 
17NFNUM9Nine-Digit Document Numbernvarchar90CHAR(N' ')YesJ_1BNFNUM9 Allow NULL? 
18DOCNUM9Random Number in Access Keynvarchar90CHAR(N' ')YesJ_1BDOCNUM9 Allow NULL? 
19CDVCheck Digit in Access Keychar10CHAR(N' ')YesJ_1BCHECKDIGIT Allow NULL? 
20AUTHCODProtocol Numbernvarchar150CHAR(N' ')YesJ_1BNFEAUTHCODE Allow NULL? 
21CODEOfficial Status Codenvarchar30CHAR(N' ')Yes*J_1BSTATUSCODE Allow NULL? 
22MESSAGE_TYPEMessage Type of Message in NF-e Logchar10CHAR(N' ')YesJ_1B_NFE_MESSAGE_TYPE Allow NULL? 
23MESSAGE_IDID of Messages in the NF-e Lognvarchar200CHAR(N' ')Yes*J_1B_NFE_MESSAGE_ID Allow NULL? 
24MESSAGE_NOMessage Number of Message in NF-e Lognvarchar30CHAR(N' ')Yes*J_1B_NFE_MESSAGE_NO Allow NULL? 
25CONTING_SSwitched to Contingencychar10CHAR(N' ')YesJ_1BCONTINGENCY_NFE_SWITCHED Allow NULL? 
26MSSTATStatus from Messaging Systemchar10CHAR(N' ')YesJ_1BNFE_MS_STATUS Allow NULL? 
27AUTHDATEProcessing Timestamp - Datenvarchar80DATS(N'00000000')YesJ_1BAUTHDATE Allow NULL? 
28AUTHTIMEProcessing Timestamp - Timenvarchar60TIMS(N'000000')YesJ_1BAUTHTIME Allow NULL? 
NamePrimaryUniqueTypeColumns
J_1BNFE_INVALID~0YesYesCLUSTEREDCOUNTER, DOCNUM, MANDT
J_1BNFE_INVALID~00NoNoNONCLUSTEREDCDV, DOCNUM9, NFNUM9, SERIE, MODEL, STCD1, NFMONTH, NFYEAR, REGIO, 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