SAP ABAP Table AVIK (Payment Advice Header)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FBAS (Package) Financial accounting 'Basis'
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FBAS (Package) Financial accounting 'Basis'
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | AVIK | Table Relationship Diagram |
Short Description | Payment Advice Header |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | * | |
2 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
3 | KOART | KOART_AV | KOART_AV | CHAR | 1 | 0 | Payment Advice Account Type | ||
4 | KONTO | KTONR_AV | KTONR | CHAR | 10 | 0 | Account Number | ||
5 | AVSID | AVSID | AVSID | CHAR | 16 | 0 | Payment Advice Number | ||
6 | XAUSG | XAUSG_AV | XFELD | CHAR | 1 | 0 | Indicator: Outgoing payment using payment advice ? | ||
7 | VBLNR | VBLNR | BELNR | CHAR | 10 | 0 | Document Number of the Payment Document | ||
8 | EIKTO | EIKTO | CHAR12 | CHAR | 12 | 0 | Shipper's (Our) Account Number at the Customer or Vendor | ||
9 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
10 | ZALDT | DZALDT | DATUM | DATS | 8 | 0 | Probable Payment Date (Cash Discount 1 Due) | ||
11 | RWBTR | RWBTR_AV | WRTV7 | CURR | 13 | 2 | Payment Amount from the Payment Advice Header | ||
12 | RWSKT | RWSKT | WRTV7 | CURR | 13 | 2 | Total Cash Discount for the Pmnt Transactn in Pmnt Currency | ||
13 | WEFAE | WEFAE | DATUM | DATS | 8 | 0 | Bill of Exchange Due Date | ||
14 | RZAWE | RZAWE | ZLSCH | CHAR | 1 | 0 | Payment Method for This Payment | * | |
15 | ZBNKL | DZBNKL | BANKL | CHAR | 15 | 0 | Bank number of the payee's bank | ||
16 | ZBNKN | DZBNKN | BANKN | CHAR | 18 | 0 | Bank account number of the payee | ||
17 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
18 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
19 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
20 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
21 | AVTXT | AVTXT_AVIK | TEXT25 | CHAR | 25 | 0 | Payment Advice Header Text | ||
22 | AVSRT | AVSRT | AVSRT | CHAR | 2 | 0 | Payment Advice Type | ||
23 | TCODE | TCODE_AVIK | TCODE | CHAR | 20 | 0 | Transaction Code | TSTC | |
24 | CPUTM | CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
25 | ASTAT | ASTAT_AVIK | CHAR1 | CHAR | 1 | 0 | Payment Advice Status | ||
26 | XACON | XACON_AVIK | XFELD | CHAR | 1 | 0 | Indicator: Payment advice posted on account? | ||
27 | XKEEP | XKEEP_AVIK | XFELD | CHAR | 1 | 0 | Indicator: Hold payment advice in the system? | ||
28 | XUNIQ | XUNIQ_AVIK | XFELD | CHAR | 1 | 0 | Indicator: Specific account/company code in payment advice? | ||
29 | VRSDG | VRSDG | VRSDG | CHAR | 3 | 0 | Reason Code Conversion Version | T053V | |
30 | SREGL | SREGL | SREGL | CHAR | 3 | 0 | Selection Rule for Payment Advices | T053A | |
31 | XBENR | AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
32 | XBTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
33 | VGREF | REFBK | CHAR35 | CHAR | 35 | 0 | Bank Reference Number | ||
34 | PAKOA | KOART_AV | KOART_AV | CHAR | 1 | 0 | Payment Advice Account Type | ||
35 | PAKTO | KTONR_AV | KTONR | CHAR | 10 | 0 | Account Number | ||
36 | BVDAT | BVDAT_EB | DATE_EB | DATS | 8 | 0 | Posting date at the bank | ||
37 | BUTIM | BUTIM_EB | TIME6 | CHAR | 6 | 0 | Value date time | ||
38 | SPESK | SPESK_EB | WERT7 | CURR | 13 | 2 | Fees in account currency | ||
39 | VORGC | VORGC_EB | CHAR3 | CHAR | 3 | 0 | Business transaction code | ||
40 | TEXTS | TEXTS_EB | CHAR4 | CHAR | 4 | 0 | Text key | ||
41 | ZBNKS | PABKS_EB | LAND1 | CHAR | 3 | 0 | Country key of partner bank | * | |
42 | ZBSWI | PASWI_EB | SWIFT | CHAR | 11 | 0 | SWIFT code of partner bank | ||
43 | KURSF | KURSF_EB | KURSF | DEC | 9 | 5 | Exchange rate (different from local currency) | ||
44 | JPDAT | JPDAT_EB | DATE_EB | DATS | 8 | 0 | Date of failed bills of exchange in Japan | ||
45 | CHECT | CHECT | CHCKN | CHAR | 13 | 0 | Check number | ||
46 | XCONF | XCONF_AVIK | CHAR1 | CHAR | 1 | 0 | Indicator: Payment confirmed | ||
47 | AVRT2 | AVSRT | AVSRT | CHAR | 2 | 0 | Payment Advice Type | ||
48 | ZBPRN | PARTN_EB | CHAR55 | CHAR | 55 | 0 | Business Partner | ||
49 | VALUT | VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | AVIK | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | AVIK | SREGL | T053A | SREGL | REF | C | CN |
3 | AVIK | TCODE | TSTC | TCODE | REF | 1 | CN |
4 | AVIK | VRSDG | T053V | VRSDG | REF | C | CN |
5 | AVIK | WAERS | TCURC | WAERS | REF | C | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |