C_MngJrnlEntrAltvPayerPayeeVH

DDL: C_MNGJRNLENTRALTVPAYERPAYEEVH Type: view_entity CONSUMPTION Package: ODATA_MANAGE_JOURNAL_ENTRY_V2
19 Fields 2 Data Sources 2 Associations

Permitted Alternative Payer and Payee

C_MngJrnlEntrAltvPayerPayeeVH is a Consumption CDS View that provides data about "Permitted Alternative Payer and Payee" in SAP S/4HANA. It reads from 2 data sources (I_SuplrPmtdAltvPayee, R_MngJrnlEntrCustPmtdAltvPayer) and exposes 19 fields with key fields CustomerSupplier, CompanyCode, AlternativePayeePayer, FinancialAccountType, CompanyCode. It has 2 associations to related views. Part of development package ODATA_MANAGE_JOURNAL_ENTRY_V2.

Data Sources (2)

SourceAliasJoin Type
I_SuplrPmtdAltvPayee _Supplier from
R_MngJrnlEntrCustPmtdAltvPayer R_MngJrnlEntrCustPmtdAltvPayer union

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Supplier _Payee $projection.AlternativePayeePayer = _Payee.Supplier
[1..1] I_Customer _Payer $projection.AlternativePayeePayer = _Payer.Customer

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Permitted Alternative Payer and Payee view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey CustomerSupplier view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CustomerSupplier Supplier Supplier
KEY CompanyCode CompanyCode Receiver Company Code
KEY AlternativePayeePayer Payer
KEY FinancialAccountType
OrganizationBPName1 _Payee OrganizationBPName1 Name 1
CityName _Payee CityName Name
StreetName _Payee StreetName Text
AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted Purpose Completed
CustomerkeyCustomerasCustomerSupplier
KEY CompanyCode CompanyCode Receiver Company Code
KEY AlternativePayeePayer CustomerPermittedPayer Payer
KEY FinancialAccountType
OrganizationBPName1 _Payer OrganizationBPName1 Name 1
CityName _Payer CityName Name
StreetName _Payer StreetName Text
AuthorizationGroup AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
DataControllerSet DataControllerSet Data Ctrlr. Set

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 C_MngJrnlEntrAltvPayerPayeeVH.
-- 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 C_MngJrnlEntrAltvPayerPayeeVH AS
SELECT
  Supplier AS CustomerSupplier,
  CompanyCode,
  cast( SupplierAlternativePayee as fac_empfb preserving type ) AS AlternativePayeePayer,
  cast('K' as fis_koart) AS FinancialAccountType,
  _Payee.OrganizationBPName1 AS OrganizationBPName1,
  _Payee.CityName AS CityName,
  _Payee.StreetName AS StreetName,
  _Supplier._SupplierCompany.AuthorizationGroup AS AuthorizationGroup,
  _Supplier._SupplierCompany.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Supplier._Supplier.DataControllerSet AS CustomerkeyCustomerasCustomerSupplier,
  DataControllerSet
FROM I_SuplrPmtdAltvPayee AS _Supplier
LEFT OUTER JOIN I_Supplier AS _Payee ON AlternativePayeePayer = _Payee.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Payer ON AlternativePayeePayer = _Payer.Customer  -- association [1..1]
-- UNION with additional select branch(es): R_MngJrnlEntrCustPmtdAltvPayer
;

Learn More