I_FldLogsPlntPerCustSlsArea

DDL: I_FLDLOGSPLNTPERCUSTSLSAREA Type: view_entity BASIC
8 Fields 2 Data Sources

Plant wise Customer Sales Area

I_FldLogsPlntPerCustSlsArea is a Basic CDS View that provides data about "Plant wise Customer Sales Area" in SAP S/4HANA. It reads from 2 data sources (nsdm_e_marc, I_Plant) and exposes 8 fields with key fields Plant, Customer, SalesOrganization, Division, DistributionChannel.

Data Sources (2)

SourceAliasJoin Type
nsdm_e_marc _materialPlant inner
I_Plant _plant inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Plant wise Customer Sales Area view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Plant I_Plant Plant Valuation Area
KEY Customer
KEY SalesOrganization I_Plant SalesOrganization Sales Organization
KEY Division I_Plant Division Internal Division ID
KEY DistributionChannel I_Plant DistributionChannel RefDistCh-Cust/Mat.
KEY ShippingCondition
KEY LoadingGroup nsdm_e_marc ladgr Loading Group
IsBusinessPurposeCompleted

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_FldLogsPlntPerCustSlsArea.
-- 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_FldLogsPlntPerCustSlsArea AS
SELECT
  _plant.Plant AS Plant,
  _plant._Customer.Customer AS Customer,
  _plant.SalesOrganization AS SalesOrganization,
  _plant.Division AS Division,
  _plant.DistributionChannel AS DistributionChannel,
  _plant._Customer._CustomerSalesArea[ left outer where SalesOrganization = salesorganization and Division = division and DistributionChannel = distributionchannel ].ShippingCondition AS ShippingCondition,
  _materialPlant.ladgr AS LoadingGroup,
  _plant._Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
INNER JOIN I_Plant AS _plant ON /* join condition not captured in parsed metadata */
INNER JOIN nsdm_e_marc AS _materialPlant ON /* join condition not captured in parsed metadata */
;

Learn More