J_1IRG23D

RG23D register for the depot | #transactional | Component: Logistics India
Column Name Description
MANDT FK Client
TRNTYP FK Excise Transaction Type
DOCYR Document year - GR for depot
DOCNO FK Internal number - GR for delivery at depot
ZEILE Item number - GR at depot
VBELN Delivery
POSNR Delivery Item
MBLNR Number of Material Document
MJAHR Material Document Year
MZEILE Item in Material Document
WERKS FK Plant
FOLIO Register Entry Serial Number
SERIALNO Item in Material Document
Column Name Description
💲 Currency (EXCUR):
EXBAS Excise Duty Base Amount
EXBED Basic Excise Duty
EXSED Special Excise Duty
EXAED Additional Excise Duty
CESS Cess amount
NCCD NCCD Value
ECS ECS Value
EXADDTAX1 Additional Tax1 value
EXADDTAX2 Additional Tax2 value
EXADDTAX3 Additional Tax3 value
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Quantity
Column Name Description
REMTIME Time of Removal
RDATE Posting date in the reference document
CPUDT Excise Document Entry Date
Column Name Description
DOWNL Download indicator Show values
STATUS Excise Document Status Show values
Column Name Description Domain name
EXGRP Excise Group J_1IEXCGRP
EXNUM Official Excise Document Number J_1IEXCNUM
EXYEAR Excise Year GJAHR
SRGRP Excise Document Series Group J_1ISERGRP
DEPEXNUM Official Excise Document Number J_1IEXCNUM
DEPEXYEAR Excise Year GJAHR
LIFNR Vendor J_1ILIFNR
SHIPFROM Account Number of Supplier LIFNR
MAKTX Material Description TEXT40
CHAPID Chapter ID CHAR12
BEDRAT BED percentage PRZ34
AEDRAT Additional Excise Duty % PRZ34
SEDRAT Special Excise Duty % PRZ34
CESSRATE Cess Rate PRZ34
RG23ASER RG23A serial no. NUMC10
RG23CSER RG23C serial no. NUMC10
RGPLASER PLA serial no. NUMC10
RDOC Reference Document 1 CHAR10
REF_FOLIO Register Entry Serial Number NUMC10
REF_SERIAL Item in Material Document MBLPO
USNAM Created By CHAR12
NCCDRATE NCCD Rate in % PRZ34
ECSRATE ECS rate in % PRZ34
EXADDRATE1 AT1 rate in % PRZ34
EXADDRATE2 AT2 rate in % PRZ34
EXADDRATE3 AT3 rate in % PRZ34
Master Data Relations Join Conditions
Currency
  • J_1IRG23D.MANDT == TCURC.MANDT
  • J_1IRG23D.EXCUR == TCURC.WAERS
Client J_1IRG23D.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • J_1IRG23D.MATNR == MARA.MATNR
  • J_1IRG23D.MANDT == MARA.MANDT
Base Unit of Measure
  • J_1IRG23D.MANDT == T006.MANDT
  • J_1IRG23D.MEINS == T006.MSEHI
Plant
  • J_1IRG23D.MANDT == T001W.MANDT
  • J_1IRG23D.WERKS == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Excise Transaction Type
  • Excise Transaction Type
  • Client