VALUES

VALUES is an SAP database table in S/4HANA. It contains 185 fields.

Fields (185)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 6
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure 6
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet 3
KEY AssetAccountingSortedKeyFigure AssetAccountingSortedKeyFigure 3
KEY AssetAccountingValueType AssetAccountingValueType 2
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn 5
KEY AssetDepreciationArea AFABE,AssetDepreciationArea 17
KEY AssetTransactionType AssetTransactionType,bwasl 7
KEY AssetValuationView AssetValuationView 5
KEY AssetValueDate AssetValueDate,bzdat 8
KEY CharcInternalID CharcInternalID 1
KEY CharcValuePositionNumber CharcValuePositionNumber 1
KEY ClassType ClassType 1
KEY ClfnObjectID FunctionalLocation 1
KEY CompanyCode bukrs,CompanyCode 22
KEY CurrencyRole CurrencyRole 6
KEY DebitCreditCode DebitCreditCode 5
KEY FiscalPeriod FiscalPeriod 9
KEY FiscalYear FiscalYear,GJAHR 17
KEY FixedAsset ANLN2,FixedAsset 19
KEY Ledger Ledger 18
KEY MasterFixedAsset ANLN1,MasterFixedAsset 19
KEY ReferenceDocument belnr,ReferenceDocument 7
KEY ReferenceDocumentItem buzei,ReferenceDocumentItem 6
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 5
KEY TransactionSubitem LNRAN,TransactionSubitem 8
_AcqnProdnCostGLAccount _AcqnProdnCostGLAccount 2
_AssetAccountDetermination _AssetAccountDetermination 2
_AssetAccountingValueType _AssetAccountingValueType 2
_AssetClass _AssetClass 2
_AssetKeyFigure _AssetKeyFigure 1
_AssetKeyFigureSet _AssetKeyFigureSet 2
_ChartOfAccounts _ChartOfAccounts 2
_ChartOfDepreciation _ChartOfDepreciation 1
_CompanyCode _CompanyCode 5
_Currency _Currency 3
_CurrencyRole _CurrencyRole 5
_DepreciationArea _DepreciationArea 2
_FiscalPeriod _FiscalPeriod 1
_FiscalYear _FiscalYear 3
_FixedAsset _FixedAsset 7
_JournalEntry _JournalEntry 1
_Ledger _Ledger 5
_MasterFixedAsset _MasterFixedAsset 5
_SelectedCurrencyBranch _SelectedCurrencyBranch 2
_UnitOfMeasure _UnitOfMeasure 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 4
AccountingDocumentCreationDate AccountingDocumentCreationDate 5
AccountingDocumentType AccountingDocumentType 4
AcqnProdnAmtInDspCrcy AcqnProdnAmtInDspCrcy 1
AcqnProdnCostGLAccount AcqnProdnCostGLAccount 2
ActualAmountInCompanyCodeCrcy ActualAmountInCompanyCodeCrcy 2
ActualAmountInFreeDfndCrcy1 ActualAmountInFreeDfndCrcy1 2
ActualAmountInFreeDfndCrcy2 ActualAmountInFreeDfndCrcy2 2
ActualAmountInFreeDfndCrcy3 ActualAmountInFreeDfndCrcy3 2
ActualAmountInFreeDfndCrcy4 ActualAmountInFreeDfndCrcy4 2
ActualAmountInFreeDfndCrcy5 ActualAmountInFreeDfndCrcy5 2
ActualAmountInFreeDfndCrcy6 ActualAmountInFreeDfndCrcy6 2
ActualAmountInFreeDfndCrcy7 ActualAmountInFreeDfndCrcy7 2
ActualAmountInFreeDfndCrcy8 ActualAmountInFreeDfndCrcy8 2
ActualAmountInGlobalCurrency ActualAmountInGlobalCurrency 2
AlternativeGLAccount AlternativeGLAccount 4
AmountInDisplayCurrency AmountInDisplayCurrency 3
AmountInDisplayCurrency1 AmountInDisplayCurrency1 2
AmountInDisplayCurrency10 AmountInDisplayCurrency10 2
AmountInDisplayCurrency11 AmountInDisplayCurrency11 2
AmountInDisplayCurrency12 AmountInDisplayCurrency12 2
AmountInDisplayCurrency13 AmountInDisplayCurrency13 2
AmountInDisplayCurrency14 AmountInDisplayCurrency14 2
AmountInDisplayCurrency15 AmountInDisplayCurrency15 2
AmountInDisplayCurrency16 AmountInDisplayCurrency16 2
AmountInDisplayCurrency17 AmountInDisplayCurrency17 2
AmountInDisplayCurrency18 AmountInDisplayCurrency18 2
AmountInDisplayCurrency19 AmountInDisplayCurrency19 2
AmountInDisplayCurrency2 AmountInDisplayCurrency2 2
AmountInDisplayCurrency20 AmountInDisplayCurrency20 1
AmountInDisplayCurrency21 AmountInDisplayCurrency21 1
AmountInDisplayCurrency22 AmountInDisplayCurrency22 1
AmountInDisplayCurrency23 AmountInDisplayCurrency23 1
AmountInDisplayCurrency3 AmountInDisplayCurrency3 2
AmountInDisplayCurrency4 AmountInDisplayCurrency4 2
AmountInDisplayCurrency5 AmountInDisplayCurrency5 2
AmountInDisplayCurrency6 AmountInDisplayCurrency6 2
AmountInDisplayCurrency7 AmountInDisplayCurrency7 2
AmountInDisplayCurrency8 AmountInDisplayCurrency8 2
AmountInDisplayCurrency9 AmountInDisplayCurrency9 2
AssetAccountDetermination AssetAccountDetermination 2
AssetAcctAnlytlTransClassfctn AssetAcctAnlytlTransClassfctn 2
AssetAuthorizationContext AssetAuthorizationContext 2
AssetClass AssetClass 2
AssetDeactivationDate AssetDeactivationDate 2
AssignmentReference AssignmentReference 5
BaseUnit BaseUnit 1
BudgetPeriod BudgetPeriod 4
BusinessArea BusinessArea 5
ChangeNumber ChangeNumber 1
CharcFromAmount CharcFromAmount 1
CharcFromDate CharcFromDate 1
CharcFromDecimalValue CharcFromDecimalValue 1
CharcFromNumericValue CharcFromNumericValue 1
CharcFromNumericValueUnit CharcFromNumericValueUnit 1
CharcFromTime CharcFromTime 1
CharcToAmount CharcToAmount 1
CharcToDate CharcToDate 1
CharcToDecimalValue CharcToDecimalValue 1
CharcToNumericValue CharcToNumericValue 1
CharcToNumericValueUnit CharcToNumericValueUnit 1
CharcToTime CharcToTime 1
CharcValue CharcValue 1
CharcValueDependency CharcValueDependency 1
ChartOfAccounts ChartOfAccounts 4
ChartOfDepreciation ChartOfDepreciation 12
CompanyCodeCurrency CompanyCodeCurrency 4
ControllingArea ControllingArea 1
CostCenter CostCenter 4
CountryChartOfAccounts CountryChartOfAccounts 4
CreationTime CreationTime 5
Criticality Criticality 1
Currency Currency 2
DepreciationFiscalPeriod DepreciationFiscalPeriod 3
DepreciationStatus DepreciationStatus 1
DisplayCurrency DisplayCurrency 6
DocumentDate DocumentDate 5
DocumentItemText DocumentItemText 6
FinancialAccountType FinancialAccountType 5
FinancialManagementArea FinancialManagementArea 4
FreeDefinedCurrency1 FreeDefinedCurrency1 4
FreeDefinedCurrency2 FreeDefinedCurrency2 4
FreeDefinedCurrency3 FreeDefinedCurrency3 4
FreeDefinedCurrency4 FreeDefinedCurrency4 4
FreeDefinedCurrency5 FreeDefinedCurrency5 4
FreeDefinedCurrency6 FreeDefinedCurrency6 4
FreeDefinedCurrency7 FreeDefinedCurrency7 4
FreeDefinedCurrency8 FreeDefinedCurrency8 4
FunctionalArea FunctionalArea 5
Fund Fund 5
FundsCenter FundsCenter 4
GLAccount GLAccount 4
GLBusinessTransactionType GLBusinessTransactionType 4
GlobalCurrency GlobalCurrency 4
GrantID GrantID 4
GroupFixedAsset GroupFixedAsset 5
GroupMasterFixedAsset GroupMasterFixedAsset 5
InterestAmountInDspCrcy InterestAmountInDspCrcy 1
IsReversal IsReversal 5
IsReversed IsReversed 5
IsStatisticalDocument IsStatisticalDocument 4
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 4
LedgerGroup LedgerGroup 9
LogicalSystem LogicalSystem 5
NetBookValueAmtInDspCrcy NetBookValueAmtInDspCrcy 1
OrdinaryDeprAmtInDspCrcy OrdinaryDeprAmtInDspCrcy 1
PartnerFixedAsset PartnerFixedAsset 4
PartnerMasterFixedAsset PartnerMasterFixedAsset 4
PersonnelNumber PersonnelNumber 4
PlanAmountInCompanyCodeCrcy PlanAmountInCompanyCodeCrcy 2
PlanAmountInFreeDefinedCrcy1 PlanAmountInFreeDefinedCrcy1 2
PlanAmountInFreeDefinedCrcy2 PlanAmountInFreeDefinedCrcy2 2
PlanAmountInFreeDefinedCrcy3 PlanAmountInFreeDefinedCrcy3 2
PlanAmountInFreeDefinedCrcy4 PlanAmountInFreeDefinedCrcy4 2
PlanAmountInFreeDefinedCrcy5 PlanAmountInFreeDefinedCrcy5 2
PlanAmountInFreeDefinedCrcy6 PlanAmountInFreeDefinedCrcy6 2
PlanAmountInFreeDefinedCrcy7 PlanAmountInFreeDefinedCrcy7 2
PlanAmountInFreeDefinedCrcy8 PlanAmountInFreeDefinedCrcy8 2
PlanAmountInGlobalCurrency PlanAmountInGlobalCurrency 2
PlannedAmountInDisplayCurrency PlannedAmountInDisplayCurrency 1
PlannedValueIsInclusive PlannedValueIsInclusive 5
Plant Plant 4
PostingDate PostingDate 6
ProfitCenter ProfitCenter 4
Quantity Quantity 1
ReferenceDocumentContext ReferenceDocumentContext 5
ReferenceDocumentType ReferenceDocumentType 5
RevalOrdnryDeprAmtInDspCrcy RevalOrdnryDeprAmtInDspCrcy 1
RevaluationAmountInDspCrcy RevaluationAmountInDspCrcy 1
ReversalReferenceDocument ReversalReferenceDocument 4
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt 4
ReversalTransactionSubitem ReversalTransactionSubitem 4
Segment Segment 5
SelectedCurrencyBranch SelectedCurrencyBranch 3
SpecialDeprAmtInDspCrcy SpecialDeprAmtInDspCrcy 1
StartingBalAmtInDspCrcy StartingBalAmtInDspCrcy 1
TotalDeprAmtInDspCrcy TotalDeprAmtInDspCrcy 1
TransferredReserveAmtInDspCrcy TransferredReserveAmtInDspCrcy 1
UnplannedDeprAmtInDspCrcy UnplannedDeprAmtInDspCrcy 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 VALUES (
    ACCOUNTINGDOCUMENT,
    ASSETACCOUNTINGKEYFIGURE,
    ASSETACCOUNTINGKEYFIGURESET,
    ASSETACCOUNTINGSORTEDKEYFIGURE,
    ASSETACCOUNTINGVALUETYPE,
    ASSETACCTTRANSCLASSFCTN,
    ASSETDEPRECIATIONAREA,
    ASSETTRANSACTIONTYPE,
    ASSETVALUATIONVIEW,
    ASSETVALUEDATE,
    CHARCINTERNALID,
    CHARCVALUEPOSITIONNUMBER,
    CLASSTYPE,
    CLFNOBJECTID,
    COMPANYCODE,
    CURRENCYROLE,
    DEBITCREDITCODE,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDASSET,
    LEDGER,
    MASTERFIXEDASSET,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    SUBLEDGERACCTLINEITEMTYPE,
    TRANSACTIONSUBITEM,
    _ACQNPRODNCOSTGLACCOUNT,
    _ASSETACCOUNTDETERMINATION,
    _ASSETACCOUNTINGVALUETYPE,
    _ASSETCLASS,
    _ASSETKEYFIGURE,
    _ASSETKEYFIGURESET,
    _CHARTOFACCOUNTS,
    _CHARTOFDEPRECIATION,
    _COMPANYCODE,
    _CURRENCY,
    _CURRENCYROLE,
    _DEPRECIATIONAREA,
    _FISCALPERIOD,
    _FISCALYEAR,
    _FIXEDASSET,
    _JOURNALENTRY,
    _LEDGER,
    _MASTERFIXEDASSET,
    _SELECTEDCURRENCYBRANCH,
    _UNITOFMEASURE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTTYPE,
    ACQNPRODNAMTINDSPCRCY,
    ACQNPRODNCOSTGLACCOUNT,
    ACTUALAMOUNTINCOMPANYCODECRCY,
    ACTUALAMOUNTINFREEDFNDCRCY1,
    ACTUALAMOUNTINFREEDFNDCRCY2,
    ACTUALAMOUNTINFREEDFNDCRCY3,
    ACTUALAMOUNTINFREEDFNDCRCY4,
    ACTUALAMOUNTINFREEDFNDCRCY5,
    ACTUALAMOUNTINFREEDFNDCRCY6,
    ACTUALAMOUNTINFREEDFNDCRCY7,
    ACTUALAMOUNTINFREEDFNDCRCY8,
    ACTUALAMOUNTINGLOBALCURRENCY,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINDISPLAYCURRENCY,
    AMOUNTINDISPLAYCURRENCY1,
    AMOUNTINDISPLAYCURRENCY10,
    AMOUNTINDISPLAYCURRENCY11,
    AMOUNTINDISPLAYCURRENCY12,
    AMOUNTINDISPLAYCURRENCY13,
    AMOUNTINDISPLAYCURRENCY14,
    AMOUNTINDISPLAYCURRENCY15,
    AMOUNTINDISPLAYCURRENCY16,
    AMOUNTINDISPLAYCURRENCY17,
    AMOUNTINDISPLAYCURRENCY18,
    AMOUNTINDISPLAYCURRENCY19,
    AMOUNTINDISPLAYCURRENCY2,
    AMOUNTINDISPLAYCURRENCY20,
    AMOUNTINDISPLAYCURRENCY21,
    AMOUNTINDISPLAYCURRENCY22,
    AMOUNTINDISPLAYCURRENCY23,
    AMOUNTINDISPLAYCURRENCY3,
    AMOUNTINDISPLAYCURRENCY4,
    AMOUNTINDISPLAYCURRENCY5,
    AMOUNTINDISPLAYCURRENCY6,
    AMOUNTINDISPLAYCURRENCY7,
    AMOUNTINDISPLAYCURRENCY8,
    AMOUNTINDISPLAYCURRENCY9,
    ASSETACCOUNTDETERMINATION,
    ASSETACCTANLYTLTRANSCLASSFCTN,
    ASSETAUTHORIZATIONCONTEXT,
    ASSETCLASS,
    ASSETDEACTIVATIONDATE,
    ASSIGNMENTREFERENCE,
    BASEUNIT,
    BUDGETPERIOD,
    BUSINESSAREA,
    CHANGENUMBER,
    CHARCFROMAMOUNT,
    CHARCFROMDATE,
    CHARCFROMDECIMALVALUE,
    CHARCFROMNUMERICVALUE,
    CHARCFROMNUMERICVALUEUNIT,
    CHARCFROMTIME,
    CHARCTOAMOUNT,
    CHARCTODATE,
    CHARCTODECIMALVALUE,
    CHARCTONUMERICVALUE,
    CHARCTONUMERICVALUEUNIT,
    CHARCTOTIME,
    CHARCVALUE,
    CHARCVALUEDEPENDENCY,
    CHARTOFACCOUNTS,
    CHARTOFDEPRECIATION,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRYCHARTOFACCOUNTS,
    CREATIONTIME,
    CRITICALITY,
    CURRENCY,
    DEPRECIATIONFISCALPERIOD,
    DEPRECIATIONSTATUS,
    DISPLAYCURRENCY,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    FINANCIALMANAGEMENTAREA,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    GLACCOUNT,
    GLBUSINESSTRANSACTIONTYPE,
    GLOBALCURRENCY,
    GRANTID,
    GROUPFIXEDASSET,
    GROUPMASTERFIXEDASSET,
    INTERESTAMOUNTINDSPCRCY,
    ISREVERSAL,
    ISREVERSED,
    ISSTATISTICALDOCUMENT,
    JOINTVENTURECOSTRECOVERYCODE,
    LEDGERGROUP,
    LOGICALSYSTEM,
    NETBOOKVALUEAMTINDSPCRCY,
    ORDINARYDEPRAMTINDSPCRCY,
    PARTNERFIXEDASSET,
    PARTNERMASTERFIXEDASSET,
    PERSONNELNUMBER,
    PLANAMOUNTINCOMPANYCODECRCY,
    PLANAMOUNTINFREEDEFINEDCRCY1,
    PLANAMOUNTINFREEDEFINEDCRCY2,
    PLANAMOUNTINFREEDEFINEDCRCY3,
    PLANAMOUNTINFREEDEFINEDCRCY4,
    PLANAMOUNTINFREEDEFINEDCRCY5,
    PLANAMOUNTINFREEDEFINEDCRCY6,
    PLANAMOUNTINFREEDEFINEDCRCY7,
    PLANAMOUNTINFREEDEFINEDCRCY8,
    PLANAMOUNTINGLOBALCURRENCY,
    PLANNEDAMOUNTINDISPLAYCURRENCY,
    PLANNEDVALUEISINCLUSIVE,
    PLANT,
    POSTINGDATE,
    PROFITCENTER,
    QUANTITY,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    REVALORDNRYDEPRAMTINDSPCRCY,
    REVALUATIONAMOUNTINDSPCRCY,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    REVERSALTRANSACTIONSUBITEM,
    SEGMENT,
    SELECTEDCURRENCYBRANCH,
    SPECIALDEPRAMTINDSPCRCY,
    STARTINGBALAMTINDSPCRCY,
    TOTALDEPRAMTINDSPCRCY,
    TRANSFERREDRESERVEAMTINDSPCRCY,
    UNPLANNEDDEPRAMTINDSPCRCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ASSETACCOUNTINGKEYFIGURE, ASSETACCOUNTINGKEYFIGURESET, ASSETACCOUNTINGSORTEDKEYFIGURE, ASSETACCOUNTINGVALUETYPE, ASSETACCTTRANSCLASSFCTN, ASSETDEPRECIATIONAREA, ASSETTRANSACTIONTYPE, ASSETVALUATIONVIEW, ASSETVALUEDATE, CHARCINTERNALID, CHARCVALUEPOSITIONNUMBER, CLASSTYPE, CLFNOBJECTID, COMPANYCODE, CURRENCYROLE, DEBITCREDITCODE, FISCALPERIOD, FISCALYEAR, FIXEDASSET, LEDGER, MASTERFIXEDASSET, REFERENCEDOCUMENT, REFERENCEDOCUMENTITEM, SUBLEDGERACCTLINEITEMTYPE, TRANSACTIONSUBITEM)
);