R_MNGJRNLENTRPRKDCHGDOCTBLKEY
Journal Entry - Parked Changed Header Table Key
R_MNGJRNLENTRPRKDCHGDOCTBLKEY is a CDS View in S/4HANA. Journal Entry - Parked Changed Header Table Key. It contains 11 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_MngJrnlEntrChangeDocument | view_entity | inner | TRANSACTIONAL | Journal Entry - Changed Document |
| R_MngJrnlEntrPrkdChgHeader | view_entity | inner | TRANSACTIONAL | Journal Entry - Parked Changed Header |
Fields (11)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocument | AccountingDocument | 2 |
| KEY | AccountingDocumentItem | JournalEntryItem | 1 |
| KEY | CompanyCode | CompanyCode | 1 |
| KEY | FiscalYear | FiscalYear | 2 |
| KEY | Ledger | Ledger | 2 |
| AccountingDocumentCategory | AccountingDocumentCategory | 1 | |
| AccountingDocumentCreationDate | CreationDate | 2 | |
| AccountingDocumentType | AccountingDocumentType | 2 | |
| CreationTime | CreationTime | 2 | |
| DocumentDate | DocumentDate | 2 | |
| PostingDate | PostingDate | 2 |
@AbapCatalog: {
sqlViewName: 'RMNGPRKDCHGKEY',
compiler.compareFilter: true,
preserveKey:true
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Journal Entry - Parked Changed Header Table Key'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #XL,
dataClass: #MIXED
}
@VDM: {
viewType: #TRANSACTIONAL,
lifecycle.contract.type:#SAP_INTERNAL_API
}
define view R_MngJrnlEntrPrkdChgDocTblKey
as select from I_ParkedAccountingDocument as Header
inner join I_ParkedOplAcctgDocItem as Item on Header.CompanyCode = Item.SourceCompanyCode
and Header.AccountingDocument = Item.SourceAccountingDocument
and Header.FiscalYear = Item.SourceFiscalYear
{
key cast('VBKPF' as farp_database_table_name ) as DatabaseTable,
key cast( case length( Header.CompanyCode )
when 4 then ( concat(Header.mandt, concat(Header.CompanyCode, concat(Header.CompanyCode, concat(Header.AccountingDocument, Header.FiscalYear ) ) ) ) )
when 3 then ( concat(Header.mandt, concat_with_space(Header.CompanyCode, concat_with_space(Header.CompanyCode, concat(Header.AccountingDocument, Header.FiscalYear ), 1 ), 1 ) ) )
when 2 then ( concat(Header.mandt, concat_with_space(Header.CompanyCode, concat_with_space(Header.CompanyCode, concat(Header.AccountingDocument, Header.FiscalYear ), 2 ), 2 ) ) )
when 1 then ( concat(Header.mandt, concat_with_space(Header.CompanyCode, concat_with_space(Header.CompanyCode, concat(Header.AccountingDocument, Header.FiscalYear ), 3 ), 3 ) ) )
else ( concat(Header.mandt, concat_with_space(Header.CompanyCode, concat_with_space(Header.CompanyCode, concat(Header.AccountingDocument, Header.FiscalYear ), 4 ), 4 ) ) )
end as cdtabkey ) as ChangeDocumentTableKey,
key Item.SourceAccountingDocumentItem as AccountingDocumentItem,
Header.CompanyCode,
Header.AccountingDocument,
Header.FiscalYear,
cast('' as fins_ledger ) as Ledger,
Header.DocumentDate,
Header.PostingDate,
Header.CreationTime,
Header.AccountingDocumentCreationDate,
Header.AccountingDocumentType,
Header.AccountingDocumentCategory
}
union all select from I_ParkedAccountingDocument as Header
inner join I_OneTimeParkingDocumentItem as OneTimeItem on Header.CompanyCode = OneTimeItem.SourceCompanyCode
and Header.AccountingDocument = OneTimeItem.AccountingDocument
and Header.FiscalYear = OneTimeItem.FiscalYear
{
key cast('VBSEC' as farp_database_table_name ) as DatabaseTable,
key cast(case length( Header.CompanyCode )
when 4 then concat(OneTimeItem.mandt, concat(Header.CompanyCode, concat( Header.CompanyCode, concat(Header.AccountingDocument, concat(Header.FiscalYear, OneTimeItem.ParkedAccountingDocumentItem ) ) ) ) )
when 3 then concat(OneTimeItem.mandt, concat_with_space(Header.CompanyCode, concat_with_space( Header.CompanyCode, concat(Header.AccountingDocument, concat(Header.FiscalYear, OneTimeItem.ParkedAccountingDocumentItem ) ), 1 ), 1 ) )
when 2 then concat(OneTimeItem.mandt, concat_with_space(Header.CompanyCode, concat_with_space( Header.CompanyCode, concat(Header.AccountingDocument, concat(Header.FiscalYear, OneTimeItem.ParkedAccountingDocumentItem ) ), 2 ), 2 ) )
when 1 then concat(OneTimeItem.mandt, concat_with_space(Header.CompanyCode, concat_with_space( Header.CompanyCode, concat(Header.AccountingDocument, concat(Header.FiscalYear, OneTimeItem.ParkedAccountingDocumentItem ) ), 3 ), 3 ) )
else concat(OneTimeItem.mandt, concat_with_space(Header.CompanyCode, concat_with_space( Header.CompanyCode, concat(Header.AccountingDocument, concat(Header.FiscalYear, OneTimeItem.ParkedAccountingDocumentItem ) ), 4 ), 4 ) )
end as cdtabkey ) as ChangeDocumentTableKey,
key OneTimeItem.ParkedAccountingDocumentItem as AccountingDocumentItem,
Header.CompanyCode,
Header.AccountingDocument,
Header.FiscalYear,
cast('' as fins_ledger ) as Ledger,
Header.DocumentDate,
Header.PostingDate,
Header.CreationTime,
Header.AccountingDocumentCreationDate,
Header.AccountingDocumentType,
Header.AccountingDocumentCategory
}
union all select from I_ParkedAccountingDocument as Header
inner join I_ParkedDocumentTaxItem as TaxItem on Header.CompanyCode = TaxItem.SourceCompanyCode
and Header.AccountingDocument = TaxItem.AccountingDocument
and Header.FiscalYear = TaxItem.FiscalYear
{
key cast('VBSET' as farp_database_table_name ) as DatabaseTable,
key cast(case length( Header.CompanyCode )
when 4 then concat(TaxItem.mandt, concat(TaxItem.SourceCompanyCode, concat( Header.CompanyCode, concat(Header.AccountingDocument, concat(Header.FiscalYear, TaxItem.ParkedAccountingDocumentItem ) ) ) ) )
when 3 then concat(TaxItem.mandt, concat_with_space(TaxItem.SourceCompanyCode, concat_with_space( Header.CompanyCode, concat(Header.AccountingDocument, concat(Header.FiscalYear, TaxItem.ParkedAccountingDocumentItem ) ), 1 ), 1 ) )
when 2 then concat(TaxItem.mandt, concat_with_space(TaxItem.SourceCompanyCode, concat_with_space( Header.CompanyCode, concat(Header.AccountingDocument, concat(Header.FiscalYear, TaxItem.ParkedAccountingDocumentItem ) ), 2 ), 2 ) )
when 1 then concat(TaxItem.mandt, concat_with_space(TaxItem.SourceCompanyCode, concat_with_space( Header.CompanyCode, concat(Header.AccountingDocument, concat(Header.FiscalYear, TaxItem.ParkedAccountingDocumentItem ) ), 3 ), 3 ) )
else concat(TaxItem.mandt, concat_with_space(TaxItem.SourceCompanyCode, concat_with_space( Header.CompanyCode, concat(Header.AccountingDocument, concat(Header.FiscalYear, TaxItem.ParkedAccountingDocumentItem ) ), 4 ), 4 ) )
end as cdtabkey ) as ChangeDocumentTableKey,
key TaxItem.ParkedAccountingDocumentItem as AccountingDocumentItem,
Header.CompanyCode as CompanyCode,
Header.AccountingDocument as AccountingDocument,
Header.FiscalYear as FiscalYear,
cast('' as fins_ledger ) as Ledger,
Header.DocumentDate,
Header.PostingDate,
Header.CreationTime,
Header.AccountingDocumentCreationDate,
Header.AccountingDocumentType,
Header.AccountingDocumentCategory
}
// Parked General Ledger Item
union all select from I_ParkedOplAcctgDocGLItem as GLAccountingDocSeg
{
key cast('VBSEG' as farp_database_table_name ) as DatabaseTable,
key cast(case length( SourceCompanyCode )
when 4 then ( concat(mandt, concat(SourceCompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ) ) ) )
when 3 then ( concat(mandt, concat_with_space(SourceCompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ), 1 ) ) )
when 2 then ( concat(mandt, concat_with_space(SourceCompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ), 2 ) ) )
when 1 then ( concat(mandt, concat_with_space(SourceCompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ), 3 ) ) )
else ( concat(mandt, concat_with_space(SourceCompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ), 4 ) ) )
end as cdtabkey ) as ChangeDocumentTableKey,
key SourceAccountingDocumentItem as AccountingDocumentItem,
SourceCompanyCode as CompanyCode,
SourceAccountingDocument as AccountingDocument,
SourceFiscalYear as FiscalYear,
cast('' as fins_ledger ) as Ledger,
_SourceParkedOplAcctgDocument.DocumentDate,
_SourceParkedOplAcctgDocument.PostingDate,
_SourceParkedOplAcctgDocument.CreationTime,
_SourceParkedOplAcctgDocument.AccountingDocumentCreationDate,
_SourceParkedOplAcctgDocument.AccountingDocumentType,
_SourceParkedOplAcctgDocument.AccountingDocumentCategory
}
// Parked Receivables Item
union all select from I_ParkedOplAcctgDocRblsItem as CustomerAccountingDocSeg
{
key cast('VBSEG' as farp_database_table_name ) as DatabaseTable,
key cast(case length( SourceCompanyCode )
when 4 then ( concat(mandt, concat(CompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ) ) ) )
when 3 then ( concat(mandt, concat_with_space(CompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ), 1 ) ) )
when 2 then ( concat(mandt, concat_with_space(CompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ), 2 ) ) )
when 1 then ( concat(mandt, concat_with_space(CompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ), 3 ) ) )
else ( concat(mandt, concat_with_space(CompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ), 4 ) ) )
end as cdtabkey ) as ChangeDocumentTableKey,
key SourceAccountingDocumentItem as AccountingDocumentItem,
SourceCompanyCode as CompanyCode,
SourceAccountingDocument as AccountingDocument,
SourceFiscalYear as FiscalYear,
cast('' as fins_ledger ) as Ledger,
_SourceParkedOplAcctgDocument.DocumentDate,
_SourceParkedOplAcctgDocument.PostingDate,
_SourceParkedOplAcctgDocument.CreationTime,
_SourceParkedOplAcctgDocument.AccountingDocumentCreationDate,
_SourceParkedOplAcctgDocument.AccountingDocumentType,
_SourceParkedOplAcctgDocument.AccountingDocumentCategory
}
// Parked Payables Item
union all select from I_ParkedOplAcctgDocPyblsItem as SupplierAccountingDocSeg
{
key cast('VBSEG' as farp_database_table_name ) as DatabaseTable,
key cast(case length( SourceCompanyCode )
when 4 then ( concat(mandt, concat(CompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ) ) ) )
when 3 then ( concat(mandt, concat_with_space(CompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ), 1 ) ) )
when 2 then ( concat(mandt, concat_with_space(CompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ), 2 ) ) )
when 1 then ( concat(mandt, concat_with_space(CompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ), 3 ) ) )
else ( concat(mandt, concat_with_space(CompanyCode, concat(SourceAccountingDocument, concat(SourceFiscalYear, SourceAccountingDocumentItem ) ), 4 ) ) )
end as cdtabkey ) as ChangeDocumentTableKey,
key SourceAccountingDocumentItem as AccountingDocumentItem,
SourceCompanyCode as CompanyCode,
SourceAccountingDocument as AccountingDocument,
SourceFiscalYear as FiscalYear,
cast('' as fins_ledger ) as Ledger,
_SourceParkedOplAcctgDocument.DocumentDate,
_SourceParkedOplAcctgDocument.PostingDate,
_SourceParkedOplAcctgDocument.CreationTime,
_SourceParkedOplAcctgDocument.AccountingDocumentCreationDate,
_SourceParkedOplAcctgDocument.AccountingDocumentType,
_SourceParkedOplAcctgDocument.AccountingDocumentCategory
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ONETIMEPARKINGDOCUMENTITEM",
"I_PARKEDACCOUNTINGDOCUMENT",
"I_PARKEDDOCUMENTTAXITEM",
"I_PARKEDOPLACCTGDOCGLITEM",
"I_PARKEDOPLACCTGDOCITEM",
"I_PARKEDOPLACCTGDOCPYBLSITEM",
"I_PARKEDOPLACCTGDOCRBLSITEM",
"I_PARKEDOPLACCTGDOCUMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/