AVIP is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of AVIP in SAP.
- Table description : Payment Advice Line Item
- Module : CRM
- Parent Module : CRM
- Package : FBAS
- Software Component : BBPCRM
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 |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output 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