P_SalesOrdJournalEntryItem

DDL: P_SALESORDJOURNALENTRYITEM SQL: PEBRRSDDOCJOUR Type: view CONSUMPTION

Journal Entry for Sales Order

P_SalesOrdJournalEntryItem is a Consumption CDS View that provides data about "Journal Entry for Sales Order" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 9 fields with key fields SalesDocument, SalesDocumentItem, CompanyCode, Ledger.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem I_JournalEntryItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PEBRRSDDOCJOUR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Journal Entry for Sales Order view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument
KEY SalesDocumentItem SalesDocumentItem
KEY CompanyCode CompanyCode
KEY Ledger Ledger
SalesOrderType SalesOrderType
FiscalYear FiscalYear
FiscalPeriod FiscalPeriod
FiscalYearVariant _CompanyCode FiscalYearVariant
Plant Plant 
@AbapCatalog.sqlViewName: 'PEBRRSDDOCJOUR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Journal Entry for Sales Order'

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED

@VDM.private: true

@VDM.viewType: #CONSUMPTION

define view P_SalesOrdJournalEntryItem
  as select from I_JournalEntryItem
{
  key       SalesDocument,
  key       SalesDocumentItem,
  key       CompanyCode,
  key       Ledger,

            SalesOrderType,
            FiscalYear,
            FiscalPeriod,
            _CompanyCode.FiscalYearVariant,

            //Exception for sales from stock

            case when ControllingObject = ''
                 then concat('VB', concat(SalesDocument, SalesDocumentItem))
                 else ControllingObject end                as ControllingObject,

            case when ControllingObject = ''
               then 'VB'
               else substring(ControllingObject, 1, 2) end as Prefix,
               
            Plant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_JOURNALENTRYITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More