I_UNIVERSALALLOCATIONSEGMENT
Universal Allocation Segment
I_UNIVERSALALLOCATIONSEGMENT is a CDS View in S/4HANA. Universal Allocation Segment. It contains 1 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_UnivAllocationSegmentVersion | view_entity | union_all | CONSUMPTION | Allocation Cycle Segment Version |
| P_UnivAllocCycleLockCounter | view_entity | inner | COMPOSITE | Cycle Lock Counter |
| R_UniversalAllocationSegmentTP | view_entity | from | TRANSACTIONAL | Universal Allocation Segment Draft |
Fields (1)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AllocationSegmentIsLocked | AllocationSegmentIsLocked | 1 |
@EndUserText.label: 'Universal Allocation Segment'
@VDM: {
lifecycle.contract.type: #SAP_INTERNAL_API,
viewType: #BASIC }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #A,
sizeCategory: #L }
define view entity I_UniversalAllocationSegment
as select from t811s
association [1..1] to I_AllocationReceiverRule as _ReceiverRule on $projection.AllocationReceiverRule = _ReceiverRule.AllocationReceiverRule
association [1..1] to I_AllocationSenderRule as _SenderRule on $projection.AllocationSenderRule = _SenderRule.AllocationSenderRule
association [1..1] to I_UnivAllocationSegmentNote as _Note on $projection.AllocationCycle = _Note.AllocationCycle
and $projection.AllocationType = _Note.AllocationType
and $projection.AllocationCycleStartDate = _Note.AllocationCycleStartDate
and $projection.AllocationCycleSegment = _Note.AllocationCycleSegment
association [1..1] to I_UnivAllocationSegmentStatus as _SegmentStatus on $projection.AllocationSegmentIsLocked = _SegmentStatus.AllocationStatus
association [0..*] to I_AllocationFieldGroupText as _AllocationFieldGroupText on $projection.AllocationFieldGroup = _AllocationFieldGroupText.AllocationFieldGroup
and $projection.AllocationType = _AllocationFieldGroupText.AllocationType
{
key tab as AllocationType,
key cycle as AllocationCycle,
key sdate as AllocationCycleStartDate,
key cast(seqnr as fco_alloc_segment_number preserving type ) as AllocationCycleSegment,
cast(name as fco_segment_name preserving type ) as SegmentName,
seqpos as AllocationSegmentPosition,
cast(srule as fco_alloc_sender_rule preserving type ) as AllocationSenderRule,
cast(rrule as fco_alloc_receiver_rule preserving type ) as AllocationReceiverRule,
cast( active as fcoua_segment_status preserving type ) as AllocationSegmentIsLocked,
negtest as AllocScNgtvTracingFctr,
scset as SenderTracingFieldGroup,
sset as SenderFieldGroup,
rset as ReceiverFieldGroup,
rcset as ReceiverTracingFieldGroup,
cast(spercent as fco_alloc_sender_share_percent preserving type ) as AllocSegmentShareInPercent,
sffeld1 as AllocationSenderFixedField1,
sffeld2 as AllocationSenderFixedField2,
sffeld3 as AllocationSenderFixedField3,
sffeld4 as AllocationSenderFixedField4,
sffeld5 as AllocationSenderFixedField5,
sffeld6 as AllocationSenderFixedField6,
sffeld7 as AllocationSenderFixedField7,
sffeld8 as AllocationSenderFixedField8,
sffeld9 as AllocationSenderFixedField9,
sffeld10 as AllocationSenderFixedField10,
facurr as AllocationCurrency,
rffeld1 as AllocationReceiverFixedField1,
rffeld2 as AllocationReceiverFixedField2,
rffeld3 as AllocationReceiverFixedField3,
rffeld4 as AllocationReceiverFixedField4,
rffeld5 as AllocationReceiverFixedField5,
rffeld6 as AllocationReceiverFixedField6,
rffeld7 as AllocationReceiverFixedField7,
rffeld8 as AllocationReceiverFixedField8,
rffeld9 as AllocationReceiverFixedField9,
rffeld10 as AllocationReceiverFixedField10,
cast( rcdata as fco_alloc_var_portion_type preserving type) as AllocationFieldGroup,
cast( asacc as fco_alloc_asacc preserving type ) as AssessmentCostElement,
pafldf as AllocationFixedCostCenterCost,
pafldg as AllocationVariableCostCtrCost,
rrfeld1 as AllocationAccountAssignment,
sortfield as AllocationSegmentSortField,
sender_not as AllocIsSndrExclAsRcvr,
cast(mrule as fco_alloc_manipulation_rule preserving type ) as ManipulationRuleForCyclicMaint,
cast(absch as fco_allocation_structure preserving type ) as AllocationStructure,
ersch as AllocationTransferStructure,
sweight_fact as AllocSndrFctrPercent,
rweight_fact as AllocRcvrFctrPercent,
_ReceiverRule,
_SenderRule,
_Note,
_SegmentStatus,
_AllocationFieldGroupText
}
where
tab = 'ACDOC_CC'
or tab = 'ACDOC_PC'
or tab = 'ACDOC_PA'