P_BPTRANSPSTDCARRALPHACODE

DDL: P_BPTRANSPSTDCARRALPHACODE Type: view_entity COMPOSITE Package: VDM_SCMB_BP
15 Fields 5 Data Sources

Private View for BP Transp SCAC

P_BPTRANSPSTDCARRALPHACODE is a Composite CDS View that provides data about "Private View for BP Transp SCAC" in SAP S/4HANA. It reads from 5 data sources (I_BusinessPartnerTransp, I_BPTranspSalesRepresentative, I_BusinessPartner, I_BuPaIdentification, I_BuPaIdentification) and exposes 15 fields with key fields BusinessPartner, BPIdentificationType, BPIdentificationNumber, BPIdentificationType, BPIdentificationNumber. Part of development package VDM_SCMB_BP.

Data Sources (5)

SourceAliasJoin Type
I_BusinessPartnerTransp _BusinessPartnerTransp inner
I_BPTranspSalesRepresentative BPTranspSalesRepresentative union
I_BusinessPartner BusinessPartner inner
I_BuPaIdentification Identification from
I_BuPaIdentification Identification inner

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BuPaIdentification BusinessPartner Issuing Authority
KEY BPIdentificationType I_BuPaIdentification BPIdentificationType ID Type
KEY BPIdentificationNumber I_BuPaIdentification BPIdentificationNumber Logical System
ValidityStartDate I_BuPaIdentification ValidityStartDate Validity Start Date
ValidityEndDate I_BuPaIdentification ValidityEndDate ValidTo
Carrier Busn. Partner
AuthorizationGroup AuthorizationGroup AuthorizGroup
BusinessPartner Issuing Authority
KEY BPIdentificationType I_BuPaIdentification BPIdentificationType ID Type
KEY BPIdentificationNumber I_BuPaIdentification BPIdentificationNumber Logical System
ValidityStartDate I_BuPaIdentification ValidityStartDate Validity Start Date
ValidityEndDate I_BuPaIdentification ValidityEndDate ValidTo
Carrier I_BPTranspSalesRepresentative TranspSalesRepresentative Busn. Partner
AuthorizationGroup I_BusinessPartner AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted Purpose Completed

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 P_BPTRANSPSTDCARRALPHACODE.
-- 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 P_BPTRANSPSTDCARRALPHACODE AS
SELECT
  Identification.BusinessPartner AS BusinessPartner,
  Identification.BPIdentificationType AS BPIdentificationType,
  Identification.BPIdentificationNumber AS BPIdentificationNumber,
  Identification.ValidityStartDate AS ValidityStartDate,
  Identification.ValidityEndDate AS ValidityEndDate,
  cast ('' as bu_partner) AS Carrier,
  AuthorizationGroup,
  BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_BuPaIdentification AS Identification
INNER JOIN I_BusinessPartnerTransp AS _BusinessPartnerTransp ON /* join condition not captured in parsed metadata */
INNER JOIN I_BuPaIdentification AS Identification ON /* join condition not captured in parsed metadata */
INNER JOIN I_BusinessPartner AS BusinessPartner ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_BPTranspSalesRepresentative
;

Learn More