P_FirstKDOperationItem

DDL: P_FIRSTKDOPERATIONITEM Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_PT
15 Fields 1 Data Sources

First K or D line Item

P_FirstKDOperationItem is a Composite CDS View that provides data about "First K or D line Item" in SAP S/4HANA. It reads from 1 data source (P_AcctgDocKDMinItemLog) and exposes 15 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. Part of development package GLO_FIN_IS_VAT_PT.

Data Sources (1)

SourceAliasJoin Type
P_AcctgDocKDMinItemLog P_AcctgDocKDMinItemLog from

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (4)

NameValueLevelField
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
EndUserText.label First K or D line Item view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode item CompanyCode Receiver Company Code
KEY AccountingDocument item AccountingDocument Journal Entry
KEY FiscalYear item FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem item AccountingDocumentItem Posting View Item
InvoiceReference item InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear item InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
Customer item Customer Sold-to Party
Supplier item Supplier Supplier
VATRegistration item VATRegistration VAT Registration No.
FinancialAccountType item FinancialAccountType Fin. Account Type
CustomerIsOneTimeAccount
SupplierIsOneTimeAccount
_Customer item _Customer
_Supplier item _Supplier
_OneTimeAccountBP item _OneTimeAccountBP

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 P_FirstKDOperationItem.
-- 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.
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW P_FirstKDOperationItem AS
SELECT
  item.CompanyCode AS CompanyCode,
  item.AccountingDocument AS AccountingDocument,
  item.FiscalYear AS FiscalYear,
  item.AccountingDocumentItem AS AccountingDocumentItem,
  item.InvoiceReference AS InvoiceReference,
  item.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  item.Customer AS Customer,
  item.Supplier AS Supplier,
  item.VATRegistration AS VATRegistration,
  item.FinancialAccountType AS FinancialAccountType,
  item._Customer.IsOneTimeAccount AS CustomerIsOneTimeAccount,
  item._Supplier.IsOneTimeAccount AS SupplierIsOneTimeAccount,
  item._Customer AS _Customer,
  item._Supplier AS _Supplier,
  item._OneTimeAccountBP AS _OneTimeAccountBP
FROM P_AcctgDocKDMinItemLog
;

Learn More