Fields (66)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | PostingRuleActionUUID | PostingRuleActionUUID | 1 |
| AssignmentReference | AssignmentReference | 1 | |
| BranchCode | BranchCode | 1 | |
| BudgetPeriod | BudgetPeriod | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessProcess | BusinessProcess | 1 | |
| CommitmentItem | CommitmentItem | 1 | |
| CostCenter | CostCenter | 1 | |
| CostObject | CostObject | 1 | |
| DeliveryOfGoodsReportingCntry | DeliveryOfGoodsReportingCntry | 1 | |
| DocumentItemText | DocumentItemText | 1 | |
| DueCalculationBaseDate | DueCalculationBaseDate | 1 | |
| EarmarkedFundsDocument | EarmarkedFundsDocument | 1 | |
| EarmarkedFundsDocumentItem | EarmarkedFundsDocumentItem | 1 | |
| FinancialManagementArea | FinancialManagementArea | 1 | |
| FinancialTransactionType | FinancialTransactionType | 1 | |
| FixedAsset | FixedAsset | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| Fund | Fund | 1 | |
| FundedProgram | FundedProgram | 1 | |
| GLAccount | GLAccount | 1 | |
| GrossIncomeTaxActivityCode | GrossIncomeTaxActivityCode | 1 | |
| GrossIncomeTaxRegion | GrossIncomeTaxRegion | 1 | |
| HouseBank | HouseBank | 1 | |
| HouseBankAccount | HouseBankAccount | 1 | |
| IsEUTriangularDeal | IsEUTriangularDeal | 1 | |
| IsNotCashDiscountLiable | IsNotCashDiscountLiable | 1 | |
| LineItemIsCompleted | LineItemIsCompleted | 1 | |
| MasterFixedAsset | MasterFixedAsset | 1 | |
| NetworkActivity | NetworkActivity | 1 | |
| OrderID | OrderID | 1 | |
| PartnerAccountNumber | PartnerAccountNumber | 1 | |
| PartnerBudgetPeriod | PartnerBudgetPeriod | 1 | |
| PartnerBusinessArea | PartnerBusinessArea | 1 | |
| PartnerCompany | PartnerCompany | 1 | |
| PartnerFunctionalArea | PartnerFunctionalArea | 1 | |
| PartnerFund | PartnerFund | 1 | |
| PartnerGrant | PartnerGrant | 1 | |
| PartnerProfitCenter | PartnerProfitCenter | 1 | |
| PartnerSegment | PartnerSegment | 1 | |
| PaymentDifferenceReason | PaymentDifferenceReason | 1 | |
| PersonnelNumber | PersonnelNumber | 1 | |
| PostingRuleUUID | PostingRuleUUID | 1 | |
| ProfitabilitySegment | ProfitabilitySegment | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProjectNetwork | ProjectNetwork | 1 | |
| PurchasingDocument | PurchasingDocument | 1 | |
| PurchasingDocumentItem | PurchasingDocumentItem | 1 | |
| Reference1IDByBusinessPartner | Reference1IDByBusinessPartner | 1 | |
| Reference2IDByBusinessPartner | Reference2IDByBusinessPartner | 1 | |
| Reference3IDByBusinessPartner | Reference3IDByBusinessPartner | 1 | |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderItem | SalesOrderItem | 1 | |
| ScheduleLine | ScheduleLine | 1 | |
| Segment | Segment | 1 | |
| ServiceDocumentItem | ServiceDocumentItem | 1 | |
| ServiceDocumentType | ServiceDocumentType | 1 | |
| StateCentralBankPaymentReason | StateCentralBankPaymentReason | 1 | |
| SupplyingCountry | SupplyingCountry | 1 | |
| TaxCode | TaxCode | 1 | |
| TaxDeterminationDate | TaxDeterminationDate | 1 | |
| TaxItemAcctgDocItemRef | TaxItemAcctgDocItemRef | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| TaxRateValidityStartDate | TaxRateValidityStartDate | 1 | |
| ValueDate | ValueDate | 1 | |
| WBSElement | WBSElement | 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 ACTIONGL (
POSTINGRULEACTIONUUID,
ASSIGNMENTREFERENCE,
BRANCHCODE,
BUDGETPERIOD,
BUSINESSAREA,
BUSINESSPROCESS,
COMMITMENTITEM,
COSTCENTER,
COSTOBJECT,
DELIVERYOFGOODSREPORTINGCNTRY,
DOCUMENTITEMTEXT,
DUECALCULATIONBASEDATE,
EARMARKEDFUNDSDOCUMENT,
EARMARKEDFUNDSDOCUMENTITEM,
FINANCIALMANAGEMENTAREA,
FINANCIALTRANSACTIONTYPE,
FIXEDASSET,
FUNCTIONALAREA,
FUND,
FUNDEDPROGRAM,
GLACCOUNT,
GROSSINCOMETAXACTIVITYCODE,
GROSSINCOMETAXREGION,
HOUSEBANK,
HOUSEBANKACCOUNT,
ISEUTRIANGULARDEAL,
ISNOTCASHDISCOUNTLIABLE,
LINEITEMISCOMPLETED,
MASTERFIXEDASSET,
NETWORKACTIVITY,
ORDERID,
PARTNERACCOUNTNUMBER,
PARTNERBUDGETPERIOD,
PARTNERBUSINESSAREA,
PARTNERCOMPANY,
PARTNERFUNCTIONALAREA,
PARTNERFUND,
PARTNERGRANT,
PARTNERPROFITCENTER,
PARTNERSEGMENT,
PAYMENTDIFFERENCEREASON,
PERSONNELNUMBER,
POSTINGRULEUUID,
PROFITABILITYSEGMENT,
PROFITCENTER,
PROJECTNETWORK,
PURCHASINGDOCUMENT,
PURCHASINGDOCUMENTITEM,
REFERENCE1IDBYBUSINESSPARTNER,
REFERENCE2IDBYBUSINESSPARTNER,
REFERENCE3IDBYBUSINESSPARTNER,
SALESORDER,
SALESORDERITEM,
SCHEDULELINE,
SEGMENT,
SERVICEDOCUMENTITEM,
SERVICEDOCUMENTTYPE,
STATECENTRALBANKPAYMENTREASON,
SUPPLYINGCOUNTRY,
TAXCODE,
TAXDETERMINATIONDATE,
TAXITEMACCTGDOCITEMREF,
TAXJURISDICTION,
TAXRATEVALIDITYSTARTDATE,
VALUEDATE,
WBSELEMENT,
PRIMARY KEY (POSTINGRULEACTIONUUID)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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