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  | NVBRK
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: SAP Healthcare - Industry-Specific Components for Hospitals :: Patient Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0NVBRK763IS-H: Billing document header dataPatient Accounting
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, FKART, FKTYP, FKHKT, VBTYP, WAERK, VKORG, VTWEG, KALSM, KNUMV, FKDAT, PLTYP, RFBSK, KURRF, CPKUR, VALTG, VALDT, ZTERM, ZLSCH, KTGRD, LAND1, REGIO, COUNC, CITYC, BUKRS, TAXK1, TAXK2, TAXK3, TAXK4, TAXK5, TAXK6, TAXK7, TAXK8, TAXK9, NETWR, ERNAM, ERZET, ERDAT, KUNRG, KUNAG, MABER, AEDAT, SFAKN, KURST, MSCHL, MANSP, SPART, HITYP_PR, KAPPL, LANDTX, XBLNR, ZUONR, MWSBK, LOGSYS, FKSTO, EINRI, ORGID, FALAR, FALNR, KOSTR, KTART, LFDVV, DATZW, SAMNR, FPKZF, SEKZF, AKRKZ, EMTYP, LFDBEW, ISHSTOID, FALRN, RESID, KTARI, ADINS, FORNR FROM NVBRK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNBilling Documentnvarchar100CHAR(N' ')NoVBUKVBELN_VF Allow NULL? 
3FKARTBilling Typenvarchar40CHAR(N' ')YesTVFKFKART Allow NULL? 
4FKTYPIS-H: Billing Category (Provisional, Final)char10CHAR(N' ')YesISH_FKTYP Allow NULL? 
5FKHKTIS-H: Source of billing documentchar10CHAR(N' ')YesISH_FKHKT Allow NULL? 
6VBTYPSD document categorychar10CHAR(N' ')YesVBTYP Allow NULL? 
7WAERKSD Document Currencynvarchar50CUKY(N' ')YesTCURCWAERK Allow NULL? 
8VKORGSales Organizationnvarchar40CHAR(N' ')YesTVKOVKORG Allow NULL? 
9VTWEGDistribution Channelnvarchar20CHAR(N' ')YesTVTWVTWEG Allow NULL? 
10KALSMSales and Distribution: Pricing Procedure in Pricingnvarchar60CHAR(N' ')YesT683KALSMASD Allow NULL? 
11KNUMVNumber of the document conditionnvarchar100CHAR(N' ')YesKNUMV Allow NULL? 
12FKDATBilling date for billing index and printoutnvarchar80DATS(N'00000000')YesFKDAT Allow NULL? 
13PLTYPPrice list typenvarchar20CHAR(N' ')YesT189PLTYP Allow NULL? 
14RFBSKStatus for transfer to accountingchar10CHAR(N' ')YesRFBSK Allow NULL? 
15KURRFExchange rate for FI postingsdecimal95DEC((0))YesKURRF
16CPKURID:Exchange rate setting (no new rate determ.in bill.doc.)char10CHAR(N' ')YesCPKUR Allow NULL? 
17VALTGAdditional value daysnvarchar20NUMC(N'00')YesVALTG Allow NULL? 
18VALDTFixed value datenvarchar80DATS(N'00000000')YesVALDT Allow NULL? 
19ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
20ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZSCHZW_BSEG Allow NULL? 
21KTGRDAccount assignment group for this customernvarchar20CHAR(N' ')YesTVKTKTGRD Allow NULL? 
22LAND1Country of Destinationnvarchar30CHAR(N' ')YesT005LLAND Allow NULL? 
23REGIORegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
24COUNCCounty Codenvarchar30CHAR(N' ')YesT005ECOUNC Allow NULL? 
25CITYCCity Codenvarchar40CHAR(N' ')YesT005GCITYC Allow NULL? 
26BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
27TAXK1Tax classification 1 for customerchar10CHAR(N' ')Yes*TAXK1 Allow NULL? 
28TAXK2Tax classification 2 for customerchar10CHAR(N' ')Yes*TAXK2 Allow NULL? 
29TAXK3Tax classification 3 for customerchar10CHAR(N' ')Yes*TAXK3 Allow NULL? 
30TAXK4Tax Classification 4 Customerchar10CHAR(N' ')Yes*TAXK4 Allow NULL? 
31TAXK5Tax classification 5 for customerchar10CHAR(N' ')Yes*TAXK5 Allow NULL? 
32TAXK6Tax classification 6 for customerchar10CHAR(N' ')Yes*TAXK6 Allow NULL? 
33TAXK7Tax classification 7 for customerchar10CHAR(N' ')Yes*TAXK7 Allow NULL? 
34TAXK8Tax classification 8 for customerchar10CHAR(N' ')Yes*TAXK8 Allow NULL? 
35TAXK9Tax classification 9 for customerchar10CHAR(N' ')Yes*TAXK9 Allow NULL? 
36NETWRNet Value in Document Currencydecimal152CURR((0))YesNETWR
37ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
38ERZETEntry timenvarchar60TIMS(N'000000')YesERZET Allow NULL? 
39ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
40KUNRGPayernvarchar100CHAR(N' ')YesKNA1KUNRG Allow NULL? 
41KUNAGSold-to partynvarchar100CHAR(N' ')YesKNA1KUNAG Allow NULL? 
42MABERDunning Areanvarchar20CHAR(N' ')YesT047MMABER Allow NULL? 
43AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
44SFAKNCancelled billing document numbernvarchar100CHAR(N' ')YesVBUKSFAKN Allow NULL? 
45KURSTExchange Rate Typenvarchar40CHAR(N' ')YesTCURVKURST Allow NULL? 
46MSCHLDunning keychar10CHAR(N' ')YesT040MSCHL Allow NULL? 
47MANSPDunning blockchar10CHAR(N' ')YesT040SMANSP Allow NULL? 
48SPARTDivisionnvarchar20CHAR(N' ')YesTSPASPART Allow NULL? 
49HITYP_PRHierarchy type for pricingchar10CHAR(N' ')YesTHITHITYP_PR Allow NULL? 
50KAPPLApplicationnvarchar20CHAR(N' ')Yes*KAPPL Allow NULL? 
51LANDTXTax departure countrynvarchar30CHAR(N' ')Yes*LANDTX Allow NULL? 
52XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR_V1 Allow NULL? 
53ZUONRAssignment numbernvarchar180CHAR(N' ')YesORDNR_V Allow NULL? 
54MWSBKTax amount in document currencydecimal132CURR((0))YesMWSBP
55LOGSYSLogical systemnvarchar100CHAR(N' ')Yes*LOGSYS Allow NULL? 
56FKSTOIS-H: Invoice Is Canceled (Fully/Partially)char10CHAR(N' ')YesISH_FKSTO Allow NULL? 
57EINRIInstitution (Especially Required for Billing)nvarchar40CHAR(N' ')YesEINRIF Allow NULL? 
58ORGIDIdentification Key of Organizational Unitnvarchar80CHAR(N' ')Yes*ORGID Allow NULL? 
59FALARIS-H: Case Typechar10CHAR(N' ')YesFALLARTF Allow NULL? 
60FALNRIS-H: Case Number (Required for Billing)nvarchar100CHAR(N' ')YesFALNRF Allow NULL? 
61KOSTRIS-H: Insurance Providernvarchar100CHAR(N' ')YesKH_KOSTRF Allow NULL? 
62KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30CHAR(N' ')YesKOSTR_ARTF Allow NULL? 
63LFDVVIS-H: Sequence Number of Insurance Relationshipnvarchar30NUMC(N'000')YesLFDVV Allow NULL? 
64DATZWIS-H: Date up to which Interim Billing Is to Be Performednvarchar80DATS(N'00000000')YesISH_ZWIABR_DAT Allow NULL? 
65SAMNRIS-H: Collective Invoice Numbernvarchar100CHAR(N' ')Yes*ISH_VBELNS Allow NULL? 
66FPKZFIS-H: Ind. whether the Case Has a Flat Rate (at Least 1)char10CHAR(N' ')YesISH_FPKZ Allow NULL? 
67SEKZFProcedure Surcharge Is Defined for Case (at Least 1)char10CHAR(N' ')YesISH_SEKZ Allow NULL? 
68AKRKZIS-H: Billing Indicator for Invoicechar10CHAR(N' ')YesABRKZ_FK Allow NULL? 
69EMTYPIS-H: Employee Typenvarchar20CHAR(N' ')Yes*ISH_EMTYPE Allow NULL? 
70LFDBEWIS-H: Sequence Number of Movementnvarchar50NUMC(N'00000')Yes*LFDBEW Allow NULL? 
71ISHSTOIDIS-H: Reason for Canceling Billing Documentnvarchar30CHAR(N' ')Yes*ISH_FAKSTOID Allow NULL? 
72FALRNIS-H SG: Logical invoice numbernvarchar100CHAR(N' ')Yes*ISH_VBELNF Allow NULL? 
73RESIDIndicator That Patient Is Non-Residentchar10CHAR(N' ')YesISH_RESID Allow NULL? 
74KTARIIS-H NL: Internal insurance provider typenvarchar40CHAR(N' ')YesISH_KTARTI Allow NULL? 
75ADINSIS-H NL: Supplementary Insurance Indicator (NL)char10CHAR(N' ')YesISH_ADINS Allow NULL? 
76FORNRSubsequent Invoice Number for Invoice Splitnvarchar20NUMC(N'00')YesISH_FORNR Allow NULL? 
NamePrimaryUniqueTypeColumns
NVBRK~0YesYesCLUSTEREDVBELN, MANDT
NVBRK~ANoNoNONCLUSTEREDVKORG, FKART, ERDAT, VBELN, MANDT
NVBRK~NNoNoNONCLUSTEREDEINRI, FALNR, 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