SAP AVIP_DRAFT I_PAYMENTADVICETP I_PAYMENTADVICEITEMTP Table

Overview

AVIP_DRAFT is a standard SAP S/4HANA table that stores I_PAYMENTADVICETP I_PAYMENTADVICEITEMTP data. There are total 67 fields in the AVIP_DRAFT table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table AVIP_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 AVIP_DRAFT to other SAP tables and standard CDS views available based on AVIP_DRAFT table in S/4HANA 2020.

Techincal Settings of AVIP_DRAFT

Below are technical details of the table AVIP_DRAFT

Buffering not allowed
No buffering
Storage type is Column Store

List of AVIP_DRAFT Fields

The following table gives you an overview of the fields available in AVIP_DRAFT

Field	Description	Data Element	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
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
PAYMENTADVICEITEM	Payment Advice Item	AVSPO	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	FARP_PA_AVSID	CHAR	16
PAYMENTADVICEITEMFOREDIT	Payment Advice Item	AVSPO	NUMC	5
PAYMENTADVICEALTVACCOUNT	Alternative Account (Payment Advice Management)	ABWKO_AV	CHAR	10
ALTERNATIVECOMPANYCODE	Alternative Company Code (Payment Advice Management)	FARP_ABWBU_AV	CHAR	4
ACCOUNTINGDOCUMENT	Document	FARP_PA_BELNR_D	CHAR	10
DOCUMENTREFERENCEID	Reference Document Number provided by the Customer/Supplier	FARP_XBLNR1	CHAR	16
BILLINGDOCUMENT	Billing Document	VBELN_VF	CHAR	10
BRANCHACCOUNT	Account Number of the Branch	FARP_FILKD	CHAR	10
ACCOUNTINGDOCUMENTCREATIONDATE	Journal Entry Date	FARP_PA_CPUDT	DATS	8
BUSINESSAREA	Business Area	GSBER	CHAR	4
BUSINESSAREANAME	Business Area Description	FARP_GTEXT	CHAR	30
ASSIGNMENTREFERENCE	Assignment number	FARP_DZUONR	CHAR	18
PAYTDIFFERENCEREASONEXTCODE	External Reason Code for Payment Differences	RSTGR_EXT	CHAR	3
DOCUMENTITEMTEXT	Item Description	FARP_PA_SGTXT	CHAR	50
TAXAMOUNTINCOCODECRCY	Tax Amount in Local Currency	FARP_MWSTS	CURR	23
TAXCODE	Tax on sales/purchases code	MWSKZ	CHAR	2
GROSSAMOUNTINPAYMENTCURRENCY	Gross Amount	WRBTR_AV	CURR	23
NETPAYMENTAMOUNTINPAYTCURRENCY	Net Payment Amount with +/- Sign	NEBTR_AV	CURR	23
CASHDISCOUNTAMOUNTINPAYTCRCY	Cash Discount Amount with +/- Sign	WSKTO_AV	CURR	23
FISCALYEAR	Fiscal Year	GJAHR	NUMC	4
ACCOUNTINGDOCUMENTITEM	Posting View Item	FARP_BUZEI	NUMC	3
PAYMENTADVICEALTVACCOUNTTYPE	Account Type	FARP_ABWKA_AV	CHAR	1
CASHDISCOUNTPERCENT	Selected cash discount percentage rate	DZBDXP	DEC	5
CASHDISCOUNTDAYS	Selected cash discount days	DZBDXT	DEC	3
DIFFERENCEAMOUNTINCOCODECRCY	Amount Difference in Local Currency	FARP_DIFHW	CURR	23
DIFFERENCEAMOUNT	Amount Difference in Foreign Currency	FARP_DIFFW	CURR	23
DIFFAMTINADDITIONALCURRENCY1	Amount Difference in Second Local Currency	FARP_DIFH2	CURR	23
DIFFAMTINADDITIONALCURRENCY2	Amount Difference in Third Local Currency	FARP_DIFH3	CURR	23
ITEMISACTIVATED	Indicator: Items Activated?	FARP_XAKTP	CHAR	1
CASHDISCOUNTISACTIVATED	Indicator: Cash Discount Activated?	FARP_XAKTS	CHAR	1
ISPARTIALPAYMENT	Indicator: Partial Payments	FARP_XPPMT	CHAR	1
PAYTDIFFRSDLBALISCARRIEDFWD	Indicator: Carryforward Residual Bal. for Payt Difference?	FARP_XVORT	CHAR	1
PAYMENTDIFFERENCEREASON	Reason Code for Payments	RSTGR	CHAR	3
PAYMENTDIFFERENCEREASONNAME	Reason Code Short Text	TXT20_053	CHAR	20
PAYMENTDIFFERENCEREASONDESC	Payment Difference Reason Code Description	FARP_PA_REASONCODE_DESC	CHAR	40
CURRENCY	Currency Key	WAERS	CUKY	5
REFERENCE1IDBYBUSINESSPARTNER	Business Partner Reference Key 1	FARP_XREF1	CHAR	12
REFERENCE2IDBYBUSINESSPARTNER	Business Partner Reference Key 2	FARP_XREF2	CHAR	12
DELIVERYDOCUMENT	Delivery	VBELN_VL	CHAR	10
INVOICEDATE	Document Date	FARP_PA_REDAT	DATS	8
PURCHASINGDOCREFERENCEBYCUST	Customer Reference	BSTNK	CHAR	20
ISPOSTEDONACCOUNT	Indicator: Posting on Account	XACON	CHAR	1
PAYMENTADVICESTATUS	Payment Advice Status	FARP_ASTAT_AVIK	CHAR	1
DEDUCTIONAMOUNTINPAYTCURRENCY	Deduction Amount	ABBTR_AV	CURR	23
PAYMENTREFERENCE	Payment Reference	FARP_KIDNO	CHAR	30
TAXCALCULATIONPROCEDURE	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	FARP_KALSM_D	CHAR	6
TOTALCOUNT	Number of Subitems	FARP_NUMBER_OF_SUBITEMS	INT4	10
ADDITIONALCURRENCY1	Additional Currency 1	FIS_HWAE2	CUKY	5
ADDITIONALCURRENCY2	Additional Currency 2	FIS_HWAE3	CUKY	5
COMPANYCODECURRENCY	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 AVIP_DRAFT

SAP AVIP_DRAFT I_PAYMENTADVICETP I_PAYMENTADVICEITEMTP Table

Overview

Techincal Settings of AVIP_DRAFT

List of AVIP_DRAFT Fields

Foreign Key Relationships

Other References