C_RevProdAllocChkCstrtRsltTP

DDL: C_REVPRODALLOCCHKCSTRTRSLTTP Type: view_entity CONSUMPTION
66 Fields 1 Data Sources

Review Product Allocation Check Constraint Result

C_RevProdAllocChkCstrtRsltTP is a Consumption CDS View that provides data about "Review Product Allocation Check Constraint Result" in SAP S/4HANA. It reads from 1 data source (R_RevProdAllocChkCstrtRsltTP) and exposes 66 fields with key field RevProdAllocChkCstrtRsltUUID.

Data Sources (1)

SourceAliasJoin Type
R_RevProdAllocChkCstrtRsltTP R_RevProdAllocChkCstrtRsltTP projection

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Review Product Allocation Check Constraint Result view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY RevProdAllocChkCstrtRsltUUID RevProdAllocChkCstrtRsltUUID Review Product Allocation Check Constraint Result UUID
RevProdAllocChkSubReqUUID RevProdAllocChkSubReqUUID Review Product Allocation Check Sub Request UUID
ATPCheckUUID ATPCheckUUID Check ID
ProdAllocSqncConstraintUUID ProdAllocSqncConstraintUUID Product Allocation Sequence Constraint UUID
CharcValueCombinationUUID CharcValueCombinationUUID Characteristic Value Combination UUID
ProdAllocSequenceConstraint _ProdAllocSequenceConstraint ProdAllocSequenceConstraint Sequence Constraint
ProductAllocationSequenceGroup _ProdAllocSequenceConstraint ProductAllocationSequenceGroup Sequence Group
ProductAllocationSequence _ProdAllocSequenceConstraint ProductAllocationSequence Allocation Sequence
ProdAllocSqncGrpPriorityValue
ProductAllocationObject
ProdAllocationPeriodTimeZone Dynamic Period Time Zone
ProductAllocationQuantityUnit
ProductAllocationPeriodType
ProdAllocationPeriodTypeDesc _CharcValCombnPeriodUnit ProdAllocationPeriodUnitDesc
ProductAllocationObjectUUID _ProdAllocObjCharcValCombn ProductAllocationObjectUUID Product Allocation Object UUID
ProdAllocCharc01 _ProdAllocObjCharcValCombn ProdAllocCharc01 Characteristic Value 1
ProdAllocCharc02 _ProdAllocObjCharcValCombn ProdAllocCharc02 Characteristic Value 2
ProdAllocCharc03 _ProdAllocObjCharcValCombn ProdAllocCharc03 Characteristic Value 3
ProdAllocCharc04 _ProdAllocObjCharcValCombn ProdAllocCharc04 Characteristic Value 4
ProdAllocCharc05 _ProdAllocObjCharcValCombn ProdAllocCharc05 Characteristic Value 5
ProdAllocCharc06 _ProdAllocObjCharcValCombn ProdAllocCharc06 Characteristic Value 6
ProdAllocCharc07 _ProdAllocObjCharcValCombn ProdAllocCharc07 Characteristic Value 7
ProdAllocCharc08 _ProdAllocObjCharcValCombn ProdAllocCharc08 Characteristic Value 8
ProdAllocCharc09 _ProdAllocObjCharcValCombn ProdAllocCharc09 Characteristic Value 9
ProdAllocCharc10 _ProdAllocObjCharcValCombn ProdAllocCharc10 Characteristic Value 10
ProdAllocChkDataSnapshotType ProdAllocChkDataSnapshotType Check Data Snapshot Type
ProdAllocChkRstrcnStatus ProdAllocChkRstrcnStatus Restriction Status
ProdAllocCheckQuantity ProdAllocCheckQuantity Check Quantity
ProdAllocCheckUTCDateTime ProdAllocCheckUTCDateTime Check Date Time
ProdAllocCheckTimeZone ProdAllocCheckTimeZone Check Time Zone
ProdAllocGoodsIssueUTCDateTime ProdAllocGoodsIssueUTCDateTime Goods Issue Date Time
ProdAllocGoodsIssueTimeZone ProdAllocGoodsIssueTimeZone Goods Issue Time Zone
ProdAllocMatlAvailyUTCDateTime ProdAllocMatlAvailyUTCDateTime Material Availability Date Time
ProdAllocMatlAvailyTimeZone ProdAllocMatlAvailyTimeZone Material Availability Time Zone
ProdAllocLeadTmeStartUTCDteTme ProdAllocLeadTmeStartUTCDteTme Lead Time Start Date Time
ProdAllocReqdDelivUTCDateTime ProdAllocReqdDelivUTCDateTime Requested Delivery Date Time
ProdAllocReqdDelivTimeZone ProdAllocReqdDelivTimeZone Requested Delivery Time Zone
ValidityStartUTCDateTime ValidityStartUTCDateTime Validity Start
ValidityEndUTCDateTime ValidityEndUTCDateTime Validity End
ProdAllocRequestedQuantityUnit ProdAllocRequestedQuantityUnit Requested Quantity Unit
NumberOfBackwardCnsmpnPeriods NumberOfBackwardCnsmpnPeriods Backward Consumption
NumberOfForwardCnsmpnPeriods NumberOfForwardCnsmpnPeriods Forward Consumption
HorizontalConsumptionDirection HorizontalConsumptionDirection Consumption Direction
PastPeriodIsAllowed PastPeriodIsAllowed Past Period Allowed
ProdAllocLeadTimeDuration ProdAllocLeadTimeDuration Lead Time Duration
ProdAllocLeadTimeDurationUnit ProdAllocLeadTimeDurationUnit Lead Time Duration Unit
ProdAllocationConstraintStatus ProdAllocationConstraintStatus Constraint Status
ProductAllocationRate ProductAllocationRate Allocation Rate
ProdAllocCheckDateTimeType ProdAllocCheckDateTimeType Check Date Time Type
OnlyOverlappingQtyIsConsumed OnlyOverlappingQtyIsConsumed Consume Overlapping Quantity Only
_ATPCheckTPredirectedtoC_RACRCheckTP
_GoodsIssueTimeZone _GoodsIssueTimeZone
_HorizontalCnsmpnDirection _HorizontalCnsmpnDirection
_LeadTimeDurationUnit _LeadTimeDurationUnit
_MatlAvailyTimeZone _MatlAvailyTimeZone
_OnlyOverlappingQtyIsCnsmdInd _OnlyOverlappingQtyIsCnsmdInd
_PastPeriodIsAllowedIndicator _PastPeriodIsAllowedIndicator
_ProdAllocCheckDateTimeType _ProdAllocCheckDateTimeType
_ProdAllocCheckTimeZone _ProdAllocCheckTimeZone
_ProdAllocChkDataSnpshtType _ProdAllocChkDataSnpshtType
_ProdAllocChkRstrcnStatus _ProdAllocChkRstrcnStatus
_ProdAllocConstraintStatus _ProdAllocConstraintStatus
_ProdAllocObjCharcValCombn _ProdAllocObjCharcValCombn
_ProdAllocSequenceConstraint _ProdAllocSequenceConstraint
_ReqdDelivTimeZone _ReqdDelivTimeZone
_RequestedQuantityUnit _RequestedQuantityUnit

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_RevProdAllocChkCstrtRsltTP.
-- 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_RevProdAllocChkCstrtRsltTP AS
SELECT
  RevProdAllocChkCstrtRsltUUID,
  RevProdAllocChkSubReqUUID,
  ATPCheckUUID,
  ProdAllocSqncConstraintUUID,
  CharcValueCombinationUUID,
  _ProdAllocSequenceConstraint.ProdAllocSequenceConstraint AS ProdAllocSequenceConstraint,
  _ProdAllocSequenceConstraint.ProductAllocationSequenceGroup AS ProductAllocationSequenceGroup,
  _ProdAllocSequenceConstraint.ProductAllocationSequence AS ProductAllocationSequence,
  _ProdAllocSequenceConstraint._ProdAllocationSequenceGroup.ProdAllocSqncGrpPriorityValue AS ProdAllocSqncGrpPriorityValue,
  _ProdAllocObjCharcValCombn._ProductAllocationObject.ProductAllocationObject AS ProductAllocationObject,
  cast(ProdAllocDynamicPeriodTimeZone as prodallocationperiodtimezone preserving type ) AS ProdAllocationPeriodTimeZone,
  _ProdAllocObjCharcValCombn._ProductAllocationObject.ProductAllocationQuantityUnit AS ProductAllocationQuantityUnit,
  _ProdAllocObjCharcValCombn._ProductAllocationObject.ProductAllocationPeriodType AS ProductAllocationPeriodType,
  _CharcValCombnPeriodUnit.ProdAllocationPeriodUnitDesc AS ProdAllocationPeriodTypeDesc,
  _ProdAllocObjCharcValCombn.ProductAllocationObjectUUID AS ProductAllocationObjectUUID,
  _ProdAllocObjCharcValCombn.ProdAllocCharc01 AS ProdAllocCharc01,
  _ProdAllocObjCharcValCombn.ProdAllocCharc02 AS ProdAllocCharc02,
  _ProdAllocObjCharcValCombn.ProdAllocCharc03 AS ProdAllocCharc03,
  _ProdAllocObjCharcValCombn.ProdAllocCharc04 AS ProdAllocCharc04,
  _ProdAllocObjCharcValCombn.ProdAllocCharc05 AS ProdAllocCharc05,
  _ProdAllocObjCharcValCombn.ProdAllocCharc06 AS ProdAllocCharc06,
  _ProdAllocObjCharcValCombn.ProdAllocCharc07 AS ProdAllocCharc07,
  _ProdAllocObjCharcValCombn.ProdAllocCharc08 AS ProdAllocCharc08,
  _ProdAllocObjCharcValCombn.ProdAllocCharc09 AS ProdAllocCharc09,
  _ProdAllocObjCharcValCombn.ProdAllocCharc10 AS ProdAllocCharc10,
  ProdAllocChkDataSnapshotType,
  ProdAllocChkRstrcnStatus,
  ProdAllocCheckQuantity,
  ProdAllocCheckUTCDateTime,
  ProdAllocCheckTimeZone,
  ProdAllocGoodsIssueUTCDateTime,
  ProdAllocGoodsIssueTimeZone,
  ProdAllocMatlAvailyUTCDateTime,
  ProdAllocMatlAvailyTimeZone,
  ProdAllocLeadTmeStartUTCDteTme,
  ProdAllocReqdDelivUTCDateTime,
  ProdAllocReqdDelivTimeZone,
  ValidityStartUTCDateTime,
  ValidityEndUTCDateTime,
  ProdAllocRequestedQuantityUnit,
  NumberOfBackwardCnsmpnPeriods,
  NumberOfForwardCnsmpnPeriods,
  HorizontalConsumptionDirection,
  PastPeriodIsAllowed,
  ProdAllocLeadTimeDuration,
  ProdAllocLeadTimeDurationUnit,
  ProdAllocationConstraintStatus,
  ProductAllocationRate,
  ProdAllocCheckDateTimeType,
  OnlyOverlappingQtyIsConsumed
FROM R_RevProdAllocChkCstrtRsltTP
;

Learn More