DFKKORDERPOS SAP (Requests: Items) Table details
Dictionary Type: Table
Description: Requests: Items
Description: Requests: Items
Table field list including key, data, relationships and ABAP select examples
DFKKORDERPOS is a standard SAP Table which is used to store Requests: Items data and is available within R/3 SAP systems depending on the version and release level.
The DFKKORDERPOS table consists of various fields, each holding specific information or linking keys about Requests: Items data available in SAP. These include ORDNR (Request Number), VERSN (Execution Period of a Standing Request), LINENR (Line Number), BUKRS_BP (Company Code of Business Partner Item).. 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 DFKKORDERPOS 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 |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| ORDNR | Request Number | ORDNR_KK | CHAR | 12 | DFKKORDER | ALPHA | ORDNR_KK | ||
| VERSN | Execution Period of a Standing Request | AOVERSN_KK | NUMC | 3 | AOVERSN_KK | ||||
| LINENR | Line Number | LINENR_KK | NUMC | 4 | LINENR_KK | ||||
| BUKRS_BP | Company Code of Business Partner Item | BUKRS_BP_KK | CHAR | 4 | Assigned to domain | BUKRS | |||
| GPART | Business Partner Number | GPART_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | |
| VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
| VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
| HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4 | Assigned to domain | HVORG_KK | 8HV | ||
| TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4 | Assigned to domain | TVORG_KK | |||
| KOFIZ | Account Determination ID | KOFIZ_KK | CHAR | 2 | KOFIZ_KK | ||||
| GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| SEGMENT | Segment for Segmental Reporting | SEGMT_KK | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
| SPART | Division | SPART_KK | CHAR | 2 | Assigned to domain | SPART | SPA | ||
| HKONT_BP | Reconciliation Account | HKONT_BP_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
| TEXTPOS | Item Text for Request | TEXTPOS_KK | CHAR | 50 | TEXTPOS_KK | ||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
| FAEDN | Due date for net payment | FAEDN_KK | DATS | 8 | DATUM | ||||
| FAEDS | Due Date for Cash Discount | FAEDS_KK | DATS | 8 | DATUM | ||||
| DISC_DAYS | Cash Discount Days | DISC_DAYS_KK | NUMC | 3 | DISC_DAYS_KK | ||||
| SKTPZ | Cash discount rate | SKTPZ_KK | DEC | 5(3) | PRZ23 | ||||
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
| BETRH | Amount In Local Currency With +/- Signs | BETRH_KK | CURR | 13(2) | WRTV7 | ||||
| KURSF | Exchange rate | KURSF_KK | DEC | 9(5) | EXCRT | KURSF | |||
| PYBLOCK | Payment Lock | PYBLOCK_KK | CHAR | 1 | PYBLOCK_KK | ||||
| PYMET | Payment Method | PYMET_KK | CHAR | 1 | Assigned to domain | PYMET_KK | |||
| GRKEY | Grouping Key for Displaying Open Items | GRKEY_KK | CHAR | 3 | CHAR3 | ||||
| MAHNV | Dunning Procedure | MAHNV_KK | CHAR | 2 | Assigned to domain | MAHNV_KK | FKK_MAHNV | ||
| DNBLOCK | Dunning Lock | DNBLOCK_KK | CHAR | 1 | DNBLOCK_KK | ||||
| INTBLOCK | Interest Lock | INTBLOCK_KK | CHAR | 1 | INTBLOCK_KK | ||||
| CRLBLOCK | Clearing Lock | CRLBLOCK_KK | CHAR | 1 | CRLBLOCK_KK | ||||
| EMGPA | Alternative Business Partner for Payments | EMGPA_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BUPA | |
| EMBVT | Bank Details ID of Payee | EMBVT_KK | CHAR | 4 | CHAR4 | ||||
| EMMND | SEPA Mandate Identifier | EMMND_KK | NUMC | 6 | NUM06 | ||||
| EMCRD | Alternative Payment Card ID in Document | EMCRD_KK | CHAR | 6 | CHAR6 | ||||
| PERSL | Key for Period Assignment | PERSL_KK | CHAR | 4 | Assigned to domain | PERSL_KK | |||
| ABRZU | Lower Limit of Settlement Period | ABRZU_KK | DATS | 8 | DATUM | ||||
| ABRZO | Upper Limit of the Billing Period | ABRZO_KK | DATS | 8 | DATUM | ||||
| BUKRS | Company Code of G/L Account Item | BUKRS_AC_KK | CHAR | 4 | Assigned to domain | BUKRS | |||
| HKONT | G/L Account | HKONT_AC_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
| AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
| KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
| KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
| KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | NUM04 | ||||
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
| PASUBNR | Profitability segment changes (CO-PA) | RKESUBNR | NUMC | 4 | RKESUBNR | ||||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
| HKONT_TAX | Tax G/L Account | HKONT_TAX_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
| KTOSL | Transaction Key | KTOSL | CHAR | 3 | CHAR3 | ||||
| STPRZ | Tax rate | STRPZ_KK_1 | DEC | 6 | PRZ33_KK | ||||
| KSCHL | Condition Type | KSCHL | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
| SBASW | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | SBASW_KK | CURR | 13(2) | WRTV7 | ||||
| SBETW | Tax Amount in Transaction Currency with +/- Sign | SBETW_KK | CURR | 13(2) | WRTV7 | ||||
| TXDAT | Decisive Date for Calculating Taxes | TXDAT_KK | DATS | 8 | DATUM | ||||
| VALDAT | Validity Date | VALDAT_KK | DATS | 8 | DATUM | ||||
| IKEY | Interest Key | IKEY_KK | CHAR | 2 | Assigned to domain | IKEY_KK | |||
| FINRE | Contract Account of Final Recipient | FINRE_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | FKKVKP_F4 | |
| RDSTA | Current Distribution Status | RDSTA_KK | CHAR | 1 | RDSTAT_KK | ||||
| RDSTB | Last Distribution Status Reported | RDSTB_KK | CHAR | 1 | RDSTAT_KK | ||||
| FDGRP | Planning Group | FDGRP_KK | CHAR | 10 | T035 | ALPHA | FDGRP | FFG | |
| FDLEV | Planning level | FDLEV_KK | CHAR | 2 | T036 | FDLEV | FFE | ||
| FDZTG | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 | NUM2 | ||||
| DOCCR | Document can be created | DOCCR_KK | CHAR | 1 | DOCCR_KK | ||||
| ORDCLS | Request Class | ORDCLS_KK | CHAR | 1 | ORDCLS_KK | ||||
| SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR | 1 | SUBAP_KK | 8SA | |||
| PSGRP | Grouping Key for Document Items | PSGRP_KK | CHAR | 4 | CHAR4 | ||||
| STAKZ | Type of statistical item | STAKZ_KK | CHAR | 1 | STAKZ_KK | ||||
| XANZA | Item is a Down Payment/Down Payment Request | XANZA_KK | CHAR | 1 | XFELD | ||||
| KONTT_BP | Category for Additional Acct Assnmt for Bus. Partner Line | KONTT_BP_KK | CHAR | 2 | Assigned to domain | KONTT_KK | |||
| KONTL_BP | Acct Assgnt Toolbar for Appl-Specific Act Assts for BP Lines | KONTL_BP_KK | CHAR | 50 | CHAR50 | ||||
| KONTT_AC | Cat. of Additional Acct Assnmt for G/L Account Lines | KONTT_AC_KK | CHAR | 2 | Assigned to domain | KONTT_KK | |||
| KONTL_AC | Acct Assgt Toolbar for Appl-Spec.AcctAssgmts for G/L A-Lines | KONTL_AC_KK | CHAR | 50 | CHAR50 | ||||
| ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
| ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
| ANBWA | Asset Transaction Type | ANBWA | CHAR | 3 | Assigned to domain | BWASL | |||
| BZDAT | Asset value date | BZDAT | DATS | 8 | DATUM | ||||
| VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
| XEIBH | Create Separate Document in General Ledger | XEIBH_KK | CHAR | 1 | XFELD | ||||
| XEIPH | Create Line Item in General Ledger | XEIPH_KK | CHAR | 1 | XFELD | ||||
| EFCIR | Earmarked Funds Created from Request | FKK_EFCIR | CHAR | 1 | XFELD | ||||
| EFLC | Last Item of Request for Earmarked Funds | FKK_EFLC | CHAR | 1 | XFELD | ||||
| MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| KBLPOS_TAX | Line Item for Earmarked Funds (Tax Part) | KBLPOS_TAX_KK | NUMC | 3 | Assigned to domain | KBLPOS | KBP |
| Key field | Non-key field |
How do I retrieve data from SAP table DFKKORDERPOS using ABAP code
The following ABAP code Example will allow you to do a basic selection on DFKKORDERPOS to SELECT all data from the tableDATA: WA_DFKKORDERPOS TYPE DFKKORDERPOS.
SELECT SINGLE *
FROM DFKKORDERPOS
INTO CORRESPONDING FIELDS OF WA_DFKKORDERPOS
WHERE...
How to access SAP table DFKKORDERPOS
Within an ECC or HANA version of SAP you can also view further information about DFKKORDERPOS 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