/SPE/DB_DATA_MAINTAIN_STY SAP (Data for Calling VBDBDM_DATA_MAINTAIN_RFC) Structure details

Dictionary Type: Structure
Description: Data for Calling VBDBDM_DATA_MAINTAIN_RFC




ABAP Code to SELECT data from /SPE/DB_DATA_MAINTAIN_STY
Related tables to /SPE/DB_DATA_MAINTAIN_STY
Access table /SPE/DB_DATA_MAINTAIN_STY




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

/SPE/DB_DATA_MAINTAIN_STY 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 "Data for Calling VBDBDM_DATA_MAINTAIN_RFC" 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_/SPE/DB_DATA_MAINTAIN_STY TYPE /SPE/DB_DATA_MAINTAIN_STY.

The /SPE/DB_DATA_MAINTAIN_STY table consists of various fields, each holding specific information or linking keys about Data for Calling VBDBDM_DATA_MAINTAIN_RFC data available in SAP. These include WERKS (Plant), PROCESS_ID (Definable Processes for Documentary Batches), AUFNR (Order Number), AUFPS (Order Item 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP /SPE/DB_DATA_MAINTAIN_STY 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
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
PROCESS_IDDefinable Processes for Documentary Batches DOCUBATCH_PROCESS_IDCHAR2DOCUBATCH_PROCESS_ID
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
AUFPSOrder Item Number CO_POSNRNUMC4CO_POSNR
VBELNDelivery VBELN_VLCHAR10Assigned to domainALPHAVBELNVL
POSNRDelivery Item POSNR_VLNUMC6Assigned to domainPOSNR
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
DOCUBATCH_CHARGDocumentary Batch - Batch Number DOCUBATCH_CHARGCHAR10DOCUBDOCUBATCH_CHARG
QUANTITYQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
UOMUnit of Entry ERFMEUNIT3Assigned to domainCUNITMEINS
DOCUBATCH_COM 0
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
MTARTMaterial Type MTARTCHAR4MTARTMTA
WAGRPMaterial group WAGRPCHAR9CHAR9
MATKLMaterial Group MATKLCHAR9MATKLMKLS_WBWG
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4LGORTLAG
BWTTYValuation Category BWTTY_DCHAR1BWTTY
LBBSAStock Type of Goods Movement (Primary Posting) LBBSACHAR2LBBSA
SOBKZSpecial Stock Indicator SOBKZCHAR1SOBKZ
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
SHKZG_MIGODirection of Goods Movement SHKZG_MIGOCHAR1SHKZG_MIGO
BWARTMovement Type (Inventory Management) BWARTCHAR3BWARTBWA
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10ALPHALIFNRLIFKRED_C
LICHAVendor Batch Number LICHNCHAR15LICHN
EKORGPurchasing Organization EKORGCHAR4EKORGEKO
BSTYPPurchasing Document Category BSTYPCHAR1BSTYP
EBELNPurchasing Document Number EBELNCHAR10ALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EBELPBSP
AUARTOrder Type AUFARTCHAR4AUFARTAAT
AUTYPOrder category AUFTYPNUMC2AUFTYP
AUFNROrder Number AUFNRCHAR12ALPHAAUFNRANR
AUFPSOrder Item Number CO_POSNRNUMC4CO_POSNR
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10RSNUMRES
RSPOSItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
RSARTRecord type RSARTCHAR1RSART
VBTYPSD document category VBTYPCHAR1VBTYP
KDAUFSales Order Number KDAUFCHAR10ALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
KDEINDelivery Schedule for Sales Order KDEINNUMC4NUM04
DELNRDelivery VBELN_VLCHAR10ALPHAVBELNVL
DELPSDelivery Item POSNR_VLNUMC6POSNR
LGNUMWarehouse Number / Warehouse Complex LGNUMCHAR3LGNUMLGN
TANUMTransfer Order Number TANUMNUMC10TANUMTAN
TAPOSTransfer order item TAPOSNUMC4TAPOSTAP
BWLVSMovement Type for Warehouse Management BWLVSNUMC3BWLVSBWL
XSTBWReversal movement type XSTBWCHAR1XFELD
CANCELDocumentary batches: Cancellation Indicator DOCUBATCH_CANCELCHAR1XFELD
KZEBUPosting as Partial Goods Receipt KZTWECHAR1XFELD
WABUCPost Goods Movement Automatically WABUCCHAR1XFELDKO3
WEBLNRNumber of a document from a goods movement with errors WEBLNRCHAR10ALPHABELNR
WEBLPOSInternal counter CIM_COUNTNUMC8CIM_COUNT
DUMMYDummy function in length 1 DUMMYCHAR1DUMMY

Key field Non-key field



How do I retrieve data from SAP structure /SPE/DB_DATA_MAINTAIN_STY using ABAP code?

As /SPE/DB_DATA_MAINTAIN_STY 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 /SPE/DB_DATA_MAINTAIN_STY as there is no data to select.

How to access SAP table /SPE/DB_DATA_MAINTAIN_STY

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