C_AccrEnginePeriodicAmountsTP

DDL: C_ACCRENGINEPERIODICAMOUNTSTP Type: view_entity CONSUMPTION
80 Fields 1 Data Sources

Accrual Engine Periodic Amounts

C_AccrEnginePeriodicAmountsTP is a Consumption CDS View that provides data about "Accrual Engine Periodic Amounts" in SAP S/4HANA. It reads from 1 data source (R_AccrEnginePeriodicAmountsTP) and exposes 80 fields with key fields AccrualEngineAccrualObjectType, AccrualObjectLogicalSystem, CompanyCode, AccrualObject, AccrualSubobject.

Data Sources (1)

SourceAliasJoin Type
R_AccrEnginePeriodicAmountsTP R_AccrEnginePeriodicAmountsTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Accrual Engine Periodic Amounts view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (80)

KeyFieldSource TableSource FieldDescription
KEY AccrualEngineAccrualObjectType AccrualEngineAccrualObjectType Component
KEY AccrualObjectLogicalSystem AccrualObjectLogicalSystem Logical System
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccrualObject AccrualObject External Reference of Accrual Object
KEY AccrualSubobject AccrualSubobject External Reference of Accrual Subobject
KEY AccrualItemType AccrualItemType Accrual Item Type
KEY Ledger Ledger Ledger
KEY AccrualEngineReferenceObject AccrualEngineReferenceObject Acr. Reference ID
KEY AccrualPeriodEndDate AccrualPeriodEndDate Last Day of Period
LedgerGroup LedgerGroup Ledger Group
AccrualPeriodStartDate AccrualPeriodStartDate First Day of Period
AccrPeriodAmtCalculationMethod AccrPeriodAmtCalculationMethod
AccrualAmountProposedByUser AccrualAmountProposedByUser
AccrAmtProposedByUserFullName AccrAmtProposedByUserFullName Name
AccrualAmountProposalDate AccrualAmountProposalDate
AccrualAmountProposalTime AccrualAmountProposalTime
AccrualAmountProposalDateTime AccrualAmountProposalDateTime
PlanAccrualItemType PlanAccrualItemType Plnd Costs Itm Type
ActualAccrualItemType ActualAccrualItemType Actl Costs Item Type
DeferralItemType DeferralItemType Deferral Item Type
ReviewProcessIsActive ReviewProcessIsActive
ReviewApprovalAccrualType ReviewApprovalAccrualType
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
TotalAccrualQuantityUnit TotalAccrualQuantityUnit Unit of Measure
ProposedAccrAmtInTransCrcy ProposedAccrAmtInTransCrcy
AccrualEnginePrpsdQtyInBsUnt AccrualEnginePrpsdQtyInBsUnt
PlannedCostInTransCrcy PlannedCostInTransCrcy Plnd Costs Bal. (TC)
AccrualEnginePlndQtyInBaseUnit AccrualEnginePlndQtyInBaseUnit
ActualCostInTransCrcy ActualCostInTransCrcy Actl Costs Bal. (TC)
AccrualEngineActlQtyInBaseUnit AccrualEngineActlQtyInBaseUnit Actual Quantity
DeferredCostInTransCrcy DeferredCostInTransCrcy Dfrd Costs Bal. (TC)
DeferredQuantityInBaseUnit DeferredQuantityInBaseUnit
AdjustedPlannedCostInTransCrcy AdjustedPlannedCostInTransCrcy
AccrualEngineAdjdQtyInBaseUnit AccrualEngineAdjdQtyInBaseUnit
AdjustedAccrAmtInTransCrcy AdjustedAccrAmtInTransCrcy
AccrualEngineAccrQtyInBaseUnit AccrualEngineAccrQtyInBaseUnit Balance Quantity
ProposedAccrAmtAdjmtReason ProposedAccrAmtAdjmtReason
ReviewComment ReviewComment
AccrualAmountAdjustedByUser AccrualAmountAdjustedByUser
AccrAmtAdjustedByUserFullName AccrAmtAdjustedByUserFullName Name
AccrualAmountAdjustmentDate AccrualAmountAdjustmentDate
AccrualAmountAdjustmentTime AccrualAmountAdjustmentTime
AccrAmountAdjustmentDateTime AccrAmountAdjustmentDateTime
AccrualPostingReviewType AccrualPostingReviewType
AccrualAmountReviewStatus AccrualAmountReviewStatus
AccrualAmountIsReviewed AccrualAmountIsReviewed
ReviewedByUser ReviewedByUser
ReviewedByUserFullName ReviewedByUserFullName Name
AmountReviewDate AmountReviewDate
AmountReviewTime AmountReviewTime
AccrAmountReviewDateTime AccrAmountReviewDateTime
AccrualPostingApprovalType AccrualPostingApprovalType
AccrualAmountApprovalStatus AccrualAmountApprovalStatus
AccrualAmountIsApproved AccrualAmountIsApproved
ApprovedByUser ApprovedByUser
ApprovedByUserFullName ApprovedByUserFullName Name
AccrualAmountApprovalDate AccrualAmountApprovalDate
AccrualAmountApprovalTime AccrualAmountApprovalTime
AccrAmountApprovalDateTime AccrAmountApprovalDateTime
_AccrCompanyCode _AccrCompanyCode
_AccrItemType _AccrItemType
_AccrLogicalSystem _AccrLogicalSystem
_AccrObj _AccrObj
_AccrObjectType _AccrObjectType
_AccrSubobj _AccrSubobj
_ActualAccrItemType _ActualAccrItemType
_AdjustedByUser _AdjustedByUser
_ApprovedByUser _ApprovedByUser
_BaseUnit _BaseUnit
_CompanyCodeCurrency _CompanyCodeCurrency
_DeferralItemType _DeferralItemType
_GlobalCurrency _GlobalCurrency
_Ledger _Ledger
_PlanAccrItemType _PlanAccrItemType
_ProposedByUser _ProposedByUser
_ReviewApprovalItemType _ReviewApprovalItemType
_ReviewedByUser _ReviewedByUser
_TransactionCurrency _TransactionCurrency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_AccrEnginePeriodicAmountsTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_AccrEnginePeriodicAmountsTP AS
SELECT
  AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  AccrualEngineReferenceObject,
  AccrualPeriodEndDate,
  LedgerGroup,
  AccrualPeriodStartDate,
  AccrPeriodAmtCalculationMethod,
  AccrualAmountProposedByUser,
  AccrAmtProposedByUserFullName,
  AccrualAmountProposalDate,
  AccrualAmountProposalTime,
  AccrualAmountProposalDateTime,
  PlanAccrualItemType,
  ActualAccrualItemType,
  DeferralItemType,
  ReviewProcessIsActive,
  ReviewApprovalAccrualType,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  TotalAccrualQuantityUnit,
  ProposedAccrAmtInTransCrcy,
  AccrualEnginePrpsdQtyInBsUnt,
  PlannedCostInTransCrcy,
  AccrualEnginePlndQtyInBaseUnit,
  ActualCostInTransCrcy,
  AccrualEngineActlQtyInBaseUnit,
  DeferredCostInTransCrcy,
  DeferredQuantityInBaseUnit,
  AdjustedPlannedCostInTransCrcy,
  AccrualEngineAdjdQtyInBaseUnit,
  AdjustedAccrAmtInTransCrcy,
  AccrualEngineAccrQtyInBaseUnit,
  ProposedAccrAmtAdjmtReason,
  ReviewComment,
  AccrualAmountAdjustedByUser,
  AccrAmtAdjustedByUserFullName,
  AccrualAmountAdjustmentDate,
  AccrualAmountAdjustmentTime,
  AccrAmountAdjustmentDateTime,
  AccrualPostingReviewType,
  AccrualAmountReviewStatus,
  AccrualAmountIsReviewed,
  ReviewedByUser,
  ReviewedByUserFullName,
  AmountReviewDate,
  AmountReviewTime,
  AccrAmountReviewDateTime,
  AccrualPostingApprovalType,
  AccrualAmountApprovalStatus,
  AccrualAmountIsApproved,
  ApprovedByUser,
  ApprovedByUserFullName,
  AccrualAmountApprovalDate,
  AccrualAmountApprovalTime,
  AccrAmountApprovalDateTime
FROM R_AccrEnginePeriodicAmountsTP
;

Learn More