IDCN_S_DOCALV SAP (Accounting Document at Segment Level) Structure details
Description: Accounting Document at Segment Level
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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS_ALV | CHAR | 4 | Assigned to domain | BUKRS | |||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
DOCLN | DOCLN for ALV Grid Control | DOCLNALV | CHAR | 6 | DOCLN6 | ||||
AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 10 | ALPHA | BELNR | |||
BSCHL | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | T074U | UMSKZ | |||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | TGSB | GSBER | GSB | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | T059Q | QSSKZ | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
VBELN | Billing Document | VBELN_VF | CHAR | 10 | VBUK | ALPHA | VBELN | VF | |
VBEL2 | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
POSN2 | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
ETEN2 | Delivery Schedule Line Number | ETENR | NUMC | 4 | VBEP | ETENR | |||
XSKRL | Indicator: Line item not liable to cash discount? | XSKRL | CHAR | 1 | XFELD | ||||
XZAHL | Indicator: Is the posting key used in a payment transaction? | XZAHL | CHAR | 1 | XFELD | ||||
SAKNR | G/L Account Number | SAKNR | CHAR | 10 | SKB1 | ALPHA | SAKNR | SAK | C_SAKNR |
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | T042Z | ZLSCH | |||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | T008 | ZAHLS | SPE | ||
ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
SAMNR | Invoice List Number | SAMNR | NUMC | 8 | SAMNR | ||||
ANFBN | Document Number of the Bill of Exchange Payment Request | ANFBN | CHAR | 10 | ALPHA | BELNR | |||
MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | MSCHL | |||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
SPGRP | Blocking reason: price | SPGRP | CHAR | 1 | XFELD | ||||
SPGRM | Blocking reason: quantity | SPGRM | CHAR | 1 | XFELD | ||||
SPGRT | Blocking Reason: Date | SPGRT | CHAR | 1 | XFELD | ||||
SPGRG | Blocking reason: order price quantity | SPGRG | CHAR | 1 | XFELD | ||||
SPGRV | Blocking reason: project budget | SPGRV | CHAR | 1 | XFELD | ||||
SPGRQ | Manual Blocking Reason | SPGRQ | CHAR | 1 | XFELD | ||||
RSTGR | Reason Code for Payments | RSTGR | CHAR | 3 | T053R | RSTGR | |||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
VNAME | Joint Venture | JV_NAME | CHAR | 6 | Assigned to domain | ALPHA | JV_NAME | JVV | |
EGRUP | Equity group | JV_EGROUP | CHAR | 3 | Assigned to domain | ALPHA | JV_EGROUP | GJE | |
BTYPE | Payroll Type | JV_BILIND | CHAR | 2 | Assigned to domain | ALPHA | JV_BILIND | ||
RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | Assigned to domain | ALPHA | JV_RECIND | ||
VPTNR | Partner account number | JV_PART | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
AUFPL | Task list number for operations in order | AUFPL_CH | NUMC | 10 | AUFPL | ||||
APLZL | General counter for order | APLZL_CH | NUMC | 8 | Assigned to domain | CO_APLZL | |||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | T042F | UZAWE | |||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
STBUK | Tax Company Code | STBUK | CHAR | 4 | Assigned to domain | BUKRS | BUK | ||
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
EMPFB | Payee/Payer | EMPFB | CHAR | 10 | ALPHA | MAXKK | |||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
PYCUR | Currency for Automatic Payment | PYCUR | CUKY | 5 | TCURC | WAERS | |||
PYAMT | Amount in Payment Currency | PYAMT | CURR | 13(2) | WERT7 | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | |||
SECCO | Section Code | SECCO | CHAR | 4 | SECCODE | SECCO | SECCO_ABA | ||
KKBER | Credit control area | KKBER | CHAR | 4 | Assigned to domain | KKBER | KKB | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
KBLNR | Document Number for Earmarked Funds | KBLNR_FI | CHAR | 10 | Assigned to domain | ALPHA | KBLNR | KBL | |
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | Assigned to domain | KBLPOS | KBP | ||
PPRCT | Partner Profit Center | PPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PPC | |
BEWAR | Transaction Type | RMVCT | CHAR | 3 | Assigned to domain | RMVCT | |||
FDLEV | Planning level | FDLEV | CHAR | 2 | Assigned to domain | FDLEV | FFE | ||
FDGRP | Planning Group | FDGRP | CHAR | 10 | Assigned to domain | ALPHA | FDGRP | FFG | |
ANBWA | Asset Transaction Type | ANBWA | CHAR | 3 | Assigned to domain | BWASL | |||
BZDAT | Asset value date | BZDAT | DATS | 8 | DATUM | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
XINVE | Indicator: Capital Goods Affected? | XINVE | CHAR | 1 | XFELD | ||||
HZUON | Assignment Number for Special G/L Accounts | HZUON | CHAR | 18 | ZUONR | ||||
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 13(2) | WERT7 | ||||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | Assigned to domain | LZBKZ | |||
LANDL | Supplying Country | LANDL | CHAR | 3 | Assigned to domain | LAND1 | |||
ABPER | Settlement period | ABPER_RF | ACCP | 6 | BUPER | ||||
VRSKZ | Insurance indicator | VRSKZ | CHAR | 1 | CHAR1 | ||||
VRSDT | Insurance date | VRSDT | DATS | 8 | DATUM | ||||
ESRNR | ISR Subscriber Number | ESRNR | CHAR | 11 | ESRNR | ||||
ESRRE | ISR Reference Number | ESRRE | CHAR | 27 | ALPHA | ESRRE | |||
ESRPZ | ISR Check Digit | ESRPZ | CHAR | 2 | CHAR2 | ||||
QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
QBSHB | Withholding Tax Amount (in Document Currency) | QBSHB | CURR | 13(2) | WERT7 | ||||
QSFBT | Withholding Tax-Exempt Amount (in Document Currency) | QSFBT | CURR | 13(2) | WERT7 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
EGBLD | Country of Destination for Delivery of Goods | EGBLD | CHAR | 3 | Assigned to domain | LAND1 | |||
EGLLD | Supplying Country for Delivery of Goods | EGLLD | CHAR | 3 | Assigned to domain | LAND1 | |||
VBEWA | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
XNEGP | Indicator: Negative posting | XNEGP | CHAR | 1 | XFELD | ||||
GRICD | Activity Code for Gross Income Tax | J_1AGICD_D | CHAR | 2 | Assigned to domain | J_1AGICD2 | |||
GRIRG | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
GITYP | Distribution Type for Employment Tax | J_1ADTYP_D | CHAR | 2 | Assigned to domain | J_1ADTYP | |||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
FKBER_LONG | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
RF05A_UBAZW | Currency Key | AZWAE | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
KOBEZ | Account Description | KOBEZ | CHAR | 30 | TEXT30 | ||||
KTONR | Account Number | KTONR_AV | CHAR | 10 | ALPHA | KTONR | |||
AZBET | Display Amount | AZBET_F05A | CURR | 17(2) | WERTV9 | ||||
AZSTE | Display Tax Amount | AZSTE_F05A | CURR | 15(2) | WRTV8 | ||||
HKBEZ | Name of the General Ledger Account | HKBEZ | CHAR | 20 | TEXT20 | ||||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
XCORR | Indicator: Correct Item? | XCORR | CHAR | 1 | BOOLEAN | ||||
PSWBT | Amount for Updating in General Ledger | PSWBT | CURR | 13(2) | WERT7 | ||||
PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY | 5 | Assigned to domain | WAERS | |||
LOKKT | Alternative account number in company code | ALTKT_SKB1 | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
DISBN | Number of Bill of Exchange Usage Document (Discount Doc.) | DISBN | CHAR | 10 | ALPHA | BELNR | |||
FASTPAY | PPA Fast Pay Indicator | FMFG_FASTPAY_FLG | CHAR | 1 | XFELD | ||||
PPA_EX_IND | PPA Exclude Indicator | EXCLUDE_FLG | CHAR | 1 | XFELD | ||||
PEROP_BEG | Billing Period of Performance Start Date | FM_PEROP_FI_LOW | DATS | 8 | DATUM | ||||
PEROP_END | Billing Period of Performance End Date | FM_PEROP_FI_HIGH | DATS | 8 | DATUM | ||||
MARKED_ALV | Marking of Position to Be Corrected | MARKED_ALV | CHAR | 1 | MARKED_ALV | ||||
PROJK_EXT | Individual Structural Element (WBS Element) in Ext. Format | PROJK_EXT | CHAR | 24 | CHAR24 | ||||
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
PFKBER | Partner Functional Area | SFKBER | CHAR | 16 | Assigned to domain | FKBER | |||
PGEBER | Partner Fund | FM_PFUND | CHAR | 10 | Assigned to domain | BP_GEBER | PARTNER_FUND | ||
PGRANT_NBR | Partner Grant | GM_PGRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GRANTS_GENERIC | ||
MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | Assigned to domain | FM_MEASURE | FM_MEASURE | ||
KTOSL | Transaction Key | KTOSL | CHAR | 3 | CHAR3 | ||||
XAUTO | Indicator: Line item automatically created | XAUTO | CHAR | 1 | XFELD | ||||
PKOSTL | Sender cost center | SKOST | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
PBUDGET_PD | FM: Partner Budget Period | FM_PBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
DMBE2 | Amount in Second Local Currency | DMBE2 | CURR | 13(2) | WERT7 | ||||
HWAE2 | Currency Key of Second Local Currency | HWAE2 | CUKY | 5 | Assigned to domain | WAERS | |||
DMBE3 | Amount in Third Local Currency | DMBE3 | CURR | 13(2) | WERT7 | ||||
HWAE3 | Currency Key of Third Local Currency | HWAE3 | CUKY | 5 | Assigned to domain | WAERS | |||
TAXPS | Tax document item number | TAX_POSNR | NUMC | 6 | NUM6 | ||||
FLACC | First Level Account | IDCN_FLACC | CHAR | 4 | CHAR4 | ||||
DEBIT | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
CREDIT | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
PRCTR_KTEXT | General Name | KTEXT | CHAR | 20 | TEXT20 | ||||
KOSTL_KTEXT | General Name | KTEXT | CHAR | 20 | TEXT20 | ||||
KUNNR_NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
LIFNR_NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
RSTGR_TXT20 | Reason Code Short Text | TXT20_053 | CHAR | 20 | TXT20 | ||||
OLDGLACC | Old G/L Account Number | IDCN_GL_ACCOUNT_OLD | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
OLDGLACC_TXT30 | Old G/L Account Description | IDCN_GL_ACCOUNT_OLD_TXT30 | CHAR | 30 | TEXT30 | ||||
LOKKT_TXT30 | Alternative Account Description | IDCN_ALTKT_TXT30 | CHAR | 30 | TEXT30 | ||||
AFLACC | First Level Account | IDCN_FLACC | CHAR | 4 | CHAR4 | ||||
FLACC_DESC | Account Level Description | IDCN_ALGACCGROUPDESC | CHAR | 128 | IDCN_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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects