I_SRVENTRYSHEETACCTASSGMTBASIC
Srv Entry Sheet Account Assignment Basic
I_SRVENTRYSHEETACCTASSGMTBASIC is a CDS View in S/4HANA. Srv Entry Sheet Account Assignment Basic. It contains 55 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_SrvcEntrShtAcctAssignment | view | from | BASIC | Account Assignment |
| I_ServiceEntrySheetAcctAssgmt | view | from | COMPOSITE | Service Entry Sheet Account Assignment |
| I_SESAccountAssignmentAPI01 | view | from | BASIC | Service Entry Sheet Account Assignment |
Fields (55)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountAssignment | AccountAssignment | 1 |
| KEY | ServiceEntrySheet | ServiceEntrySheet | 1 |
| KEY | ServiceEntrySheetItem | ServiceEntrySheetItem | 1 |
| _UnitValueHelp | _UnitValueHelp | 1 | |
| BudgetPeriod | BudgetPeriod | 1 | |
| BusinessArea | BusinessArea | 2 | |
| BusinessProcess | BusinessProcess | 1 | |
| CommitmentItem | CommitmentItem | 1 | |
| CommitmentItemShortID | CommitmentItemShortID | 1 | |
| ControllingArea | ControllingArea | 2 | |
| CostCenter | CostCenter | 2 | |
| CostCtrActivityType | CostCtrActivityType | 1 | |
| CostObject | CostObject | 2 | |
| CreatedByUser | CreatedByUser | 2 | |
| Currency | Currency | 1 | |
| EarmarkedFundsDocument | EarmarkedFundsDocument | 1 | |
| EarmarkedFundsDocumentItem | EarmarkedFundsDocumentItem | 1 | |
| FixedAsset | FixedAsset | 1 | |
| FunctionalArea | FunctionalArea | 2 | |
| Fund | Fund | 1 | |
| FundedProgram | FundedProgram | 1 | |
| FundsCenter | FundsCenter | 1 | |
| GLAccount | GLAccount | 1 | |
| GoodsRecipientName | GoodsRecipientName | 1 | |
| GrantID | GrantID | 1 | |
| IsDeleted | IsDeleted | 1 | |
| IsEndOfPurposeBlocked | IsEndOfPurposeBlocked | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LastChangeUser | LastChangeUser | 1 | |
| MasterFixedAsset | MasterFixedAsset | 1 | |
| MultipleAcctAssgmtDistrPercent | MultipleAcctAssgmtDistrPercent | 1 | |
| NetAmount | NetAmount | 2 | |
| NetworkActivityInternalID | NetworkActivityInternalID | 1 | |
| OrderID | OrderID | 1 | |
| OrderIntBillOfOperationsItem | OrderIntBillOfOperationsItem | 1 | |
| OrderInternalID | OrderInternalID | 1 | |
| PartnerAccountNumber | PartnerAccountNumber | 1 | |
| Plant | Plant | 2 | |
| ProfitabilitySegment | ProfitabilitySegment | 1 | |
| ProfitCenter | ProfitCenter | 2 | |
| ProjectNetwork | ProjectNetwork | 1 | |
| ProjectNetworkInternalID | ProjectNetworkInternalID | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| Quantity | Quantity | 1 | |
| RefDocAccountAssignment | RefDocAccountAssignment | 1 | |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderScheduleLine | SalesOrderScheduleLine | 1 | |
| ServiceDocument | ServiceDocument | 1 | |
| ServiceDocumentItem | ServiceDocumentItem | 1 | |
| ServiceDocumentType | ServiceDocumentType | 1 | |
| SettlementReferenceDate | SettlementReferenceDate | 1 | |
| UnloadingPointName | UnloadingPointName | 1 | |
| WBSElementInternalID | WBSElementInternalID | 1 | |
| WBSElementInternalID_2 | WBSElementInternalID_2 | 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.
-- Srv Entry Sheet Account Assignment Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SRVENTRYSHEETACCTASSGMTBASIC (
ACCOUNTASSIGNMENT,
SERVICEENTRYSHEET,
SERVICEENTRYSHEETITEM,
_UNITVALUEHELP,
BUDGETPERIOD,
BUSINESSAREA,
BUSINESSPROCESS,
COMMITMENTITEM,
COMMITMENTITEMSHORTID,
CONTROLLINGAREA,
COSTCENTER,
COSTCTRACTIVITYTYPE,
COSTOBJECT,
CREATEDBYUSER,
CURRENCY,
EARMARKEDFUNDSDOCUMENT,
EARMARKEDFUNDSDOCUMENTITEM,
FIXEDASSET,
FUNCTIONALAREA,
FUND,
FUNDEDPROGRAM,
FUNDSCENTER,
GLACCOUNT,
GOODSRECIPIENTNAME,
GRANTID,
ISDELETED,
ISENDOFPURPOSEBLOCKED,
LASTCHANGEDATETIME,
LASTCHANGEUSER,
MASTERFIXEDASSET,
MULTIPLEACCTASSGMTDISTRPERCENT,
NETAMOUNT,
NETWORKACTIVITYINTERNALID,
ORDERID,
ORDERINTBILLOFOPERATIONSITEM,
ORDERINTERNALID,
PARTNERACCOUNTNUMBER,
PLANT,
PROFITABILITYSEGMENT,
PROFITCENTER,
PROJECTNETWORK,
PROJECTNETWORKINTERNALID,
PURCHASINGGROUP,
PURCHASINGORGANIZATION,
QUANTITY,
REFDOCACCOUNTASSIGNMENT,
SALESORDER,
SALESORDERSCHEDULELINE,
SERVICEDOCUMENT,
SERVICEDOCUMENTITEM,
SERVICEDOCUMENTTYPE,
SETTLEMENTREFERENCEDATE,
UNLOADINGPOINTNAME,
WBSELEMENTINTERNALID,
WBSELEMENTINTERNALID_2,
PRIMARY KEY (ACCOUNTASSIGNMENT, SERVICEENTRYSHEET, SERVICEENTRYSHEETITEM)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA