_PURCHASINGGROUP

8 Fields

_PURCHASINGGROUP is an SAP database table in S/4HANA. It contains 8 fields.

Fields (8)

KeyField CDS FieldsUsed in Views
KEY PurchasingGroup PurchasingGroup 2
EmailAddress EmailAddress,PurchasingGroupEmailAddress 5
FaxNumber FaxNumber 2
OrganizationalUnitExternalID PurchasingGroup,PurchasingGroupExternalID 4
PhoneNumber PhoneNumber 4
PhoneNumberExtension PhoneNumberExtension 3
PurchasingGroupName ContactPersonName,PurchasingGroupName 111
PurchasingGroupPhoneNumber PhoneNumber,PurchasingGroupPhoneNumber 6

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 _PURCHASINGGROUP (
    PURCHASINGGROUP,
    EMAILADDRESS,
    FAXNUMBER,
    ORGANIZATIONALUNITEXTERNALID,
    PHONENUMBER,
    PHONENUMBEREXTENSION,
    PURCHASINGGROUPNAME,
    PURCHASINGGROUPPHONENUMBER,
    PRIMARY KEY (PURCHASINGGROUP)
);

Learn More