ASSETBAL

122 Fields

ASSETBAL is an SAP database table in S/4HANA. It contains 122 fields.

Fields (122)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 6
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure 4
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet 4
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn 7
KEY AssetDepreciationArea AssetDepreciationArea 6
KEY CompanyCode CompanyCode 7
KEY CurrencyRole CurrencyRole 4
KEY DebitCreditCode DebitCreditCode 4
KEY FiscalPeriod FiscalPeriod 8
KEY FiscalYear FiscalYear 8
KEY FixedAsset FixedAsset 7
KEY Ledger Ledger 7
KEY LedgerGLLineItem LedgerGLLineItem 4
KEY MasterFixedAsset MasterFixedAsset 7
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 7
KEY TransactionSubitem TransactionSubitem 4
AccountingDocumentCreationDate AccountingDocumentCreationDate 7
AccountingPrinciple AccountingPrinciple 3
AcqnProdnAmtInDspCrcy AcqnProdnAmtInDspCrcy 1
AcqnProdnCostGLAccount AcqnProdnCostGLAccount 8
AcqnProdnCostScrapPercent AcqnProdnCostScrapPercent 1
AlternativeGLAccount AlternativeGLAccount 6
AmountInDisplayCurrency AmountInDisplayCurrency 4
AssetAccountDetermination AssetAccountDetermination 4
AssetAccountingSortedKeyFigure AssetAccountingKeyFigure,AssetAccountingSortedKeyFigure 7
AssetAdditionalDescription AssetAdditionalDescription 1
AssetBudgetPeriod AssetBudgetPeriod 3
AssetBusinessArea AssetBusinessArea 3
AssetCapitalizationDate AssetCapitalizationDate 8
AssetClass AssetClass 8
AssetCostCenter AssetCostCenter 7
AssetCostCtrActivityType AssetCostCtrActivityType 3
AssetDeactivationDate AssetDeactivationDate 7
AssetFunctionalArea AssetFunctionalArea 5
AssetFund AssetFund 7
AssetFundsCenter AssetFundsCenter 7
AssetGrant AssetGrant 7
AssetLocation AssetLocation 7
AssetPersonnelNumber AssetPersonnelNumber 2
AssetPlant AssetPlant 7
AssetProfitCenter AssetProfitCenter 7
AssetRevaluationIndex AssetRevaluationIndex 5
AssetSegment AssetSegment 7
AssetSerialNumber AssetSerialNumber 8
AssetSupplierName AssetSupplierName 7
AssetTransactionType AssetTransactionType 7
AssetWBSElementExternalID AssetWBSElementExternalID 5
BaseUnit BaseUnit 7
BudgetPeriod BudgetPeriod 3
BusinessArea BusinessArea 3
BusinessTransactionCategory BusinessTransactionCategory 5
BusinessTransactionType BusinessTransactionType 5
ChartOfAccounts ChartOfAccounts 7
ChartOfDepreciation ChartOfDepreciation 3
CN_CADEFixedAssetUsage CN_CADEFixedAssetUsage 1
ComparisonFirstDeprAreaAmount ComparisonFirstDeprAreaAmount 1
ComparisonSecondDeprAreaAmount ComparisonSecondDeprAreaAmount 1
ControllingArea ControllingArea 3
CostCenter CostCenter 7
Country Country 6
CountryChartOfAccounts CountryChartOfAccounts 3
CreationTime CreationTime 7
CurrentFiscalYearBalanceAmount CurrentFiscalYearBalanceAmount 1
DepreciationKey DepreciationKey 7
DepreciationStartDate DepreciationStartDate 6
DisplayCurrency DisplayCurrency 8
ExpiredUsefulLifeInPerds ExpiredUsefulLifeInPerds 1
FinancialAccountType FinancialAccountType 3
FinancialClosingStep FinancialClosingStep 5
FinancialManagementArea FinancialManagementArea 3
FinancialStatementVariant FinancialStatementVariant 3
FirstAcquisitionFiscalPeriod FirstAcquisitionFiscalPeriod 7
FirstAcquisitionFiscalYear FirstAcquisitionFiscalYear 7
FiscalYearVariant FiscalYearVariant 7
FixedAssetDescription FixedAssetDescription 1
FixedAssetExternalID FixedAssetExternalID 1
FixedAssetGroup FixedAssetGroup 3
FixedAssetUsageObject FixedAssetUsageObject 5
FunctionalArea FunctionalArea 7
Fund Fund 7
FundsCenter FundsCenter 7
GLAccount GLAccount 7
GrantID GrantID 7
Group1AssetEvaluationKey Group1AssetEvaluationKey 3
Group2AssetEvaluationKey Group2AssetEvaluationKey 3
Group3AssetEvaluationKey Group3AssetEvaluationKey 3
Group4AssetEvaluationKey Group4AssetEvaluationKey 3
Group5AssetEvaluationKey Group5AssetEvaluationKey 3
Inventory Inventory 8
InventoryIsCounted InventoryIsCounted 3
InvestmentOrder InvestmentOrder 3
InvestmentSupportMeasure InvestmentSupportMeasure 2
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 3
JP_PrptyTxRptCity JP_PrptyTxRptCity 1
JP_PrptyTxRptClassfctnKey JP_PrptyTxRptClassfctnKey 1
LastInventoryDate LastInventoryDate 7
LedgerGroup LedgerGroup 3
NationalClassification NationalClassification 2
NetBookValueAmtInDspCrcy NetBookValueAmtInDspCrcy 1
OrdinaryDeprValAdjmtGLAccount OrdinaryDeprValAdjmtGLAccount 1
PersonnelNumber PersonnelNumber 3
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods 7
PlannedUsefulLifeInYears PlannedUsefulLifeInYears 6
PostingDate PostingDate 4
PriorFiscalYearBalanceAmount PriorFiscalYearBalanceAmount 1
ProfitCenter ProfitCenter 7
Quantity Quantity 5
RealEstateObject RealEstateObject 3
REInternalFinNumber REInternalFinNumber 1
RevalOrdnryDeprValAdjmtGLAcct RevalOrdnryDeprValAdjmtGLAcct 1
RevaluationAmountInDspCrcy RevaluationAmountInDspCrcy 1
Room Room 6
RU_AssetDepreciationGroup RU_AssetDepreciationGroup 1
RU_AssetOKOF RU_AssetOKOF 1
Segment Segment 7
SelectedCurrencyBranch SelectedCurrencyBranch 4
SpecialDeprStartDate SpecialDeprStartDate 6
Supplier Supplier 6
TaxDepreciationGroup TaxDepreciationGroup 2
TaxJurisdiction TaxJurisdiction 6
VehicleLicensePlateNumber VehicleLicensePlateNumber 6
WBSElementExternalID WBSElementExternalID 6

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 ASSETBAL (
    ACCOUNTINGDOCUMENT,
    ASSETACCOUNTINGKEYFIGURE,
    ASSETACCOUNTINGKEYFIGURESET,
    ASSETACCTTRANSCLASSFCTN,
    ASSETDEPRECIATIONAREA,
    COMPANYCODE,
    CURRENCYROLE,
    DEBITCREDITCODE,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDASSET,
    LEDGER,
    LEDGERGLLINEITEM,
    MASTERFIXEDASSET,
    SUBLEDGERACCTLINEITEMTYPE,
    TRANSACTIONSUBITEM,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGPRINCIPLE,
    ACQNPRODNAMTINDSPCRCY,
    ACQNPRODNCOSTGLACCOUNT,
    ACQNPRODNCOSTSCRAPPERCENT,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINDISPLAYCURRENCY,
    ASSETACCOUNTDETERMINATION,
    ASSETACCOUNTINGSORTEDKEYFIGURE,
    ASSETADDITIONALDESCRIPTION,
    ASSETBUDGETPERIOD,
    ASSETBUSINESSAREA,
    ASSETCAPITALIZATIONDATE,
    ASSETCLASS,
    ASSETCOSTCENTER,
    ASSETCOSTCTRACTIVITYTYPE,
    ASSETDEACTIVATIONDATE,
    ASSETFUNCTIONALAREA,
    ASSETFUND,
    ASSETFUNDSCENTER,
    ASSETGRANT,
    ASSETLOCATION,
    ASSETPERSONNELNUMBER,
    ASSETPLANT,
    ASSETPROFITCENTER,
    ASSETREVALUATIONINDEX,
    ASSETSEGMENT,
    ASSETSERIALNUMBER,
    ASSETSUPPLIERNAME,
    ASSETTRANSACTIONTYPE,
    ASSETWBSELEMENTEXTERNALID,
    BASEUNIT,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSTRANSACTIONCATEGORY,
    BUSINESSTRANSACTIONTYPE,
    CHARTOFACCOUNTS,
    CHARTOFDEPRECIATION,
    CN_CADEFIXEDASSETUSAGE,
    COMPARISONFIRSTDEPRAREAAMOUNT,
    COMPARISONSECONDDEPRAREAAMOUNT,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    COUNTRYCHARTOFACCOUNTS,
    CREATIONTIME,
    CURRENTFISCALYEARBALANCEAMOUNT,
    DEPRECIATIONKEY,
    DEPRECIATIONSTARTDATE,
    DISPLAYCURRENCY,
    EXPIREDUSEFULLIFEINPERDS,
    FINANCIALACCOUNTTYPE,
    FINANCIALCLOSINGSTEP,
    FINANCIALMANAGEMENTAREA,
    FINANCIALSTATEMENTVARIANT,
    FIRSTACQUISITIONFISCALPERIOD,
    FIRSTACQUISITIONFISCALYEAR,
    FISCALYEARVARIANT,
    FIXEDASSETDESCRIPTION,
    FIXEDASSETEXTERNALID,
    FIXEDASSETGROUP,
    FIXEDASSETUSAGEOBJECT,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    GLACCOUNT,
    GRANTID,
    GROUP1ASSETEVALUATIONKEY,
    GROUP2ASSETEVALUATIONKEY,
    GROUP3ASSETEVALUATIONKEY,
    GROUP4ASSETEVALUATIONKEY,
    GROUP5ASSETEVALUATIONKEY,
    INVENTORY,
    INVENTORYISCOUNTED,
    INVESTMENTORDER,
    INVESTMENTSUPPORTMEASURE,
    JOINTVENTURECOSTRECOVERYCODE,
    JP_PRPTYTXRPTCITY,
    JP_PRPTYTXRPTCLASSFCTNKEY,
    LASTINVENTORYDATE,
    LEDGERGROUP,
    NATIONALCLASSIFICATION,
    NETBOOKVALUEAMTINDSPCRCY,
    ORDINARYDEPRVALADJMTGLACCOUNT,
    PERSONNELNUMBER,
    PLANNEDUSEFULLIFEINPERIODS,
    PLANNEDUSEFULLIFEINYEARS,
    POSTINGDATE,
    PRIORFISCALYEARBALANCEAMOUNT,
    PROFITCENTER,
    QUANTITY,
    REALESTATEOBJECT,
    REINTERNALFINNUMBER,
    REVALORDNRYDEPRVALADJMTGLACCT,
    REVALUATIONAMOUNTINDSPCRCY,
    ROOM,
    RU_ASSETDEPRECIATIONGROUP,
    RU_ASSETOKOF,
    SEGMENT,
    SELECTEDCURRENCYBRANCH,
    SPECIALDEPRSTARTDATE,
    SUPPLIER,
    TAXDEPRECIATIONGROUP,
    TAXJURISDICTION,
    VEHICLELICENSEPLATENUMBER,
    WBSELEMENTEXTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ASSETACCOUNTINGKEYFIGURE, ASSETACCOUNTINGKEYFIGURESET, ASSETACCTTRANSCLASSFCTN, ASSETDEPRECIATIONAREA, COMPANYCODE, CURRENCYROLE, DEBITCREDITCODE, FISCALPERIOD, FISCALYEAR, FIXEDASSET, LEDGER, LEDGERGLLINEITEM, MASTERFIXEDASSET, SUBLEDGERACCTLINEITEMTYPE, TRANSACTIONSUBITEM)
);

Learn More