S261BIW1 SAP (SD - Delivery note) Table details

Dictionary Type: Table
Description: SD - Delivery note




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




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

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

The S261BIW1 table consists of various fields, each holding specific information or linking keys about SD - Delivery note data available in SAP. These include SPTAG (Period to analyze - current date), VBELN (Delivery), POSNR (Delivery Item), ETENR (Delivery Schedule Line Number).. 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 S261BIW1 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
VBELNDelivery VBELN_VLCHAR10VBUKALPHAVBELNVL
POSNRDelivery Item POSNR_VLNUMC6VBUPPOSNR
ETENRDelivery Schedule Line Number ETENRNUMC4VBEPETENR
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
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
VSTELShipping Point/Receiving Point VSTELCHAR4TVSTVSTELVST
ROUTERoute ROUTECHAR6Assigned to domainROUTE
PSPDNRForwarding agent SPDNRCHAR10Assigned to domainALPHALIFNR
PKUNREBill-to party KUNRECHAR10Assigned to domainALPHAKUNNRKUN
PKUNRGPayer KUNRGCHAR10Assigned to domainALPHAKUNNR
PVRTNRSales employee VRTNRNUMC8PERNRPREMV
KDGRPCustomer group KDGRPCHAR2Assigned to domainKDGRPVKD
BZIRKSales district BZIRKCHAR6Assigned to domainBZIRKBZI
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
SPARADivision for order header SPART_AKCHAR2Assigned to domainSPARTSPA
LFARTDelivery Type LFARTCHAR4Assigned to domainLFARTALT
FAKSKBilling block in SD document FAKSKCHAR2Assigned to domainFAKSP
LIFSKDelivery block (document header) LIFSKCHAR2Assigned to domainLIFSP
ABLADUnloading Point ABLADCHAR25TEXT25
INCO1Incoterms (Part 1) INCO1CHAR3Assigned to domainINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
KUNNRShip-to party KUNWECHAR10Assigned to domainALPHAKUNNR
KUNAGSold-to party KUNAGCHAR10Assigned to domainALPHAKUNNRVAG
LSTELLoading Point LSTELCHAR2Assigned to domainLSTEL
WADAT_ISTActual Goods Movement Date WADAT_ISTDATS8DATUMWDTI
.INCLU--AP 0
LFDATDelivery Date LFDAT_VDATS8DATUM
VBTYPSD document category VBTYPCHAR1VBTYP
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
VRKMESales unit VRKMEUNIT3T006CUNITMEINS
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
GEWEIWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
VOLEHVolume unit VOLEHUNIT3Assigned to domainCUNITMEINS
ERDATDate on Which Record Was Created ERDATDATS8DATUM
AEDATChanged On AEDATDATS8DATUM
STADATStatistics date STADATDATS8DATUM
UMVKZNumerator (factor) for conversion of sales quantity into SKU UMVKZDEC5UMBSZ
UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKU UMVKNDEC5UMBSN
PSTYVSales document item category PSTYVCHAR4Assigned to domainPSTYV
VGTYPActivity or element category VGTYPCHAR3VORG_TYP
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
PRODHProduct hierarchy PRODH_DCHAR18Assigned to domainPRODHVPR
FAKSPBlock FAKSPCHAR2Assigned to domainFAKSP
VGBELDocument number of the reference document VGBELCHAR10Assigned to domainALPHAVBELN
VGPOSItem number of the reference item VGPOSNUMC6Assigned to domainPOSNR
KOMKZIndicator for picking control KOMKZCHAR1KOMKZ
LGNUMWarehouse Number / Warehouse Complex LGNUMCHAR3Assigned to domainLGNUMLGN
LGTYPStorage Type LGTYPCHAR3Assigned to domainLGTYPLGTH_T301
LGPLAStorage Bin LGPLACHAR10Assigned to domainLGPLALGPLAG1
POSARItem type POSARCHAR1POSAR
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
VKBURSales Office VKBURCHAR4Assigned to domainVKBURVKB
VKGRPSales Group VKGRPCHAR3Assigned to domainVKGRPVKG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
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
WBSTAGoods movement status WBSTACHAR1STATV
KOSTAPicking status/Putaway status KOSTACHAR1STATV
KOQUAConfirmation status of picking/putaway KOQUACHAR1STATV
.INCLU--AP 0
APERDATCreation Date of Order Item MC_APERDATDATS8DATUM
KZVBRConsumption Posting KZVBRCHAR1KZVBR
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERZETEntry time ERZETTIMS6UZEIT
PS_POSIDWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
LFIMGActual quantity delivered (in sales units) LFIMGQUAN13(3) MENG13
NTGEWNet weight NTGEW_15QUAN15(3) MENG15
BRGEWGross weight BRGEW_15QUAN15(3) MENG15
VOLUMVolume VOLUM_15QUAN15(3) MENG15
LGMNGActual quantity delivered in stockkeeping units LGMNGQUAN13(3) MENG13
.INCLU--AP 0
ANZLINo. of deliveries MC_ANZLIDEC9MCZAEHLER
ANZLIPOSNumber of delivery items MC_ANZLIPODEC9MCZAEHLER
ETTYPSchedule line category ETTYPCHAR2Assigned to domainETTYP
LIFSPSchedule line blocked for delivery LIFSP_EPCHAR2Assigned to domainLIFSP
LDDATLoading Date LDDATDATS8DATUM
TDDATTransportation Planning Date TDDAT_DDATS8DATUM
EDATUSchedule line date EDATUDATS8DATUM
WADATGoods Issue Date WADATDATS8DATUM
MBDATMaterial Staging/Availability Date MBDATDATS8DATUM
WLDATBEDesired del. date in confirmed schedule lines WLDATBEDATS8DATUM
VSMNG_LDelivered quantity per schedule line and delivery item MC_VSMNG_LQUAN15(3) MENGV15_3

Key field Non-key field



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

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

SELECT SINGLE *
FROM S261BIW1
INTO CORRESPONDING FIELDS OF WA_S261BIW1
WHERE...

How to access SAP table S261BIW1

Within an ECC or HANA version of SAP you can also view further information about S261BIW1 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!