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  | P01BN_STAT
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.0P01BN_STAT312Status Table for Contribution Statements
SQL:  selectupdate insert create

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

SELECT MANDT, GUID, MDTYP, STATUS, GUID_STORN, GUID_CNECT, KNAPP, BNART, RECHKR, BBNRAG, WERKSAG, BTRTLAG, BBNREP, PABRP_IN, PABRJ_IN, KEKORR, LAUFNR, ABKRS, KVSFR, KVGST, DATUM, UZEIT, REPORT, EUSER, WERKS, BTRTL, KKART, BTRNR, PABRP, PABRJ, ADATUM FROM P01BN_STAT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2GUIDUnique Key for Identification of Notificationnvarchar320CHAR(N' ')NoP01_SVGUID Allow NULL? 
3MDTYPNotification Typechar10CHAR(N' ')YesP01_BN_MDTYP Allow NULL? 
4STATUSStatus Indicator of SI Contribution Statementsnvarchar20CHAR(N' ')YesP01_BN_STATUS Allow NULL? 
5GUID_STORNGUID of Reversed Notificationnvarchar320CHAR(N' ')YesP01_GUIDSTORN Allow NULL? 
6GUID_CNECTGUID of Linked Notificationnvarchar320CHAR(N' ')YesP01_GUIDCNECT Allow NULL? 
7KNAPPContribution Statement for Miners' and Mine EEs' Insurancechar10CHAR(N' ')YesP01_BN_KNAPP Allow NULL? 
8BNARTType of Contribution Statementchar10CHAR(N' ')YesP01_BN_BNART Allow NULL? 
9RECHKRLegal Areachar10CHAR(N' ')YesP01_BN_RECHKR Allow NULL? 
10BBNRAGEmployer Company Number/Paying Office Numbernvarchar150CHAR(N' ')YesP01_BN_BBNRAG Allow NULL? 
11WERKSAGPersonnel Area of Employer/Paying Officenvarchar40CHAR(N' ')Yes*P01_BN_WERKS Allow NULL? 
12BTRTLAGPersonnel Subarea of Employer/Paying Officenvarchar40CHAR(N' ')Yes*P01_BN_BTRTL Allow NULL? 
13BBNREPCompany Number of Recipientnvarchar150CHAR(N' ')YesP01_BN_BBNREP Allow NULL? 
14PABRP_INPayroll period for determining time periodnvarchar20NUMC(N'00')YesPNPPABRP Allow NULL? 
15PABRJ_INPayroll year for determining time periodnvarchar40NUMC(N'0000')YesPNPPABRJ Allow NULL? 
16KEKORRIndicator: Correction Contribution Statementchar10CHAR(N' ')YesP01_BN_KEKORR Allow NULL? 
17LAUFNRRun Numbernvarchar30CHAR(N' ')YesP01_BN_LAUFNR Allow NULL? 
18ABKRSPayroll Areanvarchar20CHAR(N' ')Yes*ABKRS Allow NULL? 
19KVSFRHI Fund Key for Compulsory Health Insurance Fundnvarchar80CHAR(N' ')Yes*KVSCH Allow NULL? 
20KVGSTHI Fund Branch Officenvarchar60CHAR(N' ')Yes*KVGST Allow NULL? 
21DATUMCreation/Change Date of Notificationnvarchar80DATS(N'00000000')YesP01_SVDATUM Allow NULL? 
22UZEITCreation/Change Time of a Notificationnvarchar60TIMS(N'000000')YesP01_SVUZEIT Allow NULL? 
23REPORTProgram Namenvarchar400CHAR(N' ')Yes*P01_SVREPID Allow NULL? 
24EUSERUser Namenvarchar120CHAR(N' ')YesP01_SVUNAME Allow NULL? 
25WERKSSender or Recipient of Notification (Personnel Area)nvarchar40CHAR(N' ')Yes*P01_SVWERKS Allow NULL? 
26BTRTLSender or Recipient of Notification (Personnel Subarea)nvarchar40CHAR(N' ')Yes*P01_SVBTRTL Allow NULL? 
27KKARTType of Organizational Unit of Health Insurance Fundnvarchar20NUMC(N'00')YesP01_KKART Allow NULL? 
28BTRNRCompany Numbernvarchar80CHAR(N' ')YesBNR_KEY Allow NULL? 
29PABRPPayroll period for determining time periodnvarchar20NUMC(N'00')YesPNPPABRP Allow NULL? 
30PABRJPayroll year for determining time periodnvarchar40NUMC(N'0000')YesPNPPABRJ Allow NULL? 
31ADATUMDate of Evaluationnvarchar80DATS(N'00000000')YesP01_SVADATUM Allow NULL? 
NamePrimaryUniqueTypeColumns
P01BN_STAT~0YesYesCLUSTEREDGUID, MANDT
P01BN_STAT~001NoNoNONCLUSTEREDLAUFNR, PABRP_IN, PABRJ_IN, STATUS, MDTYP, 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