C_OplAcctgDocItemNoTaxCode

DDL: C_OPLACCTGDOCITEMNOTAXCODE Type: view_entity CONSUMPTION
20 Fields

Postings without Tax Codes

C_OplAcctgDocItemNoTaxCode is a Consumption CDS View that provides data about "Postings without Tax Codes" in SAP S/4HANA.

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Postings without Tax Codes view
VDM.viewType #CONSUMPTION view
OData.publish true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY JournalEntry AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
JournalEntryType AccountingDocumentType Journal Entry Type
DocumentDate DocumentDate Journal Entry Date
FiscalPeriod FiscalPeriod Tax period
Supplier Supplier Supplier
TaxAmount TaxAmount Tax Amt in Rptg Crcy
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
PostingDate PostingDate Posting Date for GR
_CompanyCode _CompanyCode
_JournalEntry _JournalEntry
_FiscalYear _FiscalYear
_AccountingDocumentType _AccountingDocumentType
_FiscalPeriod _FiscalPeriod
_Supplier _Supplier
_TransactionCurrency _TransactionCurrency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_OplAcctgDocItemNoTaxCode.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_OplAcctgDocItemNoTaxCode AS
SELECT
  CompanyCode,
  AccountingDocument AS JournalEntry,
  FiscalYear,
  AccountingDocumentItem,
  AccountingDocumentType AS JournalEntryType,
  DocumentDate,
  FiscalPeriod,
  Supplier,
  TaxAmount,
  TransactionCurrency,
  CompanyCodeCurrency,
  TaxAmountInCoCodeCrcy,
  PostingDate
;

Learn More