FAV

FAV is an SAP database table in S/4HANA. It contains 20 fields.

Fields (20)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AssetAccountingKeyFigure AssetAccountingKeyFigure 1
AssetAcctTransClassfctn AssetAcctTransClassfctn 1
AssetCapitalizationDate AssetCapitalizationDate 1
AssetDeactivationDate AssetDeactivationDate 1
AssetDepreciationArea AssetDepreciationArea 1
AssetValueDate AssetValueDate 1
ChartOfDepreciation ChartOfDepreciation 1
CompanyCode CompanyCode 1
CompanyCodeCurrency CompanyCodeCurrency 1
DocumentDate DocumentDate 1
FiscalYear FiscalYear 1
FixedAsset FixedAsset 1
Ledger Ledger 1
MasterFixedAsset MasterFixedAsset 1
PartnerFixedAsset PartnerFixedAsset 1
PartnerMasterFixedAsset PartnerMasterFixedAsset 1
PostingDate PostingDate 1
SubLedgerAcctLineItemType SubLedgerAcctLineItemType 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAV (
    ACCOUNTINGDOCUMENT,
    AMOUNTINCOMPANYCODECURRENCY,
    ASSETACCOUNTINGKEYFIGURE,
    ASSETACCTTRANSCLASSFCTN,
    ASSETCAPITALIZATIONDATE,
    ASSETDEACTIVATIONDATE,
    ASSETDEPRECIATIONAREA,
    ASSETVALUEDATE,
    CHARTOFDEPRECIATION,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    DOCUMENTDATE,
    FISCALYEAR,
    FIXEDASSET,
    LEDGER,
    MASTERFIXEDASSET,
    PARTNERFIXEDASSET,
    PARTNERMASTERFIXEDASSET,
    POSTINGDATE,
    SUBLEDGERACCTLINEITEMTYPE
);