P_CN_SuplrLineItemRaw

DDL: P_CN_SUPLRLINEITEMRAW SQL: PCNSUPLLINEITEMR Type: view COMPOSITE Package: GLO_FIN_CN_BAL
75 Fields 3 Data Sources

Supplier Line Item Raw Data

P_CN_SuplrLineItemRaw is a Composite CDS View that provides data about "Supplier Line Item Raw Data" in SAP S/4HANA. It reads from 3 data sources (I_BPSuplrCustRltn, I_GLAcctLineItemEnrcd, I_GLAcctLineItemEnrcd) and exposes 75 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem, FiscalYear. Part of development package GLO_FIN_CN_BAL.

Data Sources (3)

SourceAliasJoin Type
I_BPSuplrCustRltn bpmixedaccount inner
I_GLAcctLineItemEnrcd I_GLAcctLineItemEnrcd from
I_GLAcctLineItemEnrcd I_GLAcctLineItemEnrcd union_all

Parameters (4)

NameTypeDefault
P_CompanyCode bukrs
P_FiscalYear gjahr
P_CurrencyRole fac_crcyrole
P_DimensionKey dimid

Annotations (7)

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

Fields (75)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
FiscalPeriod FiscalPeriod Tax period
GLAccount GLAccount General Ledger
AlternativeGLAccount AlternativeGLAccount Group Account
Supplier Supplier Supplier
Customer Customer Sold-to Party
SpecialGLCode SpecialGLCode Special G/L Ind
ProfitCenter ProfitCenter Profit Center
Segment Segment Segment number
BusinessArea BusinessArea Business Area
AssignmentReference AssignmentReference Assignment Reference
PostingDate PostingDate Posting Date for GR
Ledger Ledger Ledger
IsCleared IsCleared Integer
DebitCreditCode DebitCreditCode Single-Character Flag
PartnerProfitCenter PartnerProfitCenter Profit Center
FinancialAccountType FinancialAccountType Fin. Account Type
AccountingDocumentType AccountingDocumentType Journal Entry Type
DocumentDate DocumentDate Journal Entry Date
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
DocumentItemText DocumentItemText Text
ClearingDate ClearingDate Clearing Date
ClearingJournalEntry ClearingJournalEntry Clrng doc.
AlternativeReferenceDocument AlternativeReferenceDocument Alternative Reference Document
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
DisplayCurrency DisplayCurrency Display Currency
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
DebitAmountInTransCrcy DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy CreditAmountInTransCrcy Credit Amt in DC
AmountInDisplayCurrency AmountInDisplayCurrency
DebitAmountInDisplayCrcy DebitAmountInDisplayCrcy
CreditAmountInDisplayCrcy CreditAmountInDisplayCrcy
CompanyCode Receiver Company Code
KEY FiscalYear lineitem FiscalYear G/L Fiscal Year
KEY AccountingDocument lineitem AccountingDocument Journal Entry
KEY LedgerGLLineItem lineitem LedgerGLLineItem Journal Entry Item
FiscalPeriod lineitem FiscalPeriod Tax period
GLAccount lineitem GLAccount General Ledger
AlternativeGLAccount lineitem AlternativeGLAccount Group Account
Supplier I_BPSuplrCustRltn Supplier Supplier
Customer lineitem Customer Sold-to Party
SpecialGLCode lineitem SpecialGLCode Special G/L Ind
ProfitCenter lineitem ProfitCenter Profit Center
Segment lineitem Segment Segment number
ProfitCenterelseendasAggrProfitCenter
SegmentelseendasAggrSegment
BusinessArea lineitem BusinessArea Business Area
AssignmentReference lineitem AssignmentReference Assignment Reference
PostingDate lineitem PostingDate Posting Date for GR
Ledger lineitem Ledger Ledger
IsCleared lineitem IsCleared Integer
DebitCreditCode lineitem DebitCreditCode Single-Character Flag
PartnerProfitCenter lineitem PartnerProfitCenter Profit Center
FinancialAccountType lineitem FinancialAccountType Fin. Account Type
AccountingDocumentType lineitem AccountingDocumentType Journal Entry Type
DocumentDate lineitem DocumentDate Journal Entry Date
AccountingDocCreatedByUser lineitem AccountingDocCreatedByUser User which created overhead document
DocumentItemText lineitem DocumentItemText Text
ClearingDate lineitem ClearingDate Clearing Date
ClearingJournalEntry lineitem ClearingJournalEntry Clrng doc.
AlternativeReferenceDocument lineitem AlternativeReferenceDocument Alternative Reference Document
AccountingDocumentHeaderText lineitem AccountingDocumentHeaderText Doc.Header Text
DisplayCurrency lineitem DisplayCurrency Display Currency
TransactionCurrency lineitem TransactionCurrency Transaction Currency
AmountInTransactionCurrency lineitem AmountInTransactionCurrency Pt Crcy Amt
DebitAmountInTransCrcy lineitem DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy lineitem CreditAmountInTransCrcy Credit Amt in DC
AmountInDisplayCurrency lineitem AmountInDisplayCurrency
DebitAmountInDisplayCrcy lineitem DebitAmountInDisplayCrcy
CreditAmountInDisplayCrcy lineitem CreditAmountInDisplayCrcy
_Customer lineitem _Customer

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_CN_SuplrLineItemRaw.
-- 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.
-- SQL view name: PCNSUPLLINEITEMR
-- Parameters: P_CompanyCode : bukrs, P_FiscalYear : gjahr, P_CurrencyRole : fac_crcyrole, P_DimensionKey : dimid

CREATE VIEW P_CN_SuplrLineItemRaw AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  FiscalPeriod,
  GLAccount,
  AlternativeGLAccount,
  Supplier,
  Customer,
  SpecialGLCode,
  ProfitCenter,
  Segment,
  BusinessArea,
  AssignmentReference,
  PostingDate,
  Ledger,
  IsCleared,
  DebitCreditCode,
  PartnerProfitCenter,
  FinancialAccountType,
  AccountingDocumentType,
  DocumentDate,
  AccountingDocCreatedByUser,
  DocumentItemText,
  ClearingDate,
  ClearingJournalEntry,
  AlternativeReferenceDocument,
  AccountingDocumentHeaderText,
  DisplayCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  AmountInDisplayCurrency,
  DebitAmountInDisplayCrcy,
  CreditAmountInDisplayCrcy,
  case :P_DimensionKey when 'PRFCTR' then lineitem.ProfitCenter when 'PRFSEG' then lineitem.ProfitCenter else '' end as AggrProfitCenter AS ProfitCenterelseendasAggrProfitCenter,
  case :P_DimensionKey when 'SEGMNT' then lineitem.Segment when 'PRFSEG' then lineitem.Segment else '' end as AggrSegment AS SegmentelseendasAggrSegment,
  lineitem._Customer AS _Customer
FROM I_GLAcctLineItemEnrcd
INNER JOIN I_BPSuplrCustRltn AS bpmixedaccount ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_GLAcctLineItemEnrcd
;

Learn More