CFIN_AV_PRC_ELEM - Pricing Elements

Pricing Elements information is stored in SAP table CFIN_AV_PRC_ELEM.
It is part of development package FINS_CFIN_ACC_VIEW in software component FI-CF-AVL. This development package consists of objects that can be grouped under "Central Finance - Accounting View".

Fields for table CFIN_AV_PRC_ELEM

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
.INCLUDEKEYXFINS_CFIN_S_AV_DBKEY0
AV_DBKEYAccounting View DB KEYXFINS_CFIN_AV_DBKEYRAW16
.INCLUDEHIERACHYFINS_CFIN_S_AV_HIERACHY0
AV_PARENTKEYAccounting View Parent KeyFINS_CFIN_AV_PARENTKEYRAW16
AV_ROOTKEYAccounting View Root KeyFINS_CFIN_AV_ROOTKEYRAW16
.INCLUDEDATAFINS_CFIN_S_AV_PRC_ELEM0
FINS_LOGSYSLogical systemLOGSYSCHAR20TBDLS
KNUMVNumber of the Document ConditionKNUMVCHAR20
KPOSNCondition item numberKPOSNNUMC12
STUNRStep NumberSTUNRNUMC6*
KAPPLApplicationKAPPLCHAR4*
KSCHLCondition TypeKSCHACHAR8*
KDATUTimestamp for PricingVFPRC_TIMESTAMPCHAR28
KRECHCalculation Type for ConditionKRECH_LONGCHAR6
KAWRTCondition BasisVFPRC_ELEMENT_BASE_VALUEDEC13
KBETRCondition Amount or PercentageVFPRC_ELEMENT_AMOUNTDEC13
WAERSCurrency KeyWAERSCUKY10*
KKURSCondition exchange rate for conversion to local currencyKKURSDEC5
KPEINCondition Pricing UnitKPEINDEC3
KMEINCondition Unit in the DocumentKVMEIUNIT6*
KUMZANumerator for Converting to Base UoMVFPRC_NUMERATORDEC6
KUMNEDenominator for Converting to Base UoMVFPRC_DENOMINATORDEC6
KNTYPCondition Category (Examples: Tax, Freight, Price, Cost)KNTYPCHAR2
KSTATCondition is used for statisticsKSTATCHAR2
KNPRSScale TypeSTFKZCHAR2
KRUEKCondition is Relevant for Accrual (e.g. Freight)KRUEKCHAR2
KRELICondition for Invoice ListKRELICHAR2
KHERKOrigin of the ConditionKHERKCHAR2
KGRPEGroup ConditionKGRPECHAR2
KOUPDCondition UpdateKOUPDCHAR2
KOLNRAccess sequence - Access numberKOLNRNUMC6*
KNUMHNumber of the Condition RecordKNUMHCHAR20
KOPOSSequential Number of the ConditionKOPOS_LONGNUMC6
MWSK1Tax on sales/purchases codeMWSKZCHAR4*
MWSK2Withholding Tax CodeWT_WITHCDCHAR4*
KUNNRCustomer number (rebate recipient)KUNNR_KOCHAR20*
KDIFFRounding-Off Difference of the ConditionKDIFFCURR3
KWERTCondition ValueVFPRC_ELEMENT_VALUECURR8
KSTEUCondition ControlKSTEUCHAR2
KINAKCondition is InactiveKINAKCHAR2
KOAIDCondition ClassKOAIDCHAR2
KMXAWIndicator for Maximum Condition Basis ValueKMXAWCHAR2
KMXWRIndicator for Maximum Condition AmountKMXWRCHAR2
KFAKTORFactor for Condition Base ValueKFAKTORFLTP8
KDUPLStructure ConditionKDUPLCHAR2
KFAKTOR1Factor for Condition Basis (Period)KFAKTOR1FLTP8
KZBZGScale Basis IndicatorKZBZG_LONGCHAR6
KSTBSScale Base ValueVFRPC_SCALE_BASE_VALUEDEC13
KONMSCondition Scale Unit of MeasureKONMSUNIT6*
KONWSScale CurrencyKONWSCUKY10*
KAWRT_KCondition BasisVFPRC_ELEMENT_BASE_VALUEDEC13
KWAEHCondition Currency (for Cumulation Fields)KWAEHCUKY10*
KWERT_KCondition ValueVFPRC_ELEMENT_VALUECURR8
KFKIVCondition for Intercompany BillingKFKIVCHAR2
KVARCCondition Used for Variant ConfigurationKVARCCHAR2
KMPRSCondition Changed ManuallyKMPRSCHAR2
PRSQUPrice SourcePRSQU1CHAR2
VARCONDVariant Condition KeyVARCONDCHAR52*
KTRELRelevance for Account AssignmentKTRELCHAR2
MDFLGIndicator: Matrix MaintenanceMDFLGCHAR2
TXJLVTax jurisdiction code levelTXJCD_LEVELCHAR2
WAERKSD Document CurrencyWAERKCUKY10*
Privacy Policy