WB2_D_ASSGMT SAP (Assignments) Table details

Dictionary Type: Table
Description: Assignments




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




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

WB2_D_ASSGMT is a standard SAP Table which is used to store Assignments data and is available within R/3 SAP systems depending on the version and release level.

The WB2_D_ASSGMT table consists of various fields, each holding specific information or linking keys about Assignments data available in SAP. These include TYPE_FROM (Document Category), DOCUMENT_FROM (Document Number), ITEM_FROM (item number), SIDE_FROM (Side of the Document with an Assignment).. 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 WB2_D_ASSGMT 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
TYPE_FROMDocument Category WLF_SHADOW_DOC_TYPECHAR2WLF_SHADOW_DOC_TYPE
DOCUMENT_FROMDocument Number WLF_GENERIC_DOC_NUMCHAR32WLF_GENERIC_DOC_NUM
ITEM_FROMitem number WLF_GENERIC_ITEM_NUMNUMC10WLF_GENERIC_ITEM_NUM
SIDE_FROMSide of the Document with an Assignment WLF_PR_SIDE_FROMCHAR2WLF_PR_SIDE
SUB_ITEM_FROMSubitem Number WLF_GENERIC_SUB_ITEM_NUMNUMC6WLF_GENERIC_ITEM_NUM_SUB
TKONNTrading Contract: Trading Contract Number TKONNCHAR10Assigned to domainALPHATKONNWKNWBHK
TPOSNTrading Contract: Item Number TPOSNNUMC6TPOSNWKP
SIDE_TOSide of the document which is assigned to WLF_PR_SIDE_TOCHAR2WLF_PR_SIDE
TPOSN_COMCommodity Subitem Number WLF_TPOSN_COMNUMC6TPOSN
ASSGD_QUANAssigned Quantity WLF_ASSGD_QUANTITY_INDD34R34WLF_QUANTITY
ASSGD_QUAN_ORIGOriginal Assigned Quantity WLF_ASSGD_QUANTITY_ORIGD34R34WLF_QUANTITY
ASSGD_UOMUoM of the Assigned Quantity WLF_ASSGD_UOMUNIT3T006CUNITMEINS
A_GUIDGUID of an assignment WLF_ASSGMT_GUIDRAW16WLF_GUID
PRED_A_GUIDGUID of a preceding assignment WLF_PRED_ASSGMT_GUIDRAW16WLF_GUID
PRED_QUANQuantity Transferred from a Preceding Assignment WLF_PRED_ASSGD_QUANTITYD34R34WLF_QUANTITY
FROZENAssignment is frozen WLF_ASSGMT_FROZENCHAR1BOOLE
CR_NAMEName of Person who Created the Object ERNAMCHAR12USNAM
CR_DATEDate on Which Record Was Created ERDATDATS8DATUM
CR_TIMETime, at Which Record Was Added ERZEITTIMS6UHRZT
CH_NAMEName of Person Who Changed Object AENAMCHAR12USNAM
CH_DATEChanged On AEDATDATS8DATUM
CH_TIMETime of Change AEZEITTIMS6UHRZT
CANCEL_FLAGCancel WLF_CANCELCHAR1WLF_CANCEL
PLACE_HOLDER not used0

Key field Non-key field



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

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

SELECT SINGLE *
FROM WB2_D_ASSGMT
INTO CORRESPONDING FIELDS OF WA_WB2_D_ASSGMT
WHERE...

How to access SAP table WB2_D_ASSGMT

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