A_ContractAccountPartner

DDL: A_CONTRACTACCOUNTPARTNER Type: view_entity BASIC Package: ODATA_API_FICA_CONTRACCT_MNG
84 Fields 1 Data Sources 2 Associations

Vertragskonto Partner

A_ContractAccountPartner is a Basic CDS View that provides data about "Vertragskonto Partner" in SAP S/4HANA. It reads from 1 data source (I_ContractAccountPartner) and exposes 84 fields with key fields ContractAccount, BusinessPartner. It has 2 associations to related views. Part of development package ODATA_API_FICA_CONTRACCT_MNG.

Data Sources (1)

SourceAliasJoin Type
I_ContractAccountPartner I_ContractAccountPartner from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_ContractAccountHeader _ContractAccountHeader $projection.ContractAccount = _ContractAccountHeader.ContractAccount
[1..1] A_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (9)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Vertragskonto Partner view

Fields (84)

KeyFieldSource TableSource FieldDescription
KEY ContractAccount ContractAccount Contract Acct
KEY BusinessPartner BusinessPartner Issuing Authority
ContractAccountName ContractAccountName Cont. acct name
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
CABankIDForIncomingPayments CABankIDForIncomingPayments Bank Det. Inc.
CABankIDForOutgoingPayments CABankIDForOutgoingPayments Bank ID - Outg.
CAPaymentMethodForIncgPayment CAIncomingPaymentMethod Inc.Payt Method
CAPaymentMethodForOutgPayment CACnctntdOutgPaymentMethods Outg.Payt Meth.
CAHouseBankReference CAHouseBankReference Own Bank Dtls
CAPaymentCardIDForIncomingPayt CAPaymentCardIDForIncomingPayt CardID Incoming
CAPaymentCardIDForOutgoingPayt CAPaymentCardIDForOutgoingPayt CardID Outgoing
SEPAMandate SEPAMandate SEPA Mandate
CADunningProcedure CADunningProcedure Dunning Proc.
CADunningNoticeGroup CADunningNoticeGroup Grouping
CACorrespondenceDunningProced CACorrespondenceDunningProced CorrDunnProced.
CACollectionsClerk CACollectionsClerk Clerk Respons.
CACollectionsMasterDataGroup CACollectionsMasterDataGroup Master Data Grp
CACollectionStrategy CACollectionStrategy Coll. Strategy
CACollectionsContactPerson CACollectionsContactPerson Contact Person
ContractAccountForPayment ContractAccountForPayment Paid By
CABusinessPartnerForPayment CABusinessPartnerForPayment Payer/Payee
CAAlternativePayer CAAlternativePayer Alternate Payer
CAAlternativePayee CAAlternativePayee Alt. Payee
CAAlternativeDunningRecipient CAAlternativeDunningRecipient Alt.dun. recip.
CAAlternativeInvoiceRecipient CAAlternativeInvoiceRecipient Alt. bill rec.
CAAlternativeCorrespncRcpnt CAAlternativeCorrespncRcpnt Corresp. Recip.
CAAddressIDOfAlternativePayer CAAddressIDOfAlternativePayer Alt.Payer AddNo
CAAddressIDOfAlternativePayee CAAddressIDOfAlternativePayee Alt.Payee AddNo
CAAddressIDOfAltvDunRecipient CAAddressIDOfAltvDunRecipient Address number for alternative dunning notice recipient
CAAddressIDOfAltvInvoiceRcpnt CAAddressIDOfAltvInvoiceRcpnt Address number for alternative bill recipient
CACurrencyForDirectDebitLimit CACurrencyForDirectDebitLimit Currency
CADirectDebitLimit CADirectDebitLimit Dir. Debit Lmt
CANmbrMnthsForDirectDebitLimit CANmbrMnthsForDirectDebitLimit No. of Months
CADirectDebitLimitCalcMode CADirectDebitLimitCalcMode Rolling
CATargetCurrencyForInvoicing CATargetCurrencyForInvoicing Target Currency
CAInvcgCategory CAInvcgCategory Invoicing Cat.
CAInvcgSchedule CAInvcgSchedule Scheduling
CABillgCycle CABillgCycle Billing Cycle
CALastDayOfBillingPeriod CALastDayOfBillingPeriod Last Day
CADetnCodeForAltvInvoiceForm CADetnCodeForAltvInvoiceForm Form Determin.
CABusinessPartnerForPosting CABusinessPartnerForPosting Post Partner
ContractAccountForPosting ContractAccountForPosting Contract Acct
CABusinessPartnerForInvcgList CABusinessPartnerForInvcgList Recipient
ContractAccountForInvcgList ContractAccountForInvcgList Contract Acct
CAMasterAgreement CAMasterAgreement Master Agrmt
CAPartnerSettlementRule CAPartnerSettlementRule Settlement Rule
ValdtyDateForWhldgTaxExmpCert ValdtyDateForWhldgTaxExmpCert Valid Until
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
CAWhldgTaxCodeOutgoingPayt OutgPaytWithholdingTaxCode W/Htax o.payts
CAWhldgTaxCodeIncomingPayt IncgPaytWithholdingTaxCode W/Htax i.payts
WithholdingTaxCertificate WithholdingTaxCertificate WHT Certificate
CAAdditionalDaysForCashMgmt CAAdditionalDaysForCashMgmt CM Extra Days
CABusPartnerPostgLockExstcCode CABusPartnerPostgLockExstcCode BP Lock
CABusPartnerAddlLockExstcCode CABusPartnerAddlLockExstcCode Dun./Payt Lock
CABusinessPartnerLockStartDate CABusinessPartnerLockStartDate From
CABusinessPartnerLockEndDate CABusinessPartnerLockEndDate To
CABPReferenceNumber CABPReferenceNumber Reference No.
CACompanyCodeGroup CACompanyCodeGroup Company Code Gp
AltvContractAcctForCollvBills AltvContractAcctForCollvBills Coll. Bill Acct
CAInterestCode CAInterestCode Interest key
CashPlanningGroup CashPlanningGroup Planning Group
CARelationshipOfBPToContrAcct CARelationshipOfBPToContrAcct Acct.Relation.
AddressID AddressID Ship-to address
CAAddressIDOfJurisdictionCode CAAddressIDOfJurisdictionCode JurisdicCode address
CAAuthorizationGroup CAAuthorizationGroup AuthorizGroup
CAToleranceGroup CAToleranceGroup Tolerance group
CACorrespondenceVariant CACorrespondenceVariant Corresp.Variant
PartnerCompany PartnerCompany Trading Partner
CACorrespondenceActivityCode CACorrespondenceActivityCode Activity
CAClearingCategory CAClearingCategory Clearing Cat.
CADefaultClearingRstrcnCode CADefaultClearingRstrcnCode Restriction
SupplyingCountry SupplyingCountry Supplying Ctry/Reg.
BusinessPlace BusinessPlace Business place
PaymentCondition PaymentCondition Payment Terms
CAAccountDeterminationCode CAAccountDeterminationCode Acct Determ. ID
BusinessArea BusinessArea Business Area
CAPaymentCompanyCode CAPaymentCompanyCode Paying Co. Code
Country Country Venue: Ctry/Reg
_ContractAccountHeader _ContractAccountHeader
_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_ContractAccountPartner.
-- 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 A_ContractAccountPartner AS
SELECT
  ContractAccount,
  BusinessPartner,
  ContractAccountName,
  CreationDate,
  CreatedByUser,
  IsMarkedForDeletion,
  LastChangeDate,
  LastChangedByUser,
  CABankIDForIncomingPayments,
  CABankIDForOutgoingPayments,
  CAIncomingPaymentMethod AS CAPaymentMethodForIncgPayment,
  CACnctntdOutgPaymentMethods AS CAPaymentMethodForOutgPayment,
  CAHouseBankReference,
  CAPaymentCardIDForIncomingPayt,
  CAPaymentCardIDForOutgoingPayt,
  SEPAMandate,
  CADunningProcedure,
  CADunningNoticeGroup,
  CACorrespondenceDunningProced,
  CACollectionsClerk,
  CACollectionsMasterDataGroup,
  CACollectionStrategy,
  CACollectionsContactPerson,
  ContractAccountForPayment,
  CABusinessPartnerForPayment,
  CAAlternativePayer,
  CAAlternativePayee,
  CAAlternativeDunningRecipient,
  CAAlternativeInvoiceRecipient,
  CAAlternativeCorrespncRcpnt,
  CAAddressIDOfAlternativePayer,
  CAAddressIDOfAlternativePayee,
  CAAddressIDOfAltvDunRecipient,
  CAAddressIDOfAltvInvoiceRcpnt,
  CACurrencyForDirectDebitLimit,
  CADirectDebitLimit,
  CANmbrMnthsForDirectDebitLimit,
  CADirectDebitLimitCalcMode,
  CATargetCurrencyForInvoicing,
  CAInvcgCategory,
  CAInvcgSchedule,
  CABillgCycle,
  CALastDayOfBillingPeriod,
  CADetnCodeForAltvInvoiceForm,
  CABusinessPartnerForPosting,
  ContractAccountForPosting,
  CABusinessPartnerForInvcgList,
  ContractAccountForInvcgList,
  CAMasterAgreement,
  CAPartnerSettlementRule,
  ValdtyDateForWhldgTaxExmpCert,
  TaxJurisdiction,
  OutgPaytWithholdingTaxCode AS CAWhldgTaxCodeOutgoingPayt,
  IncgPaytWithholdingTaxCode AS CAWhldgTaxCodeIncomingPayt,
  WithholdingTaxCertificate,
  CAAdditionalDaysForCashMgmt,
  CABusPartnerPostgLockExstcCode,
  CABusPartnerAddlLockExstcCode,
  CABusinessPartnerLockStartDate,
  CABusinessPartnerLockEndDate,
  CABPReferenceNumber,
  CACompanyCodeGroup,
  AltvContractAcctForCollvBills,
  CAInterestCode,
  CashPlanningGroup,
  CARelationshipOfBPToContrAcct,
  AddressID,
  CAAddressIDOfJurisdictionCode,
  CAAuthorizationGroup,
  CAToleranceGroup,
  CACorrespondenceVariant,
  PartnerCompany,
  CACorrespondenceActivityCode,
  CAClearingCategory,
  CADefaultClearingRstrcnCode,
  SupplyingCountry,
  BusinessPlace,
  PaymentCondition,
  CAAccountDeterminationCode,
  BusinessArea,
  CAPaymentCompanyCode,
  Country
FROM I_ContractAccountPartner
LEFT OUTER JOIN A_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
;

Learn More