_CALCFIELDS

_CALCFIELDS is an SAP database table in S/4HANA. It contains 44 fields.

Fields (44)

KeyField CDS FieldsUsed in Views
AdjustmentType AdjustmentType 1
AverageDailyUsage ProposedAverageDailyUsage 1
AverageDailyUsageMode AverageDailyUsageMode 1
AverageDailyUsageModeDesc AverageDailyUsageModeDesc 1
AvgDailyUsageDeviationRate AvgDailyUsageDeviationRate 1
BOMExplosionDate BOMExplosionDate 1
BOMUsageCode BOMUsageCode 1
ConsumptionCode ConsumptionCode 1
DecoupledLeadTime ProposedLeadTime 1
HorizonDaysInFuture HorizonDaysInFuture 1
HorizonDaysInPast HorizonDaysInPast 1
IsInProcess IsInProcess 1
IsMinOrderQtyConsidered IsMinOrderQtyConsidered 1
IsProposalAdopted IsProposalAdopted 1
LeadTimeDeviationRate LeadTimeDeviationRate 1
LeadTimeDifference LeadTimeDifference 1
MaterialMaxStockLevelQuantity MaterialMaxStockLevelQuantity,MatlCurrentMaxStock 1
MatlProposedMaxStock MatlProposedMaxStock 1
MatlPrpslAdjmtFctrIsApplied MatlPrpslAdjmtFctrIsApplied 1
MaxStockDeviationRate MaxStockDeviationRate 1
MaxStockDifference MaxStockDifference 2
MinOrderQuantityHasChanged MinOrderQuantityHasChanged 1
MRPGroup MRPGroup 1
NormalizedCurrentGreenZone NormalizedCurrentGreenZone 1
NormalizedCurrentRedZone NormalizedCurrentRedZone 1
NormalizedCurrentYellowZone NormalizedCurrentYellowZone 1
NormalizedProposedGreenZone NormalizedProposedGreenZone 1
NormalizedProposedRedZone NormalizedProposedRedZone 1
NormalizedProposedYellowZone NormalizedProposedYellowZone 1
ProcurementType ProcurementType 1
ProductProfileChangeCategory ProductProfileChangeCategory 1
ProductProfileHasChanged ProductProfileHasChanged 1
ProposalMode ProposalMode 1
ProposalRunIsNotSuspended ProposalRunIsNotSuspended 1
ProposalRunIsSuspended ProposalRunIsSuspended 1
ProposalStatusChangeDate ProposalStatusChangeDate 1
PurchasingGroup PurchasingGroup 1
ReplenishmentLeadTimeCode ReplenishmentLeadTimeCode 1
ReplenishmentLeadTimeValue ReplenishmentLeadTimeValue 1
VariabilityCode VariabilityCode 1
VariabilityFactor ProposedVariabilityFactor 1
VariabilityFactorDeviationRate VariabilityFactorDeviationRate 1
VariabilityFactorDifference VariabilityFactorDifference 1
VariabilityQuantity VariabilityQuantity 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _CALCFIELDS (
    ADJUSTMENTTYPE,
    AVERAGEDAILYUSAGE,
    AVERAGEDAILYUSAGEMODE,
    AVERAGEDAILYUSAGEMODEDESC,
    AVGDAILYUSAGEDEVIATIONRATE,
    BOMEXPLOSIONDATE,
    BOMUSAGECODE,
    CONSUMPTIONCODE,
    DECOUPLEDLEADTIME,
    HORIZONDAYSINFUTURE,
    HORIZONDAYSINPAST,
    ISINPROCESS,
    ISMINORDERQTYCONSIDERED,
    ISPROPOSALADOPTED,
    LEADTIMEDEVIATIONRATE,
    LEADTIMEDIFFERENCE,
    MATERIALMAXSTOCKLEVELQUANTITY,
    MATLPROPOSEDMAXSTOCK,
    MATLPRPSLADJMTFCTRISAPPLIED,
    MAXSTOCKDEVIATIONRATE,
    MAXSTOCKDIFFERENCE,
    MINORDERQUANTITYHASCHANGED,
    MRPGROUP,
    NORMALIZEDCURRENTGREENZONE,
    NORMALIZEDCURRENTREDZONE,
    NORMALIZEDCURRENTYELLOWZONE,
    NORMALIZEDPROPOSEDGREENZONE,
    NORMALIZEDPROPOSEDREDZONE,
    NORMALIZEDPROPOSEDYELLOWZONE,
    PROCUREMENTTYPE,
    PRODUCTPROFILECHANGECATEGORY,
    PRODUCTPROFILEHASCHANGED,
    PROPOSALMODE,
    PROPOSALRUNISNOTSUSPENDED,
    PROPOSALRUNISSUSPENDED,
    PROPOSALSTATUSCHANGEDATE,
    PURCHASINGGROUP,
    REPLENISHMENTLEADTIMECODE,
    REPLENISHMENTLEADTIMEVALUE,
    VARIABILITYCODE,
    VARIABILITYFACTOR,
    VARIABILITYFACTORDEVIATIONRATE,
    VARIABILITYFACTORDIFFERENCE,
    VARIABILITYQUANTITY
);