I_ACMApplBusinessPartner

DDL: I_ACMAPPLBUSINESSPARTNER SQL: IACMAPPBP Type: view BASIC
8 Fields 1 Data Sources

ACM Application Business Partner

I_ACMApplBusinessPartner is a Basic CDS View that provides data about "ACM Application Business Partner" in SAP S/4HANA. It reads from 1 data source (/accgo/t_cas_cai) and exposes 8 fields with key fields ApplicationDocument, ReferenceApplicationItem, ReferenceApplicationSide, ACMApplicationDocumentSubItem.

Data Sources (1)

SourceAliasJoin Type
/accgo/t_cas_cai ApplDocItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACMAPPBP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label ACM Application Business Partner view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ApplicationDocument /accgo/t_cas_cai appldoc Appl. Document No.
KEY ReferenceApplicationItem /accgo/t_cas_cai item Task ID
KEY ReferenceApplicationSide /accgo/t_cas_cai side Side
KEY ACMApplicationDocumentSubItem /accgo/t_cas_cai sub_item SubItemNumber
NominationKey /accgo/t_cas_cai nomtk Nomination key
NominationDocItem /accgo/t_cas_cai nomit Nom. key item
LoadDataCaptureObjId /accgo/t_cas_cai uis_id LDC ID
kunnrendasCounterparty

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_ACMApplBusinessPartner.
-- 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: IACMAPPBP

CREATE VIEW I_ACMApplBusinessPartner AS
SELECT
  ApplDocItem.appldoc AS ApplicationDocument,
  ApplDocItem.item AS ReferenceApplicationItem,
  ApplDocItem.side AS ReferenceApplicationSide,
  ApplDocItem.sub_item AS ACMApplicationDocumentSubItem,
  ApplDocItem.nomtk AS NominationKey,
  ApplDocItem.nomit AS NominationDocItem,
  ApplDocItem.uis_id AS LoadDataCaptureObjId,
  case when ApplDocItem.side = 'M' then ApplDocItem.lifnr else ApplDocItem.kunnr end as Counterparty AS kunnrendasCounterparty
FROM /accgo/t_cas_cai AS ApplDocItem
;

Learn More