P_FristKDOperationItem

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

First K or D line Item

P_FristKDOperationItem 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_AcctgDocKDMinItem) 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_AcctgDocKDMinItem m from

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_FristKDOperationItem.
-- 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 P_FristKDOperationItem 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_AcctgDocKDMinItem AS m
;

Learn More