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

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
Sales and Distribution :: Billing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VBRP2241Billing Document: Item DataBilling
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, POSNR, UEPOS, FKIMG, VRKME, UMVKZ, UMVKN, MEINS, SMENG, FKLMG, LMENG, NTGEW, BRGEW, GEWEI, VOLUM, VOLEH, GSBER, PRSDT, FBUDA, KURSK, NETWR, VBELV, POSNV, VGBEL, VGPOS, VGTYP, AUBEL, AUPOS, AUREF, MATNR, ARKTX, PMATN, CHARG, MATKL, PSTYV, POSAR, PRODH, VSTEL, ATPKZ, SPART, POSPA, WERKS, ALAND, WKREG, WKCOU, WKCTY, TAXM1, TAXM2, TAXM3, TAXM4, TAXM5, TAXM6, TAXM7, TAXM8, TAXM9, KOWRR, PRSFD, SKTOF, SKFBP, KONDM, KTGRM, KOSTL, BONUS, PROVG, EANNR, VKGRP, VKBUR, SPARA, SHKZG, ERNAM, ERDAT, ERZET, BWTAR, LGORT, STAFO, WAVWR, KZWI1, KZWI2, KZWI3, KZWI4, KZWI5, KZWI6, STCUR, UVPRS, UVALL, EAN11, PRCTR, KVGR1, KVGR2, KVGR3, KVGR4, KVGR5, MVGR1, MVGR2, MVGR3, MVGR4, MVGR5, MATWA, BONBA, KOKRS, PAOBJNR, PS_PSP_PNR, AUFNR, TXJCD, CMPRE, CMPNT, CUOBJ, CUOBJ_CH, KOUPD, UECHA, XCHAR, ABRVW, SERNR, BZIRK_AUFT, KDGRP_AUFT, KONDA_AUFT, LLAND_AUFT, MPROK, PLTYP_AUFT, REGIO_AUFT, VKORG_AUFT, VTWEG_AUFT, ABRBG, PROSA, UEPVW, AUTYP, STADAT, FPLNR, FPLTR, AKTNR, KNUMA_PI, KNUMA_AG, PREFE, MWSBP, AUGRU_AUFT, FAREG, UPMAT, UKONM, CMPRE_FLT, ABFOR, ABGES, J_1ARFZ, J_1AREGIO, J_1AGICD, J_1ADTYP, J_1ATXREL, J_1BCFOP, J_1BTAXLW1, J_1BTAXLW2, J_1BTXSDC, BRTWR, WKTNR, WKTPS, RPLNR, KURSK_DAT, WGRU1, WGRU2, KDKG1, KDKG2, KDKG3, KDKG4, KDKG5, VKAUS, J_1AINDXP, J_1AIDATEP, KZFME, MWSKZ, VERTT, VERTN, SGTXT, DELCO, BEMOT, RRREL, AKKUR, WMINR, VGBEL_EX, VGPOS_EX, LOGSYS, VGTYP_EX, J_1BTAXLW3, J_1BTAXLW4, J_1BTAXLW5, MSR_ID, MSR_REFUND_CODE, MSR_RET_REASON, NRAB_KNUMH, NRAB_VALUE, DISPUTE_CASE, FUND_USAGE_ITEM, FARR_RELTYPE, CLAIMS_TAXATION, KURRF_DAT_ORIG, VGTYP_EXT, SGT_RCAT, SGT_SCAT, Z_PRS_OFFSHORE, Z_PRS_BILL_FLAG, Z_PRS_COUNTRY, Z_PRS_CHARGELEVL, AUFPL, APLZL, DPCNR, DCPNR, DPNRB, PEROP_BEG, PEROP_END, FMFGUS_KEY, FONDS, FISTL, FKBER, GRANT_NBR, BUDGET_PD, PRS_WORK_PERIOD, PPRCTR, PARGB, AUFPL_OAA, APLZL_OAA, CAMPAIGN, COMPREAS, WRF_CHARSTC1, WRF_CHARSTC2, WRF_CHARSTC3, YYCALLID FROM VBRP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNBilling Documentnvarchar100CHAR(N' ')NoVBUKVBELN_VF Allow NULL? 
3POSNRBilling itemnvarchar60NUMC(N'000000')NoVBUPPOSNR_VF Allow NULL? 
4UEPOSHigher-level item in bill of material structuresnvarchar60NUMC(N'000000')YesVBUPUEPOS Allow NULL? 
5FKIMGActual Invoiced Quantitydecimal133QUAN((0))YesFKIMG
6VRKMESales unitnvarchar30UNIT(N' ')YesT006VRKME Allow NULL? 
7UMVKZNumerator (factor) for conversion of sales quantity into SKUdecimal50DEC((0))YesUMVKZ
8UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKUdecimal50DEC((0))YesUMVKN
9MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
10SMENGScale quantity in base unit of measuredecimal133QUAN((0))YesSMENG
11FKLMGBilling quantity in stockkeeping unitdecimal133QUAN((0))YesFKLMG
12LMENGRequired quantity for mat.management in stockkeeping unitsdecimal133QUAN((0))YesLMENG
13NTGEWNet weightdecimal153QUAN((0))YesNTGEW_15
14BRGEWGross weightdecimal153QUAN((0))YesBRGEW_15
15GEWEIWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
16VOLUMVolumedecimal153QUAN((0))YesVOLUM_15
17VOLEHVolume unitnvarchar30UNIT(N' ')YesT006VOLEH Allow NULL? 
18GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
19PRSDTDate for pricing and exchange ratenvarchar80DATS(N'00000000')YesPRSDT Allow NULL? 
20FBUDADate on which services renderednvarchar80DATS(N'00000000')YesFBUDA Allow NULL? 
21KURSKExchange Rate for Price Determinationdecimal95DEC((0))YesKURSK
22NETWRNet value of the billing item in document currencydecimal152CURR((0))YesNETWR_FP
23VBELVOriginating documentnvarchar100CHAR(N' ')YesVBUKVBELV Allow NULL? 
24POSNVOriginating itemnvarchar60NUMC(N'000000')YesVBUPPOSNV Allow NULL? 
25VGBELDocument number of the reference documentnvarchar100CHAR(N' ')YesVBUKVGBEL Allow NULL? 
26VGPOSItem number of the reference itemnvarchar60NUMC(N'000000')YesVBUPVGPOS Allow NULL? 
27VGTYPDocument category of preceding SD documentchar10CHAR(N' ')YesVBTYP_V Allow NULL? 
28AUBELSales Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VA Allow NULL? 
29AUPOSSales Document Itemnvarchar60NUMC(N'000000')YesVBUPPOSNR_VA Allow NULL? 
30AUREFSales document was created from referencechar10CHAR(N' ')YesAUREF Allow NULL? 
31MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
32ARKTXShort text for sales order itemnvarchar400CHAR(N' ')YesARKTX Allow NULL? 
33PMATNPricing Reference Materialnvarchar180CHAR(N' ')YesMARAPMATN Allow NULL? 
34CHARGBatch Numbernvarchar100CHAR(N' ')YesMCHACHARG_D Allow NULL? 
35MATKLMaterial Groupnvarchar90CHAR(N' ')YesT023MATKL Allow NULL? 
36PSTYVSales document item categorynvarchar40CHAR(N' ')Yes*PSTYV Allow NULL? 
37POSARItem typechar10CHAR(N' ')YesPOSAR Allow NULL? 
38PRODHProduct hierarchynvarchar180CHAR(N' ')YesT179PRODH_D Allow NULL? 
39VSTELShipping Point/Receiving Pointnvarchar40CHAR(N' ')YesTVSTVSTEL Allow NULL? 
40ATPKZReplacement partchar10CHAR(N' ')YesATPKZ Allow NULL? 
41SPARTDivisionnvarchar20CHAR(N' ')YesTSPASPART Allow NULL? 
42POSPAItem number in the partner segmentnvarchar60NUMC(N'000000')YesVBUPPOSPA Allow NULL? 
43WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
44ALANDDeparture country (country from which the goods are sent)nvarchar30CHAR(N' ')YesT005ALAND Allow NULL? 
45WKREGRegion in which plant is locatednvarchar30CHAR(N' ')YesT005SWKREG Allow NULL? 
46WKCOUCounty in which plant is locatednvarchar30CHAR(N' ')YesWKCOU Allow NULL? 
47WKCTYCity in which plant is locatednvarchar40CHAR(N' ')YesWKCTY Allow NULL? 
48TAXM1Tax classification materialchar10CHAR(N' ')Yes*TAXM1 Allow NULL? 
49TAXM2Tax classification 2 for materialchar10CHAR(N' ')Yes*TAXM2 Allow NULL? 
50TAXM3Tax classification 3 for materialchar10CHAR(N' ')Yes*TAXM3 Allow NULL? 
51TAXM4Tax Classification 4 Materialchar10CHAR(N' ')Yes*TAXM4 Allow NULL? 
52TAXM5Tax classification 5 for materialchar10CHAR(N' ')Yes*TAXM5 Allow NULL? 
53TAXM6Tax classification 6 for materialchar10CHAR(N' ')Yes*TAXM6 Allow NULL? 
54TAXM7Tax classification 7 for materialchar10CHAR(N' ')Yes*TAXM7 Allow NULL? 
55TAXM8Tax Classification 8 Materialchar10CHAR(N' ')Yes*TAXM8 Allow NULL? 
56TAXM9Tax Classification 9 Materialchar10CHAR(N' ')Yes*TAXM9 Allow NULL? 
57KOWRRStatistical valueschar10CHAR(N' ')YesKOWRR Allow NULL? 
58PRSFDCarry out pricingchar10CHAR(N' ')YesPRSFD Allow NULL? 
59SKTOFCash discount indicatorchar10CHAR(N' ')YesSKTOF Allow NULL? 
60SKFBPAmount eligible for cash discount in document currencydecimal132CURR((0))YesSKFBP
61KONDMMaterial Pricing Groupnvarchar20CHAR(N' ')YesT178KONDM Allow NULL? 
62KTGRMAccount assignment group for this materialnvarchar20CHAR(N' ')YesTVKMKTGRM Allow NULL? 
63KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
64BONUSVolume rebate groupnvarchar20CHAR(N' ')YesTVBOBONUS Allow NULL? 
65PROVGCommission groupnvarchar20CHAR(N' ')YesTVPRPROVG Allow NULL? 
66EANNREuropean Article Number (EAN) - obsolete!!!!!nvarchar130CHAR(N' ')YesEANNR Allow NULL? 
67VKGRPSales Groupnvarchar30CHAR(N' ')YesTVKGRVKGRP Allow NULL? 
68VKBURSales Officenvarchar40CHAR(N' ')YesTVBURVKBUR Allow NULL? 
69SPARADivision for order headernvarchar20CHAR(N' ')YesTSPASPART_AK Allow NULL? 
70SHKZGReturns itemchar10CHAR(N' ')YesSHKZG_VF Allow NULL? 
71ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
72ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
73ERZETEntry timenvarchar60TIMS(N'000000')YesERZET Allow NULL? 
74BWTARValuation Typenvarchar100CHAR(N' ')YesT149DBWTAR_D Allow NULL? 
75LGORTStorage Locationnvarchar40CHAR(N' ')YesT001LLGORT_D Allow NULL? 
76STAFOUpdate group for statistics updatenvarchar60CHAR(N' ')Yes*STAFO Allow NULL? 
77WAVWRCost in document currencydecimal132CURR((0))YesWAVWR
78KZWI1Subtotal 1 from pricing procedure for conditiondecimal132CURR((0))YesKZWI1
79KZWI2Subtotal 2 from pricing procedure for conditiondecimal132CURR((0))YesKZWI2
80KZWI3Subtotal 3 from pricing procedure for conditiondecimal132CURR((0))YesKZWI3
81KZWI4Subtotal 4 from pricing procedure for conditiondecimal132CURR((0))YesKZWI4
82KZWI5Subtotal 5 from pricing procedure for conditiondecimal132CURR((0))YesKZWI5
83KZWI6Subtotal 6 from pricing procedure for conditiondecimal132CURR((0))YesKZWI6
84STCURExchange rate for statistics (Exch.rate at time of creation)decimal95DEC((0))YesSTCUR_AP
85UVPRSIncomplete with respect to pricingchar10CHAR(N' ')YesUVPRS Allow NULL? 
86UVALLGenerally incompletechar10CHAR(N' ')YesUVALL Allow NULL? 
87EAN11International Article Number (EAN/UPC)nvarchar180CHAR(N' ')YesEAN11 Allow NULL? 
88PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
89KVGR1Customer group 1nvarchar30CHAR(N' ')YesTVV1KVGR1 Allow NULL? 
90KVGR2Customer group 2nvarchar30CHAR(N' ')YesTVV2KVGR2 Allow NULL? 
91KVGR3Customer group 3nvarchar30CHAR(N' ')YesTVV3KVGR3 Allow NULL? 
92KVGR4Customer group 4nvarchar30CHAR(N' ')YesTVV4KVGR4 Allow NULL? 
93KVGR5Customer group 5nvarchar30CHAR(N' ')YesTVV5KVGR5 Allow NULL? 
94MVGR1Material group 1nvarchar30CHAR(N' ')YesTVM1MVGR1 Allow NULL? 
95MVGR2Material group 2nvarchar30CHAR(N' ')YesTVM2MVGR2 Allow NULL? 
96MVGR3Material group 3nvarchar30CHAR(N' ')YesTVM3MVGR3 Allow NULL? 
97MVGR4Material group 4nvarchar30CHAR(N' ')YesTVM4MVGR4 Allow NULL? 
98MVGR5Material group 5nvarchar30CHAR(N' ')YesTVM5MVGR5 Allow NULL? 
99MATWAMaterial enterednvarchar180CHAR(N' ')YesMARAMATWA Allow NULL? 
100BONBARebate basis 1decimal132CURR((0))YesBONBA
101KOKRSControlling Areanvarchar40CHAR(N' ')YesTKA01KOKRS Allow NULL? 
102PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
103PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
104AUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
105TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
106CMPREItem credit pricedecimal112CURR((0))YesCMPRE
107CMPNTID: Item with active credit function / relevant for creditchar10CHAR(N' ')YesCMPNT Allow NULL? 
108CUOBJConfigurationnvarchar180NUMC(N'000000000000000000')YesCUOBJ_VA Allow NULL? 
109CUOBJ_CHInternal object number of the batch classificationnvarchar180NUMC(N'000000000000000000')YesCUOBJ_CH Allow NULL? 
110KOUPDCondition updatechar10CHAR(N' ')YesKOUPD Allow NULL? 
111UECHAHigher-Level Item of Batch Split Itemnvarchar60NUMC(N'000000')Yes*UECHA Allow NULL? 
112XCHARBatch management indicator (internal)char10CHAR(N' ')YesXCHAR Allow NULL? 
113ABRVWUsage Indicatornvarchar30CHAR(N' ')YesTVLVABRVW Allow NULL? 
114SERNRBOM explosion numbernvarchar80CHAR(N' ')YesSNUMSERNR Allow NULL? 
115BZIRK_AUFTSales district of sales ordernvarchar60CHAR(N' ')YesT171BZIRK_AUFT Allow NULL? 
116KDGRP_AUFTCustomer group of sales ordernvarchar20CHAR(N' ')YesT151KDGRP_AUFT Allow NULL? 
117KONDA_AUFTPrice group of sales ordernvarchar20CHAR(N' ')YesT188KONDA_AUFT Allow NULL? 
118LLAND_AUFTCountry of destination of sales ordernvarchar30CHAR(N' ')YesT005LLAND_AUFT Allow NULL? 
119MPROKStatus manual price changechar10CHAR(N' ')YesMPROK Allow NULL? 
120PLTYP_AUFTPrice list type of sales ordernvarchar20CHAR(N' ')YesT189PLTYP_AUFT Allow NULL? 
121REGIO_AUFTRegion of sales ordernvarchar30CHAR(N' ')YesT005SREGIO_AUFT Allow NULL? 
122VKORG_AUFTSales organization of sales ordernvarchar40CHAR(N' ')YesTVKOVKORG_AUFT Allow NULL? 
123VTWEG_AUFTDistribution channel of sales ordernvarchar20CHAR(N' ')YesTVTWVTWEG_AUFT Allow NULL? 
124ABRBGStart of accounting settlement periodnvarchar80DATS(N'00000000')YesABRBG Allow NULL? 
125PROSAID for material determinationchar10CHAR(N' ')YesPROSA Allow NULL? 
126UEPVWID for higher-level item usagechar10CHAR(N' ')YesUEPVW Allow NULL? 
127AUTYPSD document categorychar10CHAR(N' ')YesVBTYP Allow NULL? 
128STADATStatistics datenvarchar80DATS(N'00000000')YesSTADAT Allow NULL? 
129FPLNRBilling plan number / invoicing plan numbernvarchar100CHAR(N' ')YesFPLAFPLNR Allow NULL? 
130FPLTRItem for billing plan/invoice plan/payment cardsnvarchar60NUMC(N'000000')Yes*FPLTR Allow NULL? 
131AKTNRPromotionnvarchar100CHAR(N' ')YesWAKHWAKTION Allow NULL? 
132KNUMA_PIPromotionnvarchar100CHAR(N' ')YesKONAKNUMA_PI Allow NULL? 
133KNUMA_AGSales dealnvarchar100CHAR(N' ')YesKONAKNUMA_AG Allow NULL? 
134PREFEPreference indicator in export/importchar10CHAR(N' ')YesPREFE Allow NULL? 
135MWSBPTax amount in document currencydecimal132CURR((0))YesMWSBP
136AUGRU_AUFTOrder reason (reason for the business transaction)nvarchar30CHAR(N' ')YesTVAUAUGRU Allow NULL? 
137FAREGRule in billing plan/invoice planchar10CHAR(N' ')YesFAREG Allow NULL? 
138UPMATPricing reference material of main itemnvarchar180CHAR(N' ')YesMARAUPMAT Allow NULL? 
139UKONMMaterial pricing group of main itemnvarchar20CHAR(N' ')YesT178UKONM Allow NULL? 
140CMPRE_FLTItem credit pricefloat1516FLTP((0))YesCMPRE_FLT
141ABFORForm of payment guaranteenvarchar20CHAR(N' ')YesT691KABSFORM_CM Allow NULL? 
142ABGESGuaranteed (factor between 0 and 1)float1516FLTP((0))YesABGES_CM
143J_1ARFZReason for zero VATchar10CHAR(N' ')YesJ_1ARFZJ_1ARFZVAT Allow NULL? 
144J_1AREGIORegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
145J_1AGICDActivity Code for Gross Income Taxnvarchar20CHAR(N' ')YesJ_1AGICDJ_1AGICD_D Allow NULL? 
146J_1ADTYPDistribution Type for Employment Taxnvarchar20CHAR(N' ')YesJ_1ADTYPJ_1ADTYP_D Allow NULL? 
147J_1ATXRELTax relevant classificationnvarchar100CHAR(N' ')YesJ_1ATXRELJ_1ATXREL_ Allow NULL? 
148J_1BCFOPCFOP Code and Extensionnvarchar100CHAR(N' ')YesJ_1BAGJ_1BCFOP Allow NULL? 
149J_1BTAXLW1Tax law: ICMSnvarchar30CHAR(N' ')YesJ_1BATL1J_1BTAXLW1 Allow NULL? 
150J_1BTAXLW2Tax law: IPInvarchar30CHAR(N' ')YesJ_1BATL2J_1BTAXLW2 Allow NULL? 
151J_1BTXSDCSD tax codenvarchar20CHAR(N' ')YesJ_1BTXSDCJ_1BTXSDC_ Allow NULL? 
152BRTWRGross value of the billing item in document currencydecimal152CURR((0))YesBRTWR_FP
153WKTNRValue contract no.nvarchar100CHAR(N' ')YesVBUKWKTNR Allow NULL? 
154WKTPSValue contract itemnvarchar60NUMC(N'000000')YesVBUPWKTPS Allow NULL? 
155RPLNRPayment card plan number of sales documentnvarchar100CHAR(N' ')YesFPLARPLNR_AU Allow NULL? 
156KURSK_DATTranslation Datenvarchar80DATS(N'00000000')YesWWERT_D Allow NULL? 
157WGRU1Material group hierarchy 1nvarchar180CHAR(N' ')YesWGRU_HIE1 Allow NULL? 
158WGRU2Material group hierarchy 2nvarchar180CHAR(N' ')YesWGRU_HIE2 Allow NULL? 
159KDKG1Customer condition group 1nvarchar20CHAR(N' ')YesTVKGGKDKG1 Allow NULL? 
160KDKG2Customer condition group 2nvarchar20CHAR(N' ')YesTVKGGKDKG2 Allow NULL? 
161KDKG3Customer condition group 3nvarchar20CHAR(N' ')YesTVKGGKDKG3 Allow NULL? 
162KDKG4Customer condition group 4nvarchar20CHAR(N' ')YesTVKGGKDKG4 Allow NULL? 
163KDKG5Customer condition group 5nvarchar20CHAR(N' ')YesTVKGGKDKG5 Allow NULL? 
164VKAUSUsage Indicatornvarchar30CHAR(N' ')YesTVLVABRVW Allow NULL? 
165J_1AINDXPInflation Indexnvarchar50CHAR(N' ')YesJ_1AINFT20J_1AINDXP Allow NULL? 
166J_1AIDATEPIndexing base datenvarchar80DATS(N'00000000')YesJ_1AIDATES Allow NULL? 
167KZFMEID: Leading unit of measure for completing a transactionchar10CHAR(N' ')YesKZFME Allow NULL? 
168MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
169VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
170VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
171SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
172DELCOAgreed delivery timenvarchar30CHAR(N' ')YesDELCO Allow NULL? 
173BEMOTAccounting Indicatornvarchar20CHAR(N' ')YesTBMOTBEMOT Allow NULL? 
174RRRELRevenue recognition categorychar10CHAR(N' ')YesRR_RELTYP Allow NULL? 
175AKKURExchange rate for letter-of-credit procg in foreign tradedecimal95DEC((0))YesAKKUR
176WMINRProduct catalog numbernvarchar100CHAR(N' ')YesWWMIWMINR Allow NULL? 
177VGBEL_EXDocument number of the reference documentnvarchar100CHAR(N' ')Yes*VGBEL Allow NULL? 
178VGPOS_EXItem number of the reference itemnvarchar60NUMC(N'000000')Yes*VGPOS Allow NULL? 
179LOGSYSLogical systemnvarchar100CHAR(N' ')Yes*LOGSYS Allow NULL? 
180VGTYP_EXCategory of an external transaction or elementnvarchar30CHAR(N' ')YesVGTYP_EX Allow NULL? 
181J_1BTAXLW3ISS Tax Lawnvarchar30CHAR(N' ')YesJ_1BATL3J_1BTAXLW3 Allow NULL? 
182J_1BTAXLW4COFINS Tax Lawnvarchar30CHAR(N' ')YesJ_1BATL4AJ_1BTAXLW4 Allow NULL? 
183J_1BTAXLW5PIS Tax Lawnvarchar30CHAR(N' ')YesJ_1BATL5J_1BTAXLW5 Allow NULL? 
184MSR_IDProcess Identification Numbernvarchar100CHAR(N' ')YesMSR_PROCESS_ID Allow NULL? 
185MSR_REFUND_CODEReturns Refund Codenvarchar30CHAR(N' ')YesMSR_C_RET_REFUNDMSR_RETURNS_REFUND_CODE Allow NULL? 
186MSR_RET_REASONReturn Reasonnvarchar30CHAR(N' ')YesMSR_C_RET_REASONMSR_RETURNS_REASON Allow NULL? 
187NRAB_KNUMHCondition record numbernvarchar100CHAR(N' ')YesKNUMH Allow NULL? 
188NRAB_VALUECondition valuedecimal132CURR((0))YesKWERT
189DISPUTE_CASEDispute Casevarbinary160RAWYesDISPUTE_CASE
190FUND_USAGE_ITEMFund Usage Itemvarbinary160RAWYesFUND_USAGE_ITEM
191FARR_RELTYPERevenue Accounting Typenvarchar100CHAR(N' ')YesFARR_RELTYPE Allow NULL? 
192CLAIMS_TAXATIONClaims Taxationchar10CHAR(N' ')YesCLAIMS_TAXATION Allow NULL? 
193KURRF_DAT_ORIGTranslation Datenvarchar80DATS(N'00000000')YesWWERT_D Allow NULL? 
194VGTYP_EXTExtension of SD document category of preceding documentnvarchar40CHAR(N' ')YesTDD_VBTYP_EXT_V Allow NULL? 
195SGT_RCATRequirement Segmentnvarchar160CHAR(N' ')YesSGT_RCAT Allow NULL? 
196SGT_SCATStock Segmentnvarchar160CHAR(N' ')YesSGT_SCAT Allow NULL? 
197Z_PRS_OFFSHOREProfessional Services: Delivery Typechar10CHAR(N' ')YesZ_PRS_OFFSHORE Allow NULL? 
198Z_PRS_BILL_FLAGProfessional Services: Billable/Non-Billablechar10CHAR(N' ')YesZ_PRS_BILLABLE_FLAG Allow NULL? 
199Z_PRS_COUNTRYCountry Keynvarchar30CHAR(N' ')Yes*LAND1 Allow NULL? 
200Z_PRS_CHARGELEVLProfessional Services: Charge Levelnvarchar20CHAR(N' ')YesZ_PRS_CHARGELEVEL Allow NULL? 
201AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
202APLZLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
203DPCNRDown Payment Chain Numbernvarchar100CHAR(N' ')Yes/SAPPCE/DPCNR Allow NULL? 
204DCPNRTransaction Numbernvarchar30NUMC(N'000')Yes/SAPPCE/DPCPNR Allow NULL? 
205DPNRBSequence Number of Accounting Document in Transactionnvarchar30NUMC(N'000')Yes/SAPPCE/DPCPNRB Allow NULL? 
206PEROP_BEGPeriod of Performance Start Datenvarchar80DATS(N'00000000')YesFM_PEROP_SD_LOW Allow NULL? 
207PEROP_ENDPeriod of Performance End Datenvarchar80DATS(N'00000000')YesFM_PEROP_SD_HIGH Allow NULL? 
208FMFGUS_KEYUnited States Federal Government Fieldsnvarchar220CHAR(N' ')YesFMFG_US_KEY Allow NULL? 
209FONDSFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
210FISTLFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
211FKBERFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
212GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
213BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
214PRS_WORK_PERIODWork Period (Internal Representation)nvarchar70NUMC(N'0000000')YesPRS_WORK_PERIOD Allow NULL? 
215PPRCTRPartner Profit Centernvarchar100CHAR(N' ')Yes*PPRCTR Allow NULL? 
216PARGBTrading partner's business areanvarchar40CHAR(N' ')Yes*PARGB Allow NULL? 
217AUFPL_OAARouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
218APLZL_OAAInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
219CAMPAIGNGeneric project planning: GUID from external R/3 systemvarbinary160RAWYesCGPL_GUID16_R3
220COMPREASAbbreviation for Complaints Reasonnvarchar40CHAR(N' ')YesCMP_COMPREAS_COPY Allow NULL? 
221WRF_CHARSTC1Characteristic Value 1nvarchar180CHAR(N' ')YesWRF_CHARSTC1 Allow NULL? 
222WRF_CHARSTC2Characteristic Value 2nvarchar180CHAR(N' ')YesWRF_CHARSTC2 Allow NULL? 
223WRF_CHARSTC3Characteristic Value 3nvarchar180CHAR(N' ')YesWRF_CHARSTC3 Allow NULL? 
224YYCALLIDCall Center IDnvarchar30CHAR(N' ')Yes*YCALLID Allow NULL? 
NamePrimaryUniqueTypeColumns
VBRP~0YesYesCLUSTEREDMANDT, VBELN, POSNR