_PARTNER

28 Fields

_PARTNER is an SAP database table in S/4HANA. It contains 28 fields.

Fields (28)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY JointVenturePartner JointVenturePartner 1
KEY role role 1
_Customer _Customer 2
_Supplier _Supplier 2
AddressID JntVntrPartnerAddressID 1
bp_id corporation_id 1
BPCustomerName JointVenturePartnerName 1
bu_sort1 bu_sort1 1
bu_sort2 bu_sort2 1
BusinessPartnerName BusinessPartnerName 3
company_name company_name,corporation_name 2
Country JntVntrPartnerCountry 1
Customer Customer,ShipToParty 4
family_name family_name 1
FaxNumber JntVntrPartnerFaxNumber 1
JntVntrBillgFormat JntVntrPartnerBillgFormat 3
JntVntrHardCopyBillgIsSupp JntVntrHardCopyBillgIsSupp 3
Language Language 1
mc_name1 mc_name1 1
mc_name2 mc_name2 1
partner_guid partner_guid 1
PartnerID PartnerID 1
PartnerName PartnerName 1
Supplier Supplier 2
TelephoneNumber1 JntVntrPartnerTelephoneNumber1 1
type type 1
valid_date valid_date 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 _PARTNER (
    COMPANYCODE,
    JOINTVENTUREPARTNER,
    ROLE,
    _CUSTOMER,
    _SUPPLIER,
    ADDRESSID,
    BP_ID,
    BPCUSTOMERNAME,
    BU_SORT1,
    BU_SORT2,
    BUSINESSPARTNERNAME,
    COMPANY_NAME,
    COUNTRY,
    CUSTOMER,
    FAMILY_NAME,
    FAXNUMBER,
    JNTVNTRBILLGFORMAT,
    JNTVNTRHARDCOPYBILLGISSUPP,
    LANGUAGE,
    MC_NAME1,
    MC_NAME2,
    PARTNER_GUID,
    PARTNERID,
    PARTNERNAME,
    SUPPLIER,
    TELEPHONENUMBER1,
    TYPE,
    VALID_DATE,
    PRIMARY KEY (COMPANYCODE, JOINTVENTUREPARTNER, ROLE)
);

Learn More