C_SupplierCompanyCodeTP

DDL: C_SUPPLIERCOMPANYCODETP Type: view_entity CONSUMPTION
58 Fields 1 Data Sources 1 OData Services

Supplier Company Code

C_SupplierCompanyCodeTP is a Consumption CDS View that provides data about "Supplier Company Code" in SAP S/4HANA. It reads from 1 data source (I_SupplierCompanyCodeTP) and exposes 58 fields with key fields BusinessPartner, CompanyCode, Supplier. It is exposed through 1 OData service (X_C_BUSPARTSUPPLIERTP_2_SRV).

Data Sources (1)

SourceAliasJoin Type
I_SupplierCompanyCodeTP I_SupplierCompanyCodeTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Supplier Company Code view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
X_C_BUSPARTSUPPLIERTP_2_SRV X_C_BUSPARTSUPPLIERTP_SRV V2 C1 NOT_RELEASED

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
KEY CompanyCode CompanyCode Receiver Company Code
KEY Supplier Supplier Supplier
BusinessPartnerUUID BusinessPartnerUUID UUID
BusinessPartnerForEdit BusinessPartnerForEdit Busn. Partner
CompanyCodeForEdit CompanyCodeForEdit Company Code
SupplierIsBlockedForPosting SupplierIsBlockedForPosting Co.code post.block
AuthorizationGroup AuthorizationGroup AuthorizGroup
AccountingClerk AccountingClerk Clerk Abbrev.
SupplierClerk SupplierClerk Clerk at vendor
AccountingClerkPhoneNumber AccountingClerkPhoneNumber Act.clk tel.no.
AccountingClerkFaxNumber AccountingClerkFaxNumber Clerk's fax
AccountingClerkInternetAddress AccountingClerkInternetAddress Clrk's internet
SupplierClerkIDBySupplier SupplierClerkIDBySupplier Acct w/ vendor
IsToBeLocallyProcessed IsToBeLocallyProcessed Local Process.
SupplierAccountNote SupplierAccountNote Account Memo
PaymentTerms PaymentTerms Pyt Terms
APARToleranceGroup APARToleranceGroup Tolerance Group
APARToleranceGroupName _ToleranceGroupText APARToleranceGroupName
SuplrInvcVerificatTolGroup SuplrInvcVerificatTolGroup Tolerance Grp
CheckPaidDurationInDays CheckPaidDurationInDays Chk cashng time
IsDoubleInvoice IsDoubleInvoice Chk Double Inv.
CustomerSupplierClearingIsUsed CustomerSupplierClearingIsUsed Clrg with vend.
ReconciliationAccount ReconciliationAccount Recon. account
SupplierHeadOffice SupplierHeadOffice Head Office
LayoutSortingRule LayoutSortingRule Sort key
SupplierCertificationDate SupplierCertificationDate Certifictn Date
PaymentMethodsList PaymentMethodsList Payment Methods
CashPlanningGroup CashPlanningGroup Planning Group
PaymentBlockingReason PaymentBlockingReason Pmnt block
PaymentBlockingReasonNamelocalized
AlternativePayee AlternativePayee Alternat.payee
HouseBank HouseBank House Bank
BillOfExchLmtAmtInCoCodeCrcy BillOfExchLmtAmtInCoCodeCrcy Bill/Ex. Limit
ItemIsToBePaidSeparately ItemIsToBePaidSeparately Individual Payt
PaymentIsToBeSentByEDI PaymentIsToBeSentByEDI Pmt adv. by EDI
WithholdingTaxCountry WithholdingTaxCountry WTax C/R Key
InterestCalculationCode InterestCalculationCode Interest Indic.
InterestCalculationDate InterestCalculationDate Last Key Date
IntrstCalcFrequencyInMonths IntrstCalcFrequencyInMonths Int.Calc.Freq.
LastInterestCalcRunDate LastInterestCalcRunDate Last Int. Calc.
SupplierReleaseGroup SupplierReleaseGroup Release Group
CreditMemoPaymentTerms CreditMemoPaymentTerms Cr Memo Terms
PaymentMethodSupplement PaymentMethodSupplement Pmnt Meth. Sup.
PaymentClearingGroup PaymentClearingGroup Payment Clrg Grp ID
PreviousAccountNumber PreviousAccountNumber Prev.Acct No.
PaymentReason PaymentReason Payment Reason
DeletionIsBlocked DeletionIsBlocked CoCd del.block
ExtendedWhldgTaxIsActive ExtendedWhldgTaxIsActive Extended WTax Active
PersonnelNumber PersonnelNumber Personnel No.
Country Country Venue: Ctry/Reg
CompanyCodeName CompanyCodeName Company Name
BPHasActiveEntity BPHasActiveEntity Is active
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
Currency Currency Valuation Crcy
MinorityGroup MinorityGroup Minority Indic.
DeletionIndicator DeletionIndicator Deletion Ind.
_SupplierToBusinessPartner _SupplierToBusinessPartner

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_SupplierCompanyCodeTP.
-- 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_SupplierCompanyCodeTP AS
SELECT
  BusinessPartner,
  CompanyCode,
  Supplier,
  BusinessPartnerUUID,
  BusinessPartnerForEdit,
  CompanyCodeForEdit,
  SupplierIsBlockedForPosting,
  AuthorizationGroup,
  AccountingClerk,
  SupplierClerk,
  AccountingClerkPhoneNumber,
  AccountingClerkFaxNumber,
  AccountingClerkInternetAddress,
  SupplierClerkIDBySupplier,
  IsToBeLocallyProcessed,
  SupplierAccountNote,
  PaymentTerms,
  APARToleranceGroup,
  _ToleranceGroupText.APARToleranceGroupName AS APARToleranceGroupName,
  SuplrInvcVerificatTolGroup,
  CheckPaidDurationInDays,
  IsDoubleInvoice,
  CustomerSupplierClearingIsUsed,
  ReconciliationAccount,
  SupplierHeadOffice,
  LayoutSortingRule,
  SupplierCertificationDate,
  PaymentMethodsList,
  CashPlanningGroup,
  PaymentBlockingReason,
  _PaymentBlockingReasonText.PaymentBlockingReasonName : localized AS PaymentBlockingReasonNamelocalized,
  AlternativePayee,
  HouseBank,
  BillOfExchLmtAmtInCoCodeCrcy,
  ItemIsToBePaidSeparately,
  PaymentIsToBeSentByEDI,
  WithholdingTaxCountry,
  InterestCalculationCode,
  InterestCalculationDate,
  IntrstCalcFrequencyInMonths,
  LastInterestCalcRunDate,
  SupplierReleaseGroup,
  CreditMemoPaymentTerms,
  PaymentMethodSupplement,
  PaymentClearingGroup,
  PreviousAccountNumber,
  PaymentReason,
  DeletionIsBlocked,
  ExtendedWhldgTaxIsActive,
  PersonnelNumber,
  Country,
  CompanyCodeName,
  BPHasActiveEntity,
  IsBusinessPurposeCompleted,
  Currency,
  MinorityGroup,
  DeletionIndicator
FROM I_SupplierCompanyCodeTP
;

Learn More