P_STANDARDIZEDDATA
Consolidation: Standardized Data
P_STANDARDIZEDDATA is a CDS View in S/4HANA. Consolidation: Standardized Data. It contains 130 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_Matrix_PreparedSFDForCGDeriv | view | from | COMPOSITE | Matrix Consolidation: Prepared SFD for Group Derivation |
| P_Matrix_SFDWGroupDerived | view | from | COMPOSITE | Matrix Consolidation: SFD with Group Derived |
| P_Matrix_VecSFD | view | from | COMPOSITE | Matrix Consolidation: For Vec, SFD with Group Derived |
| P_StandardizedDataEnhC | view | from | COMPOSITE | Consolidation: Standardized Data |
| P_StandardizedDataEnhC | view | union_all | COMPOSITE | Consolidation: Standardized Data |
| P_StandardizedDataWithParam | view | from | COMPOSITE | Consolidation: Standardized Data |
| P_VECStandardizedData | view | from | COMPOSITE | Consolidation Validation: Standardized Data |
| P_VECStandardizedData_01 | view | from | COMPOSITE | Get Standardized Data per Year |
Fields (130)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| activ | activ | 1 | |
| adhocitem | adhocitem | 1 | |
| adhocset | adhocset | 1 | |
| adhocsetitem | adhocsetitem | 1 | |
| aufnr | aufnr | 1 | |
| autom | autom | 1 | |
| aworg | aworg | 1 | |
| awtyp | awtyp | 1 | |
| bp_p_geber | bp_p_geber | 1 | |
| branch_id | branch_id | 1 | |
| brsch | brsch | 1 | |
| budat | budat | 1 | |
| bunnr | bunnr | 1 | |
| bvorg | bvorg | 1 | |
| bzirk | bzirk | 1 | |
| coiac | coiac | 1 | |
| coicu | coicu | 1 | |
| coinr | coinr | 1 | |
| cpudt | cpudt | 1 | |
| cputm | cputm | 1 | |
| datasource_id | datasource_id | 1 | |
| docct | docct | 1 | |
| docln | docln | 1 | |
| docnr | docnr | 1 | |
| docty | docty | 1 | |
| drcrk | drcrk | 1 | |
| fikrs | fikrs | 1 | |
| fiscyearper | fiscyearper | 1 | |
| fkart | fkart | 1 | |
| fs_product_group | fs_product_group | 1 | |
| ghgcategory | ghgcategory | 1 | |
| ghgdtaqltycharc | ghgdtaqltycharc | 1 | |
| ghgenergyclass | ghgenergyclass | 1 | |
| ghgenergymix | ghgenergymix | 1 | |
| ghgengysrcgtype | ghgengysrcgtype | 1 | |
| ghgscope | ghgscope | 1 | |
| ghgscp2calcmeth | ghgscp2calcmeth | 1 | |
| ghgscp2contrinstr | ghgscp2contrinstr | 1 | |
| gl_sirid | gl_sirid | 1 | |
| hsl | hsl | 1 | |
| hsl_csign | hsl_csign | 1 | |
| kdgrp | kdgrp | 1 | |
| kokrs | kokrs | 1 | |
| konzs | konzs | 1 | |
| ksl | ksl | 1 | |
| ksl_csign | ksl_csign | 1 | |
| ktopl | ktopl | 1 | |
| kunnr | kunnr | 1 | |
| kunre | kunre | 1 | |
| kunwe | kunwe | 1 | |
| land1 | land1 | 1 | |
| lifnr | lifnr | 1 | |
| logsys | logsys | 1 | |
| matkl | matkl | 1 | |
| matkl_mm | matkl_mm | 1 | |
| matnr | matnr | 1 | |
| matnr_copa | matnr_copa | 1 | |
| msl | msl | 1 | |
| msl_csign | msl_csign | 1 | |
| orig_ref | orig_ref | 1 | |
| orig_type | orig_type | 1 | |
| orndocnr | orndocnr | 1 | |
| plevl | plevl | 1 | |
| poper | poper,poper_posting | 2 | |
| pprctr | pprctr | 1 | |
| pracq | pracq | 1 | |
| prctr | prctr | 1 | |
| ps_posid | ps_posid | 1 | |
| ps_psp_pnr | ps_psp_pnr | 1 | |
| ps_pspid | ps_pspid | 1 | |
| psegment | psegment | 1 | |
| racct | racct | 1 | |
| rassc | rassc | 1 | |
| rbunit | rbunit | 1 | |
| rbuptr | rbuptr | 1 | |
| rbusa | rbusa | 1 | |
| rclnt | rclnt | 1 | |
| rcntr | rcntr | 1 | |
| rcode | rcode | 1 | |
| rcomp | rcomp | 1 | |
| rcongr | rcongr | 1 | |
| rdimen | rdimen | 1 | |
| re_account | re_account | 1 | |
| re_ktopl | re_ktopl | 1 | |
| refactiv | refactiv | 1 | |
| refdocct | refdocct | 1 | |
| refdocln | refdocln | 1 | |
| refdocnr | refdocnr | 1 | |
| refryear | refryear | 1 | |
| revyear | revyear | 1 | |
| rfarea | rfarea | 1 | |
| rfund | rfund | 1 | |
| rgrant_nbr | rgrant_nbr | 1 | |
| rhcur | rhcur | 1 | |
| ritclg | ritclg | 1 | |
| ritem | ritem | 1 | |
| rkcur | rkcur | 1 | |
| rldnr | rldnr | 1 | |
| rmvct | rmvct | 1 | |
| robukrs | robukrs | 1 | |
| rpflg | rpflg | 1 | |
| rrcty | rrcty | 1 | |
| rtcur | rtcur | 1 | |
| rtflg | rtflg | 1 | |
| runit | runit | 1 | |
| rvers | rvers | 2 | |
| rvsdocnr | rvsdocnr | 1 | |
| ryear | ryear | 1 | |
| sbusa | sbusa | 1 | |
| scntr | scntr | 1 | |
| segment | segment | 1 | |
| sfarea | sfarea | 1 | |
| sgtxt | sgtxt | 1 | |
| sityp | sityp | 1 | |
| spart | spart | 1 | |
| subit | subit | 1 | |
| susmodeoftransport | susmodeoftransport | 1 | |
| timestamp | timestamp | 1 | |
| tsl | tsl | 1 | |
| tsl_csign | tsl_csign | 1 | |
| updhp | updhp | 1 | |
| uppcu | uppcu | 1 | |
| usnam | usnam | 1 | |
| vkorg | vkorg | 1 | |
| vtweg | vtweg | 1 | |
| werks | werks | 1 | |
| wsdat | wsdat | 1 | |
| xblnr | xblnr | 1 | |
| yracq | yracq | 1 | |
| zuonr | zuonr | 1 |
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PSTANDARDIZEDDAT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm:#SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
define view P_StandardizedData
// We need two union parts because GLRecordType(rrcty) is hard coded in the first part
as select from P_CnsldtnGroupJrnlEntryItemHC
{
rclnt,
cast('' as gu_recid) as gl_sirid,
ConsolidationLedger as rldnr,
cast('0' as rrcty) as rrcty,
ConsolidationVersion as rvers,
FiscalYear as ryear,
TransactionCurrency as rtcur,
LocalCurrency as rhcur,
GroupCurrency as rkcur,
BaseUnit as runit,
cast('' as shkzg) as drcrk,
FiscalPeriod as poper,
FiscalYearPeriod as fiscyearper, //bbrCC1908
DocumentCategory as docct,
// in the aggregated data, the FI document number is not available
// cast(refdocnr as belnr_d) as docnr, //bbrCC1905
// cast(refdocln as docln6) as docln, //bbrCC1905
CnsldtnGroupJrnlEntry as docnr, //bbrCC1905
CnsldtnGroupJrnlEntryItem as docln, //bbrCC1905
Company as rcomp,
ConsolidationDimension as rdimen,
ConsolidationUnit as rbunit,
ConsolidationChartOfAccounts as ritclg,
FinancialStatementItem as ritem,
PartnerConsolidationUnit as rbuptr,
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,
cast('000' as updhp) as updhp,
AmountInTransactionCurrency as tsl,
AmountInLocalCurrency as hsl,
AmountInGroupCurrency as ksl,
CnsldtnQuantityInBaseUnit as msl,
CnsldtnCstmSignAmtInTransCrcy as tsl_csign,
CnsldtnCstmSignAmtInLoclCrcy as hsl_csign,
CnsldtnCstmSignAmtInGrpCrcy as ksl_csign,
CnsldtnCstmSignLongQtyInBsUnit as msl_csign,
DocumentItemText as sgtxt,
ConsolidationPostgItemAutoFlag as autom,
BusinessTransactionType as activ,
bvorg,
PostingDate as budat,
CurrencyTranslationDate as wsdat,
RefConsolidationDocumentNumber as refdocnr,
ReferenceFiscalYear as refryear,
RefConsolidationPostingItem as refdocln,
RefConsolidationDocumentType as refdocct,
RefBusinessTransactionType as refactiv,
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,
// cast(0 as timestamp) as timestamp,
CreationDateTime as timestamp,
GLAccount as racct,
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,
FinancialTransactionType as rmvct,
Material as matnr,
Plant as werks,
Customer as kunnr,
Supplier as lifnr,
WBSElementExternalID as ps_posid,
Project as ps_pspid,
BillingDocumentType as fkart,
SalesOrganization as vkorg,
DistributionChannel as vtweg,
OrganizationDivision as spart,
SoldProduct 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,
AssignmentReference as zuonr,
OrderID as aufnr,
xblnr,
MaterialGroup as matkl_mm,
WBSElementInternalID as ps_psp_pnr,
ChartOfAccounts as ktopl,
// 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,
// industry-specific fields Financial services: Banking Fields
FinancialServicesProductGroup as fs_product_group,
FinancialServicesBranch as branch_id,
FinancialDataSource as datasource_id,
// industry-specific fields Financial services: Green House Fields
GHGScope as ghgscope,
GHGCategory as ghgcategory,
GHGScope2CalculationMethod as ghgscp2calcmeth,
GHGScope2ContractualInstrument as ghgscp2contrinstr,
GHGDataQualityCharacteristic as ghgdtaqltycharc,
GHGEnergyClassification as ghgenergyclass,
GHGEnergyMix as ghgenergymix,
GHGEnergySourcingType as ghgengysrcgtype,
SustainabilityModeOfTransport as susmodeoftransport,
// industry-specific fields Financial services: Public Sector Fields
FinancialManagementArea as fikrs,
Fund as rfund,
PartnerFund as sfund,
GrantID as rgrant_nbr,
CnsldtnCashLedgerChartOfAccts as re_ktopl,
CashLedgerAccount as re_account,
PartnerFund as bp_p_geber
}
where
GLRecordType = 'U'
union all select from P_CnsldtnGroupJrnlEntryItemHC
{
rclnt,
cast('' as gu_recid) as gl_sirid,
ConsolidationLedger as rldnr,
GLRecordType as rrcty,
ConsolidationVersion as rvers,
FiscalYear as ryear,
TransactionCurrency as rtcur,
LocalCurrency as rhcur,
GroupCurrency as rkcur,
BaseUnit as runit,
cast('' as shkzg) as drcrk,
FiscalPeriod as poper,
FiscalYearPeriod as fiscyearper, //bbrCC1908
DocumentCategory as docct,
CnsldtnGroupJrnlEntry as docnr,
CnsldtnGroupJrnlEntryItem as docln,
Company as rcomp,
ConsolidationDimension as rdimen,
ConsolidationUnit as rbunit,
ConsolidationChartOfAccounts as ritclg,
FinancialStatementItem as ritem,
PartnerConsolidationUnit as rbuptr,
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,
cast('000' as updhp) as updhp,
AmountInTransactionCurrency as tsl,
AmountInLocalCurrency as hsl,
AmountInGroupCurrency as ksl,
CnsldtnQuantityInBaseUnit as msl,
CnsldtnCstmSignAmtInTransCrcy as tsl_csign,
CnsldtnCstmSignAmtInLoclCrcy as hsl_csign,
CnsldtnCstmSignAmtInGrpCrcy as ksl_csign,
CnsldtnCstmSignLongQtyInBsUnit as msl_csign,
DocumentItemText as sgtxt,
ConsolidationPostgItemAutoFlag as autom,
BusinessTransactionType as activ,
bvorg,
PostingDate as budat,
CurrencyTranslationDate as wsdat,
RefConsolidationDocumentNumber as refdocnr,
ReferenceFiscalYear as refryear,
RefConsolidationPostingItem as refdocln,
RefConsolidationDocumentType as refdocct,
RefBusinessTransactionType as refactiv,
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,
// cast(0 as timestamp) as timestamp,
CreationDateTime as timestamp,
GLAccount as racct,
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,
FinancialTransactionType as rmvct,
Material as matnr,
Plant as werks,
Customer as kunnr,
Supplier as lifnr,
WBSElementExternalID as ps_posid,
Project as ps_pspid,
BillingDocumentType as fkart,
SalesOrganization as vkorg,
DistributionChannel as vtweg,
OrganizationDivision as spart,
SoldProduct 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,
AssignmentReference as zuonr,
OrderID as aufnr,
xblnr,
MaterialGroup as matkl_mm,
WBSElementInternalID as ps_psp_pnr,
ChartOfAccounts as ktopl,
// 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,
// industry-specific fields Financial services: Banking Fields
FinancialServicesProductGroup as fs_product_group,
FinancialServicesBranch as branch_id,
FinancialDataSource as datasource_id,
// industry-specific fields Financial services: Green House Fields
GHGScope as ghgscope,
GHGCategory as ghgcategory,
GHGScope2CalculationMethod as ghgscp2calcmeth,
GHGScope2ContractualInstrument as ghgscp2contrinstr,
GHGDataQualityCharacteristic as ghgdtaqltycharc,
GHGEnergyClassification as ghgenergyclass,
GHGEnergyMix as ghgenergymix,
GHGEnergySourcingType as ghgengysrcgtype,
SustainabilityModeOfTransport as susmodeoftransport,
// industry-specific fields Financial services: Public Sector Fields
FinancialManagementArea as fikrs,
Fund as rfund,
PartnerFund as sfund,
GrantID as rgrant_nbr,
CnsldtnCashLedgerChartOfAccts as re_ktopl,
CashLedgerAccount as re_account,
PartnerFund as bp_p_geber
}
where
GLRecordType = '0'
and(
PostingLevel = '' // balance carry forward
or PostingLevel = '00'
or PostingLevel = '0C'
or PostingLevel = '0T'
or PostingLevel = '01'
or PostingLevel = '08'
or PostingLevel = '10'
)