A_KanbanContainerDeliveryAddr

DDL: A_KANBANCONTAINERDELIVERYADDR SQL: API_PPKANBANCDA Type: view COMPOSITE
16 Fields 1 Data Sources 1 Associations

Kanban Container Delivery Addresses

A_KanbanContainerDeliveryAddr is a Composite CDS View that provides data about "Kanban Container Delivery Addresses" in SAP S/4HANA. It reads from 1 data source (I_KanbanContainerDeliveryAddr) and exposes 16 fields with key field KanbanControlCycle. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_KanbanContainerDeliveryAddr I_KanbanContainerDeliveryAddr from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_KanbanControlCycle _KanbanControlCycle $projection.KanbanControlCycle = _KanbanControlCycle.KanbanControlCycle

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName API_PPKANBANCDA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Kanban Container Delivery Addresses view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY KanbanControlCycle KanbanControlCycle
Plant Plant Valuation Area
KanbanContainerDeliveryAddress KanbanContainerDeliveryAddress
BusinessPartnerName1 BusinessPartnerName1 Name
BusinessPartnerName2 BusinessPartnerName2 Name 2
Building Building Building code
StreetName StreetName Text
AdditionalStreetSuffixName AdditionalStreetSuffixName Street 5
CityName CityName Name
PostalCode PostalCode Postal Code
Country Country Venue: Ctry/Reg
LastChangeDateTime _KanbanControlCycle LastChangeDateTime Timestamp
_KanbanControlCycle _KanbanControlCycle
Supplier Supplier Supplier
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant

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 A_KanbanContainerDeliveryAddr.
-- 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: API_PPKANBANCDA

CREATE VIEW A_KanbanContainerDeliveryAddr AS
SELECT
  KanbanControlCycle,
  Plant,
  KanbanContainerDeliveryAddress,
  BusinessPartnerName1,
  BusinessPartnerName2,
  Building,
  StreetName,
  AdditionalStreetSuffixName,
  CityName,
  PostalCode,
  Country,
  _KanbanControlCycle.LastChangeDateTime AS LastChangeDateTime,
  Supplier
FROM I_KanbanContainerDeliveryAddr
LEFT OUTER JOIN A_KanbanControlCycle AS _KanbanControlCycle ON KanbanControlCycle = _KanbanControlCycle.KanbanControlCycle  -- association [1..1]
;

Learn More