P_ACTUALPLANGLACCTBALANCE2

CDS View
98 Fields 1 CDS Views

Actual Plan G/L Account Balances

P_ACTUALPLANGLACCTBALANCE2 is a CDS View in S/4HANA. Actual Plan G/L Account Balances. It contains 98 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ActualPlanGLAcctBalance view_entity from COMPOSITE Actual Plan G/L Account Balances

Fields (98)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY SourceLedger SourceLedger 1
_BalanceTransactionCurrency _BalanceTransactionCurrency 1
_BusinessArea _BusinessArea 1
_ChartOfAccounts _ChartOfAccounts 1
_CompanyCode _CompanyCode 1
_CompanyCodeCurrency _CompanyCodeCurrency 1
_ControllingArea _ControllingArea 1
_CostCenter _CostCenter 1
_CostSourceUnit _CostSourceUnit 1
_CurrentCostCenter _CurrentCostCenter 1
_CurrentProfitCenter _CurrentProfitCenter 1
_DebitCreditCode _DebitCreditCode 1
_FiscalCalendarDate _FiscalCalendarDate 1
_FiscalYear _FiscalYear 1
_FiscalYearVariant _FiscalYearVariant 1
_FunctionalArea _FunctionalArea 1
_GLAccountFlowType _GLAccountFlowType 1
_GLAccountFlowTypeText _GLAccountFlowTypeText 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_GLAccountInCompanyCode _GLAccountInCompanyCode 1
_GLAccountType _GLAccountType 1
_GLAccountTypeFlowType _GLAccountTypeFlowType 1
_GLAccountTypeFlowTypeTxt _GLAccountTypeFlowTypeTxt 1
_GlobalCurrency _GlobalCurrency 1
_JournalEntry _JournalEntry 1
_Ledger _Ledger 1
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant 1
_ProfitCenter _ProfitCenter 1
_Segment _Segment 1
_SourceLedger _SourceLedger 1
_TransactionCurrency _TransactionCurrency 1
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentType AccountingDocumentType 1
ActualPlanCode ActualPlanCode 1
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInGlobalCurrency AmountInGlobalCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
AssetClass AssetClass 1
BalanceTransactionCurrency BalanceTransactionCurrency 1
BusinessArea BusinessArea 1
CalendarDate CalendarDate 1
CalendarMonth CalendarMonth 1
CalendarQuarter CalendarQuarter 1
CalendarWeek CalendarWeek 1
CalendarYear CalendarYear 1
CalendarYearMonth CalendarYearMonth 1
CalendarYearQuarter CalendarYearQuarter 1
CalendarYearWeek CalendarYearWeek 1
ChartOfAccounts ChartOfAccounts 1
CompanyCodeCurrency CompanyCodeCurrency 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
CostSourceUnit CostSourceUnit 1
Customer Customer 1
DebitCreditCode DebitCreditCode 1
DistributionChannel DistributionChannel 1
FinancialAccountType FinancialAccountType 1
FiscalPeriod FiscalPeriod 1
FiscalQuarter FiscalQuarter 1
FiscalWeek FiscalWeek 1
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearQuarter FiscalYearQuarter 1
FiscalYearVariant FiscalYearVariant 1
FiscalYearWeek FiscalYearWeek 1
FixedAmountInGlobalCrcy FixedAmountInGlobalCrcy 1
FixedAsset FixedAsset 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 1
GLAccountFlowType GLAccountFlowType 1
GLAccountType GLAccountType 1
GLAccountTypeFlowType GLAccountTypeFlowType 1
GlobalCurrency GlobalCurrency 1
IsBalanceSheetAccount IsBalanceSheetAccount 1
LedgerFiscalYear LedgerFiscalYear 1
MasterFixedAsset MasterFixedAsset 1
OrderID OrderID 1
OrderType OrderType 1
OrganizationDivision OrganizationDivision 1
PlanningCategory PlanningCategory 1
Plant Plant 1
PostingDate PostingDate 1
Product Product 1
ProfitCenter ProfitCenter 1
SalesDocument SalesDocument 1
SalesOrganization SalesOrganization 1
Segment Segment 1
ServiceDocument ServiceDocument 1
ServiceDocumentType ServiceDocumentType 1
Supplier Supplier 1
TransactionCurrency TransactionCurrency 1
ValuationArea ValuationArea 1
ValuationQuantity ValuationQuantity 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.

-- Actual Plan G/L Account Balances
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ACTUALPLANGLACCTBALANCE2 (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    _BALANCETRANSACTIONCURRENCY,
    _BUSINESSAREA,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _COSTSOURCEUNIT,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _DEBITCREDITCODE,
    _FISCALCALENDARDATE,
    _FISCALYEAR,
    _FISCALYEARVARIANT,
    _FUNCTIONALAREA,
    _GLACCOUNTFLOWTYPE,
    _GLACCOUNTFLOWTYPETEXT,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _GLACCOUNTTYPE,
    _GLACCOUNTTYPEFLOWTYPE,
    _GLACCOUNTTYPEFLOWTYPETXT,
    _GLOBALCURRENCY,
    _JOURNALENTRY,
    _LEDGER,
    _LEDGERFISCALYEARFORVARIANT,
    _PROFITCENTER,
    _SEGMENT,
    _SOURCELEDGER,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTTYPE,
    ACTUALPLANCODE,
    AMOUNTINBALANCETRANSACCRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSETCLASS,
    BALANCETRANSACTIONCURRENCY,
    BUSINESSAREA,
    CALENDARDATE,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    CALENDARYEAR,
    CALENDARYEARMONTH,
    CALENDARYEARQUARTER,
    CALENDARYEARWEEK,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTSOURCEUNIT,
    CUSTOMER,
    DEBITCREDITCODE,
    DISTRIBUTIONCHANNEL,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FISCALQUARTER,
    FISCALWEEK,
    FISCALYEARPERIOD,
    FISCALYEARQUARTER,
    FISCALYEARVARIANT,
    FISCALYEARWEEK,
    FIXEDAMOUNTINGLOBALCRCY,
    FIXEDASSET,
    FUNCTIONALAREA,
    GLACCOUNT,
    GLACCOUNTFLOWTYPE,
    GLACCOUNTTYPE,
    GLACCOUNTTYPEFLOWTYPE,
    GLOBALCURRENCY,
    ISBALANCESHEETACCOUNT,
    LEDGERFISCALYEAR,
    MASTERFIXEDASSET,
    ORDERID,
    ORDERTYPE,
    ORGANIZATIONDIVISION,
    PLANNINGCATEGORY,
    PLANT,
    POSTINGDATE,
    PRODUCT,
    PROFITCENTER,
    SALESDOCUMENT,
    SALESORGANIZATION,
    SEGMENT,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTTYPE,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    VALUATIONAREA,
    VALUATIONQUANTITY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER)
);

Learn More