A_OIL_LgclInvtryPaytAdjmt

DDL: A_OIL_LGCLINVTRYPAYTADJMT Type: view_entity CONSUMPTION
19 Fields 1 Data Sources

LIA doc item data negotiated payments

A_OIL_LgclInvtryPaytAdjmt is a Consumption CDS View that provides data about "LIA doc item data negotiated payments" in SAP S/4HANA. It reads from 1 data source (R_OIL_LgclInvtryPaytAdjmtTP) and exposes 19 fields with key fields LgclInvtryAdjmtDocumentNumber, LgclInvtryAdjmtDocumentYear, LgclInvtryAdjmtDocItemNumber, LgclInvtryAdjmtItmType.

Data Sources (1)

SourceAliasJoin Type
R_OIL_LgclInvtryPaytAdjmtTP R_OIL_LgclInvtryPaytAdjmtTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label LIA doc item data negotiated payments view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
OData.entityType.name A_OIL_LgclInvtryPaytAdjmt_Type view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY LgclInvtryAdjmtDocumentNumber LgclInvtryAdjmtDocumentNumber LIA number
KEY LgclInvtryAdjmtDocumentYear LgclInvtryAdjmtDocumentYear Mat. Doc. Year
KEY LgclInvtryAdjmtDocItemNumber LgclInvtryAdjmtDocItemNumber LIA doc item
KEY LgclInvtryAdjmtItmType LgclInvtryAdjmtItmType LIA item type
CompanyCode CompanyCode Receiver Company Code
ExchangeAgreement ExchangeAgreement Exchange no.
LgclInvtryAdjmtPaymentAmount LgclInvtryAdjmtPaymentAmount LIA pyt amt.
Currency Currency Valuation Crcy
TaxCode TaxCode Tax Code
PaymentTerms PaymentTerms Pyt Terms
SalesOrganization SalesOrganization Sales Organization
PurchasingOrganization PurchasingOrganization Purchasing Organization
Plant Plant Valuation Area
FeeAccountingProcessKey FeeAccountingProcessKey Process key
PaymentBlockKey PaymentBlockKey Payment Block
InvoiceCycle InvoiceCycle Invoice cycle
LadingExternalBill LadingExternalBill Extern.BOL no.
ItemTextLgclInvtryAdjmt ItemTextLgclInvtryAdjmt Text
LgclInvtryAdjCustSuppPosIn LgclInvtryAdjCustSuppPosIn Cust/vend.ind

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 A_OIL_LgclInvtryPaytAdjmt.
-- 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 A_OIL_LgclInvtryPaytAdjmt AS
SELECT
  LgclInvtryAdjmtDocumentNumber,
  LgclInvtryAdjmtDocumentYear,
  LgclInvtryAdjmtDocItemNumber,
  LgclInvtryAdjmtItmType,
  CompanyCode,
  ExchangeAgreement,
  LgclInvtryAdjmtPaymentAmount,
  Currency,
  TaxCode,
  PaymentTerms,
  SalesOrganization,
  PurchasingOrganization,
  Plant,
  FeeAccountingProcessKey,
  PaymentBlockKey,
  InvoiceCycle,
  LadingExternalBill,
  ItemTextLgclInvtryAdjmt,
  LgclInvtryAdjCustSuppPosIn
FROM R_OIL_LgclInvtryPaytAdjmtTP
;

Learn More