I_PERIODACCRUAL

CDS View
86 Fields 3 CDS Views

Periodic Data of Accrual Subobject View

I_PERIODACCRUAL is a CDS View in S/4HANA. Periodic Data of Accrual Subobject View. It contains 86 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ManualAccrual view from COMPOSITE Manual Accrual Object View
I_PurchaseOrderAccrual view from COMPOSITE Purchase Order Accrual Object View
R_MnlAccrsAccrPerdcAmountsTP view_entity from TRANSACTIONAL Accrual Subobject Periodic Amounts

Fields (86)

KeyField CDS FieldsUsed in Views
KEY AccrualEngineApplication AccrualEngineApplication 1
KEY AccrualItemType AccrualItemType 1
KEY AccrualObject AccrualObject 1
KEY AccrualPeriodEndDate AccrualPeriodEndDate 1
KEY AccrualSubobject AccrualSubobject 1
KEY CompanyCode CompanyCode 1
KEY Ledger Ledger 1
KEY ProposedAccrAmtIsExisting ProposedAccrAmtIsExisting 1
AccrPeriodAmtCalculationMethod AccrPeriodAmtCalculationMethod 1
AccrualAmountAdjustedByUser AccrualAmountAdjustedByUser 1
AccrualAmountAdjustmentDate AccrualAmountAdjustmentDate 1
AccrualAmountAdjustmentTime AccrualAmountAdjustmentTime 1
AccrualAmountApprovalDate AccrualAmountApprovalDate 1
AccrualAmountApprovalStatus AccrualAmountApprovalStatus 1
AccrualAmountApprovalTime AccrualAmountApprovalTime 1
AccrualAmountIsApproved AccrualAmountIsApproved 1
AccrualAmountIsReviewed AccrualAmountIsReviewed 1
AccrualAmountReviewStatus AccrualAmountReviewStatus 1
AccrualAmtInCCCrcy AccrualAmtInCCCrcy 1
AccrualAmtInFreeDfndCrcy1 AccrualAmtInFreeDfndCrcy1 1
AccrualAmtInFreeDfndCrcy2 AccrualAmtInFreeDfndCrcy2 1
AccrualAmtInFreeDfndCrcy3 AccrualAmtInFreeDfndCrcy3 1
AccrualAmtInFreeDfndCrcy4 AccrualAmtInFreeDfndCrcy4 1
AccrualAmtInFreeDfndCrcy5 AccrualAmtInFreeDfndCrcy5 1
AccrualAmtInFreeDfndCrcy6 AccrualAmtInFreeDfndCrcy6 1
AccrualAmtInFreeDfndCrcy7 AccrualAmtInFreeDfndCrcy7 1
AccrualAmtInFreeDfndCrcy8 AccrualAmtInFreeDfndCrcy8 1
AccrualAmtInGlobalCrcy AccrualAmtInGlobalCrcy 1
AccrualAmtInTransCrcy AccrualAmtInTransCrcy 1
AccrualObjectLogicalSystem AccrualObjectLogicalSystem 1
AccrualPeriodStartDate AccrualPeriodStartDate 1
AccrualPostingApprovalType AccrualPostingApprovalType 1
AccrualPostingReviewType AccrualPostingReviewType 1
ActualAccrualItemType ActualAccrualItemType 1
ActualCostAmtInCCCrcy ActualCostAmtInCCCrcy 1
ActualCostInFreeDfndCrcy1 ActualCostInFreeDfndCrcy1 1
ActualCostInFreeDfndCrcy2 ActualCostInFreeDfndCrcy2 1
ActualCostInFreeDfndCrcy3 ActualCostInFreeDfndCrcy3 1
ActualCostInFreeDfndCrcy4 ActualCostInFreeDfndCrcy4 1
ActualCostInFreeDfndCrcy5 ActualCostInFreeDfndCrcy5 1
ActualCostInFreeDfndCrcy6 ActualCostInFreeDfndCrcy6 1
ActualCostInFreeDfndCrcy7 ActualCostInFreeDfndCrcy7 1
ActualCostInFreeDfndCrcy8 ActualCostInFreeDfndCrcy8 1
ActualCostInGlobalCrcy ActualCostInGlobalCrcy 1
ActualCostInTransCrcy ActualCostInTransCrcy 1
AdjustedCostInCoCodeCrcy AdjustedCostInCoCodeCrcy 1
AdjustedCostInFreeDfndCrcy1 AdjustedCostInFreeDfndCrcy1 1
AdjustedCostInFreeDfndCrcy2 AdjustedCostInFreeDfndCrcy2 1
AdjustedCostInFreeDfndCrcy3 AdjustedCostInFreeDfndCrcy3 1
AdjustedCostInFreeDfndCrcy4 AdjustedCostInFreeDfndCrcy4 1
AdjustedCostInFreeDfndCrcy5 AdjustedCostInFreeDfndCrcy5 1
AdjustedCostInFreeDfndCrcy6 AdjustedCostInFreeDfndCrcy6 1
AdjustedCostInFreeDfndCrcy7 AdjustedCostInFreeDfndCrcy7 1
AdjustedCostInFreeDfndCrcy8 AdjustedCostInFreeDfndCrcy8 1
AdjustedCostInGlobalCrcy AdjustedCostInGlobalCrcy 1
AdjustedCostInTransCrcy AdjustedCostInTransCrcy 1
AmountReviewDate AmountReviewDate 1
AmountReviewTime AmountReviewTime 1
ApprovedByUser ApprovedByUser 1
PercentageOfCompletion PercentageOfCompletion 1
PlannedAccrualItemType PlannedAccrualItemType 1
PlannedCostInFreeDfndCrcy1 PlannedCostInFreeDfndCrcy1 1
PlannedCostInFreeDfndCrcy2 PlannedCostInFreeDfndCrcy2 1
PlannedCostInFreeDfndCrcy3 PlannedCostInFreeDfndCrcy3 1
PlannedCostInFreeDfndCrcy4 PlannedCostInFreeDfndCrcy4 1
PlannedCostInFreeDfndCrcy5 PlannedCostInFreeDfndCrcy5 1
PlannedCostInFreeDfndCrcy6 PlannedCostInFreeDfndCrcy6 1
PlannedCostInFreeDfndCrcy7 PlannedCostInFreeDfndCrcy7 1
PlannedCostInFreeDfndCrcy8 PlannedCostInFreeDfndCrcy8 1
PlannedCostInGlobalCrcy PlannedCostInGlobalCrcy 1
PlannedCostInTransCrcy PlannedCostInTransCrcy 1
PlndCostInCoCodeCrcy PlndCostInCoCodeCrcy 1
ProposedAccrAmtAdjmtReason ProposedAccrAmtAdjmtReason 1
ProposedAccrAmtInCoCodeCrcy ProposedAccrAmtInCoCodeCrcy 1
ProposedAccrAmtInFreeDfndCrcy1 ProposedAccrAmtInFreeDfndCrcy1 1
ProposedAccrAmtInFreeDfndCrcy2 ProposedAccrAmtInFreeDfndCrcy2 1
ProposedAccrAmtInFreeDfndCrcy3 ProposedAccrAmtInFreeDfndCrcy3 1
ProposedAccrAmtInFreeDfndCrcy4 ProposedAccrAmtInFreeDfndCrcy4 1
ProposedAccrAmtInFreeDfndCrcy5 ProposedAccrAmtInFreeDfndCrcy5 1
ProposedAccrAmtInFreeDfndCrcy6 ProposedAccrAmtInFreeDfndCrcy6 1
ProposedAccrAmtInFreeDfndCrcy7 ProposedAccrAmtInFreeDfndCrcy7 1
ProposedAccrAmtInFreeDfndCrcy8 ProposedAccrAmtInFreeDfndCrcy8 1
ProposedAccrAmtInGlobalCrcy ProposedAccrAmtInGlobalCrcy 1
ProposedAccrAmtInTransCrcy ProposedAccrAmtInTransCrcy 1
ReviewComment ReviewComment 1
ReviewedByUser ReviewedByUser 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.

-- Periodic Data of Accrual Subobject View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PERIODACCRUAL (
    ACCRUALENGINEAPPLICATION,
    ACCRUALITEMTYPE,
    ACCRUALOBJECT,
    ACCRUALPERIODENDDATE,
    ACCRUALSUBOBJECT,
    COMPANYCODE,
    LEDGER,
    PROPOSEDACCRAMTISEXISTING,
    ACCRPERIODAMTCALCULATIONMETHOD,
    ACCRUALAMOUNTADJUSTEDBYUSER,
    ACCRUALAMOUNTADJUSTMENTDATE,
    ACCRUALAMOUNTADJUSTMENTTIME,
    ACCRUALAMOUNTAPPROVALDATE,
    ACCRUALAMOUNTAPPROVALSTATUS,
    ACCRUALAMOUNTAPPROVALTIME,
    ACCRUALAMOUNTISAPPROVED,
    ACCRUALAMOUNTISREVIEWED,
    ACCRUALAMOUNTREVIEWSTATUS,
    ACCRUALAMTINCCCRCY,
    ACCRUALAMTINFREEDFNDCRCY1,
    ACCRUALAMTINFREEDFNDCRCY2,
    ACCRUALAMTINFREEDFNDCRCY3,
    ACCRUALAMTINFREEDFNDCRCY4,
    ACCRUALAMTINFREEDFNDCRCY5,
    ACCRUALAMTINFREEDFNDCRCY6,
    ACCRUALAMTINFREEDFNDCRCY7,
    ACCRUALAMTINFREEDFNDCRCY8,
    ACCRUALAMTINGLOBALCRCY,
    ACCRUALAMTINTRANSCRCY,
    ACCRUALOBJECTLOGICALSYSTEM,
    ACCRUALPERIODSTARTDATE,
    ACCRUALPOSTINGAPPROVALTYPE,
    ACCRUALPOSTINGREVIEWTYPE,
    ACTUALACCRUALITEMTYPE,
    ACTUALCOSTAMTINCCCRCY,
    ACTUALCOSTINFREEDFNDCRCY1,
    ACTUALCOSTINFREEDFNDCRCY2,
    ACTUALCOSTINFREEDFNDCRCY3,
    ACTUALCOSTINFREEDFNDCRCY4,
    ACTUALCOSTINFREEDFNDCRCY5,
    ACTUALCOSTINFREEDFNDCRCY6,
    ACTUALCOSTINFREEDFNDCRCY7,
    ACTUALCOSTINFREEDFNDCRCY8,
    ACTUALCOSTINGLOBALCRCY,
    ACTUALCOSTINTRANSCRCY,
    ADJUSTEDCOSTINCOCODECRCY,
    ADJUSTEDCOSTINFREEDFNDCRCY1,
    ADJUSTEDCOSTINFREEDFNDCRCY2,
    ADJUSTEDCOSTINFREEDFNDCRCY3,
    ADJUSTEDCOSTINFREEDFNDCRCY4,
    ADJUSTEDCOSTINFREEDFNDCRCY5,
    ADJUSTEDCOSTINFREEDFNDCRCY6,
    ADJUSTEDCOSTINFREEDFNDCRCY7,
    ADJUSTEDCOSTINFREEDFNDCRCY8,
    ADJUSTEDCOSTINGLOBALCRCY,
    ADJUSTEDCOSTINTRANSCRCY,
    AMOUNTREVIEWDATE,
    AMOUNTREVIEWTIME,
    APPROVEDBYUSER,
    PERCENTAGEOFCOMPLETION,
    PLANNEDACCRUALITEMTYPE,
    PLANNEDCOSTINFREEDFNDCRCY1,
    PLANNEDCOSTINFREEDFNDCRCY2,
    PLANNEDCOSTINFREEDFNDCRCY3,
    PLANNEDCOSTINFREEDFNDCRCY4,
    PLANNEDCOSTINFREEDFNDCRCY5,
    PLANNEDCOSTINFREEDFNDCRCY6,
    PLANNEDCOSTINFREEDFNDCRCY7,
    PLANNEDCOSTINFREEDFNDCRCY8,
    PLANNEDCOSTINGLOBALCRCY,
    PLANNEDCOSTINTRANSCRCY,
    PLNDCOSTINCOCODECRCY,
    PROPOSEDACCRAMTADJMTREASON,
    PROPOSEDACCRAMTINCOCODECRCY,
    PROPOSEDACCRAMTINFREEDFNDCRCY1,
    PROPOSEDACCRAMTINFREEDFNDCRCY2,
    PROPOSEDACCRAMTINFREEDFNDCRCY3,
    PROPOSEDACCRAMTINFREEDFNDCRCY4,
    PROPOSEDACCRAMTINFREEDFNDCRCY5,
    PROPOSEDACCRAMTINFREEDFNDCRCY6,
    PROPOSEDACCRAMTINFREEDFNDCRCY7,
    PROPOSEDACCRAMTINFREEDFNDCRCY8,
    PROPOSEDACCRAMTINGLOBALCRCY,
    PROPOSEDACCRAMTINTRANSCRCY,
    REVIEWCOMMENT,
    REVIEWEDBYUSER,
    PRIMARY KEY (ACCRUALENGINEAPPLICATION, ACCRUALITEMTYPE, ACCRUALOBJECT, ACCRUALPERIODENDDATE, ACCRUALSUBOBJECT, COMPANYCODE, LEDGER, PROPOSEDACCRAMTISEXISTING)
);

Learn More