Overview
AVIK_DRAFT is a standard SAP S/4HANA table that stores I_PAYMENTADVICETP I_PAYMENTADVICETP data. There are total 55 fields in the AVIK_DRAFT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AVIK_DRAFT belongs to Fiori FXU Accounts Receivable FI-FIO-AR (CA-GTF-FXU-FI-AR) module and is located in the package oData Services - Payment Advices (ODATA_PAYMENTADVICES).
In addition, following links provide an overview of foreign key relationships, if any, that link AVIK_DRAFT to other SAP tables and standard CDS views available based on AVIK_DRAFT table in S/4HANA 2020.
Techincal Settings of AVIK_DRAFT
Below are technical details of the table AVIK_DRAFT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AVIK_DRAFT Fields
The following table gives you an overview of the fields available in AVIK_DRAFT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|
| MANDT | Client | MANDT | | CLNT | 3 |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | | RAW | 16 |
| COMPANYCODE | Company Code | BUKRS | | CHAR | 4 |
| PAYMENTADVICEACCOUNTTYPE | Payment Advice Account Type | KOART_AV | | CHAR | 1 |
| PAYMENTADVICEACCOUNT | Customer ID | FARP_CUSTOMER_ID | | CHAR | 10 |
| PAYMENTADVICE | Payment Advice Number | FARP_PA_AVSID | | CHAR | 16 |
| COMPANYCODEFOREDIT | Company Code | BUKRS | | CHAR | 4 |
| PAYTADVICEACCOUNTTYPEFOREDIT | Payment Advice Account Type | KOART_AV | | CHAR | 1 |
| PAYMENTADVICEACCOUNTFOREDIT | Customer ID | FARP_CUSTOMER_ID | | CHAR | 10 |
| PAYMENTADVICEFOREDIT | Payment Advice Number | FARP_PA_AVSID | | CHAR | 16 |
| PAYMENTDOCUMENT | Payment Document Number | FARP_PA_VBLNR | | CHAR | 10 |
| ACCOUNTBYSHIPPER | Payee's Account at the Customer | FARP_PA_EIKTO | | CHAR | 12 |
| PAYMENTCURRENCY | Payment Currency Key | FARP_FWAER | | CUKY | 5 |
| PAYMENTDATE | Payment Date | FARP_PAYMENT_DATE | | DATS | 8 |
| PAIDAMOUNTINPAYTCURRENCY | Payment Amount from the Payment Advice Header | RWBTR_AV | | CURR | 23 |
| CASHDISCOUNTAMOUNTINPAYTCRCY | Cash Discount Amount | FIS_WSKTO | | CURR | 23 |
| PARTNERBANKCOUNTRY | Country Key of Partner Bank | PABKS_EB | | CHAR | 3 |
| PARTNERBANKSWIFTCODE | SWIFT Code of Partner Bank | PASWI_EB | | CHAR | 11 |
| CREATEDBYUSER | Name of Person who Created the Object | ERNAM | | CHAR | 12 |
| CREATIONDATE | Date on which the record was created | ERDAT | | DATS | 8 |
| LASTCHANGEDATE | Date of Last Change | AEDAT | | DATS | 8 |
| LASTCHANGEDBYUSER | Name of person who changed object | AENAM | | CHAR | 12 |
| PAYMENTADVICEHEADERTEXT | Payment Advice Header Text | FARP_AVTXT_AVIK | | CHAR | 25 |
| PAYMENTADVICETYPE | Payment Advice Type | AVSRT | | CHAR | 2 |
| PAYMENTADVICETYPENAME | Short Text for Fixed Values | VAL_TEXT | | CHAR | 60 |
| CREATIONTIME | Time of Entry | CPUTM | | TIMS | 6 |
| PAYMENTADVICESTATUS | Payment Advice Status | ASTAT_AVIK | | CHAR | 1 |
| PAYTADVCDIFFDETERMINATIONRULE | Reason Code Conversion Version | FARP_VRSDG | | CHAR | 3 |
| PAYTADVCDIFFDETNRULEDESC | Reason Code Conversion Version Name | VRSTX | | CHAR | 30 |
| PAYMENTADVICESELECTIONRULE | Selection Rule for Payment Advices | SREGL | | CHAR | 3 |
| PAYTADVICESELECTIONRULEDESC | Text | TXT25 | | CHAR | 25 |
| ORIGINALREFERENCEDOCUMENT | Object key | AWKEY | | CHAR | 20 |
| CUSTOMERNAME | Customer Full Name | FARP_CUSTOMER_FULL_NAME | | CHAR | 220 |
| FULLNAME | Full Name of Person | AD_NAMTEXT | | CHAR | 80 |
| ORGANIZATIONBPNAME1 | Name 1 | NAME1_GP | | CHAR | 35 |
| ORGANIZATIONBPNAME2 | Name 2 | NAME2_GP | | CHAR | 35 |
| COMPANYCODENAME | Name of Company Code or Company | BUTXT | | CHAR | 25 |
| PAYMENTADVICEISEXTRACTED | Manage payment advices ML processing indicator | AVIK_ML_IS_PROCESSED | | CHAR | 1 |
| PAYTADVICEEXTRACTORCONFIDENCE | Manage payment advices ML Confidence | AVIK_ML_CONFIDENCE | | DEC | 5 |
| PAYMENTADVICEEXTRACTORUUID | Manage Payment advices ML UUID | AVIK_ML_UUID | | CHAR | 36 |
| PAYMENTADVICEUUID | Payment advice UUID | PAYMENTADVICEUUID | | CHAR | 90 |
| PAYMENTADVICEEXTRACTIONSTATUS | Payment advice extraction status | FAR_PA_ML_EXTRACTION_STATUS | | CHAR | 2 |
| UXFCPAYMENTADVICEACCOUNT | UI Field Control Byte (Should be defined centrally) | FDC_UX_FC | | INT1 | 3 |
| ACCOUNTINGCLERK | Accounting Clerk | FAC_ACCTG_CLERK | | CHAR | 2 |
| ACCOUNTINGCLERKNAME | Accounting Clerk Name | FARP_ACCOUNTING_CLERK_NAME | | CHAR | 30 |
| CUSTOMER | Account Number | KTONR_AV | | CHAR | 10 |
| PAYMENTADVICEITEMTOTALAMOUNT | Total of Payment Amounts for All Payment Advice Items | FARP_PA_ITEM_TOTAL_AMOUNT | | CURR | 23 |
| BANKREFERENCE | Payment Reference | FAR_MPA_PAYMENT_REFERENCE | | CHAR | 35 |
| BUSINESSPARTNERNAME | Extracted Customer Name | FAR_MPA_EXT_CUSTOMER_NAME | | CHAR | 55 |
| HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | | CHAR | 1 |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | | DEC | 21 |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | | DEC | 21 |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | | RAW | 16 |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | | CHAR | 1 |
| DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AVIK_DRAFT
Other References