P_ASSETBALANCECUBE1

CDS View
70 Fields 1 CDS Views

P_ASSETBALANCECUBE1 is a CDS View in S/4HANA. It contains 70 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AssetBalanceCube view_entity from COMPOSITE Asset Balances - Cube

Fields (70)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure 1
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet 1
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn 1
KEY AssetDepreciationArea AssetDepreciationArea 1
KEY CompanyCode CompanyCode 1
KEY CurrencyRole CurrencyRole 1
KEY DebitCreditCode DebitCreditCode 1
KEY FiscalPeriod FiscalPeriod 1
KEY FiscalYear FiscalYear 1
KEY FixedAsset FixedAsset 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY MasterFixedAsset MasterFixedAsset 1
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 1
KEY TransactionSubitem TransactionSubitem 1
AccountingDocumentCreationDate AccountingDocumentCreationDate 1
AccountingDocumentType AccountingDocumentType 1
AccountingPrinciple AccountingPrinciple 1
AlternativeGLAccount AlternativeGLAccount 1
AmountInDisplayCurrency AmountInDisplayCurrency 1
AssetAccountingSortedKeyFigure AssetAccountingSortedKeyFigure 1
AssetTransactionType AssetTransactionType 1
AssetValueDate AssetValueDate 1
AssignmentReference AssignmentReference 1
BudgetPeriod BudgetPeriod 1
BusinessArea BusinessArea 1
ChartOfAccounts ChartOfAccounts 1
ChartOfDepreciation ChartOfDepreciation 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
Country Country 1
CountryChartOfAccounts CountryChartOfAccounts 1
CreationTime CreationTime 1
DepreciationFiscalPeriod DepreciationFiscalPeriod 1
DisplayCurrency DisplayCurrency 1
DocumentDate DocumentDate 1
DocumentItemText DocumentItemText 1
FinancialAccountType FinancialAccountType 1
FinancialManagementArea FinancialManagementArea 1
FinancialStatementVariant FinancialStatementVariant 1
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearVariant FiscalYearVariant 1
FunctionalArea FunctionalArea 1
Fund Fund 1
FundsCenter FundsCenter 1
GLAccount GLAccount 1
GLBusinessTransactionType GLBusinessTransactionType 1
GrantID GrantID 1
GroupFixedAsset GroupFixedAsset 1
GroupMasterFixedAsset GroupMasterFixedAsset 1
IsReversal IsReversal 1
IsReversed IsReversed 1
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 1
LedgerFiscalYear LedgerFiscalYear 1
LedgerGroup LedgerGroup 1
LogicalSystem LogicalSystem 1
PartnerFixedAsset PartnerFixedAsset 1
PartnerMasterFixedAsset PartnerMasterFixedAsset 1
PersonnelNumber PersonnelNumber 1
Plant Plant 1
PostingDate PostingDate 1
ProfitCenter ProfitCenter 1
Quantity Quantity 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentItem ReferenceDocumentItem 1
ReferenceDocumentType ReferenceDocumentType 1
Segment Segment 1
SelectedCurrencyBranch SelectedCurrencyBranch 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 P_ASSETBALANCECUBE1 (
    ACCOUNTINGDOCUMENT,
    ASSETACCOUNTINGKEYFIGURE,
    ASSETACCOUNTINGKEYFIGURESET,
    ASSETACCTTRANSCLASSFCTN,
    ASSETDEPRECIATIONAREA,
    COMPANYCODE,
    CURRENCYROLE,
    DEBITCREDITCODE,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDASSET,
    LEDGER,
    LEDGERGLLINEITEM,
    MASTERFIXEDASSET,
    SUBLEDGERACCTLINEITEMTYPE,
    TRANSACTIONSUBITEM,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTINGPRINCIPLE,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINDISPLAYCURRENCY,
    ASSETACCOUNTINGSORTEDKEYFIGURE,
    ASSETTRANSACTIONTYPE,
    ASSETVALUEDATE,
    ASSIGNMENTREFERENCE,
    BUDGETPERIOD,
    BUSINESSAREA,
    CHARTOFACCOUNTS,
    CHARTOFDEPRECIATION,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    COUNTRYCHARTOFACCOUNTS,
    CREATIONTIME,
    DEPRECIATIONFISCALPERIOD,
    DISPLAYCURRENCY,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALSTATEMENTVARIANT,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    GLACCOUNT,
    GLBUSINESSTRANSACTIONTYPE,
    GRANTID,
    GROUPFIXEDASSET,
    GROUPMASTERFIXEDASSET,
    ISREVERSAL,
    ISREVERSED,
    JOINTVENTURECOSTRECOVERYCODE,
    LEDGERFISCALYEAR,
    LEDGERGROUP,
    LOGICALSYSTEM,
    PARTNERFIXEDASSET,
    PARTNERMASTERFIXEDASSET,
    PERSONNELNUMBER,
    PLANT,
    POSTINGDATE,
    PROFITCENTER,
    QUANTITY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTTYPE,
    SEGMENT,
    SELECTEDCURRENCYBRANCH,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ASSETACCOUNTINGKEYFIGURE, ASSETACCOUNTINGKEYFIGURESET, ASSETACCTTRANSCLASSFCTN, ASSETDEPRECIATIONAREA, COMPANYCODE, CURRENCYROLE, DEBITCREDITCODE, FISCALPERIOD, FISCALYEAR, FIXEDASSET, LEDGER, LEDGERGLLINEITEM, MASTERFIXEDASSET, SUBLEDGERACCTLINEITEMTYPE, TRANSACTIONSUBITEM)
);

Learn More