STR_WLB3_DETAILS SAP (Structure for WLB3 details) Structure details

Dictionary Type: Structure
Description: Structure for WLB3 details




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




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

STR_WLB3_DETAILS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure for WLB3 details" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_STR_WLB3_DETAILS TYPE STR_WLB3_DETAILS.

The STR_WLB3_DETAILS table consists of various fields, each holding specific information or linking keys about Structure for WLB3 details data available in SAP. These include MANDT (Client), MBLNR (Number of Material Document), MJAHR (Material Document Year), VGART (Transaction/Event Type).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP STR_WLB3_DETAILS structure 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
MKPF 0
MANDTClient MANDTCLNT3MANDT
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
VGARTTransaction/Event Type VGARTCHAR2VGART
BLARTDocument Type BLARTCHAR2BLARTBAR
BLAUMDocument type of revaluation document BLAUMCHAR2BLART
BLDATDocument Date in Document BLDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
AEDATChanged On AEDATDATS8DATUM
USNAMUser name USNAMCHAR12XUBNAMEUSR
TCODENot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
BKTXTDocument Header Text BKTXTCHAR25TEXT25
FRATHUnplanned delivery costs FRATHCURR13(2) WERT7
FRBNRNumber of Bill of Lading at Time of Goods Receipt FRBNR1CHAR16XBLNR1
WEVERVersion for Printing GR/GI Slip WEVERCHAR1WEVERWEV
XABLNGoods Receipt/Issue Slip Number XABLNCHAR10ALPHABELNR
AWSYSLogical System LOGSYSTEMCHAR10ALPHALOGSYS
BLA2DDoc. type for additional doc. in purchase account management BLA2DCHAR2BLART
TCODE2Transaction Code TCODECHAR20TCODETCD
BFWMSControl posting for external WMS BFWMSCHAR1BFWMS
EXNUMNumber of foreign trade data in MM and SD documents EXNUMCHAR10EXNUM
SPE_BUDAT_UHRTime of Goods Issue (Local, Relating to a Plant) WAUHRTIMS6TIME_PLANT
SPE_BUDAT_ZONETime Zone TZNZONECHAR6TZNZONE
LE_VBELNDelivery VBELN_VLCHAR10ALPHAVBELNVL
SPE_LOGSYSLogical System of EWM Material Document /SPE/_LOGSYS_MDCHAR10ALPHALOGSYS
SPE_MDNUM_EWMNumber of Material Document in EWM /SPE/MDNUM_EWMCHAR16/SPE/MDNUM_EWM
GTS_CUSREF_NOCustoms Reference Number for Scrapping /SAPSLL/SCREF_SPICHAR35CHAR35
FLS_RSTOStore Return with Inbound and Outbound Delivery FLS_RSTOCHAR1XFELD
MSR_ACTIVEAdvanced Returns Management Active MSR_ACTIVECHAR1MSR_ACTIVE
.INCLU--AP 0
KNUMVNumber of the document condition KNUMVCHAR10KNUMV
.INCLU--AP 0
XCOMPLMaterial document can only be canceled in full MILL_CANCEL_COMPLETECHAR1CHAR1
.INCLU--AP 0
LFSNRNumber of External Delivery Note LFSNR1CHAR16XBLNR1
OIB_BLTIMEPosting time in the document OIB_BLTIMETIMS6TIMES
LFA1 0
MANDTClient MANDTCLNT3MANDT
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10ALPHALIFNRLIFKRED_C
LAND1Country Key LAND1_GPCHAR3LAND1C_LAND1
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
NAME3Name 3 NAME3_GPCHAR35NAME
NAME4Name 4 NAME4_GPCHAR35NAME
ORT01City ORT01_GPCHAR35TEXT35
ORT02District ORT02_GPCHAR35TEXT35
PFACHPO Box PFACHCHAR10PFACH
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
PSTLZPostal Code PSTLZCHAR10PSTLZ
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
SORTLSort field SORTLCHAR10CHAR10
STRASHouse number and street STRAS_GPCHAR35TEXT35
ADRNRAddress ADRNRCHAR10ALPHAADRNR
MCOD1Search term for matchcode search MCDK1CHAR25CHAR25
MCOD2Search term for matchcode search MCDK2CHAR25CHAR25
MCOD3Search term for matchcode search MCDK3CHAR25CHAR25
ANREDTitle ANREDCHAR15TEXT15
BAHNSTrain station BAHNSCHAR25BAHNH
BBBNRInternational location number (part 1) BBBNRNUMC7NUM07
BBSNRInternational location number (Part 2) BBSNRNUMC5NUM05
BEGRUAuthorization Group BRGRUCHAR4BRGRU
BRSCHIndustry key BRSCHCHAR4BRSCH
BUBKZCheck digit for the international location number BUBKZNUMC1NUM01
DATLTData communication line no. DATLTCHAR14TEXT14
DTAMSIndicator for Data Medium Exchange DTAMSCHAR1DTAMS
DTAWSInstruction key for data medium exchange DTAWSCHAR2DTAWS
ERDATDate on which the Record Was Created ERDAT_RFDATS8DATUM
ERNAMName of Person who Created the Object ERNAM_RFCHAR12USNAM
ESRNRISR Subscriber Number ESRNRCHAR11ESRNR
KONZSGroup key KONZSCHAR10KONZS
KTOKKVendor account group KTOKKCHAR4KTOKKKGK
KUNNRCustomer Numbers KUNNRCHAR10ALPHAKUNNRKUNC_KUNNR
LNRZAAccount Number of the Alternative Payee LNRZACHAR10ALPHALIFNR
LOEVMCentral Deletion Flag for Master Record LOEVM_XCHAR1XFELD
SPERRCentral posting block SPERB_XCHAR1XFELD
SPERMCentrally imposed purchasing block SPERM_XCHAR1XFELD
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
STKZAIndicator: Business Partner Subject to Equalization Tax? STKZACHAR1STKZA
STKZULiable for VAT STKZUCHAR1XFELD
TELBXTelebox number TELBXCHAR15TEXT15
TELF1First telephone number TELF1CHAR16TEXT16
TELF2Second telephone number TELF2CHAR16TEXT16
TELFXFax Number TELFXCHAR31TEXT31
TELTXTeletex number TELTXCHAR30TEXT30
TELX1Telex number TELX1CHAR30TEXT30
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
XZEMPIndicator: Alternative payee in document allowed ? XZEMPCHAR1XFELD
VBUNDCompany ID of trading partner RASSCCHAR6ALPHARCOMPPGS
FISKNAccount number of the master record with fiscal address FISKN_KCHAR10ALPHALIFNR
STCEGVAT Registration Number STCEGCHAR20STCEG
STKZNNatural Person STKZNCHAR1STKZN
SPERQFunction That Will Be Blocked QSPERRFKTCHAR2QSPERRFKT
GBORTPlace of birth of the person subject to withholding tax GBORT_QCHAR25TEXT25
GBDATDate of birth of the person subject to withholding tax GBDAT_QDATS8DATUM
SEXKZKey for the Sex of the Person Subject to Withholding Tax SEXKZCHAR1SEXKZ
KRAUSCredit information number KRAUS_CMCHAR11CHAR11
REVDBLast review (external) REVDB_CMDATS8DATUM
QSSYSVendor's QM system QSSYS_ISTCHAR4QSSYSFAM
KTOCKReference Account Group for One-Time Account (Vendor) KTOCKCHAR4KTOKK
PFORTPO Box city PFORT_GPCHAR35TEXT35
WERKSPlant (Own or External) WERKS_EXTCHAR4WERKSWRKSH_T001W_EXTS
LTSNAIndicator: vendor sub-range relevant LTSNACHAR1XFELD
WERKRIndicator: plant level relevant WERKRCHAR1XFELD
PLKALFactory calendar key FABKLCHAR2WFCID
DUEFLStatus of Data Transfer into Subsequent Release DUEFL_BKPFCHAR1DUEFL_BKPF
TXJCDTax Jurisdiction TXJCDCHAR15TXJCDTXJ
SPERZPayment Block SPERZCHAR1XFELD
SCACDStandard carrier access code SCACDCHAR4SCACD
SFRGRForwarding agent freight group SFRGRCHAR4SFRGR
LZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
XLFZAIndicator: Alternative payee using account number XLFZACHAR1XFELD
DLGRPService agent procedure group DLGRPCHAR4DLGRP
FITYPTax type J_1AFITP_DCHAR2J_1AFITP
STCDTTax Number Type J_1ATOIDCHAR2J_1ATOID
REGSSRegistered for Social Insurance J_1AREGSSCHAR1XFELD
ACTSSActivity Code for Social Insurance J_1AACTSSCHAR3J_1AACTSS
STCD3Tax Number 3 STCD3CHAR18CHAR18
STCD4Tax Number 4 STCD4CHAR18CHAR18
STCD5Tax Number 5 STCD5CHAR60CHAR60
IPISPTax Split J_1BINDEQUCHAR1XFELD
TAXBSTax Base in Percentage TAXBSNUMC1TAXBS
PROFSProfession PROFSCHAR30TEXT30
STGDLShipment: statistics group, transportation service agent STGDLCHAR2STGDL
EMNFRExternal manufacturer code name or number EMNFRCHAR10CHAR10
LFURLUniform Resource Locator URLCHAR132TEXT132
J_1KFREPREName of Representative REPRESCHAR10REPRES
J_1KFTBUSType of Business GESTYPCHAR30GESTYP
J_1KFTINDType of Industry INDTYPCHAR30INDTYP
CONFSStatus of Change Authorization (Central) CONFS_XCHAR1CHAR1
UPDATDate on Which the Changes Were Confirmed UPDAT_RFDATS8DATUM
UPTIMTime of Last Change Confirmation UPTIM_RFTIMS6AS4TIME
NODELCentral deletion block for master record NODEL_XCHAR1XFELD
QSSYSDATValidity date of certification QQSSYSDATDATS8QQSSYSDAT
PODKZBVendor indicator relevant for proof of delivery PODKZBCHAR1PODKZB
FISKUAccount Number of Master Record of Tax Office Responsible FISKUCHAR10ALPHALIFNR
STENRTax Number at Responsible Tax Authority STENRCHAR18CHAR18
CARRIER_CONFCarrier confirmation is expected /SPE/CARRIER_CNFCHAR1/SPE/CARRIER_CONF
MIN_COMPMicro company indicator J_1BMICRO_COMPCHAR1XFELD
TERM_LITerms of Liability J_1BTERMS_LIABCHAR1XFELD
CRC_NUMCRC number J_1BCRC_NUMCHAR25CHAR25
RGRG Number J_1BRGCHAR11J_1BRG
EXPIssued by J_1BEXPCHAR3J_1BEXP
UFState J_1BUFCHAR2J_1BUF
RGDATERG Issue Date J_1BRGDATEDATS8DATUM
RICRIC Number J_1BRICNUMC11J_1BRIC
RNEForeign National Registration J_1BRNECHAR10J_1BRNE
RNEDATERNE Issue Date J_1BRNEDATEDATS8DATUM
CNAECNAE J_1BCNAECHAR7J_1BCNAE
LEGALNATLegal Nature J_1BLEGALNATNUMC4J_1BLEGALNAT
CRTNCRT Number J_1BCRTNCHAR1J_1BCRTN
ICMSTAXPAYICMS Taxpayer J_1BICMSTAXPAYCHAR2J_1BICMSTAXPAY
INDTYPIndustry Main Type J_1BINDTYPCHAR2J_1BINDTYP
TDTTax Declaration Type J_1BTDTCHAR2J_1BTDT
COMSIZECompany Size J_1BCOMSIZECHAR2J_1BCOMSIZE
DECREGPCDeclaration Regimen for PIS/COFINS J_1BDECREGPCCHAR2J_1BDECREGPC
.INCLU--AP 0
DUNSP4DUNS+4 number (the last four digit) /SAPHT/RN_DUNSP4CHAR4CHAR4
.INCLU--AP 0
J_SC_CAPITALCapital Amount /SAPNEA/J_SC_CAPITALCURR15(2) /SAPNEA/J_SC_CAPITAL
J_SC_CURRENCYCurrency /SAPNEA/J_SC_CURRENCYCUKY5WAERS
.INCLU--AP 0
ALCAgency Location Code FMFG_ALCCHAR8FMFG_ALCFMFG_ALC
PMT_OFFICEPayment Office FMFG_PMT_OFFCHAR5FMFG_PMT_OFFFMFG_PMT_OFFICE
PPA_RELEVANTVendor is PPA relevant FMFG_PPA_RELEVANTCHAR1XFELD
.INCLU--AP 0
PSOFGProcessor group PSOFGCHAR10PSOFG
PSOISSubledger acct preprocessing procedure PSOISCHAR20CHAR20
PSON1Name 1 NAME1_GPCHAR35NAME
PSON2Name 2 NAME2_GPCHAR35NAME
PSON3Name 3 NAME3_GPCHAR35NAME
PSOVNFirst Name PSOVNCHAR35NAME
PSOTLTitle PSOTLCHAR20FMPSOTL
PSOHSHouse number: is no longer used from Release 4.6B PSOHSCHAR6CHAR06
PSOSTStreet: No longer used from Release 4.6B PSOSTCHAR28PSOST
.INCLU--AP 0
BORGR_DATUNDate Limit for External Document Identification BORGR_DATUNDATS8DATE
BORGR_YEAUNAnnual Repetition of Date Limit BORGR_YEAUNCHAR1XFELD
.INCLU--AP 0
TRANSPORT_CHAINTransportation Chain WRF_PSCD_TC_IDCHAR10WRF_PSCD_TC_ID
STAGING_TIMEStaging Time in Days WRF_PSCD_MSTDEC3WRF_PSCD_MST
SCHEDULING_TYPEScheduling Procedure WRF_PSCD_SCHED_TYPECHAR1WRF_PSCD_SCHED_TYPE
SUBMI_RELEVANTCross Docking: Relevant for Collective Numbering WRF_SUBMI_RELEVANTCHAR1XFELD
.INCLU--AP 0
PERREF 0
RATING 0
MOBILE 0
T001W 0
MANDTClient MANDTCLNT3MANDT
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
NAME1Name NAME1CHAR30TEXT30
BWKEYValuation Area BWKEYCHAR4BWKEYBWK
KUNNRCustomer number of plant KUNNR_WKCHAR10ALPHAKUNNR
LIFNRVendor number of plant LIFNR_WKCHAR10ALPHALIFNR
FABKLFactory calendar key FABKLCHAR2WFCID
NAME2Name 2 NAME2CHAR30TEXT30
STRASHouse number and street STRASCHAR30TEXT30
PFACHPO Box PFACHCHAR10PFACH
PSTLZPostal Code PSTLZCHAR10PSTLZ
ORT01City ORT01CHAR25TEXT25
EKORGPurchasing Organization EKORGCHAR4EKORGEKO
VKORGSales organization for intercompany billing VKOIVCHAR4VKORGVKO
CHAZVIndicator: batch status management active CHAZVCHAR1XFELD
KKOWKIndicator: Conditions at plant level KKOWKCHAR1KKOWK
KORDBIndicator: Source list requirement KORDBCHAR1XFELD
BEDPLActivating requirements planning BEDPLCHAR1XFELD
LAND1Country Key LAND1CHAR3LAND1LND
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
COUNCCounty Code COUNCCHAR3COUNC
CITYCCity Code CITYCCHAR4CITYC
ADRNRAddress ADRNRCHAR10ALPHAADRNR
IWERKMaintenance Planning Plant IWERKCHAR4WERKSIWK
TXJCDTax Jurisdiction TXJCDCHAR15TXJCDTXJ
VTWEGDistribution channel for intercompany billing VTWIVCHAR2VTWEGVTW
SPARTDivision for intercompany billing SPAIVCHAR2SPARTSPA
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
WKSOPSOP plant WKSOPCHAR1XFELD
AWSLSVariance Key AWSLSCHAR6AWSLS
CHAZV_OLDIndicator: batch status management active CHAZVCHAR1XFELD
VLFKZPlant category VLFKZCHAR1VLFKZ
BZIRKSales district BZIRKCHAR6BZIRKBZI
ZONE1Supply region (region supplied) LFREGCHAR10ZONE
TAXIWTax Indicator: Plant (Purchasing) TAXIW1CHAR1TAXIW1
BZQHLTake regular vendor into account BZQHLCHAR1XFELD
LET01Number of Days for First Reminder/Expediter MAHN1DEC3MAHNT
LET02Number of Days for Second Reminder/Expediter MAHN2DEC3MAHNT
LET03Number of Days for Third Reminder/Expediter MAHN3DEC3MAHNT
TXNAM_MA1Text name of 1st dunning of vendor declarations TXNAM_MA1CHAR16TXNAM16
TXNAM_MA2Text name of the 2nd dunning of vendor declarations TXNAM_MA2CHAR16TXNAM16
TXNAM_MA3Text name of 3rd dunning of vendor declarations TXNAM_MA3CHAR16TXNAM16
BETOLNumber of days for PO tolerance - Compress info records - SU BETOLNUMC3NUMC3
J_1BBRANCHBusiness Place J_1BBRANC_CHAR4J_1BBRANCH
VTBFIRule for determining the sales area for stock transfers VTBFICHAR2VTBFI
FPRFWDistribution profile at plant level FPRFWCHAR3FEPRF
ACHVMCentral archiving marker for master record ACHVM_XCHAR1XFELD
DVSARTBatch Record: Type of DMS Used DVSARTCHAR1DVSART
NODETYPENode type: supply chain network NODETYPECHAR3NODETYPE
NSCHEMAStructure for name formation CKML_NSCHEMACHAR4CKML_NSCHEMA
PKOSACost Object Controlling linking active CKML_FLG_PKOSACHAR1BOOLE
MISCHUpdating is active for mixed costing CKML_FLG_MISCHCHAR1BOOLE
MGVUPDUpdating is active in actual costing CKML_FLG_MGVUPDCHAR1BOOLE
VSTELShipping Point/Receiving Point VSTELCHAR4VSTELVST
MGVLAUPDUpdate of Activity Consumption in the Quantity Structure CKML_MGVLAUPDCHAR1CKML_MGVLAUPD
MGVLAREVALControl of Credit of Cost Centers CKML_MGVLAREVALCHAR1CKML_MGVLAREVAL
SOURCINGInvoke Added-Function Source Determination via ATP MMPUR_SOURCINGCHAR1MMPUR_SOURCING
.INCLU--AP 0
OILIVALExchange valuation indicator OIA_VALFLGCHAR1OIA_VALFLG
OIHVTYPEVendor type (refinery/mill/other) (Brazil) OIH_J1B_VTYPCHAR1OIH_J1B_VTYP
OIHCREDIPIIPI credit allowed OIH_J1B_TXCREDIPCHAR1ANKREUZ
.INCLU--AP 0
STORETYPEStore Category to Differentiate Store, Dep. Store, Shop WRF_STORETYPECHAR1WRF_STORETYPE
DEP_STORESuperior Department Store WRF_DEP_STORECHAR4WERKS
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
T156T 0
MANDTClient MANDTCLNT3MANDT
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
BWARTMovement Type (Inventory Management) BWARTCHAR3BWARTBWA
SOBKZSpecial Stock Indicator SOBKZCHAR1SOBKZ
KZBEWMovement Indicator KZBEWCHAR1KZBEW
KZZUGReceipt Indicator KZZUGCHAR1KZZUG
KZVBRConsumption Posting KZVBRCHAR1KZVBR
BTEXTMovement Type Text (Inventory Management) BWTXTCHAR20BTEXT
POS_ZEILE 0

Key field Non-key field



How do I retrieve data from SAP structure STR_WLB3_DETAILS using ABAP code?

As STR_WLB3_DETAILS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on STR_WLB3_DETAILS as there is no data to select.

How to access SAP table STR_WLB3_DETAILS

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