CFIN_AV_CI_ROOT - Billing Document: Header Data

Billing Document: Header Data information is stored in SAP table CFIN_AV_CI_ROOT.
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_CI_ROOT

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
.INCLUDEADMINFINS_CFIN_S_AV_ADMIN_DATA0
AV_CHANGEDTIMEAccounting View Changed TimeFINS_CFIN_AV_CHANGEDTIMEDEC8
AV_CHANGEUSERAccounting View Change UserFINS_CFIN_AV_CHANGEUSERCHAR24
AV_CREATEDTIMEAccounting View Created TimeFINS_CFIN_AV_CREATEDTIMEDEC8
AV_CREATEUSERAccounting View Create UserFINS_CFIN_AV_CREATEUSERCHAR24
.INCLUDEDATAFINS_CFIN_S_AV_CI_ROOT0
FINS_LOGSYSLogical systemLOGSYSCHAR20TBDLS
VBELNBilling DocumentVBELN_VFCHAR20
KUNAGSold-to PartyKUNAGCHAR20KNA1
ERDATDate on which the record was createdERDATDATS16
BUKRSCompany CodeBUKRSCHAR8T001
VBTYPSD Document CategoryVBTYPLCHAR8
SFAKNNumber of canceled billing documentSFAKNCHAR20
FKDATBilling DateFKDATDATS16
WAERKSD Document CurrencyWAERKCUKY10TCURC
KURRFExchange Rate for Postings to Financial AccountingKURRFDEC5
KUNRGPayerKUNRGCHAR20KNA1
VALTGAdditional Value DaysVALTGNUMC4
KALSMPricing Procedure in PricingKALSMASDCHAR12T683
KNUMVNumber of the Document ConditionKNUMVCHAR20
LANDTXTax Departure Country/RegionLANDTXCHAR6*
KURRF_DATTranslation dateWWERT_DDATS16
FKSTOBilling document is canceledFKSTOCHAR2
STCEG_HOrigin of Sales Tax ID NumberSTCEG_HCHAR2
IUUC_OPERAT_FLAGDelete/Archive IndicatorFINS_CFIN_AV_OPERATIONCHAR2
FKTYPBilling CategoryFKTYPCHAR2
.INCLUDECFAVCI_INCL_EEW_PS0
DUMMY_AVCI_INCL_EEW_PSCustom Fields: Dummy for Use in Extension IncludesCFD_DUMMYCHAR2
Privacy Policy