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  | BKK_OPD_IT_EXT
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.0BKK_OPD_IT_EXT542External Item Selection Table - Outgoing Payment Dispatcher
SQL:  selectupdate insert create

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

SELECT MANDT, BKKRS, PAORN, POSNO, ITEM_STATUS, PRIORITY, POST_DATE, CURRENCY, GUID, XCREDIT, COLL_PO_REF_NO, RETURN_KEY, COM_AMOUNT, COM_CUR, SND_BANK_COUNTRY, SND_BANKKEY, SND_BIC, SND_ACC_NO_EXT, SND_IBAN, SND_ACC_HOLDER, SND_ACC_CRCY, SND_STREET_NAME, SND_HOUSE_NO, SND_POSTAL_CODE, SND_CITY, SND_REGION, SND_COUNTRY, REFNO_CR, REFNO_PAYM, REFNO_PN, RECONC_SYSTEM, RECONC_APPL, RECONC_NO, REF_SND_BANK_COUNTRY, REF_SND_BANKKEY, REF_SND_BIC, REF_SND_ACC_NO_EXT, REF_SND_IBAN, REF_SND_ACC_HOLDER, REF_SND_ACC_CRCY, XSDD, PAY_TYPE, MAND_FREQ, DATE_DUE, SIGN_DATE, CRUSR, CRDAT, CRTIM, CHUSR, CHDAT, CHTIM, RLUSR, RLDAT, RLTIM FROM BKK_OPD_IT_EXT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BKKRSBank Areanvarchar40CHAR(N' ')No*BKK_BKKRS Allow NULL? 
3PAORNPayment order numbernvarchar120NUMC(N'000000000000')NoBKK_PAORN Allow NULL? 
4POSNOItem in Payment Ordernvarchar50NUMC(N'00000')NoBKK_POPOS Allow NULL? 
5ITEM_STATUSItem Statuschar10CHAR(N' ')YesBKK_OPD_DTE_ITEM_STATUS Allow NULL? 
6PRIORITYProcessing Priority of Payment Item in OPDnvarchar20NUMC(N'00')YesBKK_OPD_PRIOBKK_OPD_DTE_PRIORITY Allow NULL? 
7POST_DATEPosting datenvarchar80DATS(N'00000000')YesBKK_PSTDAT Allow NULL? 
8CURRENCYTransaction Currencynvarchar50CUKY(N' ')YesTCURCBKK_TCUR Allow NULL? 
9GUIDGUIDvarbinary160RAWYesBKK_OPD_DTE_GUID
10XCREDITTransaction Type Initiates a Creditchar10CHAR(N' ')YesBKK_INPMNT Allow NULL? 
11COLL_PO_REF_NOCollective Payment Order Reference Numbernvarchar320CHAR(N' ')YesBKK_OPD_DTE_COL_PO_REF_NO Allow NULL? 
12RETURN_KEYReturn Reasonnvarchar40CHAR(N' ')YesBKK_RKEY Allow NULL? 
13COM_AMOUNTCompensation Amountdecimal172CURR((0))YesBKK_OPD_DTE_COM_AMOUNT
14COM_CURCompensation Amount Currencynvarchar50CUKY(N' ')Yes*BKK_OPD_DTE_COM_CURR Allow NULL? 
15SND_BANK_COUNTRYBank country keynvarchar30CHAR(N' ')Yes*BANKS Allow NULL? 
16SND_BANKKEYBank Keysnvarchar150CHAR(N' ')YesBANKK Allow NULL? 
17SND_BICSWIFT/BIC for International Paymentsnvarchar110CHAR(N' ')YesSWIFT Allow NULL? 
18SND_ACC_NO_EXTAccount number for current accountnvarchar350CHAR(N' ')YesBKK_ACEXT Allow NULL? 
19SND_IBANInternational Bank Account Numbernvarchar350CHAR(N' ')YesBKK_ACIBAN Allow NULL? 
20SND_ACC_HOLDERAccount holder namenvarchar700CHAR(N' ')YesBKK_NAME Allow NULL? 
21SND_ACC_CRCYAccount Currencynvarchar50CUKY(N' ')Yes*BKK_ACUR Allow NULL? 
22SND_STREET_NAMEStreetnvarchar600CHAR(N' ')YesAD_STREET Allow NULL? 
23SND_HOUSE_NOHouse Numbernvarchar100CHAR(N' ')YesAD_HSNM1 Allow NULL? 
24SND_POSTAL_CODECity postal codenvarchar100CHAR(N' ')YesAD_PSTCD1 Allow NULL? 
25SND_CITYCitynvarchar400CHAR(N' ')YesAD_CITY1 Allow NULL? 
26SND_REGIONRegion (State, Province, County)nvarchar30CHAR(N' ')Yes*REGIO Allow NULL? 
27SND_COUNTRYCountry Keynvarchar30CHAR(N' ')Yes*BKK_OPD_DTE_COUNTRY_KEY Allow NULL? 
28REFNO_CRReference Number of Creationnvarchar200CHAR(N' ')YesBKK_CRNO Allow NULL? 
29REFNO_PAYMReference Number from Payment Transactionsnvarchar200CHAR(N' ')YesBKK_PAYMNO Allow NULL? 
30REFNO_PNDaybook numbernvarchar120CHAR(N' ')YesBKK_PNNO Allow NULL? 
31RECONC_SYSTEMOriginating System for Payment Orders and Payment Itemsnvarchar100CHAR(N' ')Yes*BKK_DTE_PXPO_SYSTEM_FROM Allow NULL? 
32RECONC_APPLOriginating Application for Payment Orders and Payment Itemsnvarchar50CHAR(N' ')YesBKK_DTE_PXPO_APPLICATION_FROM Allow NULL? 
33RECONC_NOReconciliation Numbernvarchar150CHAR(N' ')YesBKK_DTE_PXPO_RECONC_NO Allow NULL? 
34REF_SND_BANK_COUNTRYBank country keynvarchar30CHAR(N' ')Yes*BANKS Allow NULL? 
35REF_SND_BANKKEYBank Keysnvarchar150CHAR(N' ')YesBANKK Allow NULL? 
36REF_SND_BICSWIFT/BIC for International Paymentsnvarchar110CHAR(N' ')YesSWIFT Allow NULL? 
37REF_SND_ACC_NO_EXTAccount number for current accountnvarchar350CHAR(N' ')YesBKK_ACEXT Allow NULL? 
38REF_SND_IBANInternational Bank Account Numbernvarchar350CHAR(N' ')YesBKK_ACIBAN Allow NULL? 
39REF_SND_ACC_HOLDERAccount holder namenvarchar700CHAR(N' ')YesBKK_NAME Allow NULL? 
40REF_SND_ACC_CRCYAccount Currencynvarchar50CUKY(N' ')Yes*BKK_ACUR Allow NULL? 
41XSDDSEPA Direct Debit Orderchar10CHAR(N' ')YesBKK_DTE_FLG_XSDD Allow NULL? 
42PAY_TYPESEPA: Payment Typechar10CHAR(N' ')YesSEPA_PAY_TYPE Allow NULL? 
43MAND_FREQMandate Frequencychar10CHAR(N' ')YesBKK_MAND_FREQ Allow NULL? 
44DATE_DUEDue Datenvarchar80DATS(N'00000000')YesBKK_DTE_DATE_DUE Allow NULL? 
45SIGN_DATEDate of Signaturenvarchar80DATS(N'00000000')YesSEPA_SIGN_DATE Allow NULL? 
46CRUSRUser who created the objectnvarchar120CHAR(N' ')YesBKK_CRUSR Allow NULL? 
47CRDATDate on which the object was creatednvarchar80DATS(N'00000000')YesBKK_CRDAT Allow NULL? 
48CRTIMTime at which the object was creatednvarchar60TIMS(N'000000')YesBKK_CRTIM Allow NULL? 
49CHUSRLast user to change objectnvarchar120CHAR(N' ')YesBKK_CHUSR Allow NULL? 
50CHDATDate on which the object was last changednvarchar80DATS(N'00000000')YesBKK_CHDAT Allow NULL? 
51CHTIMTime at Which Object was Last Changednvarchar60TIMS(N'000000')YesBKK_CHTIM Allow NULL? 
52RLUSRUser who released objectnvarchar120CHAR(N' ')YesBKK_RLUSR Allow NULL? 
53RLDATDate on which object was releasednvarchar80DATS(N'00000000')YesBKK_RLDAT Allow NULL? 
54RLTIMTime at Which Object Was Releasednvarchar60TIMS(N'000000')YesBKK_RLTIM Allow NULL? 
NamePrimaryUniqueTypeColumns
BKK_OPD_IT_EXT~0YesYesCLUSTEREDPOSNO, PAORN, BKKRS, MANDT
BKK_OPD_IT_EXT~GRPNoNoNONCLUSTEREDXCREDIT, CURRENCY, DATE_DUE, POST_DATE, PRIORITY, ITEM_STATUS, BKKRS, 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