C_OIL_LgclInvtryAdjDocHdrDEX

DDL: C_OIL_LGCLINVTRYADJDOCHDRDEX Type: view_entity CONSUMPTION
18 Fields 1 Data Sources

LIA Document Header Data

C_OIL_LgclInvtryAdjDocHdrDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Logical Inventory Adjustment · Cross Applications

C_OIL_LgclInvtryAdjDocHdrDEX is a Consumption CDS View that provides data about "LIA Document Header Data" in SAP S/4HANA. It reads from 1 data source (I_OIL_LgclInvtryAdjDocHdr) and exposes 18 fields with key fields LgclInvtryAdjmtDocumentNumber, LgclInvtryAdjmtDocumentYear.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-DS
CapabilitiesData Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_OIL_LgclInvtryAdjDocHdr I_OIL_LgclInvtryAdjDocHdr from

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Analytics.technicalName COILLgclInvtryAdjDocHdrDEX view
EndUserText.label LIA Document Header Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey LgclInvtryAdjmtDocumentNumber view
ObjectModel.sapObjectNodeType.name OIL_LogicalInventoryAdjustment view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY LgclInvtryAdjmtDocumentNumber LgclInvtryAdjmtDocumentNumber Document number for logical inventory adjustment
KEY LgclInvtryAdjmtDocumentYear LgclInvtryAdjmtDocumentYear Material Document Year
DocumentDate DocumentDate Document Date in Document
PostingDate PostingDate Posting Date in the Document
LgclInvtryAdjmtDocType LgclInvtryAdjmtDocType LIA document type
CreationDate CreationDate Record Created On
CreationTime CreationTime Time of creation
CreatedByUser CreatedByUser Name of Person Responsible for Creating the Object
LastChangeDate LastChangeDate Last Changed On
ChangedTime ChangedTime Time of day the record was changed
LastChangeByUser LastChangeByUser Name of Person Who Changed Object
IndicatorPreviousMonth IndicatorPreviousMonth Previous month indicator
ExchangePartner ExchangePartner Exchange partner (vendor number)
RvslLgclInvtryAdjmtDocNmbr RvslLgclInvtryAdjmtDocNmbr Document number for reversal logical inventory adjustment
ReversalMaterialDocumentYear ReversalMaterialDocumentYear Material Document Year
PrmtHbSchedDtaAgingFltrDte PrmtHbSchedDtaAgingFltrDte Data Filter Value for Data Aging
_Supplier _Supplier
_LgclInvtryAdjDoc _LgclInvtryAdjDoc

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 C_OIL_LgclInvtryAdjDocHdrDEX.
-- 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 C_OIL_LgclInvtryAdjDocHdrDEX AS
SELECT
  LgclInvtryAdjmtDocumentNumber,
  LgclInvtryAdjmtDocumentYear,
  DocumentDate,
  PostingDate,
  LgclInvtryAdjmtDocType,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  ChangedTime,
  LastChangeByUser,
  IndicatorPreviousMonth,
  ExchangePartner,
  RvslLgclInvtryAdjmtDocNmbr,
  ReversalMaterialDocumentYear,
  PrmtHbSchedDtaAgingFltrDte
FROM I_OIL_LgclInvtryAdjDocHdr
;

Learn More