FMPRPP_XZAHLB SAP (Selected Documents for Payment Program in FI) Structure details
Description: Selected Documents for Payment Program in FI
Related tables to FMPRPP_XZAHLB
Access table FMPRPP_XZAHLB
Structure field list including key, data, relationships and ABAP select examples
FMPRPP_XZAHLB 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 "Selected Documents for Payment Program in FI" 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_FMPRPP_XZAHLB TYPE FMPRPP_XZAHLB.
The FMPRPP_XZAHLB table consists of various fields, each holding specific information or linking keys about Selected Documents for Payment Program in FI data available in SAP. These include KATEG (Category of an Item to be Paid), SRTFA (Baseline Date for Due Date Calculation), SRTBL (Accounting Document Number), SRTBU (Company Code).. 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 FMPRPP_XZAHLB 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 |
ZHLG2 | 0 | ||||||||
KATEG | Category of an Item to be Paid | KATEG | CHAR | 1 | CHAR1 | ||||
SRTFA | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
SRTBL | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
SRTBU | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
SRTBZ | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
SRTGJ | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
XINVE | Indicator: Capital Goods Affected? | XINVE | CHAR | 1 | XFELD | ||||
FONUM | Consecutive Number of the Form | FONUM | NUMC | 4 | FONUM | ||||
FOFAE | Due Date for a Form | FOFAE | DATS | 8 | DATUM | ||||
SPNUM | Sequence Number of the Amount Split Group | SPNUM | NUMC | 4 | NUM4 | ||||
REGUP | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
LAUFD | Date on Which the Program Is to Be Run | LAUFD | DATS | 8 | DATUM | ||||
LAUFI | Additional Identification | LAUFI | CHAR | 6 | LAUFI | ||||
XVORL | Indicator: Only Proposal Run? | XVORL | CHAR | 1 | XFELD | ||||
ZBUKR | Paying company code | DZBUKR | CHAR | 4 | BUKRS | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | ALPHA | LIFNR | LIF | KRED_C | |
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
EMPFG | Payee code | EMPFG | CHAR | 16 | EMPFG | ||||
VBLNR | Document Number of the Payment Document | VBLNR | CHAR | 10 | ALPHA | BELNR | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
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 | |||
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | ZLSCH | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | HBKID | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
POKEN | Item Indicator | POKEN | CHAR | 3 | CHAR3 | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
BLART | Document Type | BLART | CHAR | 2 | BLART | BAR | |||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
BSCHL | Posting Key | BSCHL | CHAR | 2 | BSCHL | ||||
HKONT | General Ledger Account | HKONT | CHAR | 10 | ALPHA | SAKNR | |||
SAKNR | G/L Account Number | SAKNR | CHAR | 10 | ALPHA | SAKNR | SAK | C_SAKNR | |
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | UMSKZ | ||||
UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 1 | UMSKS | ||||
ZUMSK | Target Special G/L Indicator | DZUMSK | CHAR | 1 | UMSKZ | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
WRBTR | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
BDIFF | Valuation Difference | BDIFF | CURR | 13(2) | WRTV7 | ||||
GSBER | Business Area | GSBER | CHAR | 4 | GSBER | GSB | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | MWSKZ | ||||
MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 13(2) | WERT7 | ||||
WMWST | Tax amount in document currency | WMWST | CURR | 13(2) | WERT7 | ||||
MWSK1 | Tax Code for Distribution | MWSKX | CHAR | 2 | MWSKZ | ||||
DMBT1 | Amount in Local Currency for Tax Distribution | DMBTX | CURR | 13(2) | WRTV7 | ||||
WRBT1 | Amount in foreign currency for tax breakdown | WRBTX | CURR | 13(2) | WRTV7 | ||||
MWSK2 | Tax Code for Distribution | MWSKX | CHAR | 2 | MWSKZ | ||||
DMBT2 | Amount in Local Currency for Tax Distribution | DMBTX | CURR | 13(2) | WRTV7 | ||||
WRBT2 | Amount in foreign currency for tax breakdown | WRBTX | CURR | 13(2) | WRTV7 | ||||
MWSK3 | Tax Code for Distribution | MWSKX | CHAR | 2 | MWSKZ | ||||
DMBT3 | Amount in Local Currency for Tax Distribution | DMBTX | CURR | 13(2) | WRTV7 | ||||
WRBT3 | Amount in foreign currency for tax breakdown | WRBTX | CURR | 13(2) | WRTV7 | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
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 | ||||
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 13(2) | WERT7 | ||||
SKNTO | Cash discount amount in local currency | SKNTO | CURR | 13(2) | WERT7 | ||||
WSKTO | Cash discount amount in document currency | WSKTO | CURR | 13(2) | WERT7 | ||||
ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | ZAHLS | SPE | |||
SPLEV | Level on Which a Payment Block has Taken Place | SPLEV | CHAR | 1 | SPLEV | ||||
XREBZ | Indicator: Item is an Invoice-Related Credit Memo | XREBZ | CHAR | 1 | XFELD | ||||
ZOLLT | Customs Tariff Number | DZOLLT | CHAR | 8 | ZOLLT | ||||
ZOLLD | Customs Date | DZOLLD | DATS | 8 | DATUM | ||||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | LZBKZ | ||||
LANDL | Supplying Country | LANDL | CHAR | 3 | LAND1 | ||||
DIEKZ | Service Indicator (Foreign Payment) | DIEKZ | CHAR | 1 | DIEKZ | ||||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | QSSKZ | ||||
QSSHB | Withholding Tax Base Amount | QSSHB | CURR | 13(2) | WERT7 | ||||
QBSHB | Withholding Tax Amount (in Document Currency) | QBSHB | CURR | 13(2) | WERT7 | ||||
QBSHH | Withholding Tax Amount (in Local Currency) | QBSHH | CURR | 13(2) | WERT7 | ||||
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 | ||||
ZBDXT | Selected cash discount days | DZBDXT | DEC | 3 | ZBDXT | ||||
ZBDXP | Selected cash discount percentage rate | DZBDXP | DEC | 5(3) | PRZ23 | ||||
MSHBT | Maximum Cash Discount Amount in Local Currency | MSHBT | CURR | 13(2) | WERT7 | ||||
MSFBT | Maximum Cash Discount Amount in Foreign Currency | MSFBT | CURR | 13(2) | WERT7 | ||||
PROJN | Old: Project number : No longer used --> PS_POSNR | PROJN | CHAR | 16 | PROJN | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | ALPHA | AUFNR | ANR | ||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ALPHA | ANLN1 | AN1 | ||
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | ALPHA | ANLN2 | AN2 | ||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | ALPHA | EBELN | BES | MEKK_C | |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EBELP | BSP | |||
XANET | Indicator: Down payment in net procedure ? | XANET | CHAR | 1 | XFELD | ||||
XNETB | Indicator: Document posted net ? | XNETB | CHAR | 1 | XFELD | ||||
XNACH | Indicator: Document Data Must be Reread | XNACH | CHAR | 1 | XFELD | ||||
ZWELS | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | ZWELS | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | ALPHA | RCOMP | PGS | ||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
EGBLD | Country of Destination for Delivery of Goods | EGBLD | CHAR | 3 | LAND1 | ||||
EGLLD | Supplying Country for Delivery of Goods | EGLLD | CHAR | 3 | LAND1 | ||||
QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
BDIF2 | Valuation Difference for the Second Local Currency | BDIF2 | CURR | 13(2) | WRTV7 | ||||
DSKVH | Impending Lost Cash Discount in Local Currency | DSKVH | CURR | 13(2) | WERT7 | ||||
POKLA | Item Classification for Online Check Printing | POKLA | CHAR | 1 | CHAR1 | ||||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | FIPOS | FIP | |||
PROJK | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | KONPR | PS_POSNR | |||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | ALPHA | AUFNR | NET | ||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
BDIF3 | Valuation Difference for the Third Local Currency | BDIF3 | CURR | 13(2) | WRTV7 | ||||
DMBE2 | Amount in Second Local Currency | DMBE2 | CURR | 13(2) | WERT7 | ||||
DMBE3 | Amount in Third Local Currency | DMBE3 | CURR | 13(2) | WERT7 | ||||
MWST2 | Tax Amount in Second Local Currency | MWST2 | CURR | 13(2) | WERT7 | ||||
SKNT2 | Cash Discount Amount in Second Local Currency | SKNT2 | CURR | 13(2) | WERT7 | ||||
SKNT3 | Cash Discount Amount in Third Local Currency | SKNT3 | CURR | 13(2) | WERT7 | ||||
QBSH2 | Withholding Tax Amount in Second Local Currency | QBSH2 | CURR | 13(2) | WERT7 | ||||
QBSH3 | Withholding Tax Amount in Third Local Currency | QBSH3 | CURR | 13(2) | WERT7 | ||||
DMB21 | Amount in Second Local Currency for Tax Breakdown | DMB2X | CURR | 13(2) | WRTV7 | ||||
DMB22 | Amount in Second Local Currency for Tax Breakdown | DMB2X | CURR | 13(2) | WRTV7 | ||||
DMB23 | Amount in Second Local Currency for Tax Breakdown | DMB2X | CURR | 13(2) | WRTV7 | ||||
DMB31 | Amount in Third Local Currency for Tax Breakdown | DMB3X | CURR | 13(2) | WRTV7 | ||||
DMB32 | Amount in Third Local Currency for Tax Breakdown | DMB3X | CURR | 13(2) | WRTV7 | ||||
DMB33 | Amount in Third Local Currency for Tax Breakdown | DMB3X | CURR | 13(2) | WRTV7 | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | UZAWE | ||||
MWST3 | Tax Amount in Third Local Currency | MWST3 | CURR | 13(2) | WERT7 | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
OSKTO | Cash discount amount in local currency | SKNTO | CURR | 13(2) | WERT7 | ||||
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
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 | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | ALPHA | KOSTL | KOS | ||
XINVE | Indicator: Capital Goods Affected? | XINVE | CHAR | 1 | XFELD | ||||
VBEL2 | Sales Document | VBELN_VA | CHAR | 10 | ALPHA | VBELN | AUN | ||
VPOS2 | Numeric field: Length 6 | NUM06 | NUMC | 6 | NUM06 | ||||
ZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC | 2 | NUM02 | ||||
POSN2 | Sales Document Item | POSNR_VA | NUMC | 6 | POSNR | APO | |||
ETEN2 | Delivery Schedule Line Number | ETENR | NUMC | 4 | ETENR | ||||
FISTL | Funds Center | FISTL | CHAR | 16 | FISTL | FIS | |||
GEBER | Fund | BP_GEBER | CHAR | 10 | BP_GEBER | FIC | |||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
KKBER | Credit control area | KKBER | CHAR | 4 | KKBER | KKB | |||
EMPFB | Payee/Payer | EMPFB | CHAR | 10 | ALPHA | MAXKK | |||
PRCTR | Profit Center | PRCTR | CHAR | 10 | ALPHA | PRCTR | PRC | PRCTR_EMPTY | |
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
ZINKZ | Exempted from interest calculation | DZINKZ | CHAR | 2 | ZINKZ | ||||
DTWS1 | Instruction key 1 | DTAT16 | NUMC | 2 | DTWSX | ||||
DTWS2 | Instruction key 2 | DTAT17 | NUMC | 2 | DTWSX | ||||
DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2 | DTWSX | ||||
DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2 | DTWSX | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | MANSP | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
XCPDD | Indicator: Address and bank data set individually | XCPDD | CHAR | 1 | XFELD | ||||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
VBEWA | Flow Type | SBEWART | CHAR | 4 | SBEWART | ||||
AGZEI | Clearing Item | AGZEI | DEC | 5 | AGZEI | ||||
PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY | 5 | WAERS | ||||
PSWBT | Amount for Updating in General Ledger | PSWBT | CURR | 13(2) | WERT7 | ||||
PSSKT | Cash Discount Deduction for the Item | PSSKT | CURR | 13(2) | WRTV7 | ||||
XPYAM | Indicator: Payment Amount Predefined | XPYAM | CHAR | 1 | XFELD | ||||
GDIFF | Total Exchange Rate Difference | GDIFF | CURR | 13(2) | WRTV7 | ||||
GDIF2 | Total Exchange Rate Difference | GDIFF | CURR | 13(2) | WRTV7 | ||||
GDIF3 | Total Exchange Rate Difference | GDIFF | CURR | 13(2) | WRTV7 | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | ||||
SECCO | Section Code | SECCO | CHAR | 4 | SECCO | SECCO_ABA | |||
XSAEN | Indicator: Unconfirmed master data change | XSAEN | CHAR | 1 | XFELD | ||||
KBLNR | Document Number for Earmarked Funds | KBLNR_FI | CHAR | 10 | ALPHA | KBLNR | KBL | ||
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | KBLPOS | KBP | |||
CESSION_KZ | Accounts Receivable Pledging Indicator | CESSION_KZ | CHAR | 2 | CESSION_KZ | ||||
KEYNO | Key Number for Payment Request | PRQ_KEYNO | CHAR | 10 | ALPHA | PRQ_KEYNO | |||
PAMTF | Payment Request Amount in Payment Currency | PRQ_AMTFC | CURR | 13(2) | WERT7 | ||||
ORIGIN | Origin Indicator | FIBL_ORIGIN | CHAR | 8 | FIBL_ORIGIN | ||||
PENLC1 | Penalty charge amount in first local currency | PENALTY1 | CURR | 13(2) | WERT13 | ||||
PENLC2 | Penalty charge amount in second local currency | PENALTY2 | CURR | 13(2) | WERT13 | ||||
PENLC3 | Penalty Charge Amount in Third Local Currency | PENALTY3 | CURR | 13(2) | WERT13 | ||||
PENFC | Penalty charge amount in document currency | PENALTY | CURR | 13(2) | WERT13 | ||||
PENDAYS | Number of days for penalty charge calculation | PDAYS | INT4 | 10 | INT4 | ||||
PPRCT | Partner Profit Center | PPRCTR | CHAR | 10 | ALPHA | PRCTR | PPC | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
FKBER | Functional Area | FKBER | CHAR | 16 | FKBER | FBE | |||
SNAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
SORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
SLAND1 | Country Key | LAND1_GP | CHAR | 3 | LAND1 | C_LAND1 | |||
SAMNR | Invoice List Number | SAMNR | NUMC | 8 | SAMNR | ||||
MABER | Dunning Area | MABER | CHAR | 2 | MABER | ||||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | FM_BUDGET_PERIOD | BUDPER | |||
SNAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
SNAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
SNAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
SSTRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
SSTRS2 | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
SPSTLZ | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
SID | Original Payer of a Payment (ID) | SENDER_ID | CHAR | 35 | CHAR35 | ||||
.INCLU--AP | 0 | ||||||||
EXTACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
FAEDT | Date | DATUM | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP structure FMPRPP_XZAHLB using ABAP code?
As FMPRPP_XZAHLB 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 FMPRPP_XZAHLB as there is no data to select.How to access SAP table FMPRPP_XZAHLB
Within an ECC or HANA version of SAP you can also view further information about FMPRPP_XZAHLB 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