SAP Table OIH_S_GOITEM_TDP
Structure with display TDP fields for goods movement
OIH_S_GOITEM_TDP (Structure with display TDP fields for goods movement) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link OIH_S_GOITEM_TDP to other SAP tables.
OIH_S_GOITEM_TDP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LINE_ID | Unique identification of document line | MB_LINE_ID | NUMC | 6 | 0 | |||||||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | 0 | |||||||||
| MATNR | Material Number | MATNR | CHAR | 18 | 0 | |||||||||
| WERKS | Plant | WERKS_D | CHAR | 4 | 0 | |||||||||
| BWTAR | Valuation Type | BWTAR_D | T149D | CHAR | 10 | 0 | ||||||||
| TAXKEY | Excise Duty Status | OIH_TAXKEY | CHAR | 2 | 0 | |||||||||
| OITAXFROM | Excise duty tax key for 'from' location | OIH_TAXFRO | OIH4 | CHAR | 2 | 0 | ||||||||
| OITAXTO | Excise duty tax key for 'to' location | OIH_TAXTO | OIH4 | CHAR | 2 | 0 | ||||||||
| OIHANTYP | Excise Duty Handling Type | OIH_HANTYP | OIH5 | CHAR | 2 | 0 | ||||||||
| OITAXGRP | Excise Duty Group | OIH_TAXGRP | OIH2 | CHAR | 2 | 0 | ||||||||
| OIPRICIE | ED pricing: external (indicator) | OIH_PRICIE | CHAR | 1 | 0 |
Possible values
|
||||||||
| OIINVREC | Indicator whether ED pricing is external (not used?) | OIH_INVREC | CHAR | 1 | 0 |
Possible values
|
||||||||
| OIOILCON | Oil content in a material as a percentage | OIH_OILCON | DEC | 5 | 2 |
Possible values
|
||||||||
| OIOILCON2 | Oil content of a material as a percentage (2) | OIH_OILCN2 | DEC | 5 | 2 |
Possible values
|
||||||||
| OIFUTDT | Future tax date | OIH_FUTDT | DATS | 8 | 0 | |||||||||
| OIFUTDT2 | Future tax date 2 | OIH_FUTDT2 | DATS | 8 | 0 | |||||||||
| OIUOMQT | Base quantity for excise duty rate (e.g.per 1 or 100 UoM) | OIH_UOMQT | UNIT | 3 | 0 | |||||||||
| OITAXQT | Excise duty tax quantity in STBME | OIH_TAXQT | QUAN | 13 | 3 | |||||||||
| OIFUTQT | Future tax quantity | OIH_FUTQT | QUAN | 13 | 3 | |||||||||
| OIFUTQT2 | Future tax quantity 2 | OIH_FUTQT2 | QUAN | 13 | 3 | |||||||||
| OITAXGRP2 | Excise Duty Group | OIH_TAXGRP | CHAR | 2 | 0 | |||||||||
| OICERTF1 | Excise tax external license number | OIH_CERTF1 | CHAR | 15 | 0 | |||||||||
| OIDATFM1 | Excise Duty License Valid from Date | OIH_DATFM1 | DATS | 8 | 0 | |||||||||
| OIDATTO1 | Valid to date for excise duty tax certificate | OIH_DATTO1 | DATS | 8 | 0 | |||||||||
| OIH_LICTP | License type | OIH_LICTP | OIH20 | CHAR | 4 | 0 | ||||||||
| OIH_LICIN | Excise tax internal license number | OIH_LICIN | OIHL | CHAR | 10 | 0 | ||||||||
| OIH_LCFOL | Follow-on license for quantity license | OIH_LCFOL | OIHL | CHAR | 10 | 0 | ||||||||
| OIH_FOLQTY | Excise Tax Follow-On License Quantity | OIH_FOLQTY | QUAN | 13 | 3 | |||||||||
| MENGE | Quantity | MENGE_D | QUAN | 13 | 3 | |||||||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | 0 | |||||||||
| ERFMG | Quantity in Unit of Entry | ERFMG | QUAN | 13 | 3 | |||||||||
| ERFME | Unit of Entry | ERFME | UNIT | 3 | 0 | |||||||||
| BPMNG | Quantity in Purchase Order Price Unit | BPMNG | QUAN | 13 | 3 | |||||||||
| BPRME | Order Price Unit (Purchasing) | BBPRM | UNIT | 3 | 0 | |||||||||
| BSTMG | Goods receipt quantity in order unit | MB_BSTMG | QUAN | 13 | 3 | |||||||||
| BSTME | Purchase Order Unit of Measure | BSTME | UNIT | 3 | 0 | |||||||||
| REFDOC_HANTYP | Excise Duty Handling Type | OIH_HANTYP | CHAR | 2 | 0 | |||||||||
| REFDOC_BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | 0 | |||||||||
| ITEM_STATUS | Return Code | SYSUBRC | INT4 | 10 | 0 | |||||||||
| OIEDBAL_GI | Excise Duty Balancing is Required for Mat. (STO) | OIH_EDBAL_GI | CHAR | 1 | 0 |
Possible values
|
||||||||
| OIEDBALM_GI | Excise Duty Balancing Method Indicator for Mat. (STO) | OIH_EDBALM_GI | CHAR | 1 | 0 |
Possible values
|
||||||||
| OICERTF1_GI | Excise Tax External License Number Used During GI (STO) | OIH_CERTF1_GI | CHAR | 15 | 0 | |||||||||
| OIDATFM1_GI | Excise Duty License Valid from Date for Mat. (STO) | OIH_DATFM1_GI | DATS | 8 | 0 | |||||||||
| OIDATTO1_GI | Valid To Date for Excise Duty Tax Certificate for Mat. (STO) | OIH_DATTO1_GI | DATS | 8 | 0 | |||||||||
| OIH_LICTP_GI | License Type to Material (STO) | OIH_LICTP_GI | OIH20 | CHAR | 4 | 0 | ||||||||
| OIH_LICIN_GI | Excise Tax Internal License Number to Mat. (STO) | OIH_LICIN_GI | OIHL | CHAR | 10 | 0 | ||||||||
| OIH_LCFOL_GI | Follow-On License for Quantity License to Mat. (STO) | OIH_LCFOL_GI | OIHL | CHAR | 10 | 0 | ||||||||
| OIH_FOLQTY_GI | Excise Tax Follow-On License Quantity to Mat. (STO) | OIH_FOLQTY_GI | QUAN | 13 | 3 | |||||||||
| OIHANTYP_GI | Excise Duty Handling Type - Denotes Use of Material | OIH_HANTYP_GI | OIH5 | CHAR | 2 | 0 | ||||||||
OIH_S_GOITEM_TDP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OIH_S_GOITEM_TDP | BWTAR | SYST | MANDT | T149D | Global Valuation Types | MANDT |
| OIH_S_GOITEM_TDP | BWTAR | OIH_S_GOITEM_TDP | BWTAR | T149D | Global Valuation Types | BWTAR |
| OIH_S_GOITEM_TDP | OIHANTYP | MSEG | MANDT | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | MANDT |
| OIH_S_GOITEM_TDP | OIHANTYP | OIH_S_GOITEM_TDP | OIHANTYP | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | HANTYP |
| OIH_S_GOITEM_TDP | OIHANTYP_GI | OIH_S_GOITEM_TDP | OIHANTYP_GI | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | HANTYP |
| OIH_S_GOITEM_TDP | OIHANTYP_GI | SYST | MANDT | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | MANDT |
| OIH_S_GOITEM_TDP | OIH_LCFOL | MSEG | MANDT | OIHL | License Master Data | MANDT |
| OIH_S_GOITEM_TDP | OIH_LCFOL | OIH_S_GOITEM_TDP | OIH_LCFOL | OIHL | License Master Data | LICIN |
| OIH_S_GOITEM_TDP | OIH_LCFOL | OIH_S_GOITEM_TDP | OIH_LICTP | OIHL | License Master Data | LICTP |
| OIH_S_GOITEM_TDP | OIH_LCFOL_GI | OIH_S_GOITEM_TDP | OIH_LCFOL_GI | OIHL | License Master Data | LICIN |
| OIH_S_GOITEM_TDP | OIH_LCFOL_GI | OIH_S_GOITEM_TDP | OIH_LICTP_GI | OIHL | License Master Data | LICTP |
| OIH_S_GOITEM_TDP | OIH_LCFOL_GI | SYST | MANDT | OIHL | License Master Data | MANDT |
| OIH_S_GOITEM_TDP | OIH_LICIN | MSEG | MANDT | OIHL | License Master Data | MANDT |
| OIH_S_GOITEM_TDP | OIH_LICIN | OIH_S_GOITEM_TDP | OIH_LICIN | OIHL | License Master Data | LICIN |
| OIH_S_GOITEM_TDP | OIH_LICIN | * | OIHL | License Master Data | LICTP | |
| OIH_S_GOITEM_TDP | OIH_LICIN_GI | OIH_S_GOITEM_TDP | OIH_LICIN_GI | OIHL | License Master Data | LICIN |
| OIH_S_GOITEM_TDP | OIH_LICIN_GI | * | OIHL | License Master Data | LICTP | |
| OIH_S_GOITEM_TDP | OIH_LICIN_GI | SYST | MANDT | OIHL | License Master Data | MANDT |
| OIH_S_GOITEM_TDP | OIH_LICTP | MSEG | MANDT | OIH20 | License types | MANDT |
| OIH_S_GOITEM_TDP | OIH_LICTP | OIH_S_GOITEM_TDP | OIH_LICTP | OIH20 | License types | LICTP |
| OIH_S_GOITEM_TDP | OIH_LICTP_GI | SYST | MANDT | OIH20 | License types | MANDT |
| OIH_S_GOITEM_TDP | OIH_LICTP_GI | OIH_S_GOITEM_TDP | OIH_LICTP_GI | OIH20 | License types | LICTP |
| OIH_S_GOITEM_TDP | OITAXFROM | MSEG | MANDT | OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) | MANDT |
| OIH_S_GOITEM_TDP | OITAXFROM | OIH_S_GOITEM_TDP | OITAXFROM | OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) | TAXKEY |
| OIH_S_GOITEM_TDP | OITAXGRP | MSEG | MANDT | OIH2 | Excise duty tax group (IS-Oil TDP standard/core object) | MANDT |
| OIH_S_GOITEM_TDP | OITAXGRP | OIH_S_GOITEM_TDP | OITAXGRP | OIH2 | Excise duty tax group (IS-Oil TDP standard/core object) | TAXGRP |
| OIH_S_GOITEM_TDP | OITAXTO | MSEG | MANDT | OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) | MANDT |
| OIH_S_GOITEM_TDP | OITAXTO | OIH_S_GOITEM_TDP | OITAXTO | OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) | TAXKEY |
