P_CABusinessPartnerLock2

DDL: P_CABUSINESSPARTNERLOCK2 Type: view_entity COMPOSITE Package: ODATA_O2C_FICA_DOCUMENT_MANAGE
30 Fields 4 Data Sources

Business Partner Lock

P_CABusinessPartnerLock2 is a Composite CDS View that provides data about "Business Partner Lock" in SAP S/4HANA. It reads from 4 data sources (I_CABusinessPartnerLock, I_CABusinessPartnerLock, I_CABusinessPartnerLock, I_CABusinessPartnerLock) and exposes 30 fields with key fields CABusinessLockObject, CABusinessProcess, CABusinessLockReason, CABusinessLockValidFrom, CABusinessLockValidTo. Part of development package ODATA_O2C_FICA_DOCUMENT_MANAGE.

Data Sources (4)

SourceAliasJoin Type
I_CABusinessPartnerLock I_CABusinessPartnerLock from
I_CABusinessPartnerLock I_CABusinessPartnerLock union_all
I_CABusinessPartnerLock I_CABusinessPartnerLock union_all
I_CABusinessPartnerLock I_CABusinessPartnerLock union_all

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Partner Lock view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CABusinessLockObject BusinessPartner Issuing Authority
KEY CABusinessProcess
KEY CABusinessLockReason CADunningLockReason Posting Lock
KEY CABusinessLockValidFrom CABusinessPartnerLockStartDate From
KEY CABusinessLockValidTo CABusinessPartnerLockEndDate To
KEY BusinessPartner BusinessPartner Issuing Authority
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
KEY CABusinessProcess
KEY CABusinessLockReason CAIncomingPaymentLockReason Posting Lock
KEY CABusinessLockValidFrom CABusinessPartnerLockStartDate From
KEY CABusinessLockValidTo CABusinessPartnerLockEndDate To
KEY BusinessPartner BusinessPartner Issuing Authority
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
KEY CABusinessProcess
KEY CABusinessLockReason CAOutgoingPaymentLockReason Posting Lock
KEY CABusinessLockValidFrom CABusinessPartnerLockStartDate From
KEY CABusinessLockValidTo CABusinessPartnerLockEndDate To
KEY BusinessPartner BusinessPartner Issuing Authority
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
KEY CABusinessProcess
KEY CABusinessLockReason CAPostgAndClrgLockReason Posting Lock
KEY CABusinessLockValidFrom CABusinessPartnerLockStartDate From
KEY CABusinessLockValidTo CABusinessPartnerLockEndDate To
KEY BusinessPartner BusinessPartner Issuing Authority
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change

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_CABusinessPartnerLock2.
-- 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_CABusinessPartnerLock2 AS
SELECT
  BusinessPartner AS CABusinessLockObject,
  '01' AS CABusinessProcess,
  CADunningLockReason AS CABusinessLockReason,
  CABusinessPartnerLockStartDate AS CABusinessLockValidFrom,
  CABusinessPartnerLockEndDate AS CABusinessLockValidTo,
  BusinessPartner,
  CreatedByUser,
  CreationDate,
  CreationTime
FROM I_CABusinessPartnerLock
-- UNION ALL with additional select branch(es): I_CABusinessPartnerLock
;

Learn More