I_BusinessPartnerSupplierTP_2

DDL: I_BUSINESSPARTNERSUPPLIERTP_2 Type: view_entity TRANSACTIONAL Package: VDM_MD_BP_RAP
62 Fields 1 Data Sources 4 Associations

Business Partner Supplier

I_BusinessPartnerSupplierTP_2 is a Transactional CDS View that provides data about "Business Partner Supplier" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerSupplier) and exposes 62 fields with key fields Supplier, BusinessPartner. It has 4 associations to related views. Part of development package VDM_MD_BP_RAP.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerSupplier I_BusinessPartnerSupplier from

Associations (4)

CardinalityTargetAliasCondition
[1] I_BusinessPartnerTP_2 _BusinessPartner $projection.BusinessPartnerForEdit = _BusinessPartner.BusinessPartner
[0..*] I_SupplierCompanyCodeTP _SupplierCompanyCode
[0..*] I_SupplierPurchasingOrgTP _SupplierPurchasingOrg
[1..*] I_SUPPLIERTAXGROUPINGTP_2 _SupplierTaxGroupings

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Business Partner Supplier view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier Supplier
KEY BusinessPartner BusinessPartner Issuing Authority
SupplierForEdit Supplier Supplier
BusinessPartnerForEdit BusinessPartner Issuing Authority
BusinessPartnerUUID BusinessPartnerUUID UUID
BusinessPartnerCategory BusinessPartnerCategory Partner Cat.
SupplierAccountGroup SupplierAccountGroup Account group
TitleSupplier FormOfAddress Title Key
InternationalLocationNumber1 InternationalLocationNumber1 Location no. 1
InternationalLocationNumber2 InternationalLocationNumber2 Location no. 2
InternationalLocationNumber3 InternationalLocationNumber3 Check digit
ReferenceAccountGroup ReferenceAccountGroup Ref.Acct Group
SupplierAlternativePayee SupplierAlternativePayee Alternat. Payee
Customer Customer Sold-to Party
PostingIsBlocked PostingIsBlocked Posting Block
PurchasingIsBlocked PurchasingIsBlocked Purch. block
VATLiability VATLiability Liable for VAT
PaymentIsBlockedForSupplier PaymentIsBlockedForSupplier Payment block
SuplrProofOfDelivRlvtCode SuplrProofOfDelivRlvtCode POD-Relevant
BR_TaxIsSplit BR_TaxIsSplit Tax split
AuthorizationGroup AuthorizationGroup AuthorizGroup
IsToBeAcceptedAtOrigin IsToBeAcceptedAtOrigin Origin Accept.
SupplierCorporateGroup SupplierCorporateGroup Group
ResponsibleType ResponsibleType Tax Type
FiscalAddress FiscalAddress Fiscal address
SupplierProcurementBlock SupplierProcurementBlock Block Function
DataExchangeInstructionKey DataExchangeInstructionKey Instruction Key
BPIsEqualizationTaxSubject BPIsEqualizationTaxSubject Equalizatn tax
BRSpcfcTaxBasePercentageCode BRSpcfcTaxBasePercentageCode Tax Base
DataMediumExchangeIndicator DataMediumExchangeIndicator DME Rec. Code
TranspServiceAgentStstcGrp TranspServiceAgentStstcGrp Stat.grp, agent
TaxNumberResponsible TaxNumberResponsible
TaxNumberType TaxNumberType Tax number type
SuplrQualityManagementSystem SuplrQualityManagementSystem Target QM Sys.
SuplrQltyInProcmtCertfnValidTo SuplrQltyInProcmtCertfnValidTo QM System To
SupplierIsSubRangeRelevant SupplierIsSubRangeRelevant VSR relevant
TrainStationName TrainStationName Train station
AlternativePayeeIsAllowed AlternativePayeeIsAllowed Payee in doc.
PaytSlipWthRefSubscriber PaytSlipWthRefSubscriber PBC/POR Number
SupplierIsPlantRelevant SupplierIsPlantRelevant Plant relevant
FactoryCalendar FactoryCalendar Factory Calendar
SupplierPlant SupplierPlant Plant
DeletionIndicator DeletionIndicator Deletion Ind.
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
PaymentReason PaymentReason Payment Reason
SupplierCentralDeletionIsBlock SupplierCentralDeletionIsBlock Deletion block
IsOneTimeAccount IsOneTimeAccount One-time acct
ETag _BusinessPartner ETag Update Token
LastChangedByUser _BusinessPartner LastChangedByUser User Name
LastChangeDate _BusinessPartner LastChangeDate Time Stamp
LastChangeTime _BusinessPartner LastChangeTime Time changed
_SupplierToBusinessPartner _SupplierToBusinessPartner
_SupplierAccountGroup _SupplierAccountGroup
_SupplierAccountGroupText _SupplierAccountGroupText
_ReferenceAccountGroupText _ReferenceAccountGroupText
_FiscalAddress _FiscalAddress
_ProcurementBlock _ProcurementBlock
_QualityManagementSystem _QualityManagementSystem
_SupplierCompanyCode _SupplierCompanyCode
_SupplierPurchasingOrg _SupplierPurchasingOrg
_BusinessPartner _BusinessPartner
_SupplierTaxGroupings _SupplierTaxGroupings

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_BusinessPartnerSupplierTP_2.
-- 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 I_BusinessPartnerSupplierTP_2 AS
SELECT
  Supplier,
  BusinessPartner,
  Supplier AS SupplierForEdit,
  BusinessPartner AS BusinessPartnerForEdit,
  BusinessPartnerUUID,
  BusinessPartnerCategory,
  SupplierAccountGroup,
  FormOfAddress AS TitleSupplier,
  InternationalLocationNumber1,
  InternationalLocationNumber2,
  InternationalLocationNumber3,
  ReferenceAccountGroup,
  SupplierAlternativePayee,
  Customer,
  PostingIsBlocked,
  PurchasingIsBlocked,
  VATLiability,
  PaymentIsBlockedForSupplier,
  SuplrProofOfDelivRlvtCode,
  BR_TaxIsSplit,
  AuthorizationGroup,
  IsToBeAcceptedAtOrigin,
  SupplierCorporateGroup,
  ResponsibleType,
  FiscalAddress,
  SupplierProcurementBlock,
  DataExchangeInstructionKey,
  BPIsEqualizationTaxSubject,
  BRSpcfcTaxBasePercentageCode,
  DataMediumExchangeIndicator,
  TranspServiceAgentStstcGrp,
  TaxNumberResponsible,
  TaxNumberType,
  SuplrQualityManagementSystem,
  SuplrQltyInProcmtCertfnValidTo,
  SupplierIsSubRangeRelevant,
  TrainStationName,
  AlternativePayeeIsAllowed,
  PaytSlipWthRefSubscriber,
  SupplierIsPlantRelevant,
  FactoryCalendar,
  SupplierPlant,
  DeletionIndicator,
  IsBusinessPurposeCompleted,
  PaymentReason,
  SupplierCentralDeletionIsBlock,
  IsOneTimeAccount,
  _BusinessPartner.ETag AS ETag,
  _BusinessPartner.LastChangedByUser AS LastChangedByUser,
  _BusinessPartner.LastChangeDate AS LastChangeDate,
  _BusinessPartner.LastChangeTime AS LastChangeTime
FROM I_BusinessPartnerSupplier
LEFT OUTER JOIN I_BusinessPartnerTP_2 AS _BusinessPartner ON BusinessPartnerForEdit = _BusinessPartner.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_SupplierCompanyCodeTP AS _SupplierCompanyCode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_SupplierPurchasingOrgTP AS _SupplierPurchasingOrg ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_SUPPLIERTAXGROUPINGTP_2 AS _SupplierTaxGroupings ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More