ACCOUNTASSIGNMENT

24 Fields

ACCOUNTASSIGNMENT is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 2
KEY PurchaseOrder PurchaseOrder 1
KEY PurchaseOrderItem PurchaseOrderItem 1
ChartOfAccounts ChartOfAccounts 2
CompanyCode CompanyCode 1
ControllingArea ControllingArea 2
CostCenter CostCenter 5
GLAccount GLAccount 2
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent 2
Plant Plant 1
ProcmtHubControllingArea ProcmtHubControllingArea 2
ProcmtHubCostCenter ProcmtHubCostCenter 1
ProcmtHubGLAccount ProcmtHubGLAccount 2
ProcmtHubMasterFixedAsset ProcmtHubMasterFixedAsset 1
ProcmtHubProjectNetwork ProcmtHubProjectNetwork 1
ProcmtHubPurReqnAcctAssgmtNo AccountAssignmentNumber 1
ProcmtHubWBSElementInternalID ProcmtHubWBSElementInternalID 2
ProfitCenter ProfitCenter 2
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
Quantity Quantity 2
ReceivingCompanyCode ReceivingCompanyCode 1
ValidityDate ValidityDate 2
WBSElementInternalID WBSElement,WBSElementInternalID 3

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 ACCOUNTASSIGNMENT (
    ACCOUNTASSIGNMENTNUMBER,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    CHARTOFACCOUNTS,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    GLACCOUNT,
    MULTIPLEACCTASSGMTDISTRPERCENT,
    PLANT,
    PROCMTHUBCONTROLLINGAREA,
    PROCMTHUBCOSTCENTER,
    PROCMTHUBGLACCOUNT,
    PROCMTHUBMASTERFIXEDASSET,
    PROCMTHUBPROJECTNETWORK,
    PROCMTHUBPURREQNACCTASSGMTNO,
    PROCMTHUBWBSELEMENTINTERNALID,
    PROFITCENTER,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    QUANTITY,
    RECEIVINGCOMPANYCODE,
    VALIDITYDATE,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER, PURCHASEORDER, PURCHASEORDERITEM)
);

Learn More