A_BillOfMaterialLongText

DDL: A_BILLOFMATERIALLONGTEXT Type: view_entity COMPOSITE Package: CS_MODEL_API
13 Fields 1 Data Sources 1 OData Services

Bill Of Material Header Long Text

A_BillOfMaterialLongText is a Composite CDS View that provides data about "Bill Of Material Header Long Text" in SAP S/4HANA. It reads from 1 data source (R_BillOfMaterialLongTextTP) and exposes 13 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, EngineeringChangeDocument. It is exposed through 1 OData service (ASQL_F6657). Part of development package CS_MODEL_API.

Data Sources (1)

SourceAliasJoin Type
R_BillOfMaterialLongTextTP R_BillOfMaterialLongTextTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #TEXT view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
OData.entitySet.name MaterialBOMLongText view
EndUserText.label Bill Of Material Header Long Text view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F6657 ASQL_F6657 C2 NOT_RELEASED

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BOMHeaderLongText BillOfMaterial BOM
KEY BillOfMaterialCategory BOMHeaderLongText BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant BOMHeaderLongText BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion BOMHeaderLongText BillOfMaterialVersion BOM Version
KEY EngineeringChangeDocument BOMHeaderLongText EngineeringChangeDocument Change Number
KEY Material BOMHeaderLongText Material Vehicle Model
KEY Plant BOMHeaderLongText Plant Valuation Area
KEY Language BOMHeaderLongText Language Report Text Language
KEY LongTextID BOMHeaderLongText LongTextID Text ID
BOMHeaderInternalChangeCount BOMHeaderLongText BOMHeaderInternalChangeCount Counter
BillOfMaterialVariantUsage BOMHeaderLongText BillOfMaterialVariantUsage Usage
LongText BOMHeaderLongText LongText Text Name
EngineeringChangeDocForEdit BOMHeaderLongText EngineeringChangeDocForEdit Change Number

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_BillOfMaterialLongText.
-- 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 A_BillOfMaterialLongText AS
SELECT
  BOMHeaderLongText.BillOfMaterial AS BillOfMaterial,
  BOMHeaderLongText.BillOfMaterialCategory AS BillOfMaterialCategory,
  BOMHeaderLongText.BillOfMaterialVariant AS BillOfMaterialVariant,
  BOMHeaderLongText.BillOfMaterialVersion AS BillOfMaterialVersion,
  BOMHeaderLongText.EngineeringChangeDocument AS EngineeringChangeDocument,
  BOMHeaderLongText.Material AS Material,
  BOMHeaderLongText.Plant AS Plant,
  BOMHeaderLongText.Language AS Language,
  BOMHeaderLongText.LongTextID AS LongTextID,
  BOMHeaderLongText.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  BOMHeaderLongText.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  BOMHeaderLongText.LongText AS LongText,
  BOMHeaderLongText.EngineeringChangeDocForEdit AS EngineeringChangeDocForEdit
FROM R_BillOfMaterialLongTextTP
;

Learn More