SAP ABAP Table IRBKPF (Logistics Invoice Verification, Invoice Documents)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MRM (Package) Appl.development R/3 decentralized invoice verification
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MRM (Package) Appl.development R/3 decentralized invoice verification
Basic Data
Table Category | INTTAB | Structure |
Structure | IRBKPF | Table Relationship Diagram |
Short Description | Logistics Invoice Verification, Invoice Documents |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | BELNR | RE_BELNR | BELNR | CHAR | 10 | 0 | Document Number of an Invoice Document | ||
3 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
4 | BLART | BLART | BLART | CHAR | 2 | 0 | Document type | T003 | |
5 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
6 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
7 | USNAM | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
8 | TCODE | TCODE | TCODE | CHAR | 20 | 0 | Transaction Code | TSTC | |
9 | CPUDT | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
10 | CPUTM | CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
11 | VGART | M8VGA | M8VGA | CHAR | 2 | 0 | Transaction Type in AG08 (Internal Document Type) | ||
12 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
13 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
14 | LIFNR | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | * | |
15 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
16 | KURSF | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
17 | RMWWR | RMWWR | WERT7 | CURR | 13 | 2 | Gross invoice amount in document currency | ||
18 | BEZNK | BEZNK | ANLKWERT | CURR | 13 | 2 | Unplanned delivery costs | ||
19 | WMWST1 | FWSTEV | WERTV7 | CURR | 13 | 2 | Tax Amount in Document Currency with +/- Sign | ||
20 | MWSKZ1 | MWSKZ_MRM | MWSKZ | CHAR | 2 | 0 | Tax Code | T007A | |
21 | WMWST2 | FWSTEV | WERTV7 | CURR | 13 | 2 | Tax Amount in Document Currency with +/- Sign | ||
22 | MWSKZ2 | MWSKZ_MRM | MWSKZ | CHAR | 2 | 0 | Tax Code | T007A | |
23 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
24 | ZBD1T | DZBD1T | ZBDXT | DEC | 3 | 0 | Cash discount days 1 | ||
25 | ZBD1P | DZBD1P | PRZ23 | DEC | 5 | 3 | Cash discount percentage 1 | ||
26 | ZBD2T | DZBD2T | ZBDXT | DEC | 3 | 0 | Cash discount days 2 | ||
27 | ZBD2P | DZBD2P | PRZ23 | DEC | 5 | 3 | Cash Discount Percentage 2 | ||
28 | ZBD3T | DZBD3T | ZBDXT | DEC | 3 | 0 | Net Payment Terms Period | ||
29 | WSKTO | WSKTO | WERT7 | CURR | 13 | 2 | Cash Discount Amount in Document Currency | ||
30 | XRECH | XRECHC | XFELD | CHAR | 1 | 0 | Indicator: post invoice | ||
31 | BKTXT | BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
32 | SAPRL | SAPRL | SAPRL | CHAR | 4 | 0 | SAP Release | ||
33 | LOGSYS | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | * | |
34 | XMWST | XMWST | XFELD | CHAR | 1 | 0 | Calculate tax automatically | ||
35 | STBLG | RE_STBLG | BELNR | CHAR | 10 | 0 | Reversal document number | ||
36 | STJAH | RE_STJAH | GJAHR | NUMC | 4 | 0 | Fiscal year of reversal document | ||
37 | SOLLB | SMWWR | WERTV7 | CURR | 13 | 2 | Gross target invoice amount in local currency | ||
38 | SOLLN | SNWWR | WERTV7 | CURR | 13 | 2 | Net target invoice amount in document currency | ||
39 | MAKZB | MAKZB_D | WERTV7 | CURR | 13 | 2 | Manually accepted gross invoice difference | ||
40 | MAKZN | MAKZN | WERTV7 | CURR | 13 | 2 | Manually accepted net difference amount | ||
41 | DIFFB | REPDIF | WERTV7 | CURR | 13 | 2 | Invoice Verification difference including tax | ||
42 | DIFFN | RPDIFN | WERTV7 | CURR | 13 | 2 | Document Balance | ||
43 | LIEFFMW | LIEFFMW | WERTV7 | CURR | 13 | 2 | Tax in vendor error | ||
44 | LIEFFN | LIEFFN | WERTV7 | CURR | 13 | 2 | Vendor error (exclusive of tax) | ||
45 | SMWSKZ1 | MWSKZ_MRM | MWSKZ | CHAR | 2 | 0 | Tax Code | T007A | |
46 | SMWST1 | FWSTEV | WERTV7 | CURR | 13 | 2 | Tax Amount in Document Currency with +/- Sign | ||
47 | LIEFF1 | LIEFF_MRM | WERTV7 | CURR | 13 | 2 | Vendor error (incl. tax) | ||
48 | MWLIEFF1 | LMWST | WERTV7 | CURR | 13 | 2 | Obsolete: tax in vendor error | ||
49 | MAKZMW1 | MAKZMW | WERTV7 | CURR | 13 | 2 | Tax Amount Accepted Manually | ||
50 | MWDIFFB1 | REPDIF | WERTV7 | CURR | 13 | 2 | Invoice Verification difference including tax | ||
51 | FWNAV1 | FWSTEV | WERTV7 | CURR | 13 | 2 | Tax Amount in Document Currency with +/- Sign | ||
52 | MWBNK1 | FWSTEV | WERTV7 | CURR | 13 | 2 | Tax Amount in Document Currency with +/- Sign | ||
53 | SMWSKZ2 | MWSKZ_MRM | MWSKZ | CHAR | 2 | 0 | Tax Code | T007A | |
54 | SMWST2 | FWSTEV | WERTV7 | CURR | 13 | 2 | Tax Amount in Document Currency with +/- Sign | ||
55 | LIEFF2 | LIEFF_MRM | WERTV7 | CURR | 13 | 2 | Vendor error (incl. tax) | ||
56 | MWLIEFF2 | LMWST | WERTV7 | CURR | 13 | 2 | Obsolete: tax in vendor error | ||
57 | MAKZMW2 | MAKZMW | WERTV7 | CURR | 13 | 2 | Tax Amount Accepted Manually | ||
58 | MWDIFFB2 | REPDIF | WERTV7 | CURR | 13 | 2 | Invoice Verification difference including tax | ||
59 | FWNAV2 | FWSTEV | WERTV7 | CURR | 13 | 2 | Tax Amount in Document Currency with +/- Sign | ||
60 | MWBNK2 | FWSTEV | WERTV7 | CURR | 13 | 2 | Tax Amount in Document Currency with +/- Sign | ||
61 | ANZRPV | ANZRPV | NUMC3 | NUMC | 3 | 0 | No. of invoice verification attempts | ||
62 | REPART | REPART | REPART | CHAR | 1 | 0 | Indicator: Invoice Verification Type | ||
63 | RBSTAT | RBSTAT | RBSTAT | CHAR | 1 | 0 | Invoice document status | ||
64 | REPDAT | REPDAT | DATUM | DATS | 8 | 0 | Invoice Verification date | ||
65 | REPTIM | REPTIM | SYTIME | TIMS | 6 | 0 | Invoice Verification time | ||
66 | LFDATABLI | LFDAT | DATUM | DATS | 8 | 0 | Delivery date | ||
67 | LFDATBISLI | LFDAT | DATUM | DATS | 8 | 0 | Delivery date | ||
68 | LFDATABRT | LFDATRET | DATUM | DATS | 8 | 0 | Delivery date of return | ||
69 | LFDATBISRT | LFDATRET | DATUM | DATS | 8 | 0 | Delivery date of return | ||
70 | XZUORDLI | XZUORDLI | XFELD | CHAR | 1 | 0 | Indicates delivery item allocation | ||
71 | XZUORDRT | XZUORDRT | XFELD | CHAR | 1 | 0 | Indicates returns allocation | ||
72 | KZBNK | XBNK | CHAR1 | CHAR | 1 | 0 | Planned Delivery Costs Indicator | ||
73 | TBTKZ | TBTKZ | TBTKZ | CHAR | 1 | 0 | Indicator: Subsequent Debit/Credit | ||
74 | ESRNR | ESRNR | ESRNR | CHAR | 11 | 0 | POR subscriber number | ||
75 | ESRPZ | ESRPZ | CHAR2 | CHAR | 2 | 0 | POR check digit | ||
76 | ESRRE | ESRRE | ESRRE | CHAR | 27 | 0 | POR reference number | ||
77 | QSSHB | QSSHB | WERT7 | CURR | 13 | 2 | Withholding Tax Base Amount | ||
78 | QSFBT | QSFBT | WERT7 | CURR | 13 | 2 | Withholding Tax-Exempt Amount (in Document Currency) | ||
79 | QSSKZ | QSSKZ | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code | T059Q | |
80 | DIEKZ | DIEKZ | DIEKZ | CHAR | 1 | 0 | Service indicator (foreign payment) | ||
81 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | T005 | |
82 | LZBKZ | LZBKZ | LZBKZ | CHAR | 3 | 0 | State central bank indicator | T015L | |
83 | ANZRPO | ANZRPO | NUMC6 | NUMC | 6 | 0 | Number of selected invoice items | ||
84 | ANZUNF | ANZUNF | NUMC6 | NUMC | 6 | 0 | Number of unsolved errors | ||
85 | ZFBDT | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
86 | MONAT | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
87 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | T042Z | |
88 | XRKUE | XRKUE | XFELD | CHAR | 1 | 0 | Invoice Automatically Reduced | ||
89 | RCHGART | RCHGART | RCHGART | CHAR | 4 | 0 | Obsolete: Invoice type for inv. verification: do NOT use | ||
90 | XBEST | XZUORD | XFELD | CHAR | 1 | 0 | Checkbox: Allocations | ||
91 | XFRBR | XZUORD | XFELD | CHAR | 1 | 0 | Checkbox: Allocations | ||
92 | XLIFS | XZUORD | XFELD | CHAR | 1 | 0 | Checkbox: Allocations | ||
93 | XWERK | XZUORD | XFELD | CHAR | 1 | 0 | Checkbox: Allocations | ||
94 | TXKRS | TXKRS_BKPF | KURSF | DEC | 9 | 5 | Exchange Rate for Taxes | ||
95 | XRKUER | XRKUER | XFELD | CHAR | 1 | 0 | ID: Autom. inv. reduction allowed? | ||
96 | TAKZPB | TAKZPB | WERT7 | CURR | 13 | 2 | Absolute positive upper acceptance limit | ||
97 | TAKZPP | TAKZPP | PRZ22 | DEC | 4 | 2 | Percentage positive upper acceptance limit | ||
98 | TAKZNB | TAKZNB | WERTV7 | CURR | 13 | 2 | Negative small difference | ||
99 | TAKZNP | TAKZNP | PRZ22 | DEC | 4 | 2 | Percentage negative lower acceptance limit | ||
100 | TRKPB | TRKPB | WERT7 | CURR | 13 | 2 | Autom. invoice reduction: absolute upper limit | ||
101 | TRKPP | TRKPP | PRZ22 | DEC | 4 | 2 | Autom. invoice reduction: percentage upper limit | ||
102 | REPARTALT | REPART | REPART | CHAR | 1 | 0 | Indicator: Invoice Verification Type | ||
103 | RBSTATALT | RBSTAT | RBSTAT | CHAR | 1 | 0 | Invoice document status | ||
104 | ANZRPVALT | ANZRPV | NUMC3 | NUMC | 3 | 0 | No. of invoice verification attempts | ||
105 | KZKORREKT | MARKE | CHAR1 | CHAR | 1 | 0 | Select | ||
106 | XMANRK | XMANRK | XFELD | CHAR | 1 | 0 | Indicator for manually reduced invoices | ||
107 | XUNFEH | XUNFEH | XFELD | CHAR | 1 | 0 | Indicator for unclarified errors | ||
108 | XERL | KZERL | XFELD | CHAR | 1 | 0 | Indicates that Invoice Verification has been completed | ||
109 | XERLALT | KZERL | XFELD | CHAR | 1 | 0 | Indicates that Invoice Verification has been completed | ||
110 | LNAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
111 | SKTODAT | RM08_SKDAT | DATUM | DATS | 8 | 0 | Latest date when full cash discount still possible | ||
112 | LKZRK | KZRK | XFELD | CHAR | 1 | 0 | Indicates invoice reduction | ||
113 | RKLIMIT | RKLIMIT | WERT7 | CURR | 13 | 2 | Limit for reducing an invoice in Invoice Verification | ||
114 | PRPLIMIT | PRPLIMIT | WERT7 | CURR | 13 | 2 | Positive Invoice Verification tolerance limit | ||
115 | NRPLIMIT | NRPLIMIT | WERT7 | CURR | 13 | 2 | Negative Invoice Verification tolerance limit | ||
116 | MARKE | MARKE | CHAR1 | CHAR | 1 | 0 | Select | ||
117 | XKPFCHG | MARKE | CHAR1 | CHAR | 1 | 0 | Select |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | IRBKPF | BLART | T003 | BLART | |||
2 | IRBKPF | BUKRS | T001 | BUKRS | |||
3 | IRBKPF | LANDL | T005 | LAND1 | |||
4 | IRBKPF | LZBKZ | T015L | LZBKZ | |||
5 | IRBKPF | MANDT | T000 | MANDT | |||
6 | IRBKPF | MWSKZ1 | T007A | MWSKZ | |||
7 | IRBKPF | MWSKZ2 | T007A | MWSKZ | |||
8 | IRBKPF | QSSKZ | T059Q | QSSKZ | |||
9 | IRBKPF | SMWSKZ1 | T007A | MWSKZ | |||
10 | IRBKPF | SMWSKZ2 | T007A | MWSKZ | |||
11 | IRBKPF | TCODE | TSTC | TCODE | |||
12 | IRBKPF | WAERS | TCURC | WAERS | |||
13 | IRBKPF | ZLSCH | T042Z | ZLSCH |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |