I_ACCRENGINEPERIODICAMOUNTS
Accrual Engine:Cnsldtd Periodic Amounts
I_ACCRENGINEPERIODICAMOUNTS is a CDS View in S/4HANA. Accrual Engine:Cnsldtd Periodic Amounts. It contains 130 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_AccrEngineAccrPerdcAmounts | view | from | CONSUMPTION | Accrual Periodic Amounts |
| I_AccrSubobjItmWthPerdcAmounts | view | inner | COMPOSITE | Accrual Subobject Item with Periodic Amounts |
| I_SESAccrEngnPerdcAmounts | view | from | COMPOSITE | Service Entry Sheets Periodic Amounts |
| R_AccrEnginePeriodicAmountsTP | view_entity | from | TRANSACTIONAL | Accrual Engine:Cnsldtd Periodic Amounts |
Fields (130)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccrualEngineReferenceObject | AccrualEngineReferenceObject | 1 |
| KEY | AccrualPeriodEndDate | AccrualPeriodEndDate | 1 |
| _AdjustedByUser | _AdjustedByUser | 1 | |
| _ApprovedByUser | _ApprovedByUser | 1 | |
| _BaseUnit | _BaseUnit | 1 | |
| _CompanyCodeCurrency | _CompanyCodeCurrency | 1 | |
| _FreeDefinedCurrency1 | _FreeDefinedCurrency1 | 1 | |
| _FreeDefinedCurrency2 | _FreeDefinedCurrency2 | 1 | |
| _FreeDefinedCurrency3 | _FreeDefinedCurrency3 | 1 | |
| _FreeDefinedCurrency4 | _FreeDefinedCurrency4 | 1 | |
| _FreeDefinedCurrency5 | _FreeDefinedCurrency5 | 1 | |
| _FreeDefinedCurrency6 | _FreeDefinedCurrency6 | 1 | |
| _FreeDefinedCurrency7 | _FreeDefinedCurrency7 | 1 | |
| _FreeDefinedCurrency8 | _FreeDefinedCurrency8 | 1 | |
| _GlobalCurrency | _GlobalCurrency | 1 | |
| _ProposedByUser | _ProposedByUser | 1 | |
| _ReviewedByUser | _ReviewedByUser | 1 | |
| _TransactionCurrency | _TransactionCurrency | 1 | |
| AccrAmountAdjustmentDateTime | AccrAmountAdjustmentDateTime | 1 | |
| AccrAmountApprovalDateTime | AccrAmountApprovalDateTime | 1 | |
| AccrAmountReviewDateTime | AccrAmountReviewDateTime | 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 | |
| AccrualAmountProposalDate | AccrualAmountProposalDate | 1 | |
| AccrualAmountProposalDateTime | AccrualAmountProposalDateTime | 1 | |
| AccrualAmountProposalTime | AccrualAmountProposalTime | 1 | |
| AccrualAmountProposedByUser | AccrualAmountProposedByUser | 1 | |
| AccrualAmountReviewStatus | AccrualAmountReviewStatus | 1 | |
| AccrualEngineAccrQtyInBaseUnit | AccrualEngineAccrQtyInBaseUnit | 1 | |
| AccrualEngineActlQtyInBaseUnit | AccrualEngineActlQtyInBaseUnit | 1 | |
| AccrualEngineAdjdQtyInBaseUnit | AccrualEngineAdjdQtyInBaseUnit | 1 | |
| AccrualEnginePlndQtyInBaseUnit | AccrualEnginePlndQtyInBaseUnit | 1 | |
| AccrualEnginePrpsdQtyInBsUnt | AccrualEnginePrpsdQtyInBsUnt | 1 | |
| AccrualPeriodStartDate | AccrualPeriodStartDate | 1 | |
| AccrualPostingApprovalType | AccrualPostingApprovalType | 1 | |
| AccrualPostingReviewType | AccrualPostingReviewType | 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 | |
| AdjdAccrAmtInInFreeDfndCrcy1 | AdjdAccrAmtInInFreeDfndCrcy1 | 1 | |
| AdjdAccrAmtInInFreeDfndCrcy2 | AdjdAccrAmtInInFreeDfndCrcy2 | 1 | |
| AdjdAccrAmtInInFreeDfndCrcy3 | AdjdAccrAmtInInFreeDfndCrcy3 | 1 | |
| AdjdAccrAmtInInFreeDfndCrcy4 | AdjdAccrAmtInInFreeDfndCrcy4 | 1 | |
| AdjdAccrAmtInInFreeDfndCrcy5 | AdjdAccrAmtInInFreeDfndCrcy5 | 1 | |
| AdjdAccrAmtInInFreeDfndCrcy6 | AdjdAccrAmtInInFreeDfndCrcy6 | 1 | |
| AdjdAccrAmtInInFreeDfndCrcy7 | AdjdAccrAmtInInFreeDfndCrcy7 | 1 | |
| AdjdAccrAmtInInFreeDfndCrcy8 | AdjdAccrAmtInInFreeDfndCrcy8 | 1 | |
| AdjdPlannedCostInCoCodeCrcy | AdjdPlannedCostInCoCodeCrcy | 1 | |
| AdjdPlannedCostInFreeDfndCrcy1 | AdjdPlannedCostInFreeDfndCrcy1 | 1 | |
| AdjdPlannedCostInFreeDfndCrcy2 | AdjdPlannedCostInFreeDfndCrcy2 | 1 | |
| AdjdPlannedCostInFreeDfndCrcy3 | AdjdPlannedCostInFreeDfndCrcy3 | 1 | |
| AdjdPlannedCostInFreeDfndCrcy4 | AdjdPlannedCostInFreeDfndCrcy4 | 1 | |
| AdjdPlannedCostInFreeDfndCrcy5 | AdjdPlannedCostInFreeDfndCrcy5 | 1 | |
| AdjdPlannedCostInFreeDfndCrcy6 | AdjdPlannedCostInFreeDfndCrcy6 | 1 | |
| AdjdPlannedCostInFreeDfndCrcy7 | AdjdPlannedCostInFreeDfndCrcy7 | 1 | |
| AdjdPlannedCostInFreeDfndCrcy8 | AdjdPlannedCostInFreeDfndCrcy8 | 1 | |
| AdjdPlannedCostInGlobalCrcy | AdjdPlannedCostInGlobalCrcy | 1 | |
| AdjustedAccrAmtInCoCodeCrcy | AdjustedAccrAmtInCoCodeCrcy | 1 | |
| AdjustedAccrAmtInGlobalCrcy | AdjustedAccrAmtInGlobalCrcy | 1 | |
| AdjustedAccrAmtInTransCrcy | AdjustedAccrAmtInTransCrcy | 1 | |
| AdjustedPlannedCostInTransCrcy | AdjustedPlannedCostInTransCrcy | 1 | |
| AmountReviewDate | AmountReviewDate | 1 | |
| AmountReviewTime | AmountReviewTime | 1 | |
| ApprovedByUser | ApprovedByUser | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| DeferredCostInCoCodeCrcy | DeferredCostInCoCodeCrcy | 1 | |
| DeferredCostInFreeDfndCrcy1 | DeferredCostInFreeDfndCrcy1 | 1 | |
| DeferredCostInFreeDfndCrcy2 | DeferredCostInFreeDfndCrcy2 | 1 | |
| DeferredCostInFreeDfndCrcy3 | DeferredCostInFreeDfndCrcy3 | 1 | |
| DeferredCostInFreeDfndCrcy4 | DeferredCostInFreeDfndCrcy4 | 1 | |
| DeferredCostInFreeDfndCrcy5 | DeferredCostInFreeDfndCrcy5 | 1 | |
| DeferredCostInFreeDfndCrcy6 | DeferredCostInFreeDfndCrcy6 | 1 | |
| DeferredCostInFreeDfndCrcy7 | DeferredCostInFreeDfndCrcy7 | 1 | |
| DeferredCostInFreeDfndCrcy8 | DeferredCostInFreeDfndCrcy8 | 1 | |
| DeferredCostInGlobalCrcy | DeferredCostInGlobalCrcy | 1 | |
| DeferredCostInTransCrcy | DeferredCostInTransCrcy | 1 | |
| DeferredQuantityInBaseUnit | DeferredQuantityInBaseUnit | 1 | |
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | 1 | |
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | 1 | |
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | 1 | |
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | 1 | |
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | 1 | |
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | 1 | |
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | 1 | |
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | 1 | |
| GlobalCurrency | GlobalCurrency | 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 | |
| ReviewApprovalAccrualType | ReviewApprovalAccrualType | 1 | |
| ReviewComment | ReviewComment | 1 | |
| ReviewedByUser | ReviewedByUser | 1 | |
| ReviewProcessIsActive | ReviewProcessIsActive | 1 | |
| TotalAccrualQuantityUnit | TotalAccrualQuantityUnit | 1 | |
| TransactionCurrency | TransactionCurrency | 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.
-- Accrual Engine:Cnsldtd Periodic Amounts
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACCRENGINEPERIODICAMOUNTS (
ACCRUALENGINEREFERENCEOBJECT,
ACCRUALPERIODENDDATE,
_ADJUSTEDBYUSER,
_APPROVEDBYUSER,
_BASEUNIT,
_COMPANYCODECURRENCY,
_FREEDEFINEDCURRENCY1,
_FREEDEFINEDCURRENCY2,
_FREEDEFINEDCURRENCY3,
_FREEDEFINEDCURRENCY4,
_FREEDEFINEDCURRENCY5,
_FREEDEFINEDCURRENCY6,
_FREEDEFINEDCURRENCY7,
_FREEDEFINEDCURRENCY8,
_GLOBALCURRENCY,
_PROPOSEDBYUSER,
_REVIEWEDBYUSER,
_TRANSACTIONCURRENCY,
ACCRAMOUNTADJUSTMENTDATETIME,
ACCRAMOUNTAPPROVALDATETIME,
ACCRAMOUNTREVIEWDATETIME,
ACCRPERIODAMTCALCULATIONMETHOD,
ACCRUALAMOUNTADJUSTEDBYUSER,
ACCRUALAMOUNTADJUSTMENTDATE,
ACCRUALAMOUNTADJUSTMENTTIME,
ACCRUALAMOUNTAPPROVALDATE,
ACCRUALAMOUNTAPPROVALSTATUS,
ACCRUALAMOUNTAPPROVALTIME,
ACCRUALAMOUNTISAPPROVED,
ACCRUALAMOUNTISREVIEWED,
ACCRUALAMOUNTPROPOSALDATE,
ACCRUALAMOUNTPROPOSALDATETIME,
ACCRUALAMOUNTPROPOSALTIME,
ACCRUALAMOUNTPROPOSEDBYUSER,
ACCRUALAMOUNTREVIEWSTATUS,
ACCRUALENGINEACCRQTYINBASEUNIT,
ACCRUALENGINEACTLQTYINBASEUNIT,
ACCRUALENGINEADJDQTYINBASEUNIT,
ACCRUALENGINEPLNDQTYINBASEUNIT,
ACCRUALENGINEPRPSDQTYINBSUNT,
ACCRUALPERIODSTARTDATE,
ACCRUALPOSTINGAPPROVALTYPE,
ACCRUALPOSTINGREVIEWTYPE,
ACTUALCOSTAMTINCCCRCY,
ACTUALCOSTINFREEDFNDCRCY1,
ACTUALCOSTINFREEDFNDCRCY2,
ACTUALCOSTINFREEDFNDCRCY3,
ACTUALCOSTINFREEDFNDCRCY4,
ACTUALCOSTINFREEDFNDCRCY5,
ACTUALCOSTINFREEDFNDCRCY6,
ACTUALCOSTINFREEDFNDCRCY7,
ACTUALCOSTINFREEDFNDCRCY8,
ACTUALCOSTINGLOBALCRCY,
ACTUALCOSTINTRANSCRCY,
ADJDACCRAMTININFREEDFNDCRCY1,
ADJDACCRAMTININFREEDFNDCRCY2,
ADJDACCRAMTININFREEDFNDCRCY3,
ADJDACCRAMTININFREEDFNDCRCY4,
ADJDACCRAMTININFREEDFNDCRCY5,
ADJDACCRAMTININFREEDFNDCRCY6,
ADJDACCRAMTININFREEDFNDCRCY7,
ADJDACCRAMTININFREEDFNDCRCY8,
ADJDPLANNEDCOSTINCOCODECRCY,
ADJDPLANNEDCOSTINFREEDFNDCRCY1,
ADJDPLANNEDCOSTINFREEDFNDCRCY2,
ADJDPLANNEDCOSTINFREEDFNDCRCY3,
ADJDPLANNEDCOSTINFREEDFNDCRCY4,
ADJDPLANNEDCOSTINFREEDFNDCRCY5,
ADJDPLANNEDCOSTINFREEDFNDCRCY6,
ADJDPLANNEDCOSTINFREEDFNDCRCY7,
ADJDPLANNEDCOSTINFREEDFNDCRCY8,
ADJDPLANNEDCOSTINGLOBALCRCY,
ADJUSTEDACCRAMTINCOCODECRCY,
ADJUSTEDACCRAMTINGLOBALCRCY,
ADJUSTEDACCRAMTINTRANSCRCY,
ADJUSTEDPLANNEDCOSTINTRANSCRCY,
AMOUNTREVIEWDATE,
AMOUNTREVIEWTIME,
APPROVEDBYUSER,
COMPANYCODECURRENCY,
DEFERREDCOSTINCOCODECRCY,
DEFERREDCOSTINFREEDFNDCRCY1,
DEFERREDCOSTINFREEDFNDCRCY2,
DEFERREDCOSTINFREEDFNDCRCY3,
DEFERREDCOSTINFREEDFNDCRCY4,
DEFERREDCOSTINFREEDFNDCRCY5,
DEFERREDCOSTINFREEDFNDCRCY6,
DEFERREDCOSTINFREEDFNDCRCY7,
DEFERREDCOSTINFREEDFNDCRCY8,
DEFERREDCOSTINGLOBALCRCY,
DEFERREDCOSTINTRANSCRCY,
DEFERREDQUANTITYINBASEUNIT,
FREEDEFINEDCURRENCY1,
FREEDEFINEDCURRENCY2,
FREEDEFINEDCURRENCY3,
FREEDEFINEDCURRENCY4,
FREEDEFINEDCURRENCY5,
FREEDEFINEDCURRENCY6,
FREEDEFINEDCURRENCY7,
FREEDEFINEDCURRENCY8,
GLOBALCURRENCY,
PLANNEDCOSTINFREEDFNDCRCY1,
PLANNEDCOSTINFREEDFNDCRCY2,
PLANNEDCOSTINFREEDFNDCRCY3,
PLANNEDCOSTINFREEDFNDCRCY4,
PLANNEDCOSTINFREEDFNDCRCY5,
PLANNEDCOSTINFREEDFNDCRCY6,
PLANNEDCOSTINFREEDFNDCRCY7,
PLANNEDCOSTINFREEDFNDCRCY8,
PLANNEDCOSTINGLOBALCRCY,
PLANNEDCOSTINTRANSCRCY,
PLNDCOSTINCOCODECRCY,
PROPOSEDACCRAMTADJMTREASON,
PROPOSEDACCRAMTINCOCODECRCY,
PROPOSEDACCRAMTINFREEDFNDCRCY1,
PROPOSEDACCRAMTINFREEDFNDCRCY2,
PROPOSEDACCRAMTINFREEDFNDCRCY3,
PROPOSEDACCRAMTINFREEDFNDCRCY4,
PROPOSEDACCRAMTINFREEDFNDCRCY5,
PROPOSEDACCRAMTINFREEDFNDCRCY6,
PROPOSEDACCRAMTINFREEDFNDCRCY7,
PROPOSEDACCRAMTINFREEDFNDCRCY8,
PROPOSEDACCRAMTINGLOBALCRCY,
PROPOSEDACCRAMTINTRANSCRCY,
REVIEWAPPROVALACCRUALTYPE,
REVIEWCOMMENT,
REVIEWEDBYUSER,
REVIEWPROCESSISACTIVE,
TOTALACCRUALQUANTITYUNIT,
TRANSACTIONCURRENCY,
PRIMARY KEY (ACCRUALENGINEREFERENCEOBJECT, ACCRUALPERIODENDDATE)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA