_PURGDOCACCOUNTASSIGNMENT

_PURGDOCACCOUNTASSIGNMENT is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 4
_GLAccount _GLAccount 1
_MM_CostCenterValueHelp _MM_CostCenterValueHelp 1
_WBSElementBasicData _WBSElementBasicData 1
BusinessArea BusinessArea 1
CostCenter CostCenter 1
FixedAsset AssetSubNumber 1
GLAccount GLAccount 1
GoodsRecepientName GoodsRecepientName 1
MasterFixedAsset ActiveMasterFixedAsset 1
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent 1
NetworkActivityInternalID NetworkActivityInternalID 1
OrderID InternalOrder 1
ProfitCenter ProfitCenter 1
ProjectInternalID ProjectInternalID 1
ProjectNetwork ProjectNetwork 1
Quantity StandardPurchaseOrderQuantity 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
WBSElementInternalID WBSElementInternalID 1
WBSElementInternalID_2 WBSElementInternalID 4

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 _PURGDOCACCOUNTASSIGNMENT (
    ACCOUNTASSIGNMENTNUMBER,
    _GLACCOUNT,
    _MM_COSTCENTERVALUEHELP,
    _WBSELEMENTBASICDATA,
    BUSINESSAREA,
    COSTCENTER,
    FIXEDASSET,
    GLACCOUNT,
    GOODSRECEPIENTNAME,
    MASTERFIXEDASSET,
    MULTIPLEACCTASSGMTDISTRPERCENT,
    NETWORKACTIVITYINTERNALID,
    ORDERID,
    PROFITCENTER,
    PROJECTINTERNALID,
    PROJECTNETWORK,
    QUANTITY,
    SALESORDER,
    SALESORDERITEM,
    WBSELEMENTINTERNALID,
    WBSELEMENTINTERNALID_2,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER)
);