P_HR_CustomerVendorLineItem

DDL: P_HR_CUSTOMERVENDORLINEITEM Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_HR
13 Fields 2 Data Sources 2 Associations

SI VAT Customer Supplier Line Item

P_HR_CustomerVendorLineItem is a Composite CDS View that provides data about "SI VAT Customer Supplier Line Item" in SAP S/4HANA. It reads from 2 data sources (P_HR_FIRSTDBTRCRDTRRBLSPYBLMIN, I_JournalEntry) and exposes 13 fields with key fields CompanyCode, AccountingDocument, FiscalYear. It has 2 associations to related views. Part of development package GLO_FIN_IS_VAT_HR.

Data Sources (2)

SourceAliasJoin Type
P_HR_FIRSTDBTRCRDTRRBLSPYBLMIN _CustomerSupplierLine inner
I_JournalEntry I_JournalEntry from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Supplier _Supplier _Supplier.Supplier = $projection.Supplier
[0..1] I_Customer _Customer _Customer.Customer = $projection.Customer

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode Receiver Company Code
KEY AccountingDocument I_JournalEntry AccountingDocument Journal Entry
KEY FiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
ClearingAccountingDocument I_OperationalAcctgDocItem ClearingAccountingDocument Clearing Journal Entry
Customer I_OperationalAcctgDocItem Customer Sold-to Party
Supplier I_OperationalAcctgDocItem Supplier Supplier
DocumentItemText I_OperationalAcctgDocItem DocumentItemText Text
VATRegistration I_OperationalAcctgDocItem VATRegistration VAT Registration No.
SupplyingCountry I_OperationalAcctgDocItem SupplyingCountry Supplying Ctry/Reg.
ClearingDate I_OperationalAcctgDocItem ClearingDate Clearing Date
StreetNameendasStreetName
CityNameendasCityName

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_HR_CustomerVendorLineItem.
-- 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_HR_CustomerVendorLineItem AS
SELECT
  I_JournalEntry.CompanyCode AS CompanyCode,
  I_JournalEntry.AccountingDocument AS AccountingDocument,
  I_JournalEntry.FiscalYear AS FiscalYear,
  I_OperationalAcctgDocItem.AccountingDocumentItem AS AccountingDocumentItem,
  I_OperationalAcctgDocItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  I_OperationalAcctgDocItem.Customer AS Customer,
  I_OperationalAcctgDocItem.Supplier AS Supplier,
  I_OperationalAcctgDocItem.DocumentItemText AS DocumentItemText,
  I_OperationalAcctgDocItem.VATRegistration AS VATRegistration,
  I_OperationalAcctgDocItem.SupplyingCountry AS SupplyingCountry,
  I_OperationalAcctgDocItem.ClearingDate AS ClearingDate,
  case when I_OperationalAcctgDocItem.Customer <> '' then _Customer.StreetName else _Supplier.StreetName end as StreetName AS StreetNameendasStreetName,
  case when I_OperationalAcctgDocItem.Customer <> '' then _Customer.CityName else _Supplier.CityName end as CityName AS CityNameendasCityName
FROM I_JournalEntry
INNER JOIN P_HR_FIRSTDBTRCRDTRRBLSPYBLMIN AS _CustomerSupplierLine ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = Customer  -- association [0..1]
;

Learn More