P_FARMLVD_ACCDOCITM

DDL: P_FARMLVD_ACCDOCITM SQL: PFMLVACCDOCITM Type: view CONSUMPTION
17 Fields 1 Data Sources

Accounting Document Key

P_FARMLVD_ACCDOCITM is a Consumption CDS View that provides data about "Accounting Document Key" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 17 fields.

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName PFMLVACCDOCITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Accounting Document Key view

Fields (17)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode Receiver Company Code
AccountingDocument AccountingDocument Journal Entry
AccountingDocumentItem AccountingDocumentItem Posting View Item
FiscalYear FiscalYear G/L Fiscal Year
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
ClearingJournalEntry ClearingJournalEntry Clrng doc.
ClearingDate ClearingDate Clearing Date
ClearingDocFiscalYear ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
AssignmentReference AssignmentReference Assignment Reference
PostingKey PostingKey Posting Key
FinancialAccountType FinancialAccountType Fin. Account Type
GLAccount GLAccount General Ledger
DebitCreditCode DebitCreditCode Single-Character Flag
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
InvoiceReference InvoiceReference Invoice Reference
Customer Customer Sold-to Party

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_FARMLVD_ACCDOCITM.
-- 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: PFMLVACCDOCITM

CREATE VIEW P_FARMLVD_ACCDOCITM AS
SELECT
  CompanyCode,
  AccountingDocument,
  AccountingDocumentItem,
  FiscalYear,
  ClearingAccountingDocument,
  ClearingJournalEntry,
  ClearingDate,
  ClearingDocFiscalYear,
  ClearingJournalEntryFiscalYear,
  AssignmentReference,
  PostingKey,
  FinancialAccountType,
  GLAccount,
  DebitCreditCode,
  AmountInTransactionCurrency,
  InvoiceReference,
  Customer
FROM I_OperationalAcctgDocItem
;

Learn More