C_DeliverySalesDocumentTypeVH

DDL: C_DELIVERYSALESDOCUMENTTYPEVH SQL: CDLVSLSDOCTYPEVH Type: view CONSUMPTION
8 Fields 2 Associations

Sales Document Type Value Help

C_DeliverySalesDocumentTypeVH is a Consumption CDS View that provides data about "Sales Document Type Value Help" in SAP S/4HANA. It has 2 associations to related views.

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_SalesDocumentTypeText _Text $projection.SalesDocumentType = _Text.SalesDocumentType
[0..*] I_SDDocumentCategoryText _SDDocumentCategoryText $projection.SDDocumentCategory = _SDDocumentCategoryText.SDDocumentCategory

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CDLVSLSDOCTYPEVH view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
Search.searchable true view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Sales Document Type Value Help view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SalesDocumentType SalesDocumentType Sales Doc. Type
SalesDocumentTypeName
SDDocumentCategory SDDocumentCategory Document Cat.
SDDocumentCategoryName
RetsMgmtIsActive RetsMgmtIsActive
SalesDocumentTypeLangDepdnt
_Text _Text
_SDDocumentCategoryText _SDDocumentCategoryText

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 C_DeliverySalesDocumentTypeVH.
-- 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: CDLVSLSDOCTYPEVH

CREATE VIEW C_DeliverySalesDocumentTypeVH AS
SELECT
  SalesDocumentType,
  cast(_Text[1: Language=$session.system_language].SalesDocumentTypeName as tvakt_bezei) AS SalesDocumentTypeName,
  SDDocumentCategory,
  cast(_SDDocumentCategoryText[1: Language=$session.system_language].SDDocumentCategoryName as bezei) AS SDDocumentCategoryName,
  RetsMgmtIsActive,
  SalesDocumentType._SalesDocumentTypeLangDepdnt[1:Language=$session.system_language].SalesDocumentTypeLangDepdnt AS SalesDocumentTypeLangDepdnt
LEFT OUTER JOIN I_SalesDocumentTypeText AS _Text ON SalesDocumentType = _Text.SalesDocumentType  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentCategoryText AS _SDDocumentCategoryText ON SDDocumentCategory = _SDDocumentCategoryText.SDDocumentCategory  -- association [0..*]
;

Learn More