I_CustMatlAddrDepdntInfoTP

DDL: I_CUSTMATLADDRDEPDNTINFOTP SQL: ICSTMTLADRDEPTP Type: view TRANSACTIONAL Package: ODATA_SD_CUSTOMER_MATERIAL
18 Fields 1 Data Sources 1 Associations

Customer Material Address Dependent Info

I_CustMatlAddrDepdntInfoTP is a Transactional CDS View that provides data about "Customer Material Address Dependent Info" in SAP S/4HANA. It reads from 1 data source (I_CustMatlAddrDepdntInfo) and exposes 18 fields with key fields SalesOrganization, DistributionChannel, Customer, Material, AddressID. It has 1 association to related views. Part of development package ODATA_SD_CUSTOMER_MATERIAL.

Data Sources (1)

SourceAliasJoin Type
I_CustMatlAddrDepdntInfo CustMatlAddrDepdntInfo from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CustomerMaterialTP _CustomerMaterial $projection.SalesOrganization = _CustomerMaterial.SalesOrganization and $projection.DistributionChannel = _CustomerMaterial.DistributionChannel and $projection.Customer = _CustomerMaterial.Customer and $projection.Material = _CustomerMaterial.Material

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName ICSTMTLADRDEPTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence ICSTMTLADRDEP_D view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
Search.searchable true view
EndUserText.label Customer Material Address Dependent Info view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization I_CustMatlAddrDepdntInfo SalesOrganization Sales Organization
KEY DistributionChannel I_CustMatlAddrDepdntInfo DistributionChannel RefDistCh-Cust/Mat.
KEY Customer I_CustMatlAddrDepdntInfo Customer Sold-to Party
KEY Material
KEY AddressID I_CustMatlAddrDepdntInfo AddressID Ship-to address
AddressIDForEdit I_CustMatlAddrDepdntInfo AddressID Ship-to address
SalesOrganizationForEdit I_CustMatlAddrDepdntInfo SalesOrganization Sales Organization
DistributionChannelForEdit I_CustMatlAddrDepdntInfo DistributionChannel RefDistCh-Cust/Mat.
CustomerForEdit I_CustMatlAddrDepdntInfo Customer Sold-to Party
MaterialForEdit I_CustMatlAddrDepdntInfo Material Vehicle Model
BusinessPartner
Plant I_CustMatlAddrDepdntInfo Plant Valuation Area
_CustomerMaterial _CustomerMaterial
_Customer _Customer
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Plant _Plant
_Material _Material

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_CustMatlAddrDepdntInfoTP.
-- 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.
-- SQL view name: ICSTMTLADRDEPTP

CREATE VIEW I_CustMatlAddrDepdntInfoTP AS
SELECT
  CustMatlAddrDepdntInfo.SalesOrganization AS SalesOrganization,
  CustMatlAddrDepdntInfo.DistributionChannel AS DistributionChannel,
  CustMatlAddrDepdntInfo.Customer AS Customer,
  cast (CustMatlAddrDepdntInfo.Material as productnumber preserving type) AS Material,
  CustMatlAddrDepdntInfo.AddressID AS AddressID,
  CustMatlAddrDepdntInfo.AddressID AS AddressIDForEdit,
  CustMatlAddrDepdntInfo.SalesOrganization AS SalesOrganizationForEdit,
  CustMatlAddrDepdntInfo.DistributionChannel AS DistributionChannelForEdit,
  CustMatlAddrDepdntInfo.Customer AS CustomerForEdit,
  CustMatlAddrDepdntInfo.Material AS MaterialForEdit,
  CustMatlAddrDepdntInfo._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  CustMatlAddrDepdntInfo.Plant AS Plant
FROM I_CustMatlAddrDepdntInfo AS CustMatlAddrDepdntInfo
LEFT OUTER JOIN I_CustomerMaterialTP AS _CustomerMaterial ON SalesOrganization = _CustomerMaterial.SalesOrganization AND DistributionChannel = _CustomerMaterial.DistributionChannel AND Customer = _CustomerMaterial.Customer AND Material = _CustomerMaterial.Material  -- association [1..1]
;

Learn More