_PURORDACCOUNTASSIGNMENT

_PURORDACCOUNTASSIGNMENT is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 3
ControllingArea ControllingArea 1
CostCenter CostCenter 4
CostCenterName CostCenterName 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 1
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent 1
ProfitCenter ProfitCenter 1
PurgDocNetAmount PurgDocNetAmount 1
Quantity Quantity 1
SalesOrder SalesOrder 4
SalesOrderItem SalesOrderItem 2
WBSElementExternalID WBSElementExternalID 2
WBSElementInternalID WBSElementInternalID 1
WBSElementObject WBSElementObject 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 _PURORDACCOUNTASSIGNMENT (
    ACCOUNTASSIGNMENTNUMBER,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTCENTERNAME,
    FUNCTIONALAREA,
    GLACCOUNT,
    MULTIPLEACCTASSGMTDISTRPERCENT,
    PROFITCENTER,
    PURGDOCNETAMOUNT,
    QUANTITY,
    SALESORDER,
    SALESORDERITEM,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    WBSELEMENTOBJECT,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER)
);