P_ACTUALPLANBALFLOW2

CDS View
34 Fields 1 CDS Views

P_ActualPlanBalFlow2

P_ACTUALPLANBALFLOW2 is a CDS View in S/4HANA. P_ActualPlanBalFlow2. It contains 34 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_GLAcctFlowSemTagDateFunc2 view_entity from COMPOSITE P_GLAcctFlowSemTagDateFunc2

Fields (34)

KeyField CDS FieldsUsed in Views
KEY ActualPlanCode ActualPlanCode 1
KEY CompanyCode CompanyCode 1
KEY DateFunction DateFunction 1
KEY FiscalYearPeriod FiscalYearPeriod 1
KEY GLAccountFlowType GLAccountFlowType 1
KEY Ledger Ledger 1
KEY PlanningCategory PlanningCategory 1
_GlobalCurrency _GlobalCurrency 1
AmountInGlobalCurrency AmountInGlobalCurrency 1
BusinessArea BusinessArea 1
ChartOfAccounts ChartOfAccounts 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
Customer Customer 1
CustomerGroup CustomerGroup 1
FiscalPeriod FiscalPeriod 1
FiscalQuarter FiscalQuarter 1
FiscalYearQuarter FiscalYearQuarter 1
FiscalYearVariant FiscalYearVariant 1
FixedAmountInGlobalCrcy FixedAmountInGlobalCrcy 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 1
GlobalCurrency GlobalCurrency 1
IsBalanceSheetAccount IsBalanceSheetAccount 1
KslonlyBCF KslonlyBCF 1
KslwoBCF KslwoBCF 1
LedgerFiscalYear LedgerFiscalYear 1
Product Product 1
ProductGroup ProductGroup 1
ProfitCenter ProfitCenter 1
Segment Segment 1
SoldProduct SoldProduct 1
SoldProductGroup SoldProductGroup 1
Supplier Supplier 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.

-- P_ActualPlanBalFlow2
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ACTUALPLANBALFLOW2 (
    ACTUALPLANCODE,
    COMPANYCODE,
    DATEFUNCTION,
    FISCALYEARPERIOD,
    GLACCOUNTFLOWTYPE,
    LEDGER,
    PLANNINGCATEGORY,
    _GLOBALCURRENCY,
    AMOUNTINGLOBALCURRENCY,
    BUSINESSAREA,
    CHARTOFACCOUNTS,
    CONTROLLINGAREA,
    COSTCENTER,
    CUSTOMER,
    CUSTOMERGROUP,
    FISCALPERIOD,
    FISCALQUARTER,
    FISCALYEARQUARTER,
    FISCALYEARVARIANT,
    FIXEDAMOUNTINGLOBALCRCY,
    FUNCTIONALAREA,
    GLACCOUNT,
    GLOBALCURRENCY,
    ISBALANCESHEETACCOUNT,
    KSLONLYBCF,
    KSLWOBCF,
    LEDGERFISCALYEAR,
    PRODUCT,
    PRODUCTGROUP,
    PROFITCENTER,
    SEGMENT,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SUPPLIER,
    PRIMARY KEY (ACTUALPLANCODE, COMPANYCODE, DATEFUNCTION, FISCALYEARPERIOD, GLACCOUNTFLOWTYPE, LEDGER, PLANNINGCATEGORY)
);

Learn More