OIRADBT - Document base table

Document base table information is stored in SAP table OIRADBT.
It is part of development package OIR in software component IS-OIL-DS-SSR. This development package consists of objects that can be grouped under "SSR Service Station Retailing (master/overall)".

Fields for table OIRADBT

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6*
LINKNRLink numberXOIRA_LINKNRNUMC20
ITLINKNRItem link numberXOIRA_ITLINKNRNUMC12*
LINKYEARDocument link number yearXOIRA_JAHRNUMC8
.INCLUDEROIRA_DBT_DATA0
PBLNRBusiness location identifier (IS-Oil MRN)OIF_PBLNRCHAR20*
DATATYPEData typeOIRA_DATATYPECHAR6
SRCETABSource tableOIRA_SRCETABCHAR32
RNBTBusiness typeOIRA_RNBTCHAR8*
PARFNMRN business partner role / relation typeOIF_PARFNCHAR8*
FTMSTMStart of partner function validity period: time stampOIF_FTMSTMNUMC28
PARPOSPartner counterOIF_PARPOSNUMC6
MATNRMaterial NumberMATNRCHAR80*
STYPService typeOIRA_STYPCHAR8*
VKDATSSR PC: Sales date at the service stationOIRE_VKDATDATS16
WERKSPlantWERKS_DCHAR8*
LGORTStorage locationLGORT_DCHAR8*
BUKRSCompany CodeBUKRSCHAR8*
CHOBJSSR PC: Clearing houseOIRE_CHOBJCHAR12*
SSR_CCINSSSR PC: Payment card typeOIRE_CCINSCHAR8*
STORNOSSR PC: Reversal indicatorOIRE_STORNOCHAR2
COMPFLComplaint indicator for OIRADBT entriesOIRA_COMPFLCHAR2
VRKMESales unitVRKMEUNIT6*
DCINDDebit/Credit indicatorOIRA_DCINDCHAR2
KBETRCondition Amount or PercentageKBETRCURR6
KONWACondition Unit (Currency or Percentage)KONWACUKY10*
KPEINCondition Pricing UnitKPEINDEC3
KMEINCondition UnitKMEINUNIT6*
MENGESSR PC: Quantity sold at the business locationOIRE_MENGEQUAN7
BRTWRSSR PC: Gross valueOIRE_BRTWRCURR7
STPARTPROCPartially processed indicator for Settlement transmissionOIRE_SETTRANPARTPROCCHAR2
SEQNRGMM: Sequence number of meter assigned to customerOII_GSEQNRCHAR20
TNKNRSequence number of SO assigned to business locationOII_BSEQNRCHAR20
HDRNRSSR PC: DTF payment card transaction number (internal)OIRE_UPLNRCHAR20
ITMNRItem number of the SD documentPOSNRNUMC12*
GMMNRGMM: Number of general meterOII_GMMNRCHAR40*
ITMSTMUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPDEC8
METREVSSR: Meter event typeOIRC_METREVCHAR4*
TRANSYEARDocument link number yearOIRA_JAHRNUMC8
SOCNRSOC: Storage object characteristic segment numberOII_SOCNRCHAR40*
ETMSTMSSR Stocks - Tank dip time stampOIRC_TMSTMDEC8
SOCEVSOC eventOII_SOCEVCHAR4*
KWAEHCondition Currency (for Cumulation Fields)KWAEHCUKY10*
SRCD_DATESSR - Source data dateOIRA_SRCD_DATEDATS16
SRCD_TIMESSR - Source date timeOIRA_SRCD_TIMETIMS12
COUNTERTransaction counterOIRA_COUNTERINT44
PROCINDProcessed record indicatorOIRA_PROCINDCHAR2
.INCLUDEOIRA_DBT_CUST0
OIRA_CUSTDummy function in length 1DUMMYCHAR2
.INCLUDEOIRA_DBT_IND0
IS01Subsequent process indicator for document base tableOIRA_INDCHAR2
MM01Subsequent process indicator for document base tableOIRA_INDCHAR2
MM02Subsequent process indicator for document base tableOIRA_INDCHAR2
PC02Subsequent process indicator for document base tableOIRA_INDCHAR2
.INCLUDECI_OIRA_DBT_IND0
Privacy Policy