I_JITBusPartContact

DDL: I_JITBUSPARTCONTACT Type: view_entity BASIC
10 Fields 1 Data Sources 4 Associations

JIT Customer Contact Person Relationship

I_JITBusPartContact is a Basic CDS View that provides data about "JIT Customer Contact Person Relationship" in SAP S/4HANA. It reads from 1 data source (but050) and exposes 10 fields with key fields RelationshipNumber, BusinessPartnerCompany, BusinessPartnerPerson, ValidityEndDate. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
but050 but050 from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_JITBusPartContactPerson _JITBusPartContactPerson $projection.RelationshipNumber = _JITBusPartContactPerson.RelationshipNumber and $projection.BusinessPartnerCompany = _JITBusPartContactPerson.BusinessPartnerCompany and $projection.BusinessPartnerPerson = _JITBusPartContactPerson.BusinessPartnerPerson and $projection.ValidityEndDate = _JITBusPartContactPerson.ValidityEndDate
[0..1] I_BusinessPartner _BusinessPartnerPerson $projection.BusinessPartnerPerson = _BusinessPartnerPerson.BusinessPartner
[0..1] I_Customer _BusinessPartnerCompany $projection.BusinessPartnerCompany = _BusinessPartnerCompany.Customer
[0..1] I_JITCustomer _JITCustomer $projection.BusinessPartnerCompany = _JITCustomer.ShipToParty

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label JIT Customer Contact Person Relationship view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY RelationshipNumber but050 relnr BP Rel. Number
KEY BusinessPartnerCompany partner1 Busn. Partner
KEY BusinessPartnerPerson partner2 Busn. Partner
KEY ValidityEndDate date_to Validity End Date
ValidityStartDate date_from Validity Start Date
RelationshipCategory reltyp Relatshp Cat.
_JITBusPartContactPerson _JITBusPartContactPerson
_BusinessPartnerPerson _BusinessPartnerPerson
_BusinessPartnerCompany _BusinessPartnerCompany
_JITCustomer _JITCustomer

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_JITBusPartContact.
-- 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_JITBusPartContact AS
SELECT
  but050.relnr AS RelationshipNumber,
  partner1 AS BusinessPartnerCompany,
  partner2 AS BusinessPartnerPerson,
  date_to AS ValidityEndDate,
  date_from AS ValidityStartDate,
  reltyp AS RelationshipCategory
FROM but050
LEFT OUTER JOIN I_JITBusPartContactPerson AS _JITBusPartContactPerson ON RelationshipNumber = _JITBusPartContactPerson.RelationshipNumber AND BusinessPartnerCompany = _JITBusPartContactPerson.BusinessPartnerCompany AND BusinessPartnerPerson = _JITBusPartContactPerson.BusinessPartnerPerson AND ValidityEndDate = _JITBusPartContactPerson.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartnerPerson ON BusinessPartnerPerson = _BusinessPartnerPerson.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BusinessPartnerCompany ON BusinessPartnerCompany = _BusinessPartnerCompany.Customer  -- association [0..1]
LEFT OUTER JOIN I_JITCustomer AS _JITCustomer ON BusinessPartnerCompany = _JITCustomer.ShipToParty  -- association [0..1]
;

Learn More