SAP AVIP (Payment Advice Line Item) Table & Fields

AVIP is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of AVIP.
  • Table description : Payment Advice Line Item
  • Module : CRM
  • Parent Module : CRM
  • Package : FBAS
  • Software Component : BBPCRM

AVIP hierarchy

BBPCRMCRMCRMAVIP

AVIP Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
BUKRSCompany CodeBUKRSBUKRS
KOARTPayment Advice Account TypeKOART_AVKOART_AV
KONTOAccount NumberKTONR_AVKTONR
AVSIDPayment Advice NumberAVSIDAVSID
AVSPOPayment Advice Line ItemAVSPOAVSPO
ABWKOAlternative Account (Payment Advice Management)ABWKO_AVKTONR
ABWBUAlternative Company Code (Payment Advice Management)ABWBU_AVBUKRS
SFELDName of Selection FieldSFELD_AVFDNAME
SWERTSelection Value (Payment Advice Management)SWERT_AVCHAR30
BELNRAccounting Document NumberBELNR_DBELNR
XBLNRReference Document NumberXBLNR1XBLNR1
VBELNBilling documentVBELN_VFVBELN
FILKDAccount Number of the BranchFILKDMAXKK
CPUDTAccounting document entry dateCPUDTDATUM
GSBERBusiness AreaGSBERGSBER
ZUONRAssignment numberDZUONRZUONR
RESTGExternal Reason Code for Payment DifferencesRSTGR_EXTCHAR3
SGTXTItem TextSGTXTTEXT50
MWSTSTax Amount in Local CurrencyMWSTSWERT7
MWSKZTax on sales/purchases codeMWSKZMWSKZ
WRBTRGross amountWRBTR_AVWRTV7
NEBTRNet Payment Amount with +/- SignNEBTR_AVWRTV7
WSKTOCash discount amount with +/- signWSKTO_AVWRTV7
GJAHRFiscal YearGJAHRGJAHR
BUZEINumber of Line Item Within Accounting DocumentBUZEIBUZEI
ABWKAAccount TypeABWKA_AVKOART_AV
ZBDXPSelected cash discount percentage rateDZBDXPPRZ23
ZBDXTSelected cash discount daysDZBDXTZBDXT
DIFHWAmount Difference in Local CurrencyDIFHWWERT7
DIFFWAmount Difference in Foreign CurrencyDIFFWWRTV7
DIFH2Amount Difference in Second Local CurrencyDIFH2WERT7
DIFH3Amount Difference in Third Local CurrencyDIFH3WERT7
XAKTPIndicator: Items activated ?XAKTPXFELD
XAKTSIndicator: Cash discount activated ?XAKTSXFELD
XPPMTIndicator: partial paymentsXPPMTXFELD
XVORTIndicator: Carryforward residual bal. for pmnt difference ?XVORTXFELD
RSTGNReason Code for PaymentsRSTGRRSTGR
WAERSCurrency KeyWAERSWAERS
SCURREntry Field for Search Criteria (Amount Fields)SCURR_AVWERT7
SDATEEntry Field for Search Criteria (Date Fields)SDATE_AVDATUM
STYPEType of Selection Field (Character, Date, Amount)STYPE_AVSTYPE_AV
SPRIOSelection PrioritySPRIO_AVXFELD
XREF1Business partner reference keyXREF1CHAR12
XREF2Business partner reference keyXREF2CHAR12
AFELDName of External Selection Field SpecifiedAFELD_AVFDNAME
LIEFNDeliveryVBELN_VLVBELN
REDATInvoice DateREDATDATUM
BSTNKCustomer purchase order numberBSTNKBSTNK
XACONIndicator: Posting on accountXACONXFELD
ASTATPayment Advice StatusASTAT_AVIKCHAR1
XAMCAIndicator: Do not calculate gross amount if initial?XAMCAXFELD
ABBTRDeduction amountABBTR_AVWRTV7
CONTRPayment Advice Processing Control FieldCONTR_AVCHAR6
KIDNOPayment ReferenceKIDNOCHAR30