FKKJOURNAL_ALV SAP (Document Journal: ALV List) Structure details

Dictionary Type: Structure
Description: Document Journal: ALV List




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




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

FKKJOURNAL_ALV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Document Journal: ALV List" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FKKJOURNAL_ALV TYPE FKKJOURNAL_ALV.

The FKKJOURNAL_ALV table consists of various fields, each holding specific information or linking keys about Document Journal: ALV List data available in SAP. These include OPBEL (Number of Contract Accts Rec. & Payable Doc.), OPPOS (Item Category), OPUPW (Repetition Item in Contract Account Document), OPUPK (Item number in contract account document).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FKKJOURNAL_ALV structure 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
FIKEYReconciliation Key for General Ledger FIKEY_KKCHAR12Assigned to domainFIKEY_KKFKFI1
OPBELNumber of Contract Accts Rec. & Payable Doc. OPBEL_KKCHAR12Assigned to domainALPHAOPBEL_KK80B
OPPOSItem Category OPPOS_KKCHAR2OPPOS_KK
OPUPWRepetition Item in Contract Account Document OPUPW_KKNUMC3OPUPW_KK
OPUPKItem number in contract account document OPUPK_KKNUMC4OPUPK_KK
OPUPZSubitem for a Partial Clearing in Document OPUPZ_KKNUMC3OPUPZ_KK
OPAUGClearing Status OPAUG_KKCHAR1OPAUG_KK
FIKSTStatus of Summary Records for Reconciliation Key FIKST_KKCHAR1FIKST_KK
SUMSZNumber of Summary Records for Reconciliation Key SUMSZ_KKINT410INT4
CPUDTDate of entry (CPU date) CPUDT_KKDATS8DATUM
XERROTable DFKKSUM Not Completely Updated XERRO_KKCHAR1XFELD
KORLVHighest assigned correction level KORLV_KKNUMC2NUM02
UEBISPosting Date Up To Which Data Was Transferred To G/L UEBIS_KKDATS8DATUM
UEKLVTransferred Up To Correction Level UEKLV_KKNUMC2NUM02
XUEVOTransfer all data to general ledger XUEVO_KKCHAR1XFELD
XCLOSNo Further Postings Allowed XCLOS_KKCHAR1XFELD
RESOBReservation Object RESOB_KKCHAR3RESOB_KK
RESKYKey of Object That Used the Reconciliation Key RESKY_KKCHAR30CHAR30
XARCHDocuments Already Archived XARCH_KKCHAR1XFELD
USNAMName of the User who Created the Reconciliation Key USNAM_KKCHAR12USNAM
CLDATDate on which the Reconciliation Key was Closed CLDAT_KKDATS8DATUM
CLTIMTime at which the Reconciliation Key was Closed CLTIM_KKTIMS6UZEIT
CLNAMUser who Closed the Reconciliation Key CLNAM_KKCHAR12UNAME
UECPUCPU date of the last transfer run UECPU_KKDATS8DATUM
BLCNTCounter for documents transferred to G/L BLCNT_KKNUMC7NUM07
COCNTNumber of Accounting Calls for CO-PA COCNT_KKNUMC7NUM07
XUECOPAData Transferred to Profitability Analysis (CO-PA) XUECOPA_KKCHAR1XUECOPA_KK
XMISSNot all documents are contained in the totals XMISS_KKCHAR1XFELD
COMPLETEStatus Of Detail Structures For Reconciliation Key COMPLETE_KKCHAR1COMPLETE_KK
XEXTKONTAdjustments Allowed When Transferring To General Ledger XEXTKONT_KKCHAR1BOOLE
XKORRReconciliation Key Corrected with RFKKGL20 XKORR_KKCHAR1XFELD
UEBPANRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
UEBPADATDate DATUMDATS8DATUM
STATIStatus Icon STATI_KKCHAR4Assigned to domainICON
APPLKApplication area APPLK_KKCHAR1APPLK_KK
BLARTDocument Type BLART_KKCHAR2Assigned to domainBLART_KK
HERKFDocument Origin Key HERKF_KKCHAR2Assigned to domainHERKF_KK
CPUTMTime of Entry CPUTMTIMS6UZEIT
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
WAERSTransaction Currency BLWAE_KKCUKY5Assigned to domainWAERSFWS
WWERTTranslation Date WWERT_DDATS8DATUM
XBLNRReference document number XBLNR_KKCHAR16ALPHAXBLNR_KK
RLGRDReturn reason RLGRD_KKCHAR3Assigned to domainRLGRD_KK
ABGRDPosting Reason (For Write-Offs And Transfer Postings) BUGRD_KKCHAR2BUGRD_KK
XEIBHCreate Separate Document in General Ledger XEIBH_KKCHAR1XFELD
XBWERDocument Created by Foreign Currency Valuation or Reclass. XBWER_KKCHAR1XBWER_KK
AWTYPReference Transaction AWTYPCHAR5Assigned to domainAWTYP
AWKEYReference Key AWKEYCHAR20AWKEY
STBELNumber of Reversed Document STBEL_KKCHAR12Assigned to domainALPHAOPBEL_KK
STMETReversal Method Selected Internally STMET_INT_KKCHAR1STMET_INT_KK
BLTYPDocument Class BLTYP_KKCHAR1BLTYP_KK
AGINFClearing Information AGINF_KKCHAR1AGINF_KK
STBUKTax Company Code STBUK_KKCHAR4Assigned to domainBUKRSBUK
STORBNumber of Reversal Document STORB_KKCHAR12Assigned to domainALPHAOPBEL_KK
APPDXExisting document supplements APPDX_KKCHAR1APPDX_KK
XMBELSample document XMBEL_KKCHAR1XFELD
AWSYSLogical system of source document AWSYSCHAR10Assigned to domainALPHALOGSYS
VERSNVersion Number VERSN_KKCHAR3CHAR3
BRANCHBusiness Place J_1BBRANC_CHAR4Assigned to domainJ_1BBRANCH
C4EYECheck Reason for Workflows Acc. to Dual Control Principle C4EYE_KKCHAR2Assigned to domainC4EYE_KK
C4EYPEditing Process To Be Confirmed C4EYP_KKCHAR1C4EYP_KK
TATYPTransaction Class of Document TATYP_KKCHAR1TATYP_KK
HBBLADocument Type for Transfer to General Ledger HBBLA_KKCHAR2Assigned to domainBLART
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
BUPLABusiness Place BUPLACHAR4Assigned to domainJ_1BBRANCH
SEGMENTSegment for Segmental Reporting SEGMT_KKCHAR10Assigned to domainALPHAFB_SEGMENT
AUGSTClearing status AUGST_KKCHAR1AUGST_KK
GPARTBusiness Partner Number GPART_KKCHAR10Assigned to domainALPHABU_PARTNERBPA
GPARTTText for business partner GPTXT_KKCHAR55GPTXT_KK
VTREFReference Specifications from Contract VTREF_KKCHAR20ALPHAVTREF_KKVTZ
VTRE2Additional Reference Information VTRE2_KKCHAR20ALPHAVTREF_KK
VKONTContract Account Number VKONT_KKCHAR12Assigned to domainALPHAVKONT_KKKTOFKKVKP_F4
ABWBLNumber of the substitute FI-CA document ABWBL_KKCHAR12ALPHAABWBL_KK
ABWTPCategory of substitute document in FI-CA ABWTP_KKCHAR1ABWTP_KK
ABWKTAlternative contract account for collective bills ABWVK_KKCHAR12Assigned to domainALPHAVKONT_KK
HVORGMain Transaction for Line Item HVORG_KKCHAR4Assigned to domainHVORG_KK8HV
TVORGSubtransaction for Document Item TVORG_KKCHAR4Assigned to domainTVORG_KK
KOFIZAccount Determination ID KOFIZ_KKCHAR2KOFIZ_KK
SPARTDivision SPART_KKCHAR2Assigned to domainSPARTSPA
HKONTGeneral ledger account HKONT_KKCHAR10Assigned to domainALPHASAKNRSAKO
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
MWSZKZSupplementary Tax MWSZKZ_KKCHAR2Assigned to domainMWSKZ
XANZAItem is a Down Payment/Down Payment Request XANZA_KKCHAR1XFELD
STAKZType of statistical item STAKZ_KKCHAR1STAKZ_KK
BLDATDocument Date in Document BLDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
OPTXTItem text OPTXT_KKCHAR50TEXT50
FAEDNDue date for net payment FAEDN_KKDATS8DATUM
FAEDSDue Date for Cash Discount FAEDS_KKDATS8DATUM
VERKZItem Can Only Be Cleared VERKZ_KKCHAR1VERKZ_KK
STUDTDeferral to STUDT_KKDATS8DATUM
SKTPZCash discount rate SKTPZ_KKDEC5(3) PRZ23
XMANLExclude Item from Dunning Run XMANL_KKCHAR1XFELD
XCSHADocument Contains Assignments from Cash Flows XCSHA_KKCHAR1XFELD
REACCOriginating Account in Cash Flow Anlaysis REACC_KKCHAR10Assigned to domainALPHASAKNR
REBUKPartner Company Code for Cash Flow Analysis REBUK_KKCHAR4Assigned to domainBUKRS
KURSFExchange rate KURSF_KKDEC9(5) EXCRTKURSF
BETRHAmount In Local Currency With +/- Signs BETRH_KKCURR13(2) WRTV7
WAERHLocal currency WAERHCUKY5Assigned to domainWAERS
BETRWAmount in Transaction Currency with +/- Sign BETRW_KKCURR13(2) WRTV7
BETR2Amount in second parallel currency with +/- sign BETR2_KKCURR13(2) WRTV7
BETR3Amount in third parallel currency with +/- sign BETR3_KKCURR13(2) WRTV7
SKFBTAmount eligible for cash discount in document currency SKFBT_KKCURR13(2) WRTV7
SBETHTax Amount in Local Currency With +/- Sign SBETH_KKCURR13(2) WRTV7
SBETWTax Amount in Transaction Currency with +/- Sign SBETW_KKCURR13(2) WRTV7
SBET2Tax amount in second parallel currency SBET2_KKCURR13(2) WRTV7
SBET3Tax amount in third parallel currency SBET3_KKCURR13(2) WRTV7
MWSKOAccount for posting taxes for down payments MWSKO_KKCHAR10Assigned to domainALPHASAKNR
MWVKOAccount for offsetting tax posting in down payments MWVKO_KKCHAR10Assigned to domainALPHASAKNR
TXRULUpdate Rule for Tax and Tax Clearing TXRUL_KKCHAR1TXRUL_KK
SPZAHLock Reason for Automatic Payment SPZAH_KKCHAR1Assigned to domainSPZAH_KK
PYMETPayment Method PYMET_KKCHAR1Assigned to domainPYMET_KK
PYBUKCompany Code for Automatic Payment Transactions PYBUK_KKCHAR4Assigned to domainBUKRS
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
GRKEYGrouping Key for Displaying Open Items GRKEY_KKCHAR3CHAR3
PERSLKey for Period Assignment PERSL_KKCHAR4Assigned to domainPERSL_KK
XAESPPrinting - No Changes Possible XAESP_KKCHAR1XFELD
AUGDTClearing date AUGDT_KKDATS8DATUM
AUGBLClearing Document or Printed Document AUGBL_KKCHAR12ALPHAAUGBL_KK
AUGBDClearing document posting date AUGBD_KKDATS8DATUM
AUGRDClearing Reason AUGRD_KKCHAR2Assigned to domainAUGRD_KK
AUGWAClearing currency AUGWA_KKCUKY5Assigned to domainWAERS
AUGBTClearing amount in clearing currency AUGBT_KKCURR13(2) WRTV7
AUGBSTax amount in clearing currency AUGBS_KKCURR13(2) WRTV7
AUGSKCash Discount Granted/Surcharge Levied in Clearing Currency AUGSK_KKCURR13(2) WRTV7
AUGVDValue date for clearing AUGVD_KKDATS8DATUM
AUGOBItem Canceled AUGOB_KKCHAR1XFELD
WHANGNumber of repetition items WHANG_KKNUMC3NUM03
WHGRPRepetition group WHGRP_KKNUMC3Assigned to domainWHGRP_KK
XEIPHCreate Line Item in General Ledger XEIPH_KKCHAR1XFELD
MAHNVDunning Procedure MAHNV_KKCHAR2Assigned to domainMAHNV_KKFKK_MAHNV
MANSPDunning Lock Reason MANSP_KKCHAR1Assigned to domainMANSP_KK
XAUGPCheck Sample Record Clearing XAUGP_KKCHAR1XFELD
ABRZULower Limit of Settlement Period ABRZU_KKDATS8DATUM
ABRZOUpper Limit of the Billing Period ABRZO_KKDATS8DATUM
FDGRPPlanning Group FDGRP_KKCHAR10Assigned to domainALPHAFDGRPFFG
FDLEVPlanning level FDLEV_KKCHAR2Assigned to domainFDLEVFFE
FDZTGAdditional Days for Cash Management FDZTG_KKNUMC2NUM2
FDWBTPlanning amount in document currency FDWBTCURR13(2) WERTV7
XTAUSItem Split XTAUS_KKCHAR1XFELD
AUGRSClearing restriction AUGRS_KKCHAR1AUGRS_KK
PYGRPGrouping field for automatic payments PYGRP_KKCHAR10CHAR10
PDTYPCategory of Payment Specification PDTYP_KKCHAR1PDTYP_KK
SPERZInterest Lock Reason SPERZ_KKCHAR1Assigned to domainSPERZ_KK
INFOZDoubtful Item Entry/Individual Value Adjustment INFOZ_KKNUMC3INFOZ_KK
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
TXDATDecisive Date for Calculating Taxes TXDAT_KKDATS8DATUM
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
KONTTAccount Assignment Category KONTT_KKCHAR2Assigned to domainKONTT_KK
KONTLAcct assnmnt string for industry-specific account assngments KONTL_KKCHAR50CHAR50
OPSTADunning indicator OPSTA_KKCHAR3OPSTA_KK
EMGPAAlternative Business Partner for Payments EMGPA_KKCHAR10Assigned to domainALPHABU_PARTNERBUPA
EMBVTBank Details ID of Payee EMBVT_KKCHAR4CHAR4
EMADRAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
IKEYInterest Key IKEY_KKCHAR2Assigned to domainIKEY_KK
EUROUStatus of Euro Conversion EUROU_KKCHAR1EUROU_KK
XRAGLClearing posting reversed XRAGL_KKCHAR1XFELD
ASTKZStatistical Key of the Initiating Item ASTKZ_KKCHAR1ASTKZ_KK
ASBLGNumber of Triggering Document ASBLG_KKCHAR12Assigned to domainALPHAOPBEL_KK
INKPSCollection Item INKPS_KKNUMC3NUM03
RNDPSType of Rounding Item RNDPS_KKCHAR1RNDPS_KK
QSSKZWithholding Tax Code QSSKZCHAR2Assigned to domainQSSKZ
QSSEWWithholding Tax Supplement QSSEW_KKCHAR2Assigned to domainQSSEW_KK
QSPTPLine Item Category From Withholding Tax View QSPTP_KKCHAR1QSPTP_KK
QSSHBTax Base Amount QSSHB_KKCURR13(2) WRTV7
QBSHBWithholding Tax Amount (in Document Currency) QBSHB_KKCURR13(2) WRTV7
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
RFUPKReference Item In FI-CA Document RFUPK_KKNUMC4OPUPK_KK
STRKZTax Code for Other Taxes STRKZ_KKCHAR2Assigned to domainSTRKZ_KK
FITPRTax type J_1AFITP_DCHAR2Assigned to domainJ_1AFITP
XPYORItem Included in a Payment Order XPYOR_KKCHAR1XPYOR_KK
LANDLCountry Supplied (for Tax Notifications) LANDL_KKCHAR3Assigned to domainLAND1
INTBUReason for Automatic Creation of Posting INTBU_KKCHAR1INTBU_KK
EMCRDAlternative Payment Card ID in Document EMCRD_KKCHAR6CHAR6
SCTAXTax Portion in FI-CA Local Currency SCTAX_KKCURR13(2) WRTV7
STTAXTax Amount as Statistical Information in Document Currency STTAX_KKCURR13(2) WRTV7
STZALStatus of Payment Processing STZAL_KKCHAR1STZAL_KK
ORUPZSubitem Number before Item Split ORUPZ_KKCHAR3CHAR3
NEGBUControl Field for Negative Posting NEGBU_KKNUMC1NEGBU_KK
SUBAPSubapplication in Contract Accounts Receivable and Payable SUBAP_KKCHAR1SUBAP_KK8SA
PSWSLUpdate Currency for General Ledger Transaction Figures PSWSL_KKCUKY5Assigned to domainWAERS
PSWBTAmount for Updating in General Ledger PSWBT_KKCURR13(2) WRTV7
PSWTXTax Amount for Update in General Ledger PSWTX_KKCURR13(2) WRTV7
PSGRPGrouping Key for Document Items PSGRP_KKCHAR4CHAR4
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
KDAUFSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
KDEINDelivery Schedule for Sales Order KDEINNUMC4NUM04
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PASUBNRProfitability segment changes (CO-PA) RKESUBNRNUMC4RKESUBNR
VALUTValue date VALUTDATS8DATUM
TXJCOTax Jurisdiction Code (Entered value) TXJCO_KKCHAR15Assigned to domainTXJCD
TXCNTLevel Counter for Multi-Level Taxes in Tax Jurisdiction TXCNT_KKNUMC1NUM01
TXEXKKey for tax exception TXEXK_KKCHAR16CHAR16
SBASHAmount Subject to Tax in Local Currency (Tax Base Amount) SBASH_KKCURR13(2) WRTV7
SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt) SBASW_KKCURR13(2) WRTV7
KTOSLTransaction key for account determination KTOSL_KKCHAR3CHAR3
STPRZTax rate STPRZ_KKNUMC6STPRZ_KK
VATDATETax Reporting Date VATDATE_KKDATS8DATUM
KSCHLCondition Type KSCHLCHAR4Assigned to domainKSCHLVKS
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
XINTBItem Created by Posting Interface XINTB_KKCHAR1XFELD
XCOPACO-PA update done directly XCOPA_KKCHAR1XFELD
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
COUNCCounty Code COUNCCHAR3Assigned to domainCOUNC
GRICDActivity Code for Gross Income Tax J_1AGICD_DCHAR2Assigned to domainJ_1AGICD2
GITYPDistribution Type for Employment Tax J_1ADTYP_DCHAR2Assigned to domainJ_1ADTYP
INVGRGrouping Key for Invoicing INVGR_KKCHAR4CHAR4
FINREContract Account of Final Recipient FINRE_KKCHAR12Assigned to domainALPHAVKONT_KKFKKVKP_F4
RDSTACurrent Distribution Status RDSTA_KKCHAR1RDSTAT_KK
RDSTBLast Distribution Status Reported RDSTB_KKCHAR1RDSTAT_KK
FMTYPUpdate Method for FM - FI-CA Integration FMTYP_KKCHAR2FMTYP_KK
ORIGFIKRSOriginal FM Area for FM Account Assignment ORIGFIKRS_KKCHAR4Assigned to domainFIKRS
FIPEXCommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
FONDSFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
MEASUREFunded Program FM_MEASURECHAR24Assigned to domainFM_MEASUREFM_MEASURE
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
BUDGETYEAROriginal Year for FM Account Assignment FM_START_OF_CHAINNUMC4GJAHRGJAHR
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER

Key field Non-key field



How do I retrieve data from SAP structure FKKJOURNAL_ALV using ABAP code?

As FKKJOURNAL_ALV is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FKKJOURNAL_ALV as there is no data to select.

How to access SAP table FKKJOURNAL_ALV

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