P_MATRIX_CP_GROUPDERIVED_2
P_MATRIX_CP_GROUPDERIVED_2 is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_Matrix_CP_GroupFilled_2 | view | union_all | COMPOSITE |
@AbapCatalog: {
sqlViewName: 'PMCPGRPD2',
compiler.compareFilter: true
}
@VDM: {
viewType: #COMPOSITE,
private:true
}
@AccessControl: {
authorizationCheck: #NOT_REQUIRED,
personalData.blocking: #NOT_REQUIRED
}
@ClientHandling: {
algorithm:#SESSION_VARIABLE
}
@ObjectModel: {
usageType: {
serviceQuality: #X,
dataClass: #MIXED,
sizeCategory: #XL
}
}
@Metadata: {
ignorePropagatedAnnotations: true
}
define view P_Matrix_CP_GroupDerived_2
with parameters
P_FromFiscalYearPeriod : fincs_fiscyearper,
P_ToFiscalYearPeriod : fincs_fiscyearper
as select from P_StandardizedDataWithParam(
P_FromFiscalYearPeriod : $parameters.P_FromFiscalYearPeriod,
P_ToFiscalYearPeriod : $parameters.P_ToFiscalYearPeriod ) as transaction_data
inner join I_CnsldtnVersion as version_assignment on transaction_data.rvers = version_assignment.ConsolidationVersion
inner join I_CnsldtnGroupStructure as group_structure on group_structure.ConsolidationDimension = transaction_data.rdimen
and group_structure.ConsolidationStructureVersion = version_assignment.ConsolidationStructureVersion
and group_structure.ConsolidationUnit = transaction_data.rbunit
and transaction_data.fiscyearper between group_structure.FromFiscalYearPeriod and group_structure.ToFiscalYearPeriod
{
$session.client as mandt,
// Key Fields
$session.client as rclnt,
rldnr,
rdimen,
ryear,
docnr,
docln,
// Common Fields
rrcty,
rvers,
rtcur,
rhcur,
rkcur,
runit,
drcrk,
poper,
fiscyearper,
cast('PER' as fincs_period_mode) as period_mode,
transaction_data.poper as poper_posting,
docct,
rcomp,
rbunit,
ritclg,
ritem,
rbuptr,
group_structure.ConsolidationGroup as rcongr,
robukrs,
sityp,
subit,
plevl,
rpflg,
rtflg,
docty,
yracq,
pracq,
coicu,
uppcu,
tsl,
hsl,
ksl,
msl,
sgtxt,
autom,
activ,
bvorg,
budat,
wsdat,
refdocnr,
refryear,
refdocln,
refdocct,
refactiv,
timestamp,
cpudt,
cputm,
usnam,
rvsdocnr,
orndocnr,
coiac,
coinr,
revyear,
awtyp,
aworg,
logsys,
// Additional Fields
ktopl,
racct,
xblnr,
zuonr,
// Additional Fields - Universal Journal Entry: G/L additional account assignments
rcntr,
prctr,
rfarea,
rbusa,
kokrs,
segment,
scntr,
pprctr,
sfarea,
sbusa,
rassc,
psegment,
aufnr,
kunnr,
lifnr,
matnr,
matkl_mm,
werks,
rmvct,
ps_psp_pnr,
ps_posid,
ps_pspid,
// Additional Fields - SFIN: Universal Journal Entry - Fixed CO-PA fields
fkart,
vkorg,
vtweg,
spart,
matnr_copa,
matkl,
kdgrp,
land1,
brsch,
bzirk,
kunre,
kunwe,
konzs,
// Additional Fields - Ad Hoc Items
adhocitem,
adhocset,
adhocsetitem,
rcode,
orig_type,
orig_ref,
bunnr
}
union all select from P_CnsldtnGroupJrnlEntryItem(
P_FromFiscalYearPeriod : $parameters.P_FromFiscalYearPeriod,
P_ToFiscalYearPeriod : $parameters.P_ToFiscalYearPeriod ) as transaction_data
inner join I_CnsldtnVersion as version_assignment on transaction_data.ConsolidationVersion = version_assignment.ConsolidationVersion
inner join I_CnsldtnGroupStructure as unit_structure on unit_structure.ConsolidationDimension = transaction_data.ConsolidationDimension
and unit_structure.ConsolidationStructureVersion = version_assignment.ConsolidationStructureVersion
and unit_structure.ConsolidationUnit = transaction_data.ConsolidationUnit
and transaction_data.FiscalYearPeriod between unit_structure.FromFiscalYearPeriod and unit_structure.ToFiscalYearPeriod
inner join I_CnsldtnGroupStructure as punit_structure on punit_structure.ConsolidationDimension = transaction_data.ConsolidationDimension
and punit_structure.ConsolidationStructureVersion = version_assignment.ConsolidationStructureVersion
and punit_structure.ConsolidationUnit = transaction_data.PartnerConsolidationUnit
and punit_structure.ConsolidationGroup = unit_structure.ConsolidationGroup
and transaction_data.FiscalYearPeriod between punit_structure.FromFiscalYearPeriod and punit_structure.ToFiscalYearPeriod
{
$session.client as mandt,
// Key Fields
$session.client as rclnt,
transaction_data.ConsolidationLedger as rldnr,
transaction_data.ConsolidationDimension as rdimen,
FiscalYear as ryear,
CnsldtnGroupJrnlEntry as docnr,
CnsldtnGroupJrnlEntryItem as docln,
// Common Fields
GLRecordType as rrcty,
transaction_data.ConsolidationVersion as rvers,
TransactionCurrency as rtcur,
LocalCurrency as rhcur,
transaction_data.GroupCurrency as rkcur,
BaseUnit as runit,
cast('' as shkzg preserving type) as drcrk,
FiscalPeriod as poper,
FiscalYearPeriod as fiscyearper,
cast('PER' as fincs_period_mode) as period_mode,
transaction_data.FiscalPeriod as poper_posting,
DocumentCategory as docct,
Company as rcomp,
transaction_data.ConsolidationUnit as rbunit,
ConsolidationChartOfAccounts as ritclg,
FinancialStatementItem as ritem,
PartnerConsolidationUnit as rbuptr,
unit_structure.ConsolidationGroup as rcongr,
CompanyCode as robukrs,
SubItemCategory as sityp,
SubItem as subit,
PostingLevel as plevl,
ConsolidationApportionment as rpflg,
CurrencyConversionsDiffType as rtflg,
ConsolidationDocumentType as docty,
ConsolidationAcquisitionYear as yracq,
ConsolidationAcquisitionPeriod as pracq,
InvesteeConsolidationUnit as coicu,
InvestorConsolidationUnit as uppcu,
AmountInTransactionCurrency as tsl,
AmountInLocalCurrency as hsl,
AmountInGroupCurrency as ksl,
CnsldtnQuantityInBaseUnit as msl,
DocumentItemText as sgtxt,
ConsolidationPostgItemAutoFlag as autom,
BusinessTransactionType as activ,
'' as bvorg, // missing in I_MatrixCnsldtnFoundation
PostingDate as budat,
CurrencyTranslationDate as wsdat,
RefConsolidationDocumentNumber as refdocnr,
ReferenceFiscalYear as refryear,
RefConsolidationPostingItem as refdocln,
RefConsolidationDocumentType as refdocct,
RefBusinessTransactionType as refactiv,
CreationDateTime as timestamp,
CreationDate as cpudt,
CreationTime as cputm,
UserID as usnam,
ReverseDocument as rvsdocnr,
ReversedDocument as orndocnr,
InvestmentActivityType as coiac,
InvestmentActivity as coinr,
ConsolidationDocReversalYear as revyear,
ReferenceDocumentType as awtyp,
ReferenceDocumentContext as aworg,
LogicalSystem as logsys,
// Additional Fields
ChartOfAccounts as ktopl,
GLAccount as racct,
'' as xblnr, // missing in I_MatrixCnsldtnFoundation
AssignmentReference as zuonr,
// Additional Fields - Universal Journal Entry: G/L additional account assignments
CostCenter as rcntr,
ProfitCenter as prctr,
FunctionalArea as rfarea,
BusinessArea as rbusa,
ControllingArea as kokrs,
Segment as segment,
PartnerCostCenter as scntr,
PartnerProfitCenter as pprctr,
PartnerFunctionalArea as sfarea,
PartnerBusinessArea as sbusa,
PartnerCompany as rassc,
PartnerSegment as psegment,
OrderID as aufnr,
Customer as kunnr,
Supplier as lifnr,
Material as matnr,
MaterialGroup as matkl_mm,
Plant as werks,
FinancialTransactionType as rmvct,
WBSElementInternalID as ps_psp_pnr,
WBSElementExternalID as ps_posid,
Project as ps_pspid,
// Additional Fields - SFIN: Universal Journal Entry - Fixed CO-PA fields
BillingDocumentType as fkart,
SalesOrganization as vkorg,
DistributionChannel as vtweg,
OrganizationDivision as spart,
SoldMaterial as matnr_copa,
SoldProductGroup as matkl,
CustomerGroup as kdgrp,
CustomerSupplierCountry as land1,
CustomerSupplierIndustry as brsch,
SalesDistrict as bzirk,
BillToParty as kunre,
ShipToParty as kunwe,
CustomerSupplierCorporateGroup as konzs,
// Additional Fields - Ad Hoc Items
CnsldtnAdhocItem as adhocitem,
CnsldtnAdhocSet as adhocset,
CnsldtnAdhocSetItem as adhocsetitem,
MatchingReasonCode as rcode,
OriginType as orig_type,
OriginReference as orig_ref,
CnsldtnGroupJrnlEntryBundle as bunnr
}
where
PostingLevel = '20'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNGROUPSTRUCTURE",
"I_CNSLDTNVERSION",
"P_CNSLDTNGROUPJRNLENTRYITEM",
"P_STANDARDIZEDDATAWITHPARAM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/