I_DCBLocation

DDL: I_DCBLOCATION Type: view_entity BASIC
5 Fields 1 Data Sources

Deal Capture Location

I_DCBLocation is a Basic CDS View (Dimension) that provides data about "Deal Capture Location" in SAP S/4HANA. It reads from 1 data source (oijloc) and exposes 5 fields with key field CommodityDealLocationID.

Data Sources (1)

SourceAliasJoin Type
oijloc oijloc from

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Consumption.ranked true view
EndUserText.label Deal Capture Location view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey CommodityDealLocationID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
Metadata.allowExtensions true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CommodityDealLocationID locid Single-Character Flag
CommodityDealLocationText locnam Location name
DealBusinessLocation Location ID
IsBlocked bloind Single-Character Flag
IsDeleted delind Will be Deleted

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 I_DCBLocation.
-- 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 I_DCBLocation AS
SELECT
  locid AS CommodityDealLocationID,
  locnam AS CommodityDealLocationText,
  cast ( pblnr as cmm_oil_dc_business_location preserving type ) AS DealBusinessLocation,
  bloind AS IsBlocked,
  delind AS IsDeleted
FROM oijloc
;

Learn More