P_SUPPLIERWITHCOMPANYCODE

CDS View
58 Fields 1 CDS Views

P_SUPPLIERWITHCOMPANYCODE is a CDS View in S/4HANA. It contains 58 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SuplrCoCodePurOrgAssgmt view from COMPOSITE

Fields (58)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY Supplier Supplier 1
_StandardAddress _StandardAddress 1
_SupplierAccountGroup _SupplierAccountGroup 1
_SupplierAccountGroupText _SupplierAccountGroupText 1
AccountingClerk AccountingClerk 1
AccountingClerkFaxNumber AccountingClerkFaxNumber 1
AccountingClerkPhoneNumber AccountingClerkPhoneNumber 1
AccountIsBlockedForPosting AccountIsBlockedForPosting 1
AddressID AddressID 1
AlternativePayee AlternativePayee 1
AlternativePayeeAccountNumber AlternativePayeeAccountNumber 1
AuthorizationGroup AuthorizationGroup 1
CashPlanningGroup CashPlanningGroup 1
CityName CityName 1
CompanyCodeName CompanyCodeName 1
Country Country 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
DeletionIndicator DeletionIndicator 1
FaxNumber FaxNumber 1
IsNaturalPerson IsNaturalPerson 1
IsToBeCheckedForDuplicates IsToBeCheckedForDuplicates 1
LayoutSortingRule LayoutSortingRule 1
MinorityGroup MinorityGroup 1
OrganizationBPName1 OrganizationBPName1 1
OrganizationBPName2 OrganizationBPName2 1
PaymentBlockingReason PaymentBlockingReason 1
PaymentIsBlockedForSupplier PaymentIsBlockedForSupplier 1
PaymentMethodsList PaymentMethodsList 1
PhoneNumber1 PhoneNumber1 1
PhoneNumber2 PhoneNumber2 1
PostalCode PostalCode 1
PreviousAccountNumber PreviousAccountNumber 1
PurchasingIsBlocked PurchasingIsBlocked 1
ReconciliationAccount ReconciliationAccount 1
Region Region 1
ResponsibleType ResponsibleType 1
StreetName StreetName 1
SuplrCoCodePaymentTerms SuplrCoCodePaymentTerms 1
SuplrIsDeltdCoCode SuplrIsDeltdCoCode 1
SupplierAccountGroup SupplierAccountGroup 1
SupplierAccountNote SupplierAccountNote 1
SupplierClerkURL SupplierClerkURL 1
SupplierFullName SupplierFullName 1
SupplierIsBlockedForPosting SupplierIsBlockedForPosting 1
SupplierName SupplierName 1
SupplierReleaseGroup SupplierReleaseGroup 1
TaxNumber1 TaxNumber1 1
TaxNumber2 TaxNumber2 1
TaxNumber3 TaxNumber3 1
TaxNumber4 TaxNumber4 1
TaxNumber5 TaxNumber5 1
TaxNumberResponsible TaxNumberResponsible 1
TaxNumberType TaxNumberType 1
TradingPartner TradingPartner 1
VATLiability VATLiability 1
WithholdingTaxCountry WithholdingTaxCountry 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SUPPLIERWITHCOMPANYCODE (
    COMPANYCODE,
    SUPPLIER,
    _STANDARDADDRESS,
    _SUPPLIERACCOUNTGROUP,
    _SUPPLIERACCOUNTGROUPTEXT,
    ACCOUNTINGCLERK,
    ACCOUNTINGCLERKFAXNUMBER,
    ACCOUNTINGCLERKPHONENUMBER,
    ACCOUNTISBLOCKEDFORPOSTING,
    ADDRESSID,
    ALTERNATIVEPAYEE,
    ALTERNATIVEPAYEEACCOUNTNUMBER,
    AUTHORIZATIONGROUP,
    CASHPLANNINGGROUP,
    CITYNAME,
    COMPANYCODENAME,
    COUNTRY,
    CREATEDBYUSER,
    CREATIONDATE,
    DELETIONINDICATOR,
    FAXNUMBER,
    ISNATURALPERSON,
    ISTOBECHECKEDFORDUPLICATES,
    LAYOUTSORTINGRULE,
    MINORITYGROUP,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    PAYMENTBLOCKINGREASON,
    PAYMENTISBLOCKEDFORSUPPLIER,
    PAYMENTMETHODSLIST,
    PHONENUMBER1,
    PHONENUMBER2,
    POSTALCODE,
    PREVIOUSACCOUNTNUMBER,
    PURCHASINGISBLOCKED,
    RECONCILIATIONACCOUNT,
    REGION,
    RESPONSIBLETYPE,
    STREETNAME,
    SUPLRCOCODEPAYMENTTERMS,
    SUPLRISDELTDCOCODE,
    SUPPLIERACCOUNTGROUP,
    SUPPLIERACCOUNTNOTE,
    SUPPLIERCLERKURL,
    SUPPLIERFULLNAME,
    SUPPLIERISBLOCKEDFORPOSTING,
    SUPPLIERNAME,
    SUPPLIERRELEASEGROUP,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXNUMBERRESPONSIBLE,
    TAXNUMBERTYPE,
    TRADINGPARTNER,
    VATLIABILITY,
    WITHHOLDINGTAXCOUNTRY,
    PRIMARY KEY (COMPANYCODE, SUPPLIER)
);

Learn More