OIRADBT is a SAP table coming under IS module and IS-OIL component.View details, Fields & related tables of OIRADBT in SAP.
- Table description : Document base table
- Module : IS-OIL-DS-SSR
- Parent Module : IS
- Package : OIR
- Software Component : IS-OIL
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP OIRADBT Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
LINKNR | Link number | OIRA_LINKNR | NUMC10 |
ITLINKNR | Item link number | OIRA_ITLINKNR | POSNR |
LINKYEAR | Document link number year | OIRA_JAHR | GJAHR |
.INCLUDE | Document Base Table data fields | ||
PBLNR | Business location identifier (IS-Oil MRN) | OIF_PBLNR | OIF_PBLNR |
DATATYPE | Data type | OIRA_DATATYPE | OIRA_DATATYPE |
SRCETAB | Source table | OIRA_SRCETAB | OIRA_SRCETAB |
RNBT | Business type | OIRA_RNBT | OIRA_RNBT |
PARFN | MRN business partner role / relation type | OIF_PARFN | OIF_PARFN |
FTMSTM | Start of partner function validity period: time stamp | OIF_FTMSTM | OIF_TMSTM |
PARPOS | Partner counter | OIF_PARPOS | OIF_PARPOS |
MATNR | Material Number | MATNR | MATNR |
STYP | Service type | OIRA_STYP | OIRA_STYP |
VKDAT | SSR PC: Sales date at the service station | OIRE_VKDAT | DATS |
WERKS | Plant | WERKS_D | WERKS |
LGORT | Storage location | LGORT_D | LGORT |
BUKRS | Company Code | BUKRS | BUKRS |
CHOBJ | SSR PC: Clearing house | OIRE_CHOBJ | OIRE_CHOBJ |
SSR_CCINS | SSR PC: Payment card type | OIRE_CCINS | OIRE_CCINS |
STORNO | SSR PC: Reversal indicator | OIRE_STORNO | CHAR1 |
COMPFL | Complaint indicator for OIRADBT entries | OIRA_COMPFL | CHAR1 |
VRKME | Sales unit | VRKME | MEINS |
DCIND | Debit/Credit indicator | OIRA_DCIND | OIRE_DCIND |
KBETR | Rate (condition amount or percentage) | KBETR | WERTV6 |
KONWA | Rate unit (currency or percentage) | KONWA | WAERS |
KPEIN | Condition pricing unit | KPEIN | KPEIN |
KMEIN | Condition Unit | KMEIN | MEINS |
MENGE | SSR PC: Quantity sold at the business location | OIRE_MENGE | MENG13V |
BRTWR | SSR PC: Gross value | OIRE_BRTWR | WERTV7 |
STPARTPROC | Partially processed indicator for Settlement transmission | OIRE_SETTRANPARTPROC | YESNO |
SEQNR | GMM: Sequence number of meter assigned to customer | OII_GSEQNR | OII_SEQNR |
TNKNR | Sequence number of SO assigned to business location | OII_BSEQNR | OII_SEQNR |
HDRNR | SSR PC: DTF payment card transaction number (internal) | OIRE_UPLNR | CHAR10 |
ITMNR | Item number of the SD document | POSNR | POSNR |
GMMNR | GMM: Number of general meter | OII_GMMNR | OII_GMMNR |
ITMSTM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | TZNTSTMPS |
METREV | SSR: Meter event type | OIRC_METREV | OIRC_METREV |
TRANSYEAR | Document link number year | OIRA_JAHR | GJAHR |
SOCNR | SOC: Storage object characteristic segment number | OII_SOCNR | OII_SOCNR |
ETMSTM | SSR Stocks - Tank dip time stamp | OIRC_TMSTM | TZNTSTMPS |
SOCEV | SOC event | OII_SOCEV | OII_SOCEV |
KWAEH | Condition currency (for cumulation fields) | KWAEH | WAERS |
SRCD_DATE | SSR - Source data date | OIRA_SRCD_DATE | DATUM |
SRCD_TIME | SSR - Source date time | OIRA_SRCD_TIME | UZEIT |
COUNTER | Transaction counter | OIRA_COUNTER | OIRA_COUNTER |
PROCIND | Processed record indicator | OIRA_PROCIND | OIRA_PROCIND |
.INCLUDE | Customer fields in the DBT | ||
OIRA_CUST | Dummy function in length 1 | DUMMY | DUMMY |
.INCLUDE | Indicator fields for DBT | ||
IS01 | Subsequent process indicator for document base table | OIRA_IND | CHAR1 |
MM01 | Subsequent process indicator for document base table | OIRA_IND | CHAR1 |
MM02 | Subsequent process indicator for document base table | OIRA_IND | CHAR1 |
PC02 | Subsequent process indicator for document base table | OIRA_IND | CHAR1 |
.INCLUDE |
OIRADBT related tables
Table | Note |
---|---|
N2BASEITEM | Base Items: Base Item |
N2BASEITEMT | Base Items: Base Item Texts |
N2BIGROUPA | Base Items: Base Item Groups Assignment |
TN2BIACT | Base Items: Base Item Type Actions |
TN2BIACTT | Base Items: Base Item Type Actions Texts |
TN2BIGROUP | Base Items: Base Item - Groups |
TN2BIGROUPT | Base Items: Base Item Groups - Texts |
TN2BIPROPS | Base Items: Base Item Type - Supported Functions |
TN2BITYP | Base Items: Base Item Types |
TN2BITYPEF | Base Items: Base Item Types - Filter Values |
TN2BITYPEFT | Base Items: Base Item Types - Filter Values, Texts |
TN2BITYPT | Base Items: Base Item Types - Texts |
TN2BITYPUSE | Base Items: Base Item Type Application Area |
TN2BIXDIAGNOSIS | Base Items: Filter Value Base Item Diagnoses |
TN2BIXPROBLEM | Base Items: Filter Value Base Item Problem |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP