OIA12I SAP (Movement Based Netting document item) Table details

Dictionary Type: Table
Description: Movement Based Netting document item




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




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

OIA12I is a standard SAP Table which is used to store Movement Based Netting document item data and is available within R/3 SAP systems depending on the version and release level.

The OIA12I table consists of various fields, each holding specific information or linking keys about Movement Based Netting document item data available in SAP. These include BUKRS (Company Code), NETNUM (Exchange - netting document number), ITMNO (Exchange - netting document item number), BUDAT (Posting Date in the Document).. 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 OIA12I 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 MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
NETNUMExchange - netting document number OIA_NETNUMCHAR10OIA_NETNUMOIM
ITMNOExchange - netting document item number OIA_ITNONUMC5OIA_ITNO
BUDATPosting Date in the Document BUDATDATS8DATUM
SELKZSelection flag SELKZCHAR1SELKZ
OIEXGNUMExchange agreement number OIA_EXGNUMCHAR10Assigned to domainALPHAOIA_EXGNUMOI1OIAE
ITCATExchange - netting document item type OIA_ITCATCHAR1OIA_MVTYPE
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
ZEILEItem number OIA_ITEMNUMC6OIA_ITEM
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
OIVBELNDelivery VBELN_VLCHAR10Assigned to domainALPHAVBELNVL
OIPOSNRDelivery Item POSNR_VLNUMC6Assigned to domainPOSNR
KDAUFSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
DMBTRAmount in local currency OIA_DMBTR1CURR13(2) WERTV7
WRBTRAmount in document currency OIA_WRBTR1CURR13(2) WERTV7
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
CLRNODoc. number of the netting document clearing the item/cycle OIA_CLRNOCHAR10ALPHAOIA_PREQNO
OIBASPRODBase product number OIA_SBMATCHAR18Assigned to domainMATN1MATNR
BOMCONIndicator: BOM continuation item OIA_BOMCONCHAR1OI0_SELKZ
OICLRDCYCItem already cleared in all cycles under process (X/ ) OIA_CLRCYCCHAR1KREUZ
OIMATREFMaterial group reference for exchange balance reporting OIA_MATREFCHAR20ALPHAOIA_MATREF
OIPIPEVALValidation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEVCHAR1X
OIC_LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
OIC_DCITYCDestination city code OIC_DCITYCCHAR4T005GCITYC
OIC_DCOUNCDestination county code OIC_DCOUNCCHAR3T005ECOUNC
OIC_DREGIODestination region OIC_DREGIOCHAR3T005SREGIO
OIC_DLAND1Destination country OIC_DLAND1CHAR3T005LAND1
OIC_OCITYCOrigin city code OIC_OCITYCCHAR4T005GCITYC
OIC_OCOUNCOrigin county code OIC_OCOUNCCHAR3T005ECOUNC
OIC_OREGIOOrigin region OIC_OREGIOCHAR3T005SREGIO
OIC_OLAND1Origin country OIC_OLAND1CHAR3T005LAND1
OIC_PORGINTax origin OIC_PORGINCHAR15OIC_PORGIN
OIC_PDESTNTax destination OIC_PDESTNCHAR15OIC_PDESTN
OIC_PTRIPPipeline trip number (external) OIC_PTRIPCHAR16OIC_PTRIP
OIC_PBATCHPipeline operatorĀ“s external batch number OIC_PBATCHCHAR16OIC_PBATCH
OIC_MOTIS-OIL MAP external details mode of transport OIC_MOTCHAR2TVTRVKTRA
OIC_AORGINAlternate origin OIC_AORGINCHAR15OIC_PORGIN
OIC_ADESTNAlternate destination OIC_ADESTNCHAR15OIC_PDESTN
OIC_TRUCKNTruck number OIC_TRUCKNCHAR10OIC_TRUCKN
OIA_BASELOBase location OIA_BASELOCHAR15OIA_BASELO
OID_EXTBOLExternal bill of lading OID_EXTBOLCHAR16OID_EXTBOL
OID_MISCDLMiscellaneous delivery number OID_MISCDLCHAR16OID_MISCDL
OIAOBALOpening exchange balance OIA_OBALQUAN15(3) MENGV15
BASEPMEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
MENGEMovement quantity OIA_QUANQUAN13(3) OIA_MENGE
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS

Key field Non-key field



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

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

SELECT SINGLE *
FROM OIA12I
INTO CORRESPONDING FIELDS OF WA_OIA12I
WHERE...

How to access SAP table OIA12I

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