P_SG_OperationalAcctgDocItem

DDL: P_SG_OPERATIONALACCTGDOCITEM Type: view COMPOSITE

P_SG_OperationalAcctgDocItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 24 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSGOPACCTGDOCIT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY AccountingDocumentItem AccountingDocumentItem
TaxCode TaxCode
DebitCreditCode DebitCreditCode
TransactionCode _JournalEntry TransactionCode
ReferenceDocumentType _JournalEntry ReferenceDocumentType
AccountingDocumentHeaderText _JournalEntry AccountingDocumentHeaderText
BankName
TaxID1 _HouseBank TaxID1
PlanningLevel PlanningLevel
TransactionTypeDetermination TransactionTypeDetermination
TaxType TaxType
ProfitLossAccountType ProfitLossAccountType
FinancialAccountType FinancialAccountType
CompanyCodeCurrencyDetnMethod CompanyCodeCurrencyDetnMethod
Product Product
DocumentItemText DocumentItemText
IsAutomaticallyCreated IsAutomaticallyCreated
CompanyCodeCurrency CompanyCodeCurrency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
TransactionCurrency TransactionCurrency
AmountInTransactionCurrency AmountInTransactionCurrency 
@AccessControl: {authorizationCheck: #NOT_REQUIRED}
@AbapCatalog: {sqlViewName: 'PSGOPACCTGDOCIT', preserveKey: true, compiler.compareFilter: true}
@VDM: {private: true, viewType: #COMPOSITE}
@ClientHandling: {algorithm: #SESSION_VARIABLE}

define view P_SG_OperationalAcctgDocItem
  as select from I_OperationalAcctgDocItem
  
  {
  //I_OperationalAcctgDocItem

   key CompanyCode,
   key AccountingDocument,
   key FiscalYear,
   key AccountingDocumentItem,
   TaxCode,
   DebitCreditCode,
   _JournalEntry.TransactionCode,
   _JournalEntry.ReferenceDocumentType,
   _JournalEntry.AccountingDocumentHeaderText,
   _HouseBank._Bank.BankName,
   _HouseBank.TaxID1,
   PlanningLevel,
   TransactionTypeDetermination,
   TaxType,
   ProfitLossAccountType,
   FinancialAccountType,
   CompanyCodeCurrencyDetnMethod,
   Product,
   DocumentItemText,
   IsAutomaticallyCreated,
   CompanyCodeCurrency,
   AmountInCompanyCodeCurrency,
   TransactionCurrency,
   AmountInTransactionCurrency
   }

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANK",
"I_HOUSEBANK",
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More