I_JITSalesAreaPartnerData

DDL: I_JITSALESAREAPARTNERDATA Type: view_entity BASIC
10 Fields 3 Data Sources 2 Associations

JIT Partner Data

I_JITSalesAreaPartnerData is a Basic CDS View that provides data about "JIT Partner Data" in SAP S/4HANA. It reads from 3 data sources (I_JITCustomer, edsdc, edpar) and exposes 10 fields with key fields ActiveSupplier, CustomerPartnerDescription, UnloadingPointName, ShipToParty, SalesOrganization. It has 2 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_JITCustomer _JITCustomer inner
edsdc AssgEDIPartnerToSalesArea inner
edpar PartnerExtToIntMapping inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer $projection.ShipToParty = _Customer.Customer
[0..1] I_Customer _SoldToParty $projection.SoldToParty = _SoldToParty.Customer

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Analytics.technicalName IJITPARTNERDATA view
EndUserText.label JIT Partner Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ActiveSupplier EDISoldToParty ActiveSupplier Vendor no.
KEY CustomerPartnerDescription EDISoldToParty CustomerPartnerDescription Partner desc.
KEY UnloadingPointName EDISoldToParty UnloadingPointName Unloading Point Name
KEY ShipToParty edsdc kunnr Stock customer
KEY SalesOrganization edsdc vkorg SD Sales Org.
KEY DistributionChannel edsdc vtweg RefDistCh-Cust/Mat.
KEY Division edsdc spart Source supplier
SoldToParty EDISoldToParty SoldToParty Sold-to Party
_Customer _Customer
_SoldToParty _SoldToParty

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_JITSalesAreaPartnerData.
-- 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_JITSalesAreaPartnerData AS
SELECT
  EDISoldToParty.ActiveSupplier AS ActiveSupplier,
  EDISoldToParty.CustomerPartnerDescription AS CustomerPartnerDescription,
  EDISoldToParty.UnloadingPointName AS UnloadingPointName,
  AssgEDIPartnerToSalesArea.kunnr AS ShipToParty,
  AssgEDIPartnerToSalesArea.vkorg AS SalesOrganization,
  AssgEDIPartnerToSalesArea.vtweg AS DistributionChannel,
  AssgEDIPartnerToSalesArea.spart AS Division,
  EDISoldToParty.SoldToParty AS SoldToParty
INNER JOIN edpar AS PartnerExtToIntMapping ON /* join condition not captured in parsed metadata */
INNER JOIN edsdc AS AssgEDIPartnerToSalesArea ON /* join condition not captured in parsed metadata */
INNER JOIN I_JITCustomer AS _JITCustomer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON ShipToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
;

Learn More