IDCN_S_DOCALV SAP (Accounting Document at Segment Level) Structure details

Dictionary Type: Structure
Description: Accounting Document at Segment Level




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




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

IDCN_S_DOCALV 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 "Accounting Document at Segment Level" 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_IDCN_S_DOCALV TYPE IDCN_S_DOCALV.

The IDCN_S_DOCALV table consists of various fields, each holding specific information or linking keys about Accounting Document at Segment Level data available in SAP. These include BUKRS (Company Code), BELNR (Accounting Document Number), GJAHR (Fiscal Year), BUZEI (Number of Line Item Within Accounting 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 IDCN_S_DOCALV 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
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRS_ALVCHAR4Assigned to domainBUKRS
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
DOCLNDOCLN for ALV Grid Control DOCLNALVCHAR6DOCLN6
AUGBLDocument Number of the Clearing Document AUGBLCHAR10ALPHABELNR
BSCHLPosting Key BSCHLCHAR2TBSLBSCHL
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
KOARTAccount Type KOARTCHAR1KOART
UMSKZSpecial G/L Indicator UMSKZCHAR1T074UUMSKZ
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
PARGBTrading partner's business area PARGBCHAR4TGSBGSBERGSB
MWSKZTax on sales/purchases code MWSKZCHAR2T007AMWSKZ
QSSKZWithholding Tax Code QSSKZCHAR2T059QQSSKZ
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
VALUTValue date VALUTDATS8DATUM
ZUONRAssignment Number DZUONRCHAR18ZUONR
SGTXTItem Text SGTXTCHAR50TEXT50
VBUNDCompany ID of trading partner RASSCCHAR6T880ALPHARCOMPPGS
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
VBELNBilling Document VBELN_VFCHAR10VBUKALPHAVBELNVF
VBEL2Sales Document VBELN_VACHAR10VBUKALPHAVBELNAUN
POSN2Sales Document Item POSNR_VANUMC6VBUPPOSNRAPO
ETEN2Delivery Schedule Line Number ETENRNUMC4VBEPETENR
XSKRLIndicator: Line item not liable to cash discount? XSKRLCHAR1XFELD
XZAHLIndicator: Is the posting key used in a payment transaction? XZAHLCHAR1XFELD
SAKNRG/L Account Number SAKNRCHAR10SKB1ALPHASAKNRSAKC_SAKNR
FILKDAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
ZBD1TCash discount days 1 DZBD1TDEC3ZBDXT
ZBD2TCash discount days 2 DZBD2TDEC3ZBDXT
ZBD3TNet Payment Terms Period DZBD3TDEC3ZBDXT
ZBD1PCash Discount Percentage 1 DZBD1PDEC5(3) PRZ23
ZBD2PCash Discount Percentage 2 DZBD2PDEC5(3) PRZ23
ZLSCHPayment Method SCHZW_BSEGCHAR1T042ZZLSCH
ZLSPRPayment Block Key DZLSPRCHAR1T008ZAHLSSPE
ZBFIXFixed Payment Terms DZBFIXCHAR1ZBFIX
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
SAMNRInvoice List Number SAMNRNUMC8SAMNR
ANFBNDocument Number of the Bill of Exchange Payment Request ANFBNCHAR10ALPHABELNR
MSCHLDunning key MSCHLCHAR1T040MSCHL
MANSPDunning block MANSPCHAR1T040SMANSP
MANSTDunning level MAHNS_DNUMC1MAHNS
MABERDunning Area MABERCHAR2Assigned to domainMABER
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
SPGRPBlocking reason: price SPGRPCHAR1XFELD
SPGRMBlocking reason: quantity SPGRMCHAR1XFELD
SPGRTBlocking Reason: Date SPGRTCHAR1XFELD
SPGRGBlocking reason: order price quantity SPGRGCHAR1XFELD
SPGRVBlocking reason: project budget SPGRVCHAR1XFELD
SPGRQManual Blocking Reason SPGRQCHAR1XFELD
RSTGRReason Code for Payments RSTGRCHAR3T053RRSTGR
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
VNAMEJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
EGRUPEquity group JV_EGROUPCHAR3Assigned to domainALPHAJV_EGROUPGJE
BTYPEPayroll Type JV_BILINDCHAR2Assigned to domainALPHAJV_BILIND
RECIDRecovery Indicator JV_RECINDCHAR2Assigned to domainALPHAJV_RECIND
VPTNRPartner account number JV_PARTCHAR10Assigned to domainALPHAKUNNR
VERTTContract Type RANTYPCHAR1RANTYP
VERTNContract Number RANLCHAR13ALPHARANLRAN
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
DABRZReference Date for Settlement DABRBEZDATS8DDAT
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
NPLNRNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
AUFPLTask list number for operations in order AUFPL_CHNUMC10AUFPL
APLZLGeneral counter for order APLZL_CHNUMC8Assigned to domainCO_APLZL
UZAWEPayment Method Supplement UZAWECHAR2T042FUZAWE
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
STBUKTax Company Code STBUKCHAR4Assigned to domainBUKRSBUK
XREF1Business partner reference key XREF1CHAR12CHAR12
XREF2Business partner reference key XREF2CHAR12CHAR12
EMPFBPayee/Payer EMPFBCHAR10ALPHAMAXKK
XREF3Reference key for line item XREF3CHAR20CHAR20
PYCURCurrency for Automatic Payment PYCURCUKY5TCURCWAERS
PYAMTAmount in Payment Currency PYAMTCURR13(2) WERT7
BUPLABusiness Place BUPLACHAR4J_1BBRANCHJ_1BBRANCH
SECCOSection Code SECCOCHAR4SECCODESECCOSECCO_ABA
KKBERCredit control area KKBERCHAR4Assigned to domainKKBERKKB
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
KBLNRDocument Number for Earmarked Funds KBLNR_FICHAR10Assigned to domainALPHAKBLNRKBL
KBLPOSEarmarked Funds: Document Item KBLPOSNUMC3Assigned to domainKBLPOSKBP
PPRCTPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
BEWARTransaction Type RMVCTCHAR3Assigned to domainRMVCT
FDLEVPlanning level FDLEVCHAR2Assigned to domainFDLEVFFE
FDGRPPlanning Group FDGRPCHAR10Assigned to domainALPHAFDGRPFFG
ANBWAAsset Transaction Type ANBWACHAR3Assigned to domainBWASL
BZDATAsset value date BZDATDATS8DATUM
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
XINVEIndicator: Capital Goods Affected? XINVECHAR1XFELD
HZUONAssignment Number for Special G/L Accounts HZUONCHAR18ZUONR
SKFBTAmount Eligible for Cash Discount in Document Currency SKFBTCURR13(2) WERT7
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
LZBKZState Central Bank Indicator LZBKZCHAR3Assigned to domainLZBKZ
LANDLSupplying Country LANDLCHAR3Assigned to domainLAND1
ABPERSettlement period ABPER_RFACCP6BUPER
VRSKZInsurance indicator VRSKZCHAR1CHAR1
VRSDTInsurance date VRSDTDATS8DATUM
ESRNRISR Subscriber Number ESRNRCHAR11ESRNR
ESRREISR Reference Number ESRRECHAR27ALPHAESRRE
ESRPZISR Check Digit ESRPZCHAR2CHAR2
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
QBSHBWithholding Tax Amount (in Document Currency) QBSHBCURR13(2) WERT7
QSFBTWithholding Tax-Exempt Amount (in Document Currency) QSFBTCURR13(2) WERT7
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
STCEGVAT Registration Number STCEGCHAR20STCEG
EGBLDCountry of Destination for Delivery of Goods EGBLDCHAR3Assigned to domainLAND1
EGLLDSupplying Country for Delivery of Goods EGLLDCHAR3Assigned to domainLAND1
VBEWAFlow Type SBEWARTCHAR4Assigned to domainSBEWART
XNEGPIndicator: Negative posting XNEGPCHAR1XFELD
GRICDActivity Code for Gross Income Tax J_1AGICD_DCHAR2Assigned to domainJ_1AGICD2
GRIRGSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
GITYPDistribution Type for Employment Tax J_1ADTYP_DCHAR2Assigned to domainJ_1ADTYP
KIDNOPayment Reference KIDNOCHAR30CHAR30
FKBER_LONGFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
HWAERLocal Currency HWAERCUKY5Assigned to domainWAERS
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
RF05A_UBAZWCurrency Key AZWAECUKY5Assigned to domainWAERSFWS
KOBEZAccount Description KOBEZCHAR30TEXT30
KTONRAccount Number KTONR_AVCHAR10ALPHAKTONR
AZBETDisplay Amount AZBET_F05ACURR17(2) WERTV9
AZSTEDisplay Tax Amount AZSTE_F05ACURR15(2) WRTV8
HKBEZName of the General Ledger Account HKBEZCHAR20TEXT20
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
XCORRIndicator: Correct Item? XCORRCHAR1BOOLEAN
PSWBTAmount for Updating in General Ledger PSWBTCURR13(2) WERT7
PSWSLUpdate Currency for General Ledger Transaction Figures PSWSLCUKY5Assigned to domainWAERS
LOKKTAlternative account number in company code ALTKT_SKB1CHAR10Assigned to domainALPHASAKNR
DISBNNumber of Bill of Exchange Usage Document (Discount Doc.) DISBNCHAR10ALPHABELNR
FASTPAYPPA Fast Pay Indicator FMFG_FASTPAY_FLGCHAR1XFELD
PPA_EX_INDPPA Exclude Indicator EXCLUDE_FLGCHAR1XFELD
PEROP_BEGBilling Period of Performance Start Date FM_PEROP_FI_LOWDATS8DATUM
PEROP_ENDBilling Period of Performance End Date FM_PEROP_FI_HIGHDATS8DATUM
MARKED_ALVMarking of Position to Be Corrected MARKED_ALVCHAR1MARKED_ALV
PROJK_EXTIndividual Structural Element (WBS Element) in Ext. Format PROJK_EXTCHAR24CHAR24
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
PSEGMENTPartner Segment for Segmental Reporting FB_PSEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
PFKBERPartner Functional Area SFKBERCHAR16Assigned to domainFKBER
PGEBERPartner Fund FM_PFUNDCHAR10Assigned to domainBP_GEBERPARTNER_FUND
PGRANT_NBRPartner Grant GM_PGRANT_NBRCHAR20ALPHAGM_GRANT_NBRGRANTS_GENERIC
MEASUREFunded Program FM_MEASURECHAR24Assigned to domainFM_MEASUREFM_MEASURE
KTOSLTransaction Key KTOSLCHAR3CHAR3
XAUTOIndicator: Line item automatically created XAUTOCHAR1XFELD
PKOSTLSender cost center SKOSTCHAR10Assigned to domainALPHAKOSTLKSK
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
PBUDGET_PDFM: Partner Budget Period FM_PBUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
DMBE2Amount in Second Local Currency DMBE2CURR13(2) WERT7
HWAE2Currency Key of Second Local Currency HWAE2CUKY5Assigned to domainWAERS
DMBE3Amount in Third Local Currency DMBE3CURR13(2) WERT7
HWAE3Currency Key of Third Local Currency HWAE3CUKY5Assigned to domainWAERS
TAXPSTax document item number TAX_POSNRNUMC6NUM6
FLACCFirst Level Account IDCN_FLACCCHAR4CHAR4
DEBITAmount in Local Currency DMBTRCURR13(2) WERT7
CREDITAmount in Local Currency DMBTRCURR13(2) WERT7
PRCTR_KTEXTGeneral Name KTEXTCHAR20TEXT20
KOSTL_KTEXTGeneral Name KTEXTCHAR20TEXT20
KUNNR_NAME1Name 1 NAME1_GPCHAR35NAME
LIFNR_NAME1Name 1 NAME1_GPCHAR35NAME
RSTGR_TXT20Reason Code Short Text TXT20_053CHAR20TXT20
OLDGLACCOld G/L Account Number IDCN_GL_ACCOUNT_OLDCHAR10Assigned to domainALPHASAKNR
OLDGLACC_TXT30Old G/L Account Description IDCN_GL_ACCOUNT_OLD_TXT30CHAR30TEXT30
LOKKT_TXT30Alternative Account Description IDCN_ALTKT_TXT30CHAR30TEXT30
AFLACCFirst Level Account IDCN_FLACCCHAR4CHAR4
FLACC_DESCAccount Level Description IDCN_ALGACCGROUPDESCCHAR128IDCN_ALGACCGROUPDESC

Key field Non-key field



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

As IDCN_S_DOCALV 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 IDCN_S_DOCALV as there is no data to select.

How to access SAP table IDCN_S_DOCALV

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