AVIP is an SAP table in package FBAS (Financial accounting 'Basis'), used in FI (Financial Accounting), FI-GL / FI-AR / FI-AP. View details, fields & related tables of AVIP in SAP.
- Table description : Payment Advice Line Item
- Module : FI (Financial Accounting)
- Component : FI-GL / FI-AR / FI-AP
- Package : FBAS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP AVIP Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| BUKRS | Company Code | BUKRS | BUKRS |
| KOART | Payment Advice Account Type | KOART_AV | KOART_AV |
| KONTO | Account Number | KTONR_AV | KTONR |
| AVSID | Payment Advice Number | AVSID | AVSID |
| AVSPO | Payment Advice Line Item | AVSPO | AVSPO |
| ABWKO | Alternative Account (Payment Advice Management) | ABWKO_AV | KTONR |
| ABWBU | Alternative Company Code (Payment Advice Management) | ABWBU_AV | BUKRS |
| SFELD | Name of Selection Field | SFELD_AV | FDNAME |
| SWERT | Selection Value (Payment Advice Management) | SWERT_AV | CHAR30 |
| BELNR | Accounting Document Number | BELNR_D | BELNR |
| XBLNR | Reference Document Number | XBLNR1 | XBLNR1 |
| VBELN | Billing document | VBELN_VF | VBELN |
| FILKD | Account Number of the Branch | FILKD | MAXKK |
| CPUDT | Accounting document entry date | CPUDT | DATUM |
| GSBER | Business Area | GSBER | GSBER |
| ZUONR | Assignment number | DZUONR | ZUONR |
| RESTG | External Reason Code for Payment Differences | RSTGR_EXT | CHAR3 |
| SGTXT | Item Text | SGTXT | TEXT50 |
| MWSTS | Tax Amount in Local Currency | MWSTS | WERT7 |
| MWSKZ | Tax on sales/purchases code | MWSKZ | MWSKZ |
| WRBTR | Gross amount | WRBTR_AV | WRTV7 |
| NEBTR | Net Payment Amount with +/- Sign | NEBTR_AV | WRTV7 |
| WSKTO | Cash discount amount with +/- sign | WSKTO_AV | WRTV7 |
| GJAHR | Fiscal Year | GJAHR | GJAHR |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | BUZEI |
| ABWKA | Account Type | ABWKA_AV | KOART_AV |
| ZBDXP | Selected cash discount percentage rate | DZBDXP | PRZ23 |
| ZBDXT | Selected cash discount days | DZBDXT | ZBDXT |
| DIFHW | Amount Difference in Local Currency | DIFHW | WERT7 |
| DIFFW | Amount Difference in Foreign Currency | DIFFW | WRTV7 |
| DIFH2 | Amount Difference in Second Local Currency | DIFH2 | WERT7 |
| DIFH3 | Amount Difference in Third Local Currency | DIFH3 | WERT7 |
| XAKTP | Indicator: Items activated ? | XAKTP | XFELD |
| XAKTS | Indicator: Cash discount activated ? | XAKTS | XFELD |
| XPPMT | Indicator: partial payments | XPPMT | XFELD |
| XVORT | Indicator: Carryforward residual bal. for pmnt difference ? | XVORT | XFELD |
| RSTGN | Reason Code for Payments | RSTGR | RSTGR |
| WAERS | Currency Key | WAERS | WAERS |
| SCURR | Entry Field for Search Criteria (Amount Fields) | SCURR_AV | WERT7 |
| SDATE | Entry Field for Search Criteria (Date Fields) | SDATE_AV | DATUM |
| STYPE | Type of Selection Field (Character, Date, Amount) | STYPE_AV | STYPE_AV |
| SPRIO | Selection Priority | SPRIO_AV | XFELD |
| XREF1 | Business partner reference key | XREF1 | CHAR12 |
| XREF2 | Business partner reference key | XREF2 | CHAR12 |
| AFELD | Name of External Selection Field Specified | AFELD_AV | FDNAME |
| LIEFN | Delivery | VBELN_VL | VBELN |
| REDAT | Invoice Date | REDAT | DATUM |
| BSTNK | Customer purchase order number | BSTNK | BSTNK |
| XACON | Indicator: Posting on account | XACON | XFELD |
| ASTAT | Payment Advice Status | ASTAT_AVIK | CHAR1 |
| XAMCA | Indicator: Do not calculate gross amount if initial? | XAMCA | XFELD |
| ABBTR | Deduction amount | ABBTR_AV | WRTV7 |
| CONTR | Payment Advice Processing Control Field | CONTR_AV | CHAR6 |
| KIDNO | Payment Reference | KIDNO | CHAR30 |
AVIP related tables
| Table | Note |
|---|---|
| AVIP | Payment Advice Line Item |
| EPIC_EBR_AV | Additional Data on Payment Advice Line Item for Bank Receipt |
| IUEEDPPLOTACIND | Interpretation of Payment Advice Line: Ind. Search Module |
| TINV_INV_LINE_A | Payment Advice Line |
| IUEEDPPLOTACINAT | Interpretation of Payment Advice Item: Algorythm IDs, Texts |
| IUEEDPPLOTACINBT | Interpretation of Payment Advice Item: Search Objects, Texts |
| DBERDLB | Reference of a Print Doc. Line Item to a Bill.Doc. Line Item |
| AVIK | Payment Advice Header |
| AVIR | Payment Advice Subitem |
| CNVTDMS_05_INTIN | Internal Bill/Payment Advice Number ISU for TDMS |
| CNVTDMS_05_PAYAD | Fill Header table for Payment Advice |
| CRMD_FS_PA_PROC | Business Process for Payment Advice Details |
| CRMD_FS_PYMT_ADV | FS Payment Advice Extension: DB Table |
| DFKKAVK | Payment Advice: Header Data |
| DFKKAVP | Payment Advice: Items |
Related tcodes for AVIP
Transaction codes in the same SAP package (FBAS) as the AVIP table.
| Tcode | Description |
|---|---|
| FB12 | Correspondence Request |
| FB15 | Assign Items |
| FB16 | Assign Items |
| FB17 | Open Item Assignmnt: Check from List |
| FB18 | Maintain Standard Mail Texts |
| FB21 | Enter Statistical Posting |
| FB22 | Reverse Statistical Posting |
| FB31 | Enter Noted Item |
| FBD9 | Enter Recurring Entry |
| FBS1 | Enter Accrual/Deferral Doc. |
| FSO2 | Change Finan.Statement Vers. (old) |
| FSO3 | Display Finan.Statement Vers. (Old) |
Latest Table Searches
Handling units sap table in SAPHow to display handling unit table in SAP
Sap handling unit zuordnung löschen table in SAP
Where to find handling unit table in SAP
Handling unit management configuration wm table in SAP
Handling unit wm table in SAP
What is sap handling unit table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP