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  | AKKP
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
Sales and Distribution :: Foreign Trade :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0AKKP1137Documentary Payment Guarantee: Fin.Doc.Master - Header DataBasic Functions
SQL:  selectupdate insert create

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

SELECT MANDT, LCNUM, REFLCNUM, AKKEI, BUKRS, AKART, AKKTP, KUNNR, ELIFN, CADNR, INTER, WAEMP, CADNR_WE, AKKST, TSSTA, TZSTA, KOMMA, TSSTB, TZSTB, KOMMB, TSSTC, TZSTC, KOMMC, TSSTD, TZSTD, KOMMD, TSSTE, TZSTE, KOMME, AENDGRUND, TSSTF, TZSTF, KOMMF, TSSTZ, TZSTZ, KOMMZ, AADAT, AATZO, AIDAT, AITZO, AJDAT, AJTZO, AXDAT, AXTZO, AXLND, AXORT, AXREG, AYDAT, AYTZO, AODAT, AOTZO, AHDAT, AHTZO, ANYTG, WRTAK, WAERS, IAPRZ, EUPRZ, ZTERM, INCO1, INCO2, AUTLF, ATRSI, AMINQ, AMAXQ, MEINS, ERNAM, ERDAT_TS, ERDAT_TZ, VOLL, AKKCONFIRM, UNPRZ, KUNFS, KUNCK, AADFS, AADCK, AIDFS, AIDCK, AEDFS, AEDCK, AXDFS, AXDCK, AVDFS, AVDCK, ALDFS, ALDCK, ADDFS, ADDCK, AWEFS, AWECK, IAPFS, EUPFS, EUPCK, TEZFS, TEZCK, INCFS, INCCK, AUTFS, AUTCK, ATRFS, ATRCK, AMIFS, AMICK, TXTGR, FDLANGU, REFFS, INDGRUND, DOKFREI, FTCCD, DDZCK, DDICK, UNPFS, UNPCK FROM AKKP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2LCNUMFinancial doc. processing: Internal financial doc. numbernvarchar100CHAR(N' ')NoLCNUM Allow NULL? 
3REFLCNUMFinancial document processing: Search termnvarchar400CHAR(N' ')YesAKKSUCH Allow NULL? 
4AKKEIFinancial document processing: Export / Importchar10CHAR(N' ')YesAKKEI Allow NULL? 
5BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
6AKARTFinancial document processing: Type of financial documentnvarchar20CHAR(N' ')YesT607IAKART Allow NULL? 
7AKKTPFinancial document processing: Financial document categorychar10CHAR(N' ')YesAKKTP Allow NULL? 
8KUNNRCustomer Numbernvarchar100CHAR(N' ')YesKNB1KUNNR Allow NULL? 
9ELIFNVendor Account Numbernvarchar100CHAR(N' ')YesLFA1ELIFN Allow NULL? 
10CADNRAddress numbernvarchar100CHAR(N' ')YesADRCAD_ADDRNUM Allow NULL? 
11INTERInternational address version IDchar10CHAR(N' ')YesTSAVINTER Allow NULL? 
12WAEMPCustomer Numbernvarchar100CHAR(N' ')YesKNA1KUNNR Allow NULL? 
13CADNR_WEAddress numbernvarchar100CHAR(N' ')YesADRCAD_ADDRNUM Allow NULL? 
14AKKSTFinancial document processing: Statuschar10CHAR(N' ')YesAKKST Allow NULL? 
15TSSTAFinancial document determination: Time stamp for statusnvarchar140NUMC(N'00000000000000')YesSTTMS Allow NULL? 
16TZSTAFinancial document processing: Status of time zonenvarchar60CHAR(N' ')YesTTZZSTTMZ Allow NULL? 
17KOMMAText, 40 Characters Longnvarchar400CHAR(N' ')YesTEXT40 Allow NULL? 
18TSSTBFinancial document determination: Time stamp for statusnvarchar140NUMC(N'00000000000000')YesSTTMS Allow NULL? 
19TZSTBFinancial document processing: Status of time zonenvarchar60CHAR(N' ')YesTTZZSTTMZ Allow NULL? 
20KOMMBText, 40 Characters Longnvarchar400CHAR(N' ')YesTEXT40 Allow NULL? 
21TSSTCFinancial document determination: Time stamp for statusnvarchar140NUMC(N'00000000000000')YesSTTMS Allow NULL? 
22TZSTCFinancial document processing: Status of time zonenvarchar60CHAR(N' ')YesTTZZSTTMZ Allow NULL? 
23KOMMCText, 40 Characters Longnvarchar400CHAR(N' ')YesTEXT40 Allow NULL? 
24TSSTDFinancial document determination: Time stamp for statusnvarchar140NUMC(N'00000000000000')YesSTTMS Allow NULL? 
25TZSTDFinancial document processing: Status of time zonenvarchar60CHAR(N' ')YesTTZZSTTMZ Allow NULL? 
26KOMMDText, 40 Characters Longnvarchar400CHAR(N' ')YesTEXT40 Allow NULL? 
27TSSTEFinancial document determination: Time stamp for statusnvarchar140NUMC(N'00000000000000')YesSTTMS Allow NULL? 
28TZSTEFinancial document processing: Status of time zonenvarchar60CHAR(N' ')YesTTZZSTTMZ Allow NULL? 
29KOMMEText, 40 Characters Longnvarchar400CHAR(N' ')YesTEXT40 Allow NULL? 
30AENDGRUNDFinancial document processing: Reason for changechar10CHAR(N' ')YesAENDGRUND Allow NULL? 
31TSSTFFinancial document determination: Time stamp for statusnvarchar140NUMC(N'00000000000000')YesSTTMS Allow NULL? 
32TZSTFFinancial document processing: Status of time zonenvarchar60CHAR(N' ')YesTTZZSTTMZ Allow NULL? 
33KOMMFText, 40 Characters Longnvarchar400CHAR(N' ')YesTEXT40 Allow NULL? 
34TSSTZFinancial document determination: Time stamp for statusnvarchar140NUMC(N'00000000000000')YesSTTMS Allow NULL? 
35TZSTZFinancial document processing: Status of time zonenvarchar60CHAR(N' ')YesTTZZSTTMZ Allow NULL? 
36KOMMZText, 40 Characters Longnvarchar400CHAR(N' ')YesTEXT40 Allow NULL? 
37AADATFinancial document processing: Request datenvarchar140NUMC(N'00000000000000')YesAADAT Allow NULL? 
38AATZOFinancial document processing: Time zone - Request Datenvarchar60CHAR(N' ')YesTTZZAATZO Allow NULL? 
39AIDATFinancial document processing: Opening datenvarchar140NUMC(N'00000000000000')YesAIDAT Allow NULL? 
40AITZOFinancial document processing: Time zone - Opening datenvarchar60CHAR(N' ')YesTTZZAITZO Allow NULL? 
41AJDATFinancial document processing: Date of receiptnvarchar140NUMC(N'00000000000000')YesAJDAT Allow NULL? 
42AJTZOFinancial document processing: Time zone - Date of receiptnvarchar60CHAR(N' ')YesTTZZAJTZO Allow NULL? 
43AXDATFinancial document processing: Validity end datenvarchar140NUMC(N'00000000000000')YesAXDAT Allow NULL? 
44AXTZOFinancial document processing: Time zone - Validity end datenvarchar60CHAR(N' ')YesTTZZAXTZO Allow NULL? 
45AXLNDCountry Keynvarchar30CHAR(N' ')YesT005LAND1 Allow NULL? 
46AXORTCity Codenvarchar40CHAR(N' ')Yes*CITYC Allow NULL? 
47AXREGRegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
48AYDATFinancial document processing: Latest shipping datenvarchar140NUMC(N'00000000000000')YesAYDAT Allow NULL? 
49AYTZOFinancial doc. processing: Time zone - Latest shipping datenvarchar60CHAR(N' ')YesTTZZAYTZO Allow NULL? 
50AODATFinancial doc. procg: Latest date of shipped bill of ladingnvarchar140NUMC(N'00000000000000')YesAODAT Allow NULL? 
51AOTZOFin.doc.procg: Time zone-Latest date-Shipped bill of ladingnvarchar60CHAR(N' ')YesTTZZAOTZO Allow NULL? 
52AHDATFinancial doc. processing: Date when docs presented to banknvarchar140NUMC(N'00000000000000')YesAHDAT Allow NULL? 
53AHTZOFinancial doc. processing : Time zone - Presentation to banknvarchar60CHAR(N' ')YesTTZZAHTZO Allow NULL? 
54ANYTGFinancial doc. procg: No. of days for submitt. docs to banknvarchar30NUMC(N'000')YesANYTG Allow NULL? 
55WRTAKFinancial document processing: Financial document valuedecimal152CURR((0))YesWRTAK
56WAERSCurrency key for letter-of-credit procg in foreign tradenvarchar50CUKY(N' ')YesTCURCAKWAE Allow NULL? 
57IAPRZFinancial doc. proc.: Consumption factor of letter of creditdecimal52DEC((0))YesIAPRZ
58EUPRZFinancial document processing: Allowed overdraft percentagedecimal52DEC((0))YesEUPRZ
59ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
60INCO1Incoterms (Part 1)nvarchar30CHAR(N' ')YesTINCINCO1 Allow NULL? 
61INCO2Incoterms (Part 2)nvarchar280CHAR(N' ')YesINCO2 Allow NULL? 
62AUTLFComplete delivery defined for each sales order?char10CHAR(N' ')YesAUTLF Allow NULL? 
63ATRSIFinancial document processing: Reload indicatorchar10CHAR(N' ')YesATRSI Allow NULL? 
64AMINQFinancial document processing: Minimum quantitydecimal133QUAN((0))YesAMINQ
65AMAXQFinancial document processing: Maximum quantitydecimal133QUAN((0))YesAMAXQ
66MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
67ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
68ERDAT_TSDate on which record has been added (time stamp)nvarchar140NUMC(N'00000000000000')YesERDAT_TS Allow NULL? 
69ERDAT_TZDate on which record has been added (time zone)nvarchar60CHAR(N' ')YesTTZZERDAT_TZ Allow NULL? 
70VOLLFinancial document processing: Document completion flagchar10CHAR(N' ')YesVOLL Allow NULL? 
71AKKCONFIRMFinancial doc.procg: MAIL user of person confirming fin.doc.nvarchar120CHAR(N' ')YesUSR02AKKCONFIRM Allow NULL? 
72UNPRZAllowed shortfall percentage rate for financial documentsdecimal52DEC((0))YesUNPRZ
73KUNFSFinancial doc. processing: Field sel. cust./vendor numberschar10CHAR(N' ')YesKUNFS Allow NULL? 
74KUNCKFinancial doc. processing: Check customer / vendor numberschar10CHAR(N' ')YesKUNCK Allow NULL? 
75AADFSFinancial document processing: Fld selection - Request datechar10CHAR(N' ')YesAADFS Allow NULL? 
76AADCKFinancial document processing: Check request datechar10CHAR(N' ')YesAADCK Allow NULL? 
77AIDFSFinancial document processing: Fld selection - Opening datechar10CHAR(N' ')YesAIDFS Allow NULL? 
78AIDCKFinancial document processing: Check creation datechar10CHAR(N' ')YesAIDCK Allow NULL? 
79AEDFSFinancial doc. processing: Fld selection - Date of receiptchar10CHAR(N' ')YesAEDFS Allow NULL? 
80AEDCKFinancial document processing: Check date of receiptchar10CHAR(N' ')YesAEDCK Allow NULL? 
81AXDFSFinancial doc. procg: Field selection - Validity end datechar10CHAR(N' ')YesAXDFS Allow NULL? 
82AXDCKFinancial document processing: Check validity end datechar10CHAR(N' ')YesAXDCK Allow NULL? 
83AVDFSFinancial doc. procg: Field selection - Latest shipping datechar10CHAR(N' ')YesAVDFS Allow NULL? 
84AVDCKfinancial document processing: Check latest shipping datechar10CHAR(N' ')YesAVDCK Allow NULL? 
85ALDFSFinancial doc.procg: Fld selection - Date of bill of ladingchar10CHAR(N' ')YesALDFS Allow NULL? 
86ALDCKFinancial doc. procg: Check date of shipped bill of ladingchar10CHAR(N' ')YesALDCK Allow NULL? 
87ADDFSFinancial document processing: Fld ctrl - Submission of doc.char10CHAR(N' ')YesADDFS Allow NULL? 
88ADDCKFinancial document processing: Check submission of documentchar10CHAR(N' ')YesADDCK Allow NULL? 
89AWEFSFinancial doc. procg: Field selection - Financial doc. valuechar10CHAR(N' ')YesAWEFS Allow NULL? 
90AWECKFinancial doc. processing: Check financial document valuechar10CHAR(N' ')YesAWECK Allow NULL? 
91IAPFSFinancial document processing: Field selection consumptionchar10CHAR(N' ')YesIAPFS Allow NULL? 
92EUPFSFinancial document processing: Fld selection for overdraft %char10CHAR(N' ')YesEUPFS Allow NULL? 
93EUPCKFinancial document processing: Check percentage of overdraftchar10CHAR(N' ')YesEUPCK Allow NULL? 
94TEZFSFinancial doc. proc.: Field selection terms of paymentchar10CHAR(N' ')YesTEZFS Allow NULL? 
95TEZCKFinancial doc. processing: Check terms of paymentchar10CHAR(N' ')YesTEZCK Allow NULL? 
96INCFSFinancial document processing: Incoterms field selectionchar10CHAR(N' ')YesINCFS Allow NULL? 
97INCCKFinancial doc. processing: Check INCOTermschar10CHAR(N' ')YesINCCK Allow NULL? 
98AUTFSFinancial doc. procg: Field selection for partial dlv. ind.char10CHAR(N' ')YesAUTFS Allow NULL? 
99AUTCKFinancial document processing: Check partial delivery ind.char10CHAR(N' ')YesAUTCH Allow NULL? 
100ATRFSFinancial document processing: Fld selection - Reload ind.char10CHAR(N' ')YesATRFS Allow NULL? 
101ATRCKFinancial doc. procg: Check reload indicatorchar10CHAR(N' ')YesATRCK Allow NULL? 
102AMIFSFinancial document processing: Fld selection - Min./Max.qtychar10CHAR(N' ')YesAMIFS Allow NULL? 
103AMICKFinancial document processing: Check minimum/maximum qtychar10CHAR(N' ')YesAMICK Allow NULL? 
104TXTGRText determination procedurenvarchar20CHAR(N' ')YesTTXGTXTGR Allow NULL? 
105FDLANGUFinancial document processing: Default document languagechar10LANG(N' ')YesFDLANGU Allow NULL? 
106REFFSFinancial document processing: Field selection search termchar10CHAR(N' ')YesSUCHFS Allow NULL? 
107INDGRUNDFinancial document processing: Indicator for change reasonchar10CHAR(N' ')YesT607GINDGRUND Allow NULL? 
108DOKFREIFinancial document processing: Free entry of docs possiblechar10CHAR(N' ')YesDOKFREI Allow NULL? 
109FTCCDDerivation of company code from org. unit for Foreign Tradechar10CHAR(N' ')YesFTCCD Allow NULL? 
110DDZCKExistence check control of payment terms for financial docschar10CHAR(N' ')YesDDZCK Allow NULL? 
111DDICKExistence check control of Incoterms for financial documentschar10CHAR(N' ')YesDDICK Allow NULL? 
112UNPFSFinancial document processing: Field selection shortfall PRchar10CHAR(N' ')YesUNPFS Allow NULL? 
113UNPCKFinancial document processing: Shortfall percentage ratechar10CHAR(N' ')YesUNPCK Allow NULL? 
NamePrimaryUniqueTypeColumns
AKKP~0YesYesCLUSTEREDLCNUM, MANDT
AKKP~ANoNoNONCLUSTEREDKUNNR, MANDT
AKKP~BNoNoNONCLUSTEREDELIFN, MANDT
AKKP~CNoNoNONCLUSTEREDBUKRS, MANDT
AKKP~DNoNoNONCLUSTEREDAKKTP, AKART, MANDT
AKKP~ENoNoNONCLUSTEREDAKKST, MANDT
AKKP~FNoNoNONCLUSTEREDVOLL, 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