FIKZD_REGINV_IN SAP (Incoming Invoice Registration Journal) Table details

Dictionary Type: Table
Description: Incoming Invoice Registration Journal




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




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

FIKZD_REGINV_IN is a standard SAP Table which is used to store Incoming Invoice Registration Journal data and is available within R/3 SAP systems depending on the version and release level.

The FIKZD_REGINV_IN table consists of various fields, each holding specific information or linking keys about Incoming Invoice Registration Journal data available in SAP. These include BUKRS (Company Code), GJAHR (Fiscal Year), NUM (Number), VEND_TYPE (Resident Vendor).. 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 FIKZD_REGINV_IN 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 BUKRSCHAR4T001BUKRSBUKC_T001
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
NUMNumber FIKZ_NUMNUMC10NUM10
VEND_TYPEResident Vendor FIKZ_REGINV_VEND_TYPECHAR1FIKZ_REGINV_VEND_TYPE
VAT_AMNT_DEDUCTVAT Amount to be Deducted FIKZ_REGINV_VAT_AMNT_DEDUCTCURR15(2) WERTV8
CUSTOMS_DECLCustoms Declaration Info FIKZ_REGINV_DECL_NUMCHAR255TEXT255
EXCISE_AMNTExcise Amount in Local Currency FIKZ_REGINV_EXCISECURR15(2) WERTV8
INV_BELNROriginal FI Document FIKZ_REGINV_INV_BELNRCHAR10BKPFALPHABELNR
INV_GJAHROriginal FI Document Year FIKZ_REGINV_INV_GJAHRNUMC4GJAHRGJAHR
INVADD_BELNRAdditional FI Document FIKZ_REGINV_INVADD_BELNRCHAR10BKPFALPHABELNR
INVADD_GJAHRAdditional FI Document Year FIKZ_REGINV_INVADD_GJAHRNUMC4BKPFGJAHRGJAHR
CORR_BELNRRevised FI Document Number FIKZ_REGINV_CORR_BELNRCHAR10BKPFALPHABELNR
CORR_GJAHRRevised FI Document Year FIKZ_REGINV_CORR_GJAHRNUMC4GJAHRGJAHR
INV_TYPELine Type FIKZ_REGINV_INV_TYPECHAR1FIKZ_REGINV_INV_TYPE
DATE_REGRegistration Date in Journal FIKZ_REGINV_INV_REGDATEDATS8DATUM
INV_NUMVAT Invoice Number FIKZ_REGINV_INV_NUMCHAR50TEXT50
INV_DATEVAT Invoice Date FIKZ_REGINV_INV_DATEDATS8DATUM
INVADD_NUMAdditional VAT Invoice Number FIKZ_REGINV_INVADD_NUMCHAR50TEXT50
INVADD_DATEAdditional VAT Invoice Date FIKZ_REGINV_INVADD_DATEDATS8DATUM
CORR_DATERevision Date FIKZ_REGINV_CORR_DATEDATS8DATUM
CONTR_NUMExternal Contract Number J_3RF_EXTCNTNUMCHAR40Assigned to domainJ_3RF_EXTCNTNUMJ_3RF_CNT_SH
CONTR_DATEContract Date J_3RF_CNTDATDATS8DATUM
PARTN_NAMEPartner Name FIKZ_REGINV_CUST_NAMECHAR160CHAR160_LOWER_CASE
PARTN_RNNPartner RNN FIKZ_RNNCHAR12CHAR12
PARTN_INNPartner INN FIKZ_INNCHAR12CHAR12
PARTN_KPPPartner KPP FIKZ_KPPCHAR9CHAR9
PARTN_UNPPartner UNP FIKZ_REGINV_CUST_UNPCHAR9CHAR9
PARTN_BINPartner BIN FIKZ_BINCHAR12CHAR12
PARTN_IINPartner IIN FIKZ_IINCHAR12CHAR12
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
CURR_CODELocal Currency HWAER_CURDCUKY5TCURCWAERSFWS
CURR_CODE_FDocument Currency TWCURCUKY5TCURCWAERS
EXCH_RATEExchange rate for FI postings KURRFDEC9(5) KURRF
BASE_AMNT_LCInvoice Amount Without VAT in Local Currency FIKZ_REGINV_BASE_AMNT_LCCURR15(2) WERTV8
VAT_AMNT_LCVAT Amount in Local Currency FIKZ_REGINV_VAT_AMNT_LCCURR15(2) WERTV8
GROSS_AMNT_LCTotal Invoice Amount, Including VAT in Local Currency FIKZ_REGINV_GROSS_AMNT_LCCURR15(2) WERTV8
BASE_AMNT_FCInvoice Amount without VAT in Document Currency FIKZ_REGINV_BASE_AMNT_FCCURR15(2) WERTV8
VAT_AMNT_FCVAT Amount in Document Currency FIKZ_REGINV_VAT_AMNT_FCCURR15(2) WERTV8
GROSS_AMNT_FCTotal Invoice Amount, Including VAT, in Document Currency FIKZ_REGINV_GROSS_AMNT_FCCURR15(2) WERTV8
ACTIVITY_TYPEActivity Type FIKZ_REGINV_ACTIVITY_TYPECHAR1FIKZ_REGINV_ACTIVITY_TYPE
USNAMUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
TMSTMPTime Stamp FIKZ_TMSTMPCHAR14TIMESTAMP
LANDPartner country of registration FIKZ_PARTN_REG_COUNTRYCHAR3T005LAND1
STATVendor Status FIKZ_REGINV_PARTNERSTATCHAR1FIKZ_REGINV_PARTNERSTAT
VATOFFSET_DATEVAT Reporting Date FIKZ_REGINV_VATOFFSET_DATEDATS8DATUM
APPX7_SEQ_NUMDocument Sequence Number in Declaration FIKZ_REGINV_APPX7_SEQ_NUMNUMC8NUM8
DECL_QUARTDeclaration Quarter FIKZ_REGINV_DECL_QUARTNUMC1FIKZ_REGINV_DECL_QUART
DECL_YEARDeclaration Year FIKZ_REGINV_DECL_YEARNUMC4GJAHRGJAHR
DECL_TYPEDeclaration Type FIKZ_RETTYPENUMC1FIKZ_RETTYPE
DECL_SUBMIT_DATEDeclaration Submit Date in Tax Office FIKZ_REGINV_DECL_SUBMIT_DATEDATS8DATUM
AUTOPOSTMark when Document was Modified Automatically FIKZ_REGINV_AUTOPOSTCHAR1FIKZ_REGINV_MODIF_FLG
REVERSALMark that Document is Reversal FIKZ_REGINV_REVERSALCHAR1FIKZ_REGINV_REVERSAL
APPD_NUMAppendix Number FIKZ_APP_NUMNUMC2NUMC2
ADD_INFOAdditional Information FIKZ_REGINV_ADD_INFOCHAR140TEXT140

Key field Non-key field



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

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

SELECT SINGLE *
FROM FIKZD_REGINV_IN
INTO CORRESPONDING FIELDS OF WA_FIKZD_REGINV_IN
WHERE...

How to access SAP table FIKZD_REGINV_IN

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