S262BIW1 SAP (SD - Billing document) Table details

Dictionary Type: Table
Description: SD - Billing document




ABAP Code to SELECT data from S262BIW1
Related tables to S262BIW1
Access table S262BIW1




Table field list including key, data, relationships and ABAP select examples

S262BIW1 is a standard SAP Table which is used to store SD - Billing document data and is available within R/3 SAP systems depending on the version and release level.

The S262BIW1 table consists of various fields, each holding specific information or linking keys about SD - Billing document data available in SAP. These include SPTAG (Period to analyze - current date), VBELN (Billing Document), POSNR (Billing item), VRSIO (Version number in the information structure).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP S262BIW1 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
VBELNBilling Document VBELN_VFCHAR10VBUKALPHAVBELNVF
POSNRBilling item POSNR_VFNUMC6VBUPPOSNR
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
SSOURStatistic(s) origin SSOURCHAR4SSOUR
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
WAERKSD Document Currency WAERKCUKY5TCURCWAERSFWS
STWAEStatistics currency STWAECUKY5Assigned to domainWAERS
HWAERLocal Currency HWAERCUKY5Assigned to domainWAERS
KURRFExchange rate for FI postings KURRFDEC9(5) KURRF
FKARTBilling Type FKARTCHAR4Assigned to domainFKART
FKTYPBilling category FKTYPCHAR1FKTYP
VBTYPSD document category VBTYPCHAR1VBTYP
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
KUNRGPayer KUNRGCHAR10Assigned to domainALPHAKUNNR
KUNAGSold-to party KUNAGCHAR10KNA1ALPHAKUNNRVAG
KDGRPCustomer group KDGRPCHAR2Assigned to domainKDGRPVKD
BZIRKSales district BZIRKCHAR6Assigned to domainBZIRKBZI
FKDATBilling date for billing index and printout FKDATDATS8DATUM
UMVKZNumerator (factor) for conversion of sales quantity into SKU UMVKZDEC5UMBSZ
UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKU UMVKNDEC5UMBSN
KURSKExchange Rate for Price Determination KURSKDEC9(5) EXCRTKURRF
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
VRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
VOLEHVolume unit VOLEHUNIT3Assigned to domainCUNITMEINS
GEWEIWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
ERDATDate on Which Record Was Created ERDATDATS8DATUM
AEDATChanged On AEDATDATS8DATUM
STADATStatistics date STADATDATS8DATUM
PRSDTDate for pricing and exchange rate PRSDTDATS8DATUM
FBUDADate on which services rendered FBUDADATS8DATUM
PSTYVSales document item category PSTYVCHAR4Assigned to domainPSTYV
POSARItem type POSARCHAR1POSAR
PRODHProduct hierarchy PRODH_DCHAR18Assigned to domainPRODHVPR
VSTELShipping Point/Receiving Point VSTELCHAR4Assigned to domainVSTELVST
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
BONUSVolume rebate group BONUSCHAR2Assigned to domainBONUS
PROVGCommission group PROVGCHAR2Assigned to domainPROVG
VKGRPSales Group VKGRPCHAR3Assigned to domainVKGRPVKG
VKBURSales Office VKBURCHAR4Assigned to domainVKBURVKB
SPARADivision for order header SPART_AKCHAR2Assigned to domainSPARTSPA
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
KVGR1Customer group 1 KVGR1CHAR3Assigned to domainKVGR1
KVGR2Customer group 2 KVGR2CHAR3Assigned to domainKVGR2
KVGR3Customer group 3 KVGR3CHAR3Assigned to domainKVGR3
KVGR4Customer group 4 KVGR4CHAR3Assigned to domainKVGR4
KVGR5Customer group 5 KVGR5CHAR3Assigned to domainKVGR5
MVGR1Material group 1 MVGR1CHAR3Assigned to domainMVGR1
MVGR2Material group 2 MVGR2CHAR3Assigned to domainMVGR2
MVGR3Material group 3 MVGR3CHAR3Assigned to domainMVGR3
MVGR4Material group 4 MVGR4CHAR3Assigned to domainMVGR4
MVGR5Material group 5 MVGR5CHAR3Assigned to domainMVGR5
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
PKUNWEShip-to party KUNWECHAR10Assigned to domainALPHAKUNNR
PKUNREBill-to party KUNRECHAR10Assigned to domainALPHAKUNNRKUN
PSPDNRForwarding agent SPDNRCHAR10Assigned to domainALPHALIFNR
PVRTNRSales employee VRTNRNUMC8PERNRPREMV
AUBELSales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
AUPOSSales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
VGBELDocument number of the reference document VGBELCHAR10Assigned to domainALPHAVBELN
VGPOSItem number of the reference item VGPOSNUMC6Assigned to domainPOSNR
.INCLU--AP 0
STCURExchange rate for statistics (Exch.rate at time of creation) STCUR_APDEC9(5) KURRF
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERZETEntry time ERZETTIMS6UZEIT
PS_POSIDWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
FKIMGActual Invoiced Quantity FKIMGQUAN13(3) MENG13
SMENGScale quantity in base unit of measure SMENGQUAN13(3) MENG13
FKLMGBilling quantity in stockkeeping unit FKLMGQUAN13(3) MENG13
LMENGRequired quantity for mat.management in stockkeeping units LMENGQUAN13(3) MENG13
NTGEWNet weight NTGEW_15QUAN15(3) MENG15
BRGEWGross weight BRGEW_15QUAN15(3) MENG15
VOLUMVolume VOLUM_15QUAN15(3) MENG15
NETWRNet value of the billing item in document currency NETWR_FPCURR15(2) WERTV8
SKFBPAmount eligible for cash discount in document currency SKFBPCURR13(2) WERTV7
WAVWRCost in document currency WAVWRCURR13(2) WERTV7
KZWI1Subtotal 1 from pricing procedure for condition KZWI1CURR13(2) WERTV7
KZWI2Subtotal 2 from pricing procedure for condition KZWI2CURR13(2) WERTV7
KZWI3Subtotal 3 from pricing procedure for condition KZWI3CURR13(2) WERTV7
KZWI4Subtotal 4 from pricing procedure for condition KZWI4CURR13(2) WERTV7
KZWI5Subtotal 5 from pricing procedure for condition KZWI5CURR13(2) WERTV7
KZWI6Subtotal 6 from pricing procedure for condition KZWI6CURR13(2) WERTV7
BONBARebate basis 1 BONBACURR13(2) WERTV7
MWSBPTax amount in document currency MWSBPCURR13(2) WERTV7
.INCLU--AP 0
ANZFKNo.of billing docs MC_ANZFKDEC9MCZAEHLER
ANZFKPOSNumber of billing items MC_ANZFKPODEC9MCZAEHLER

Key field Non-key field



How do I retrieve data from SAP table S262BIW1 using ABAP code

The following ABAP code Example will allow you to do a basic selection on S262BIW1 to SELECT all data from the table
DATA: WA_S262BIW1 TYPE S262BIW1.

SELECT SINGLE *
FROM S262BIW1
INTO CORRESPONDING FIELDS OF WA_S262BIW1
WHERE...

How to access SAP table S262BIW1

Within an ECC or HANA version of SAP you can also view further information about S262BIW1 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!