I_ALLOCATIONSEGMENT
Allocation Segment
I_ALLOCATIONSEGMENT is a CDS View in S/4HANA. Allocation Segment. It contains 6 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AllocationSegmentTP | view | from | TRANSACTIONAL | Allocation Segment TP |
| P_AllocationStatus | view | inner | CONSUMPTION | Allocation Status |
| P_CycleSegmentHierSourceParam | view | from | CONSUMPTION | |
| P_UniAllocTagObjectAssignment | view | inner | COMPOSITE |
Fields (6)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AllocationCycleSegment | AllocationCycleSegment | 2 |
| KEY | AllocationSegmentIsLocked | AllocationSegmentIsLocked | 1 |
| KEY | AllocationType | AllocationType | 1 |
| AllocationCycle | AllocationCycle | 1 | |
| AllocationCycleStartDate | AllocationCycleStartDate | 1 | |
| SegmentName | SegmentName | 2 |
@AbapCatalog.sqlViewName: 'ALLOCSEGMENT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:#NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Allocation Segment'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@VDM.viewType: #BASIC
define view I_AllocationSegment
as select from t811s
association [1] to I_AllocationCycle as _Cycle on $projection.AllocationType = _Cycle.AllocationType
and $projection.AllocationCycle = _Cycle.AllocationCycle
and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate
// association [1..1] to P_AllocationCycleCalc as _CycleCalc on $projection.AllocationCycle = _CycleCalc.AllocationCycle
// and $projection.AllocationType = _CycleCalc.AllocationType
// and $projection.AllocationCycleStartDate = _CycleCalc.AllocationCycleStartDate
association [0..1] to I_AllocAssmtDistrLongText as _Text on $projection.AllocationType = _Text.AllocationType
and $projection.AllocationCycle = _Text.AllocationCycle
and $projection.AllocationCycleStartDate = _Text.AllocationCycleStartDate
and _Text.LanguageCode = $session.system_language
and $projection.AllocationCycleSegment = _Text.AllocationCycleSegment
{
key cast(tab as fco_allocation_type) as AllocationType,
key cycle as AllocationCycle,
key cast(sdate as fco_alloc_valid_from ) as AllocationCycleStartDate,
key cast(seqnr as fco_alloc_segment_number ) as AllocationCycleSegment,
cast(name as fco_segment_name ) as SegmentName,
seqpos as AllocationSegmentPosition,
cast(srule as fco_alloc_sender_rule) as AllocationSenderRule,
cast(rrule as fco_alloc_receiver_rule) as AllocationReceiverRule,
active 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) 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,
// scip as OriginPAType, //missing GFN
rcdata as AllocationFieldGroup,
asacc 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) as ManipulationRuleForCyclicMaint,
cast( absch as fco_allocation_structure ) as AllocationStructure,
ersch as AllocationTransferStructure,
sweight_fact as AllocSndrFctrPercent ,
rweight_fact as AllocRcvrFctrPercent,
_Cycle,
_Text
// _CycleCalc
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T811S"
],
"ASSOCIATED":
[
"I_ALLOCASSMTDISTRLONGTEXT",
"I_ALLOCATIONCYCLE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/