Overview
AVIR_DRAFT is a standard SAP S/4HANA table that stores I_PAYMENTADVICETP I_PAYMENTADVICESUBITEMTP data. There are total 31 fields in the AVIR_DRAFT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AVIR_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 AVIR_DRAFT to other SAP tables and standard CDS views available based on AVIR_DRAFT table in S/4HANA 2020.
Techincal Settings of AVIR_DRAFT
Below are technical details of the table AVIR_DRAFT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AVIR_DRAFT Fields
The following table gives you an overview of the fields available in AVIR_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 |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | | RAW | 16 |
| ROOTDRAFTUUID | 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 | AVSID | | CHAR | 16 |
| PAYMENTADVICEITEM | Payment Advice Item | AVSPO | | NUMC | 5 |
| PAYMENTADVICESUBITEM | Payment Advice Subitem | AVSUP | | NUMC | 5 |
| 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 | AVSID | | CHAR | 16 |
| PAYMENTADVICEITEMFOREDIT | Payment Advice Item | AVSPO | | NUMC | 5 |
| PAYMENTADVICESUBITEMFOREDIT | Payment Advice Subitem | AVSUP | | NUMC | 5 |
| NETDEDUCTIONAMOUNTINPAYTCRCY | Net Deduction Amount | RESTN_AV | | CURR | 23 |
| GROSSDEDUCTIONAMOUNTINPAYTCRCY | Gross Deduction Amount | RESTB_AV | | CURR | 23 |
| PAYMENTDIFFERENCEREASON | Reason Code for Payments | FARP_RSTGR | | CHAR | 3 |
| PAYMENTDIFFERENCEREASONNAME | Reason Code Short Text | TXT20_053 | | CHAR | 20 |
| PAYMENTDIFFERENCEREASONDESC | Reason Code Long Text | TXT40_053 | | CHAR | 40 |
| REFERENCE1IDBYBUSINESSPARTNER | Business Partner Reference Key 1 | FARP_XREF1 | | CHAR | 12 |
| REFERENCE2IDBYBUSINESSPARTNER | Business Partner Reference Key 2 | FARP_XREF2 | | CHAR | 12 |
| PAYTDIFFERENCEREASONEXTCODE | External Reason Code for Payment Differences | RSTGR_EXT | | CHAR | 3 |
| CURRENCY | Currency Key | WAERS | | CUKY | 5 |
| 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 AVIR_DRAFT
Other References