_PERIODPARAM

110 Fields

_PERIODPARAM is an SAP database table in S/4HANA. It contains 110 fields.

Fields (110)

KeyField CDS FieldsUsed in Views
KEY ProposedAccrAmtIsExisting is_proposed 2
AccrPeriodAmtCalculationMethod period_amnt_source 2
AccrualAmountAdjustedByUser adjusted_by 2
AccrualAmountAdjustmentDate adjusted_on 2
AccrualAmountAdjustmentTime adjusted_at 2
AccrualAmountApprovalDate approved_on 2
AccrualAmountApprovalStatus approval_status 2
AccrualAmountApprovalTime approved_at 2
AccrualAmountIsApproved xapproved 2
AccrualAmountIsReviewed xreviewed 2
AccrualAmountProposalDate PERIOD_AMNT_CHANGED_ON 2
AccrualAmountProposalTime PERIOD_AMNT_CHANGED_AT 2
AccrualAmountProposedByUser PERIOD_AMNT_CHANGED_BY 2
AccrualAmountReviewStatus review_status 2
AccrualAmtInCCCrcy accrual_amnt_hsl 2
AccrualAmtInFreeDfndCrcy1 accrual_amnt_osl 2
AccrualAmtInFreeDfndCrcy2 accrual_amnt_vsl 2
AccrualAmtInFreeDfndCrcy3 accrual_amnt_bsl 2
AccrualAmtInFreeDfndCrcy4 accrual_amnt_csl 2
AccrualAmtInFreeDfndCrcy5 accrual_amnt_dsl 2
AccrualAmtInFreeDfndCrcy6 accrual_amnt_esl 2
AccrualAmtInFreeDfndCrcy7 accrual_amnt_fsl 2
AccrualAmtInFreeDfndCrcy8 accrual_amnt_gsl 2
AccrualAmtInGlobalCrcy accrual_amnt_ksl 2
AccrualAmtInTransCrcy accrual_amnt_wsl 2
AccrualEngineAccrQtyInBaseUnit accrual_msl 1
AccrualEngineActlQtyInBaseUnit actual_cost_msl 1
AccrualEngineAdjdQtyInBaseUnit adjusted_cost_msl 1
AccrualEnginePlndQtyInBaseUnit planned_cost_msl 1
AccrualEnginePrpsdQtyInBsUnt proposed_accr_msl 1
AccrualPeriodStartDate period_start_date 2
AccrualPostingApprovalType approval_type 2
AccrualPostingReviewType review_type 2
ActualAccrualItemType actual_itemtype 1
ActualCostAmtInCCCrcy actual_cost_amnt_hsl 1
ActualCostInFreeDfndCrcy1 actual_cost_amnt_osl 1
ActualCostInFreeDfndCrcy2 actual_cost_amnt_vsl 1
ActualCostInFreeDfndCrcy3 actual_cost_amnt_bsl 1
ActualCostInFreeDfndCrcy4 actual_cost_amnt_csl 1
ActualCostInFreeDfndCrcy5 actual_cost_amnt_dsl 1
ActualCostInFreeDfndCrcy6 actual_cost_amnt_esl 1
ActualCostInFreeDfndCrcy7 actual_cost_amnt_fsl 1
ActualCostInFreeDfndCrcy8 actual_cost_amnt_gsl 1
ActualCostInGlobalCrcy actual_cost_amnt_ksl 1
ActualCostInTransCrcy actual_cost_amnt_wsl 1
AdjustedCostInCoCodeCrcy adjusted_cost_amnt_hsl 1
AdjustedCostInFreeDfndCrcy1 adjusted_cost_amnt_osl 1
AdjustedCostInFreeDfndCrcy2 adjusted_cost_amnt_vsl 1
AdjustedCostInFreeDfndCrcy3 adjusted_cost_amnt_bsl 1
AdjustedCostInFreeDfndCrcy4 adjusted_cost_amnt_csl 1
AdjustedCostInFreeDfndCrcy5 adjusted_cost_amnt_dsl 1
AdjustedCostInFreeDfndCrcy6 adjusted_cost_amnt_esl 1
AdjustedCostInFreeDfndCrcy7 adjusted_cost_amnt_fsl 1
AdjustedCostInFreeDfndCrcy8 adjusted_cost_amnt_gsl 1
AdjustedCostInGlobalCrcy adjusted_cost_amnt_ksl 1
AdjustedCostInTransCrcy adjusted_cost_amnt_wsl 1
AmountReviewDate reviewed_on 2
AmountReviewTime reviewed_at 2
ApprovedByUser approved_by 2
DeferralItemType deferral_itemtype 1
DeferredCostInCoCodeCrcy deferred_cost_amnt_hsl 1
DeferredCostInFreeDfndCrcy1 deferred_cost_amnt_osl 1
DeferredCostInFreeDfndCrcy2 deferred_cost_amnt_vsl 1
DeferredCostInFreeDfndCrcy3 deferred_cost_amnt_bsl 1
DeferredCostInFreeDfndCrcy4 deferred_cost_amnt_csl 1
DeferredCostInFreeDfndCrcy5 deferred_cost_amnt_dsl 1
DeferredCostInFreeDfndCrcy6 deferred_cost_amnt_esl 1
DeferredCostInFreeDfndCrcy7 deferred_cost_amnt_fsl 1
DeferredCostInFreeDfndCrcy8 deferred_cost_amnt_gsl 1
DeferredCostInGlobalCrcy deferred_cost_amnt_ksl 1
DeferredCostInTransCrcy deferred_cost_amnt_wsl 1
DeferredQuantityInBaseUnit deferred_msl 1
PlannedAccrualItemType planned_itemtype 1
PlannedCostInFreeDfndCrcy1 planned_cost_amnt_osl 1
PlannedCostInFreeDfndCrcy2 planned_cost_amnt_vsl 1
PlannedCostInFreeDfndCrcy3 planned_cost_amnt_bsl 1
PlannedCostInFreeDfndCrcy4 planned_cost_amnt_csl 1
PlannedCostInFreeDfndCrcy5 planned_cost_amnt_dsl 1
PlannedCostInFreeDfndCrcy6 planned_cost_amnt_esl 1
PlannedCostInFreeDfndCrcy7 planned_cost_amnt_fsl 1
PlannedCostInFreeDfndCrcy8 planned_cost_amnt_gsl 1
PlannedCostInGlobalCrcy planned_cost_amnt_ksl 1
PlannedCostInTransCrcy planned_cost_amnt_wsl 1
PlndCostInCoCodeCrcy planned_cost_amnt_hsl 1
ProposedAccrAmtAdjmtReason adjstmnt_reason 2
ProposedAccrAmtInCoCodeCrcy proposed_accr_amnt_hsl 2
ProposedAccrAmtInFreeDfndCrcy1 proposed_accr_amnt_osl 2
ProposedAccrAmtInFreeDfndCrcy2 proposed_accr_amnt_vsl 2
ProposedAccrAmtInFreeDfndCrcy3 proposed_accr_amnt_bsl 2
ProposedAccrAmtInFreeDfndCrcy4 proposed_accr_amnt_csl 2
ProposedAccrAmtInFreeDfndCrcy5 proposed_accr_amnt_dsl 2
ProposedAccrAmtInFreeDfndCrcy6 proposed_accr_amnt_esl 2
ProposedAccrAmtInFreeDfndCrcy7 proposed_accr_amnt_fsl 2
ProposedAccrAmtInFreeDfndCrcy8 proposed_accr_amnt_gsl 2
ProposedAccrAmtInGlobalCrcy proposed_accr_amnt_ksl 2
ProposedAccrAmtInTransCrcy proposed_accr_amnt_wsl 2
RecognizedCostInCoCodeCrcy recognized_cost_amnt_hsl 1
RecognizedCostInFreeDfndCrcy1 recognized_cost_amnt_osl 1
RecognizedCostInFreeDfndCrcy2 recognized_cost_amnt_vsl 1
RecognizedCostInFreeDfndCrcy3 recognized_cost_amnt_bsl 1
RecognizedCostInFreeDfndCrcy4 recognized_cost_amnt_csl 1
RecognizedCostInFreeDfndCrcy5 recognized_cost_amnt_dsl 1
RecognizedCostInFreeDfndCrcy6 recognized_cost_amnt_esl 1
RecognizedCostInFreeDfndCrcy7 recognized_cost_amnt_fsl 1
RecognizedCostInFreeDfndCrcy8 recognized_cost_amnt_gsl 1
RecognizedCostInGlobalCrcy recognized_cost_amnt_ksl 1
RecognizedCostInTransCrcy recognized_cost_amnt_wsl 1
RecognizedQuantityInBaseUnit recognized_msl 1
ReviewComment adjstmnt_comment 2
ReviewedByUser reviewed_by 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PERIODPARAM (
    PROPOSEDACCRAMTISEXISTING,
    ACCRPERIODAMTCALCULATIONMETHOD,
    ACCRUALAMOUNTADJUSTEDBYUSER,
    ACCRUALAMOUNTADJUSTMENTDATE,
    ACCRUALAMOUNTADJUSTMENTTIME,
    ACCRUALAMOUNTAPPROVALDATE,
    ACCRUALAMOUNTAPPROVALSTATUS,
    ACCRUALAMOUNTAPPROVALTIME,
    ACCRUALAMOUNTISAPPROVED,
    ACCRUALAMOUNTISREVIEWED,
    ACCRUALAMOUNTPROPOSALDATE,
    ACCRUALAMOUNTPROPOSALTIME,
    ACCRUALAMOUNTPROPOSEDBYUSER,
    ACCRUALAMOUNTREVIEWSTATUS,
    ACCRUALAMTINCCCRCY,
    ACCRUALAMTINFREEDFNDCRCY1,
    ACCRUALAMTINFREEDFNDCRCY2,
    ACCRUALAMTINFREEDFNDCRCY3,
    ACCRUALAMTINFREEDFNDCRCY4,
    ACCRUALAMTINFREEDFNDCRCY5,
    ACCRUALAMTINFREEDFNDCRCY6,
    ACCRUALAMTINFREEDFNDCRCY7,
    ACCRUALAMTINFREEDFNDCRCY8,
    ACCRUALAMTINGLOBALCRCY,
    ACCRUALAMTINTRANSCRCY,
    ACCRUALENGINEACCRQTYINBASEUNIT,
    ACCRUALENGINEACTLQTYINBASEUNIT,
    ACCRUALENGINEADJDQTYINBASEUNIT,
    ACCRUALENGINEPLNDQTYINBASEUNIT,
    ACCRUALENGINEPRPSDQTYINBSUNT,
    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,
    DEFERRALITEMTYPE,
    DEFERREDCOSTINCOCODECRCY,
    DEFERREDCOSTINFREEDFNDCRCY1,
    DEFERREDCOSTINFREEDFNDCRCY2,
    DEFERREDCOSTINFREEDFNDCRCY3,
    DEFERREDCOSTINFREEDFNDCRCY4,
    DEFERREDCOSTINFREEDFNDCRCY5,
    DEFERREDCOSTINFREEDFNDCRCY6,
    DEFERREDCOSTINFREEDFNDCRCY7,
    DEFERREDCOSTINFREEDFNDCRCY8,
    DEFERREDCOSTINGLOBALCRCY,
    DEFERREDCOSTINTRANSCRCY,
    DEFERREDQUANTITYINBASEUNIT,
    PLANNEDACCRUALITEMTYPE,
    PLANNEDCOSTINFREEDFNDCRCY1,
    PLANNEDCOSTINFREEDFNDCRCY2,
    PLANNEDCOSTINFREEDFNDCRCY3,
    PLANNEDCOSTINFREEDFNDCRCY4,
    PLANNEDCOSTINFREEDFNDCRCY5,
    PLANNEDCOSTINFREEDFNDCRCY6,
    PLANNEDCOSTINFREEDFNDCRCY7,
    PLANNEDCOSTINFREEDFNDCRCY8,
    PLANNEDCOSTINGLOBALCRCY,
    PLANNEDCOSTINTRANSCRCY,
    PLNDCOSTINCOCODECRCY,
    PROPOSEDACCRAMTADJMTREASON,
    PROPOSEDACCRAMTINCOCODECRCY,
    PROPOSEDACCRAMTINFREEDFNDCRCY1,
    PROPOSEDACCRAMTINFREEDFNDCRCY2,
    PROPOSEDACCRAMTINFREEDFNDCRCY3,
    PROPOSEDACCRAMTINFREEDFNDCRCY4,
    PROPOSEDACCRAMTINFREEDFNDCRCY5,
    PROPOSEDACCRAMTINFREEDFNDCRCY6,
    PROPOSEDACCRAMTINFREEDFNDCRCY7,
    PROPOSEDACCRAMTINFREEDFNDCRCY8,
    PROPOSEDACCRAMTINGLOBALCRCY,
    PROPOSEDACCRAMTINTRANSCRCY,
    RECOGNIZEDCOSTINCOCODECRCY,
    RECOGNIZEDCOSTINFREEDFNDCRCY1,
    RECOGNIZEDCOSTINFREEDFNDCRCY2,
    RECOGNIZEDCOSTINFREEDFNDCRCY3,
    RECOGNIZEDCOSTINFREEDFNDCRCY4,
    RECOGNIZEDCOSTINFREEDFNDCRCY5,
    RECOGNIZEDCOSTINFREEDFNDCRCY6,
    RECOGNIZEDCOSTINFREEDFNDCRCY7,
    RECOGNIZEDCOSTINFREEDFNDCRCY8,
    RECOGNIZEDCOSTINGLOBALCRCY,
    RECOGNIZEDCOSTINTRANSCRCY,
    RECOGNIZEDQUANTITYINBASEUNIT,
    REVIEWCOMMENT,
    REVIEWEDBYUSER,
    PRIMARY KEY (PROPOSEDACCRAMTISEXISTING)
);

Learn More