_SUPPLIERPURCHASINGORG

_SUPPLIERPURCHASINGORG is an SAP database table in S/4HANA. It contains 17 fields.

Fields (17)

KeyField CDS FieldsUsed in Views
KEY ProcmtHubPurchasingOrg ProcmtHubPurchasingOrg 1
KEY PurchasingOrganization PurchasingOrganization,SupplierPurchasingOrg 2
_CurrencyVH _CurrencyVH 1
_PaymentTermsVH _PaymentTermsVH 1
_PurchasingGroupText _PurchasingGroupText 1
AuthorizationGroup AuthorizationGroup 1
CurrencyName CurrencyName 1
PaymentTerms PaymentTerms 2
PaymentTermsName PaymentTermsName 1
PlanningCycle PlanningCycle 1
ProcmtHubPurgOrgName ProcmtHubPurgOrgName 1
PurchaseOrderCurrency PurchaseOrderCurrency 2
PurchasingGroup PurchasingGroup,SupplierPurchasingGroup 3
PurchasingGroupName PurchasingGroupName 1
PurchasingIsBlockedForSupplier PurchasingIsBlockedForSupplier 2
RoundingProfile RoundingProfile 1
SupplierABCClassificationCode SupplierABCClassificationCode 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 _SUPPLIERPURCHASINGORG (
    PROCMTHUBPURCHASINGORG,
    PURCHASINGORGANIZATION,
    _CURRENCYVH,
    _PAYMENTTERMSVH,
    _PURCHASINGGROUPTEXT,
    AUTHORIZATIONGROUP,
    CURRENCYNAME,
    PAYMENTTERMS,
    PAYMENTTERMSNAME,
    PLANNINGCYCLE,
    PROCMTHUBPURGORGNAME,
    PURCHASEORDERCURRENCY,
    PURCHASINGGROUP,
    PURCHASINGGROUPNAME,
    PURCHASINGISBLOCKEDFORSUPPLIER,
    ROUNDINGPROFILE,
    SUPPLIERABCCLASSIFICATIONCODE,
    PRIMARY KEY (PROCMTHUBPURCHASINGORG, PURCHASINGORGANIZATION)
);