A_BuPaIdentification

DDL: A_BUPAIDENTIFICATION SQL: ABUPAID Type: view BASIC

Identification

A_BuPaIdentification is a Basic CDS View that provides data about "Identification" in SAP S/4HANA. It reads from 1 data source (I_BuPaIdentification) and exposes 11 fields with key fields BusinessPartner, BPIdentificationType, BPIdentificationNumber.

Data Sources (1)

SourceAliasJoin Type
I_BuPaIdentification I_BuPaIdentification from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ABUPAID view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Identification view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
KEY BPIdentificationType BPIdentificationType ID Type
KEY BPIdentificationNumber BPIdentificationNumber Logical System
BPIdnNmbrIssuingInstitute BPIdnNmbrIssuingInstitute Institution
BPIdentificationEntryDate BPIdentificationEntryDate Entry date
Country Country Venue: Ctry/Reg
Region Region Venue Region
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
AuthorizationGroup AuthorizationGroup AuthorizGroup
_BusinessPartner _BusinessPartner

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_BuPaIdentification.
-- 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: ABUPAID

CREATE VIEW A_BuPaIdentification AS
SELECT
  BusinessPartner,
  BPIdentificationType,
  BPIdentificationNumber,
  BPIdnNmbrIssuingInstitute,
  BPIdentificationEntryDate,
  Country,
  Region,
  ValidityStartDate,
  ValidityEndDate,
  AuthorizationGroup
FROM I_BuPaIdentification
;